Adapters for Informatica

Build advanced visibility and control into the Informatica ETL process.

Job Scheduling vs. Workload Automation: What's the Difference?

Read the Ebook

Accurate, Timely Information to Support Strategic Decision-Making

Adapters Overview

The Tidal Automation Adapters for Informatica allows users to schedule Informatica jobs through the Tidal platform, enabling them to leverage its capabilities to automate, simplify and improve job scheduling and ETL performance.

We offer two Tidal Automation adapters to support Informatica’s technology stacks:

  • PowerCenter
  • Intelligent Cloud Services

With our adapters 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 Informatica data workflows. It allows Informatica administrators to integrate all data pathway executions into an automated, repeatable scheduling solution that delivers a high degree of visibility and control of steps in the ETL process.

More About These Adapters

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, accounting, human resources 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 many elements to 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 adapters for Informatics help to deliver mission-critical data to the right place at the right time for all Informatica extract, transform and load (ETL) pathways.

How the Adapters Work

Tidal’s adapters integrate into the existing embedded Informatica schedulers. The Tidal Automation platform then controls and manages the Informatica tasks within those schedulers. The adapters create an interface between Tidal’s platform and Informatica, which gives IT operations staff a robust scheduling solution for cross- platform, cross-application dependency support, real-time interaction, and centralized control of Informatica data integration, ETL and data warehouse processes.

Our adapters integrate with Informatica’s application program interfaces (APIs). Through these interfaces, the adapters communicate with Informatica  to define, run and monitor workflows.

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

Informica Job

Features
  • Schedules and monitors Informatica workflows, concurrent workflows, linear and advanced taskflows from a centralized console in Tidal
  • Specifies execution parameters to override Informatica
  • Creates associations to Tidal defined variables for use as job attributes
  • Creates associations to Tidal defined dependencies and events for scheduling control
  • Applies advanced scheduling constructs such as business calendars and job factory to Informatica jobs
  • Enables email notifications for completed task flows
Benefits

  • Captures FTP files from outside the firewall, e.g., data from SaaS applications or external partners
  • Creates standard Informatica data collection and ETL process templates
  • Expedites problem resolution, improves trouble ticket clearance rates, and enables IT to adhere to service legal agreements (SLAs)
  • Integrates business partners and service providers into extended workflows

 

Where We Run

The Cloud

Tidal’s enterprise-wide automation platform transcends the inherent limitations associated with standalone point products or native cloud schedulers. We can automate and orchestrate cross-application workloads and enterprise-wide business processes that traverse multiple clouds and hybrid environments – all from a single-pane-of-glass view.

On-Premises

Tidal helps you optimize the value and performance of your legacy infrastructure while opening new opportunities to leverage next-gen applications and workflows. From pure on-prem to hybrid on-prem and cloud engagements – the answer is Tidal.

  • CentOS
  • Linux Kernel 2.6.18 & above
  • Linux PPC
  • Microsoft Windows
  • Microsoft Windows Server
  • Open VMS
  • Oracle Cloud
  • Oracle Enterprise Linux
  • Red Hat Enterprise Server
  • Suse Enterprise
  • Tandem NSK
  • Ubuntu
  • UNIX
  • HPUX (PA-RISC, Itanium)
  • Solaris (Sparc, X86)
  • AIX
  • OS/400 iSeries
  • z/Linux
  • z/OS