How to Install the Informatica Plugin

Products

• CA Workload Automation DE - System Agent (dSeries)
• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation Agent
• CA Workload Automation Agent
• CA Workload Automation Agents
• CA Workload Automation DE - Business Agents (dSeries)
• CA Workload Automation AE - System Agent (AutoSys)

Issue/Introduction

How to Install the Agent Plugin for Informatica

Resolution

Reference https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/workload-automation-agent-for-informatica/12-0/installing/install-ca-wa-agent-for-informatica/Configure-Informatica-Plugin.html#concept.dita_0e8193e5-433f-4ec0-965e-2ae231b8faba_libsLinux for listing of libraries, drivers and other files required for the Informatica plugin to work with the release of Informatica that you are running on each respective platform.
Notes:

1. These drivers are the IDP drivers that you will need to get from the Informatica server itself or from Informatica support. 
2. Windows drivers will not work on Linux/UNIX systems. Neither will Linux/UNIX drivers work on Windows.

Now that you've gathered the required files,

• Create a directory in the agent installation path called infa_drivers. 
    - Copy all of the IDP drivers you just gathered into the infa_drivers folder.
  
  
• Further down page, you will see section that talks about JARS. 
    - Download log4j-license.txt & log4j-1.2.8.jar from https://mvnrepository.com/artifact/log4j/log4j/1.2.8 and save them in the jars/ext directory located beneath the root of the agent.
    - Copy the pmserversdk.jar and jlmapi.jar files from your Informatica server; as documented, into the jars/ext directory beneath the root of the agent.
   
• Install the Informatica Plugin
    - Execute the PluginInstaller script as advised in the documentation and provide appropriate responses to the interview questions with respect to your Informatica environment. 
      Note: You will need to work with your Informatica support team if you are unsure about responses to any of the interview questions.
  
  
• Now that the plugin is installed, let's return to the documentation. Look for section titled "List of .res, .dat, .bin files"
    - Copy the 4 files mentioned from the Informatica server location as documented to the config/informatica/locale directory located beneath the root of the agent.
   
• Create a directory called security in the config/informatica/ folder located beneath the root of the agent.
    - Copy the below files from your Informatica server to this location:
           - infa_keystore.jks
           - infa_keystore.pem
           - infa_truststore.jks
           - infa_truststore.pem
  
  
• Copy the domains.infa file from your Informatica server to the config/informatica directory located beneath the root of the agent.
  
  
• Edit the cybAgent script
    - Add the full path to the infa_drivers directory that you created earlier (/opt/CA/WA_Agent/12_0/infa_drivers) to the LD_LIBRARY_PATH.
      Example:
             LD_LIBRARY_PATH="/opt/CA/WA_Agent/12_0:/opt/CA/WA_Agent/12_0/jre/lib/amd64/server:/opt/CA/WA_Agent/12_0/jre/lib/amd64:/opt/CA/WA_Agent/12_0/infa_drivers:$LD_LIBRARY_PATH"
             export LD_LIBRARY_PATH
    - Add the INFA_DOMAINS_FILE & INFA_TRUSTSTORE variables as documented and save the changes when done.
      Example:
             INFA_DOMAINS_FILE=/opt/CA/WA_Agent/12_0/config/informatica/domains.infa
             export INFA_DOMAINS_FILE
  
             INFA_TRUSTSTORE=/opt/CA/WA_Agent/12_0/config/informatica/security
             export INFA_TRUSTSTORE

• Back to the documentation, scroll down to the "Install JDBC Drivers for your Database" section.
    - Download the JDBC drivers for your database and copy them to the jars/ext directory located beneath the root of the agent.
  
  
• Finally, restart your agent and set up Informatica job for testing.