Tidal Workload Automation Adapter for Informatica
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.
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.
- Defines, launches, and monitors any Informatica service request
- Connects Informatica to other platforms, other applications, and other Informatica instances with unlimited dependencies
- Eliminates the need for scripting to integrate Informatica workflows
- Provides advanced error control and failure notification
- Collects and consolidates log file data and captures Informatica process exit codes from jobs tasks and workflows
- Captures FTP files from outside the firewall, e.g., data from software-as-a-service (SaaS) applications or external partners
- Creates standard Informatica data collection and ETL process templates
- Leverages existing technology and increases the return on investment in Informatica
- Reduces costs by consolidating Informatica workflows under one corporate-wide scheduling console with one set of internal procedures
- Reduces maintenance requirements and accelerates ROI
- Expedites problem resolution, improves trouble ticket clearance rates, and enables IT to adhere to service legal agreements (SLAs)
- Makes workflows more efficient by adding a rich source of data for process trending and bottleneck remediation
- Integrates business partners and service providers into extended workflows
- Customizes and reuses Informatica-store jobs to save time and reduce costs
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.