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
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:
- Log in to the OvalEdge application
- Navigate to Administration > Connectors module.
- Click on the + icon, and the Manage Connection with Search Connector pop-up window is displayed.
- Select the connection type as Informatica ICS. The Manage Connection with Informatica ICS details pop-up window is displayed.
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. |
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.