Informatica ICS Connector

An out-of-the-box connector is available for Informatica. It provides support for PowerCenter and Intelligent Cloud Services (ICS) for data integration components.

The connector supports the crawling of datasets from ICS (Connection, Connectors, Tasks, Mapping Template Tasks, Mapping Template) and Lineage building for ICS (Mapping Template Task).

Informatica ICS

Connectivity Summary

Edition Version Support
ICS Feb’22 API Version Supported

Technical Specification

Feature

Supported Objects

Remarks

Crawling(ICS)

Connections

Supported

Connectors

Supported

Tasks

Supported

Mapping Template Task

Supported

Mapping Template

Supported

Crawl Parameter Files

 

Informatica uses parameter files to override connection and source/target objects in runtime. We require access to read parameter files to link the correct source or target during the lineage-building process.

Lineage Building

Table lineage

Supported

Column lineage

Supported

 

Order By

Supported

Prerequisites 

The following are prerequisites required for the connection of Informatica ICS.

  • Connection details as specified in the following section should be available.

User Permissions

An admin/service account is required for crawling. The minimum privileges required to connect to the source system are as follows:

Operation 

Access Permission

Connection validation

Designer

Crawl Folders

Designer

Crawl Workflows, Mappings etc

Designer

Lineage Building

Designer

The following are the minimum permissions required for OvalEdge to validate the Informatica ICS connection. 

Permission: READ (Meta Read and Data Read)

Roles: Crawler Admin 

Super User: OE ADMIN

Note: Navigate to Configuration  > Users & Roles for roles and permission.

Connection Details

To connect to Informatica ICS using the OvalEdge application, complete the following steps:

  1. Log in to the OvalEdge application
  2. Navigate to Administration > Connectors module.
  3. Click on the + icon, and the Manage Connection with Search Connector pop-up window is displayed.
  4. Select the connection type as Informatica ICS. The Manage Connection with Informatica ICS details pop-up window is displayed.

 23

5. The following are the field attributes required for the connection of Informatica ICS.

Field Name

Mandatory/Optional

Description

Connection Type

Mandatory

By default the selected connection type is displayed as the Informatica ICS. 

License Type

Mandatory

Select the License type as standard/Auto Lineage.

Connection Name

Mandatory

Enter the name of the connection, the connection name specified in the Connection Name textbox will be a reference to the Informatica ICS connection in the OvalEdge application.

Example: Informatica ICS Connection1

Login Via

Optional

Select the Authentication type from the drop-down list.

Server

Mandatory

Enter the server name.

Example: https://dm-us.informaticacloud.com/ https://dm-ap.informaticacloud.com/ https://dm-em.informaticacloud.com

Note: The server name will be one of the above three based on the region of the data center.

User Name

Mandatory

Username for Informatica ICS Server account

Password

Mandatory

Password for  Informatica ICS Server account

Parameter Files Directory

Mandatory

Informatica uses parameter files to override connection and source/target objects in runtime. Access is required to read parameter files to link the correct source or target during the lineage-building process.
Example: https://ovaledge.s3.us-west-1.amazonaws.com/OvalEdge+Clients/Twitch+Poc/Documents/Parameters.txt

Default Governance Roles

Mandatory

From the dropdown list, select Stewards, Custodian, Owner, GovernanceRole4, GovernanceRole5, and GovernanceRole6.

No Of Archive Objects

Mandatory

Select the toggle button to set the if the user wants to enter the count of no. of the archive objects. 

Select Bridge

Optional

Select option NO Bridge if no bridge is available for connector 

6.Once after entering the connection details in the required fields, click on the Save button or Save & Configure to establish the connection and configure the connection settings. Here when you click on the Save & Configure button, the Connection Settings pop-up window is displayed. Where you can configure the connection settings for the selected Connector.

Note: The Save & Configure button is displayed only for the Connectors for which the settings configuration is required.

7. Click on the Validate button to validate the entered connection details. 

Note: It is up to the user’s wish, to save the connections details first or to validate the connection first, and then save it. 

 Error Validation Details  

Error Messages

Description

Failed to establish connection, Please check the credentials(User name, Password, Server name, etc.,)

In case of invalid user name, wrong password, invalid Server name 

Connection Settings 

Lineage

Only the Lineage setting option is available for the Informatica ICS Connector, and the setting option will be enabled when the Auto Lineage License type is selected.

The purpose of the lineage setting is to serve the option of changing the server/source connection to build the lineage. You can configure multiple servers simultaneously in the  Selecting Source Server Type for lineage and also set the connection priority lists to pick the tables in the Connections Priority to pick the source table for lineage building.

FAQs

What features does Informatica ICS support?
Ans: Currently Informatica ICS supports only Cloud Integration from ICS.

Can you explain lineage in ICS?

Ans: Connector builds lineage for ICS as mentioned below:
Builds Table Lineage between Sources, Mapping, and Targets.