Previous Topic: How to Connect to an Additional Informatica Target ServerNext Topic: Create the Default Database Repository File


Create the Informatica Properties File

To connect to an additional Informatica target server, you first create an Informatica properties file.

Follow these steps:

  1. Create the following directory:
    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.

  2. Create a new properties file named informatica.properties in the directory you created using a text editor.
  3. 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 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.

    Note: The password must be encrypted. To encrypt a password, use the Password utility that is provided with the agent. For more information about the Password utility, see the CA Workload Automation Agent for UNIX, Linux, or Windows Implementation Guide.

  4. 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

Note: The properties for the default database repository will be stored in the Infa_Rep_Srv.properties file in the same directory.

More information:

Properties Files