Tidal™ Enterprise Adapter for Informatica

Download the PDF version of this document

Informatica™ has data warehouse and integration solutions that do an adequate job of managing batch processes from within, however, they are not optimized for all enterprise-wide scheduling requirements. The native scheduler within Informatica cannot set dependencies outside Informatica processes and operations staff cannot view or interact with Informatica processes in real-time. Custom made by Tidal Consulting Services for an organization’s unique needs, Tidal Enterprise Adapter™ for Informatica is the interface between Tidal Enterprise Scheduler™ and Informatica. Together, they provide organizations with robust scheduling functionality including cross-platform, cross-application dependency support, real-time interaction and centralized control.

Why Not Make Life Easier?
With the Enterprise Adapter for Informatica, organizations can add complex scheduling functions to their Informatica solution and consolidate multiple schedulers into one centralized console. The Enterprise Adapter, in conjunction with Tidal Enterprise Scheduler, can be used to define, launch and monitor Informatica requests within an Informatica DataCenter or PowerMart environment.

• Leverages existing technology and expands Informatica investments to create a complete enterprise solution
• Connects Informatica to other platforms, other business applications and other Informatica instances with unlimited dependencies for broader, integrated workflows
• Consolidates Informatica application automation under one corporate-wide console with one staff and one set of internal procedures
• Reduces training and operational support to one application automation environment
• Provides richer, more advanced scheduling features than the native Informatica job scheduler for greater efficiency and productivity

Key Features

• Cross-application, cross-platform, unlimited external dependencies for Informatica jobs
• Provides scheduling based on multiple types of business calendars such as year end, month end or week end
• Ability to view reports and alert personnel based on various report job statuses
• Monitors any files that are used as event triggers for the initiation of backup requests
• Queue management for all Informatica process requests
• Centralizes security and control for operations of scheduled requests
• Offers error control and failure notification
• Integrates without scripting to reach other applications and platforms, offering minimal maintenance and a higher ROI
• Accommodates restarting of a workflow from a specific task within a workflow
• Collects and consolidates log file data from the workflow and all of its tasks and makes it available from the Tidal console to expedite problem resolution
• Reduces learning time and maintenance for multiple schedulers

How It Works
The Enterprise Adapter for Informatica is an API-level integration solution. The Enterprise Adapter can reside on any Windows® machine and uses an environment file to connect to the Informatica repository. The Informatica server and repository can be on any machine in the data center that Informatica supports.

The security, user names and passwords set up in Informatica are observed by the Enterprise Adapter. The creation of an Informatica job from within Tidal Enterprise Scheduler is as simple as creating any other job.

A Tidal job definition defines the internal request set information defined within Informatica and is used by the Enterprise Adapter to launch the Informatica request. Once the request is made to Informatica, the Enterprise Adapter monitors the process until it completes. The Enterprise Adapter also captures the Informatica process exit code, returns it to Tidal Enterprise Scheduler and provides additional log information about the request. In addition, the Connector allows you to maintain complete control over each request that is launched. The request can be cancelled, aborted or rerun from Tidal Enterprise Scheduler, a feature that provides extensive user control over the environment.

The Enterprise Adapter launches processes based on defined calendars and schedules as well as monitoring and controlling those processes as they execute. In addition, the Enterprise Adapter provides error control and failure notification to enhance the overall business processes that drive an organization's data processing requirements.

The Enterprise Adapter leverages Tidal Enterprise Scheduler's cutting edge job scheduling technology to feed into Informatica's data warehousing products.

By taking advantage of the Enterprise Adapter, organizations can create a job definition to manage the most simple or the most complex request sets defined within the Informatica data integration environment. Tidal Enterprise Scheduler allows you to develop process streams and manage the information flow from a centralized console, thereby giving users greater control over all aspects of an Informatica PowerCenter or DataMart job stream.

Tidal Enterprise Scheduler provides virtually unlimited flexibility in developing process streams. Also, you can develop complex job streams that utilize the Enterprise Adapter to merge any system process and ERP application process into a cohesive, centrally managed job stream. This provides error detection, correction and management across the enterprise. Since the Informatica request set is defined like any other Tidal Enterprise Scheduler job, users can take full advantage of job dependencies, file dependencies, variable dependencies, calendars, events and email notifications.

Call Tidal Software for more information or to see a demo.

1-877-55-Tidal
sales@tidalsoftware.com