How do we call different integration service within same repository for Informatica plugin
search cancel

How do we call different integration service within same repository for Informatica plugin

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  and how do we call them in jobs?

 

Environment

Release : 12.0
Component : ESP WORKLOAD AUTOMATION

Cause

No parameter to add 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/<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": "######"
  }
}