Configure the Connection between Informatica MDM and IDP Pipeline

Prerequisites

The following are the prerequisite conditions:

Area Prerequisite
Configure Connections Make sure to configure the system name in ODP.Admin.ConnectionStrings of IDPs Entity Collections.
API System name Make sure to create the system name in ODP.Admin.ApiIntegrations of IDPs Entity Collections.

Create Connection between Informatica and IDP

To create a connection between IDP and Informatica MDM, you first need to create a system name in ODP.Admin.ConnectionStrings. Follow the below steps to create a system name.

  1. Login to Orchestrated Analytics (IDP tenant) with valid credentials.

  2. Go to IT Support page and from the System Integrator section, click Entity Collection.

  3. Search for ODP.Admin.ConnectionStrings and then click eye to open the ODP.Admin.ConnectionStrings.

  4. Click Add and enter the below details to create the new system name and click SAVE. See the figure below.

    Field Tab Details to Provide
    System Name System name can be anything that you want. Ex: INFORMATICA SAAS
    isHidden false
    type AppConnection
    password Enter the password provided
    description Informatica
    additionalProperties N/A
    username Enter the user name provided
    url https://dmp-us.informaticacloud.com/saas/public/core/v3/login

Similarly, create a system name in ODP.Admin.ApiIntegrations. Follow the below steps:

  1. ogin to Orchestrated Analytics (IDP tenant) with valid credentials.

  2. Go to IT Support page and from the System Integrator section, click Entity Collection.

  3. Search for ODP.Admin.ApiIntegrations and then click eye to open the ODP.Admin.ApiIntegrations.

  4. Click Add and enter the necessary details to create the new system name and then click SAVE. See the figure below.

Informatica Job Execution

Every new Ingress and Egress job that is created in the Informatica MDM must be executed by connecting to the IDP platform. To establish a connection between IDP and Informatica Ingress and Egress jobs, you must configure the below postman collections JSON request. This must be done only once for each new Ingress and Egress job.

Click to link below to view the postman collections JSON.

IDPInformaticaConfig.postman_collection

Follow the below steps to configure the Postman Collections JSON

  1. Open the file InformaticaPlugin...n_collection.json. See the figure below.

  2. Enter the jobid (as shown in the figure above).

  3. In case you do not provide the jobid, the source, entityType and the jobtype details must be provided.

  4. Save the file once you configure the postman collections with the required changes.

  5. Run the file in postman to establish the connection between IDP and Informatica jobs.

Configure the Postman Collections JSON

In order to successfully perform the execution of Ingress or Egress jobs in to Informatica MDM using IDP, you first need to configure certain parameters in the postman collections file and RUN it to establish a connection between IDP Pipeline and Informatica MDM.

Note:   

  • Since we do not have a dedicated UI in Informatica to execute Ingress or Egress jobs, user need to configure the JSON as per the requirement and run the Postman Collections to execute the Ingress or Egress jobs.

  • If the user provides the jobId, then the source and entityType fields are not required to be configured. If the user does not provide the jobid, then it is mandatory to provide the source and entityType.