Informatica Adapter

Pre-built DW / ETL / BI Informatica Adapter from Tidal

Quest Webinar

Sept. 12th Webinar – Getting More From Your Oracle ERP

Whether you’re running JDE, PeopleSoft, EBS, or other Oracle applications, your ERP connects with critical applications and systems. Join this Quest-sponsored webinar and learn from experts how they use Tidal Automation™ to get the most from their ERP in multi-system environments.

Register Now

Adapter Overview

Managing Complex ETL Processes in the Enterprise

Data integration software from Informatica plays a crucial role for businesses. It links and reports on database, supply chain management (SCM), accounting, human resource (HR), and sales information. Accessing and integrating large amounts of data from sources both inside and outside the firewall, and even from within the cloud, is complex and requires that many elements work together to deliver accurate and timely information that support the right strategic decisions.

In many cases, complex data pathways and their associated moving parts break, dependencies cannot be met, networks fail, systems go offline and, without visibility into each process, reports will be incorrect, late, or both. Tidal Workload Automation Adapter for Informatics helps to deliver mission-critical data to the right place at the right time for all Informatica extract, transform, and load (ETL) pathways.

Tidal Workload Automation Adapter for Informatica

Tidal Workload Automation Adapter for Informatica allows users to schedule Informatica jobs through Workload Automation, enabling them to leverage its capabilities to automate, simplify, and improve job scheduling and ETL performance. With Tidal Workload Automation Adapter for Informatica, IT operations can add complex scheduling functions to their Informatica data pathways and consolidate multiple job routines into one centralized enterprise solution. The adapter can define, launch, and monitor data workflows within an Informatica PowerCenter environment. It allows Informatica administrators to integrate all data pathway executions into an automated, repeatable, and schedulable solution that delivers a high degree of visibility and control over steps in the ETL process.

How Tidal Workload Automation Adapter for Informatica Works

Tidal Workload Automation Adapter for Informatica creates an interface between Workload Automation and Informatica PowerCenter, which gives IT operations staff a robust scheduling solution that incorporates cross- platform, cross-application dependency support, real-time interaction, and centralized control of Informatica data integration, ETL, and data warehouse processes.

Tidal Workload Automation Adapter for Informatica integrates with the PowerCenter server using Informatica Load Manager application program interfaces (APIs). Through these interfaces, the adapter communicates with Informatica PowerCenter to define, run, and monitor workflows.

Users can schedule, monitor, and manage PowerCenter workflows from the Workload Automation browser-based console, which provides rich scheduling features that include granular calendaring, events management, and access to enterprise-wide dependencies. Each Tidal Workload Automation Adapter for Informatica job definition encapsulates workflows loaded from the PowerCenter repository and permits parameter value overrides. Then, based on defined scheduling criteria, the adapter submits a workflow to the PowerCenter Integration Service. Job execution is authenticated against Workload Automation runtime user definitions and PowerCenter namespaces, roles, and users. After a workflow instance has been submitted, the adapter monitors all job steps and interactions until completion.

Figure 9. Informatica PowerCenter workflows are viewed and managed using the Tidal Workload Automation job definition screen.

Informica Job

Features and Benefits

Tidal Workload Automation Adapter for Informatica extends Workload Automation, enabling IT staff to schedule Informatica jobs through the Workload Automation interface. It simplifies job scheduling and respects the integrity and security of the Informatica environment.

This adapter, with Tidal Workload Automation, delivers standardized and centralized scriptless scheduling for both simple and complex processes and thorough tracking and alerting capabilities. These capabilities work in conjunction to increase efficiency, reduce errors, and support enterprise objectives, allowing IT staff to focus on innovation and strategic initiatives. Specific capabilities include:

Control and Visibility – Tidal Workload Automation provides robust flexibility in developing ETL processing steps, giving users the ability to develop complex workflows that merge any ETL process and enterprise resource planning (ERP) application into a cohesive, centrally managed business process.

During execution, real-time task status details are visible from the job activity console of Workload Automation. Additionally, the adapter permits Informatica users to cancel, abort, recover, or rerun workflows from Tidal Workload Automation, a feature that provides added control over the Informatica environment.

When a job is complete, the adapter returns its final output, which can then be used to control downstream jobs, as well as details associated with the job run. Because Informatica jobs are defined like any other Workload Automation job, users can take full advantage of job, file, and variable dependencies, calendars, events, monitoring, and error notifications. In addition, they can benefit from detailed runtime error detection, alerts, and automated remediation.

Seamless Support for Ad Hoc and Scheduled Informatica Jobs – Business unit managers frequently make ad hoc ETL job requests that must be run immediately. Gradually, these jobs begin to be reused and fall into predictable patterns. For efficiency, they should be organized into calendars or schedules. Workload Automation, in conjunction with Informatica PowerCenter, allows ad hoc jobs to be easily transferred to standard production runs, eliminating manual intervention in the ETL job scheduling process. Working together, these two solutions also enable IT operations staff to incorporate Informatica data management processes into established IT policies and to seamlessly update run book operations.

Features Summary

Benefits Summary

Ultimately, using Tidal Workload Automation Adapter for Informatica, in conjunction with Workload Automation, makes it possible to leverage existing technology and investment in Informatica and enables companies to increase efficiency and focus their resources on supporting strategic business initiatives.