Configure Connection

The Connection Configuration explains how to configure Redshift Database, S3 bucket, Reltio tenant, OCE, Anypoint queue and AWS SQS connection details using OA's Collection.

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

  2. Select IT Support in Business Unit and click Entity Collection.

  3. Search ODP.Admin.ConnectionStrings in Entity Collection and select View to open the connection strings collection.

  4. Verify whether the s3_connector system variable has a correct s3 bucket name, url and access key. If not, click Edit and then update the existing details with the correct details.

  5. Verify whether the database-default system variable has a correct snowflake database url, username and password details. If not, select Edit to update the existing details with correct details.

  6. Verify whether the database-streaming-default system variable has a correct snowflake database url, username and password details. If not, click to update the existing details with correct details.

  7. Click Add to add RDM tenant details, see below table for the details.

    Name Example Description
    System Name RDM_Reltio Note down this value to use it in future steps.

    type

    		RDM  
    password xyz Reltio tenant password
    description RDM Tenant Prod Any meaning full description
    additional properties

    limit=1000;

    tenant_id=<RDMTenant>;

    svc_host=rdm.reltio.com;

    client_id=cmVsdGlvX3VpOm1ha2l0YQ==

    		 Here replace <RDMTenant> with actual rdm tenant id.
    username abcd1234 RDM tenant username
    url https://361.reltio.com /reltio/api/bcQ231XyzLmnOpQRST Reltio tenant url

  8. Click Add to add Reltio tenant details, see below table for the details.

    Navigate to Data Pipeline > Data Pipeline Maintenance and under the general properties tab, enter the below details for System Name, Password, Description, URL and Username and then click Save. See the Figure and Table below for details.

    Name Example Description
    System Name mdm_test_IDP_TEGX_Automation Make sure to note this value which must be used while importing the task group templates.

    type

    		Reltio  
    password ************ Reltio tenant password
    description Customer Master Any meaning full description
    additional properties auth_host=auth.reltio.com;auth_path=/oauth/token;client_id=cmVsdGlvX3VpOm1ha2l0YQ== ;svc_host=test.reltio.com;export_svc_path=/jobs/export;export_status_svc_path=/reltio; tenant_id=0JItgeQask3TEGx;fileFormat=json;distributed=true;taskPartsCount=6;options=parallelExecution,resolveMergedEntities, resolveRelationEdgeTypes;partSize=100mb;activeness=ALL;s3Connection=s3_connector;s3Bucket=omch-

    Here RDM_Reltio is the value from previous step.

    All the semicolon separated values should be in single line without spaces in between.
    username INTEG_USER Reltio tenant username
    url https://test.reltio.com/reltio/api/0JItgeQask3TEGx Reltio tenant url

  9. Click Add to add OCE conenctions details, see below table for the details. Refer to OCE Connector section from IDP User Guide.

  10. Name Example Description
    System Name OCEP Make sure to note this value to use it in future steps.

    type

    		 OCE  
    password xyzabc OCE sales force Password
    description CRM Connector Any meaning full description
    additional properties

    authToken=;host=ocelexi-us.lightning.force.com;sfVersion=46.0;esbConnection=esb_default;

    s3Connection=s3_connector;s3Bucket=oaidp-dev-usv-iqviadev-odp;s3Folder=OCE_SFP

    Here replace <RDMTenant> with actual rdm tenant id.
    username (OCE username) axbycz@ocelexi-us.com OCE sales force user name
    url https://login.salesforce.com/services/Soap/u/46.0 OCE sales force url

     

  11. Click Add to add AWS SQS details, see below table for the details.

    Name Example Description
    System Name sqs_prod Make sure to note this value to use it in future steps.

    type

    		SQS  
    password xyzabc AWS Secret Key
    description Reltio AWS SQS Any meaning full description
    additional properties

    region=us-east-1;

    queue-name=mdm-mSPsWCYuJQkIcVw-sqs

    Here replace <RDMTenant> with actual rdm tenant id.
    username AKIAVANVLL3RLUGBXKTR AWS access key
    url https://sqs.us-east-1.amazonaws.com/344514584290/mdm-mSPsWCYuJQkIcVw-dev2-sqs AWS SQS url

  12. Click Add to add HTTP Connector Plugin details, see below table for the details.

    Name Example Description
    System Name anypoint-dev-2 Make sure to note this value to use it in future steps.

    type

    		HTTP  
    password  84fa685A86e04C21BCB0DD222de880Dd Password
    description HTTP Connector Plugin Any meaning full description
    additional properties

    authType=Basic;queueName=iqviaQueueLexiIntakeIDL;baseURLMethod=POST;httpConType=HTTP

     
    username 839e79a0ded4455cad6a99f969e7ba1d User Id
    url https://iqvia-ts-external-intake-1-1-d6-u.ext-lexi-pro-usv-d-pl1-p-r1.devops.lexi.solutions.iqvia.com/api/publishArrayToLexi? Url

     

  13. Logout from Orchestrated Analytics (IDP) platform.