Informatica PowerCenter Connector: Overview¶
The OCF Connector for Informatica PowerCenter was developed by Alation.
To download the Informatica PowerCenter OCF connector package, go to the Alation Connector Hub available from the Customer Portal. Go to Customer Portal > Connectors > Alation Connector Hub. Only Alation users with access to the Customer Portal can access the Alation Connector Hub. If you don’t have access to the Customer Portal, contact Alation Support.
This connector should be used to catalog Informatica PowerCenter metadata for the following data sources:
Oracle
DB2
SQL Server
This connector extracts Informatica PowerCenter Repository objects such as folders, mappings, transformations, sessions, and workflows. Users will be able to search and find Informatica PowerCenter objects, curate Informatica PowerCenter object pages, and understand the business transformation on their data from the Alation user interface.
Team¶
The following administrators are required to install this connector:
Alation Server Admin:
Installs the connector
Creates a Informatica PowerCenter source
Scope¶
The table below shows what features are covered by this connector:
Feature |
Scope |
Availability |
|---|---|---|
Data source |
List of source tables List and count of all extracted tables List of source tables used in mappings List of source tables used as shortcuts List of source tables, mapping names, and source database names |
Yes |
Schema |
List of all the folders in the repository |
Yes |
Table |
List of target tables |
Yes |
Table.Columns |
List of target columns |
Yes |
Table.Columns.DataType |
List of target column datatypes |
Yes |
Transformation |
List of all transformations |
Yes |
Expression |
List of all expression transformations that use the concat function List of all port details of an expression transformations List of all expression transformation port links |
Yes |
Joiner |
List of joiner transformations |
Yes |
Aggregator |
List of aggregator transformations |
Yes |
Router |
List of router transformations |
Yes |
Sorter |
List of sorter transformations |
Yes |
Filter |
List of filter transformations |
Yes |
Normalizer |
List of normalizer transformations |
Yes |
Sequence |
List of sequence generator value List of sequence transformations |
Yes |
Lookup |
List of tables used as lookups Lookup SQL |
Yes |
Stored Procedures |
List of stored procedures transformations |
Yes |
External Procedures |
List of external procedures transformations |
Yes |
Sessions |
List session names |
Yes |
Workflow |
List workflow names List workflows whose server is not assigned |
Yes |
Worklet |
List worklet names List hierarchies of all workflows and it worklets |
Yes |
Domain |
Domain information |
No |
Repository |
Repository information |
Yes |
Folder |
List folder details List of shared folders List of users and groups having privileges on folders List of folder owners |
Yes |
SQL Override |
SQL and lookup SQL List of transformation using SQL overrides |
Yes |
Informatica PowerCenter Object Hierarchy¶
