Informatica PowerCenter Connector: Overview

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

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

../../../_images/InformaticaPC_01.png