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).

Connectivity Summary

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

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.

 

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.

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

 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.