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 .
Release : 12.0
Component : ESP WORKLOAD AUTOMATION
No parameter to add to an Informatica job to denote a separate Integration Service.
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"
}
}