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 and how do we call them in jobs?
Release : 12.0
Component : ESP WORKLOAD AUTOMATION
No parameter to add 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/<path>/ASCII_IS/informatica.properties
Example: AGENT_HOME/path>/UNI_IS/informatica.properties
Example: AGENT_HOME/path>/XM_UNI_IS/informatica.properties
All of the informatica.properties can be named the same, but have different target/integration service names with the same repository name.
Each of the properties files will contain unique information for that unique integration service.
For installation, we need to copy the default target(usually the host address) and replicate it for as many targets needed and rename accordingly.
Then edit the informatica.properties file with the specific information for each target/integration service.
INFORMATICA_JOB <your job name>_A
USER <username>
AGENT <agent name>
FOLDER <folder>
TARGET <target>ASCII_IS
WORKFLOW <workflow name>
REPOSITORY <repository>
PARAMETER_FILE $<parm file>
RUN ANY
ENDJOB
INFORMATICA_JOB <your job name>_B
USER <username>
AGENT <agent name>
TARGET <target>UNI_IS
FOLDER <folder>
WORKFLOW <workflow name>
REPOSITORY <repository>
PARAMETER_FILE $<parm file>
RUN ANY
ENDJOB
INFORMATICA_JOB <your job name>_C
USER <username>
AGENT <agent name>
FOLDER <folder>
TARGET <target>XM_UNI_IS
WORKFLOW <workflow name>
REPOSITORY <repository>
PARAMETER_FILE $<parm file>
RUN ANY
ENDJOB
Sample connection profile from CTM
{
"ASCII_IS": {
"Type": "ConnectionProfile:Informatica",
"Repository": "<repository>",
"User": "<username>",
"ConnectionType": "HTTPS",
"PowerCenterDomain": "<domain>",
"Port": "####",
"Host": "<agent name>.<domain>.com",
"IntegrationService": "ASCII_IS",
"Password": "#####",
"MaxConcurrentConnections": "###",
"TargetAgent": "<agent name>",
"TargetCTM": "######"
},
"UNI_IS": {
"Type": "ConnectionProfile:Informatica",
"Repository": "<repository>",
"User": "<username>",
"ConnectionType": "HTTPS",
"PowerCenterDomain": "<domain>",
"Port": "####",
"Host": "<agent name>.<domain>.com",
"IntegrationService": "UNI_IS",
"Password": "#####",
"MaxConcurrentConnections": "###",
"TargetAgent": "<agent name>",
"TargetCTM": "######"
},
"XM_UNI_IS": {
"Type": "ConnectionProfile:Informatica",
"Repository": "<repository>",
"User": "<username>",
"ConnectionType": "HTTPS",
"PowerCenterDomain": "<domain>",
"Port": "####",
"Host": "<agent name>.<domain>.com",
"IntegrationService": "XM_UNI_IS",
"Password": "#####",
"MaxConcurrentConnections": "###",
"TargetAgent": "<agent name>",
"TargetCTM": "######"
},
"ASCII_IS": {
"Type": "ConnectionProfile:Informatica",
"Repository": "<repository>",
"User": "<username>",
"ConnectionType": "HTTPS",
"PowerCenterDomain": "<domain>",
"Port": "####",
"Host": "<agent name>.<domain>.com",
"IntegrationService": "ASCII_IS",
"Password": "#####",
"MaxConcurrentConnections": "###",
"TargetAgent": "<agent name>",
"TargetCTM": "######"
}
}