Informatica plugin deployment :- How do we call different integration service within same repository
search cancel

Informatica plugin deployment :- How do we call different integration service within same repository

book

Article ID: 241506

calendar_today

Updated On:

Products

ESP Workload Automation

Issue/Introduction

How do we call different integration service within same repository . 

We have one Repository with different integration service . How do we define them in Agent , how do we call them in jobs .

 

Environment

Release : 12.0

Component : ESP WORKLOAD AUTOMATION

Cause

No parameter to add to an Informatica job to denote a separate Integration Service.

Resolution

 

Agent looks for the informatica.properties file based on the target from the ESP job definition.

Example: AGENT_HOME/config/informatica/DX_Dev_XM_ASCII_IS/informatica.properties
Example: AGENT_HOME/config/informatica/DX_Dev_UNI_IS/informatica.properties
Example: AGENT_HOME/config/informatica/DX_Dev_XM_UNI_IS/informatica.properties

All of the informatica.properties can be named the same but different target/integration service names
with the same repository name as needed. So within each of the properties files,
they will contain the unique information for that unique integration service.

From an installation perspective, we only need to copy the default target(usually the host address)
and replicate it for as many targets as needed and rename accordingly. Then edit the
informatica.properties file with the specific information for each target/integration service.

INFORMATICA_JOB DX_EDW_COTIVITI_CS90_CLM_LOAD_OG_INSERT_INFAPLGN_DERE  

    USER CTM_DX_Dev                                                    
    AGENT VA10DUPINF002                                              
    FOLDER DX_Standard
    TARGET DX_Dev_XM_ASCII_IS
    WORKFLOW wf_DX_LOAD_LOG_INSERT_NON_GBD                            
    REPOSITORY DX_Dev_RS                                              
    PARAMETER_FILE $PMRootDIR/InfaParm/DX_EDW_COTIVITI/DX_EDW_COTIVITI_+
    CS90_CLM.parm                                                        
    RUN ANY                                                        
  ENDJOB        

INFORMATICA_JOB DX_EDW_COTIVITI_CS90_CLM_LOAD_OG_INSERT_INFAPLGN_JOHN 
    USER CTM_DX_Dev                                                    
    AGENT VA10DUPINF002
    TARGET DX_Dev_UNI_IS
    FOLDER DX_Standard                                                
    WORKFLOW wf_DX_LOAD_LOG_INSERT_NON_GBD                            
    REPOSITORY DX_Dev_RS                                              
    PARAMETER_FILE $PMRootDIR/InfaParm/DX_EDW_COTIVITI/DX_EDW_COTIVITI_+
    CS91_CLM.parm                                                        
    RUN ANY                                                        
  ENDJOB        
 
INFORMATICA_JOB DX_EDW_COTIVITI_CS90_CLM_LOAD_OG_INSERT_INFAPLGN_GHI                              USER CTM_DX_Dev                                                    
    AGENT VA10DUPINF002                                              
    FOLDER DX_Standard
    TARGET DX_Dev_XM_UNI_IS
    WORKFLOW wf_DX_LOAD_LOG_INSERT_NON_GBD                            
    REPOSITORY DX_Dev_RS                                              
    PARAMETER_FILE $PMRootDIR/InfaParm/DX_EDW_COTIVITI/DX_EDW_COTIVITI_+
    CS95_CLM.parm                                                        
    RUN ANY                                                        
  ENDJOB        
 
 
Sample connection profile from CTM

{
  "DX_DEV_XM_ASCII_IS": {
    "Type": "ConnectionProfile:Informatica",
    "Repository": "DX_Dev_RS",
    "User": "CTM_DX_Dev",
    "ConnectionType": "HTTPS",
    "PowerCenterDomain": "DX_Dev_Domain",
    "Port": "7344",
    "Host": "va10dupinf002.wellpoint.com",
    "IntegrationService": "DX_Dev_XM_ASCII_IS",
    "Password": "*****",
    "MaxConcurrentConnections": "100",
    "TargetAgent": "va10dupinf002",
    "TargetCTM": "CTM006"
  },
  "DX_DEV_UNI_IS": {
    "Type": "ConnectionProfile:Informatica",
    "Repository": "DX_Dev_RS",
    "User": "CTM_DX_Dev",
    "ConnectionType": "HTTPS",
    "PowerCenterDomain": "DX_Dev_Domain",
    "Port": "7344",
    "Host": "va10dupinf002.wellpoint.com",
    "IntegrationService": "DX_Dev_UNI_IS",
    "Password": "*****",
    "MaxConcurrentConnections": "100",
    "TargetAgent": "va10dupinf002",
    "TargetCTM": "CTM006"
  },
  "DX_DEV_XM_UNI_IS": {
    "Type": "ConnectionProfile:Informatica",
    "Repository": "DX_Dev_RS",
    "User": "CTM_DX_Dev",
    "ConnectionType": "HTTPS",
    "PowerCenterDomain": "DX_Dev_Domain",
    "Port": "7344",
    "Host": "va10dupinf002.wellpoint.com",
    "IntegrationService": "DX_Dev_XM_UNI_IS",
    "Password": "*****",
    "MaxConcurrentConnections": "100",
    "TargetAgent": "va10dupinf002",
    "TargetCTM": "CTM006"
  },
  "DX_DEV_ASCII_IS": {
    "Type": "ConnectionProfile:Informatica",
    "Repository": "DX_Dev_RS",
    "User": "CTM_DX_Dev",
    "ConnectionType": "HTTPS",
    "PowerCenterDomain": "DX_Dev_Domain",
    "Port": "7344",
    "Host": "va10dupinf002.wellpoint.com",
    "IntegrationService": "DX_Dev_ASCII_IS",
    "Password": "*****",
    "MaxConcurrentConnections": "100",
    "TargetAgent": "va10dupinf002",
    "TargetCTM": "CTM006"
  }
}