Overview

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

The connector for Informatica CDI is available as a Zip file that can be uploaded and installed in the Alation application. The latest connector package can be downloaded from the Alation Customer Portal (Customer Portal > Connectors).

Use the instructions given in this guide to install and manage the connector.

Use this connector to catalog Informatica data sources o n Alation on-premise and Cloud Service instances. It extracts Informatica objects such as Informatica Mappings, Informatica Sources or Targets, Informatica Columns, and other metadata. You can search and find Informatica objects and understand the transformation of the data using Lineage diagrams.

Team

You may need the assistance of your database administrator to configure this data source.

• Informatica administrator:

  • Provides the Informatica CDI user account

• Alation Server Admin:

  • Ensures that Alation Connector Manager is installed and running or installs it.

  • Installs the connector.

  • Performs initial extraction and prepares the data source for Alation users.

Scope

The table below lists the features supported by the connector.

Feature	Scope	Availability
Authentication
Basic (username and password)	Authentication using the IICS user account’s username and password
SSL	Connection over the TLS protocol
Kerberos	Authentication with the Kerberos protocol
Metadata extraction (MDE)
Default MDE	Extraction of metadata from Informatica
Query-based MDE	Extraction of metadata based on custom extraction queries provided by a user
Extracted metadata objects
Schemas	List of Informatica Mappings
Tables	List of Informatica Source or Targets
Columns	List of columns
Column data types	Column data types
Views	List of views	Not applicable
Source comments	Source comments	Not applicable
Primary keys	Primary key information for extracted tables
Foreign keys	Foreign key information for extracted tables
Functions	Extraction of function metadata
Function Definitions	Extraction of function definition metadata
Sampling and Profiling - Not supported
Query Log Ingestion (QLI) - Not supported
Lineage
Table-level Lineage	Table-level lineage for Informatica source to target
External table file lineage	Lineage for external tables
Column-level lineage	Calculation of lineage data at the column level
Compose - Not supported

Object Mapping

Informatica Object	Alation Object
Informatica Mappings	Schema
Informatica Sources Informatica Targets	Table
Informatica Columns	Columns