Cisco Cisco Tidal Enterprise Adapter for Informatica Data Sheet
Data Sheet
© 2010 Cisco and/or its affiliates. All rights reserv ed. This document is Cisco Public Information.
Page 2 of 3
Enterprise Adapter for Informatica integrates w ith the Pow erCenter server using vendor-approved application
program interfaces (APIs). Through these interfaces, the adapter communicates w ith Infor matica Pow erCenter to
define, run, and monitor w orkflow s.
Users can schedule, monitor, and manage Pow erCenter w orkflow s from the Enterpr ise Scheduler brow ser-based
console, w hich provides rich scheduling features that include granular calendaring, events management, and access
to enterpr ise-w ide dependencies. Each Enterprise Adapter for Infor matica job definition encapsulates w orkflow s
loaded from the Pow erCenter repository and per mits parameter value overrides. Then, based on defined scheduling
criteria, the adapter submits a w orkflow to the Pow erCenter Integration Service. Job execution is authenticated
against Enterprise Scheduler runtime user definitions and Pow erCenter namespaces, roles, and users. After a
w orkflow instance has been submitted, the adapter monitors all job steps and interactions until completion.
Features and Benefits
Enterprise Adapter for Informatica extends the reach of Enterprise Scheduler, enabling IT staff to schedule
Infor matica jobs through the Enterprise Scheduler interface. It simplifies job scheduling and respects the integrity and
security of the Informatica env ironment.
This adapter delivers standardized and centralized script-less scheduling for both s imple and complex processes and
thorough tracking and alerting capabilities. These capabilities w ork in conjunction to increase efficiency, reduce
errors, and support enterprise objectives, allow ing IT staff to focus on innovation and strategic initiatives. Specific
capabilities include:
Control and Visibility
– Enterprise Scheduler prov ides robust flexibility in developing ETL processing steps, giv ing
users the ability to develop complex w orkflow s that merge any ETL process and enterprise application into a
cohesive, centrally managed business process.
Dur ing execution, real-time task status details are v isible from the job activity console of Enterpr ise Scheduler.
Additionally, the adapter per mits Infor matica users to cancel, abort, recover, or rerun w orkflow s from the scheduler, a
feature that provides added control over the Infor matica environment.
When a job is complete, the adapter returns its final output, w hich can then be used to control dow nstream jobs, as
w ell as details associated w ith the job run. Because Informatica jobs are defined like any other Enterprise Scheduler
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.
Seam less Support for Ad Hoc and Scheduled Inform atica Jobs
– Business unit managers frequently make ad
hoc ETL job requests that must be run on demand. Gradually, these jobs begin to be reused and fall into predictable
patterns. For efficiency, they should be organized into calendars or schedules . Enterprise Scheduler, in conjunction
w ith Informatica Pow erCenter, allow s ad hoc jobs to be easily transferred to standard production r uns, eliminating
manual intervention in the ETL job scheduling process. Wor king together, these tw o solutions also enab le IT
operations staff to incorporate Infor matica data management processes into established IT policies and to seamlessly
update run book operations.
Features Summary
Benefits Summary
Def ines, launches, and monitors any Inf ormatica service request
Lev erages existing technology and increases the return on investment
in Informatica
in Informatica
Connects Informatica to other platf orms, other applications, and
other Informatica instances with unlimited dependencies
other Informatica instances with unlimited dependencies
Reduces costs by consolidating Inf ormatica workf lows under one
corporate-wide scheduling console with one set of internal procedures
corporate-wide scheduling console with one set of internal procedures
Eliminates the need f or scripting to integrate Inf ormatica workf lows
Reduces maintenance requirements and accelerates ROI
Prov ides advanced error control and f ailure notification
Expedites problem resolution, improves trouble ticket clearance rates,
and enables IT to adhere to service lev el agreements (SLAs)
and enables IT to adhere to service lev el agreements (SLAs)
Collects and consolidates log file data and captures Informatica
process exit codes from jobs tasks and workflows
process exit codes from jobs tasks and workflows
Makes workflows more efficient by adding a rich source of data for
process trending and bottleneck remediation
process trending and bottleneck remediation