Overview

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

Core Connector Core connectors are included with all Alation platform tiers (subject to each tier’s connector limits) and are fully supported by Alation.

You can install and upgrade the connector using one of the following methods, depending on your Alation deployment type:

  • On-premise instances: Download the latest connector package from the Alation Customer Portal (Customer Portal > Connectors), then upload and install it in Alation.

  • Alation Cloud Service: Install and upgrade the connector directly from your instance without downloading the package. Any connector available on the Alation Customer Portal (Customer Portal > Connectors) can be installed and upgraded this way. See Install Connectors (Cloud-Native Architecture). You can also download the connector package from the Alation Customer Portal and install or upgrade it manually by uploading the Zip file.

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