Configuring (Optional)

After installing the agent, you might want to perform additional configuration tasks.
HID_Configuring
After installing the agent, you might want to perform additional configuration tasks, such as setting values for Informatica properties or specifying additional Informatica target servers. For information and instructions, see the following topics.
Set Values for Informatica Properties
You can set properties for Informatica in the agentparm.txt file. To see a list of these properties, with a description of each see Plug-In Specific Parameters.
Specify an Additional Informatica Target Server
During installation, the installer creates an Informatica properties file and a default database repository properties file based on the information you provided. You can create more properties files, as necessary, so that jobs can connect to multiple Informatica targets. To specify an additional Informatica target server use the following procedure.
Create a Directory for a New Target Server
To connect to an additional Informatica target server, you first create a directory for the property files.
Follow these steps:
 
  1. Create the following directory
    • On Linux:
      install_dir
      /config/informatica/
      infaTarget
    • On Windows:
      install_dir
      \config\informatica\
      infaTarget
      • install_dir
        Specifies the agent installation directory.
      • infaTarget
        Specifies the name of the Informatica target (
        infaTarget
        ). The 
        install_dir
        /config/informatica/
        infaTarget
         directory contains the properties for connecting to the Informatica server and one or more database repositories.
Create the Informatica Properties File
  1. Create a properties file named informatica.properties in the directory you created using a text editor.
  2. Add the following properties to the file:
    • informatica.domain.name
      Specifies the name of the Informatica server domain. An Informatica PowerCenter environment uses a domain to centralize the administration. A domain can contain multiple nodes. Each node is identified by a host and port. The domain name can be obtained from the domains.infa file.
    • informatica.service.name
      Specifies the name of the Informatica integration service. The integration service name can be obtained from the Informatica Workflow Designer.
    • informatica.repository.name.default
      Specifies the name of the default database repository that is created on the Informatica server. The repository can be obtained from the Informatica Administrative console. The 
      repositoryName
      .properties file for a specified Informatica target contains the database connection properties.
    • informatica.user.id.default
      Specifies the Informatica server user name.
    • informatica.password.default
      Specifies the password for the Informatica server user name.
      The password must be encrypted. To encrypt a password, use the Password utility that is provided with the agent.
    • informatica.security.domain.default
      Specifies the default name for the LDAP security domain.
  3. Save the informatica.properties file.
The Informatica properties file is created.
Example: Informatica Properties File
 
This example shows the Informatica properties in the informatica.properties file for a target server named ABCD. The informatica.properties file was created in the 
install_dir
/config/informatica/ABCD directory.
informatica.domain.name=LODMA0012 informatica.service.name=Infa_Int_Srv_T2 informatica.repository.name.default=Infa_Rep_Srv informatica.user.id.default=U_JAPI informatica.password.default=2415AC61385DB210
The properties for the default database repository will be stored in the Infa_Rep_Srv.properties file in the same directory.
Create the Default Database Repository File
After you create the informatica.properties file, you create the default database repository file in the same directory.
Follow these steps:
 
  1. Create a new properties file using a text editor. Name the file 
    repositoryName
    .properties, where 
    repositoryName
     corresponds to the value you specified in the informatica.repository.name.default property in the informatica.properties file.
  2. Add the following properties to the file:
    • informatica.db.type 
      Specifies the type of database.
    • informatica.db.user
      Specifies the user who has access to the database.
      Limits:
       Up to 30 characters; can include alphanumeric characters and the following special characters: pound (#), dollar symbol ($), and underscore (_)
      If you are using Microsoft SQL Server, the user can be a Windows domain user for Windows domain authentication. The format for Windows domain authentication is d
      omain_name
      \u
      ser_name
      .
    • informatica.db.password
      Specifies the password that corresponds to the default database user ID.
    • informatica.db.url
      Specifies the JDBC URL.
      Examples:
      jdbc:oracle:thin:@abcd:1521:orcl
      jdbc:jtds:sqlserver://lodma0012:1433/test
Consult with your database administrator or refer to an existing property file for JDBC URL format for your database.
Example: Default Database Repository File
 
This example shows the default database repository in the Infa_Rep_Srv.properties file:
informatica.db.type=Oracle informatica.db.user =INFA_REP informatica.db.password=43621DB580AC7251 informatica.db.url=jdbc:oracle:thin:@abcd:1521:orcl