Table of Contents

Search

  1. Installation Overview
  2. Before You Install the Services
  3. Service Installation
  4. After You Install the Services
  5. Client Installation
  6. Uninstallation
  7. Starting and Stopping Informatica Services
  8. Connecting to Databases from Windows
  9. Connecting to Databases from UNIX
  10. Updating the DynamicSections Parameter of a DB2 Database
  11. Installation and Configuration Checklist
  12. Split Domain Configuration for Metadata Manager

Installation and Configuration Guide

Installation and Configuration Guide

Configuring the Properties File

Configuring the Properties File

Informatica provides a sample properties file that includes the parameters that are required by the installer. You can customize the sample properties file to specify the options for your installation. Then run the silent installation.
The sample SilentInput.properties file is stored in the root directory of the DVD or the installer download location. After you customize the file, re-save it with the file name SilentInput.properties.
  1. Go to the root of the directory that contains the installation files.
  2. Locate the sample
    SilentInput.properties
    file.
  3. Create a backup copy of the SilentInput.properties file.
  4. Use a text editor to open the file and modify the values of the installation parameters.
    The following table describes the installation parameters that you can modify:
    Property Name
    Description
    LICENSE_KEY_LOC
    Absolute path and file name of the license key file.
    USER_INSTALL_DIR
    Directory in which to install Informatica.
    INSTALL_TYPE
    Indicates whether to install or upgrade Informatica.
    If the value is 0, the installer performs a fresh installation of Informatica. If the value is 1, the installer upgrades a previous version of Informatica.
    UPGRADE_WITHOUT_BIGDATA
    Informatica does not support big data products for version 10.1.1 HotFix 2. If you want to install or upgrade to this version, the big data functionality will not be available.Set the value to 1, to continue with the upgrade.Set the value to 0, to quit the upgrade
    ENABLE_KERBEROS
    Indicates whether to configure the Informatica domain to run on a network with Kerberos authentication.
    To configure the Informatica domain to run on a network with Kerberos authentication, set this parameter to 1.
    SERVICE_REALM_NAME
    Name of the Kerberos realm to which the Informatica domain services belong. The service realm name and the user realm name must be the same.
    USER_REALM_NAME
    Name of the Kerberos realm to which the Informatica domain users belong. The service realm name and the user realm name must be the same.
    KEYTAB_LOCATION
    Directory where all keytab files for the Informatica domain are stored. The name of a keytab file in the Informatica domain must follow a format set by Informatica.
    KRB5_FILE_LOCATION
    Path and file name of the Kerberos configuration file. Informatica requires the following name for the Kerberos configuration file: krb5.conf
    SPN_SHARE_LEVEL
    Indicates the service principal level for the domain. Set the property to one of the following levels:
    • Process. The domain requires a unique service principal name (SPN) and keytab file for each node and each service on a node. The number of SPNs and keytab files required for each node depends on the number of service processes that run on the node. Recommended for production domains.
    • Node. The domain uses one SPN and keytab file for the node and all services that run on the node. It also requires a separate SPN and keytab file for all HTTP processes on the node. Recommended for test and development domains.
    Default is process.
    HTTPS_ENABLED
    Indicates whether to secure the connection to Informatica Administrator. If the value is 0, the installer sets up an unsecure HTTP connection to Informatica Administrator. If the value is 1, the installer sets up a secure HTTPS connection to Informatica Administrator.
    DEFAULT_HTTPS_ENABLED
    Indicates whether the installer creates a keystore file.
    If the value is 1, the installer creates a keystore and uses it for the HTTPS connection. If the value is 0, the installer uses a keystore file that you specify.
    CUSTOM_HTTPS_ENABLED
    Indicates whether the installer uses an existing keystore file.
    If the value is 1, the installer uses a keystore file that you specify. If DEFAULT_HTTPS_ENABLED=1, you must set this parameter to 0. If DEFAULT_HTTPS_ENABLED=0, you must set this parameter to 1.
    KSTORE_PSSWD
    Plain text password for the keystore file.
    KSTORE_FILE_LOCATION
    Absolute path and file name of the keystore file.
    HTTPS_PORT
    Port number to use for the secure connection to Informatica Administrator.
    CREATE_DOMAIN
    Indicates whether to create an Informatica domain.
    If the value is 1, the installer creates a node and an Informatica domain. If the value is 0, the installer creates a node and joins the node to another domain created in a previous installation.
    KEY_DEST_LOCATION
    Directory in which to store the encryption key on the node created during the installation.
    PASS_PHRASE_PASSWD
    Keyword to use to create an encryption key to secure sensitive data in the domain. The keyword must meet the following criteria:
    • From 8 to 20 characters long
    • Includes at least one uppercase letter
    • Includes at least one lowercase letter
    • Includes at least one number
    • Does not contain spaces
    JOIN_DOMAIN
    Indicates whether to join the node to another domain created in a previous installation.
    If the value is 1, the installer creates a node and joins the node to another domain. If CREATE_DOMAIN=1, you must set this parameter to 0. If CREATE_DOMAIN=0, you must set this parameter to 1.
    KEY_SRC_LOCATION
    Directory that contains the encryption key on the master gateway node of the Informatica domain that you want to join.
    SSL_ENABLED
    Enables or disables secure communication between services in the Informatica domain.
    Indicates whether to set up secure communication between services within the domain. If the value is true, secure communication between services within the domain is enabled. You can set this property to true if CREATE_DOMAIN=1. You must set this property to true if JOIN_DOMAIN=1.
    SECURITY_DOMAIN_NAME
    Name of the default security domain in the domain to which you join the node you create.
    TLS_CUSTOM_SELECTION
    Indicates whether to use SSL certificates that you provide to enable secure communication in the Informatica domain.
    To use SSL certificates that you provide, set this property to True.
    NODE_KEYSTORE_DIR
    Required if TLS_CUSTOM_SELECTION is set to True. Directory that contains the keystore files. The directory must contain files named infa_keystore.jks and infa_keystore.pem.
    NODE_KEYSTORE_PASSWD
    Required if TLS_CUSTOM_SELECTION is set to True. Password for the keystore infa_keystore.jks.
    NODE_TRUSTSTORE_DIR
    Required if TLS_CUSTOM_SELECTION is set to True. Directory that contains the truststore files. The directory must contain files named infa_truststore.jks and infa_truststore.pem.
    NODE_TRUSTSTORE_PASSWD
    Required if TLS_CUSTOM_SELECTION is set to True. Password for the infa_truststore.jks file.
    SERVES_AS_GATEWAY
    Indicates whether to create a gateway or worker node.
    If the value is 1, the installer configures the node as a gateway node. If the value is 0, the installer configures the node as a worker node.
    DB_TYPE
    Database for the domain configuration repository. Enter one of the following values:
    • Oracle
    • MSSQLServer
    • DB2
    • Sybase
    DB_UNAME
    Database user account name for the domain configuration repository.
    DB_PASSWD
    Password for the database user account.
    DB_SSL_ENABLED
    Indicates whether the database for the domain configuration repository is secure. To create the domain configuration repository in a secure database, set this parameter to True. If this parameter is set to True, you must provide the JDBC connection string with the secure database parameters.
    TRUSTSTORE_DB_FILE
    Path and file name of the truststore file for the secure domain configuration repository database.
    If the domain that you create or join uses a secure domain configuration repository, set this property to the truststore file of the repository database.
    TRUSTSTORE_DB_PASSWD
    Password for the truststore file for the secure domain configuration repository database.
    SQLSERVER_SCHEMA_NAME
    For Microsoft SQL Server. Name of the schema that will contain domain configuration tables. If this parameter is empty, the installer creates the tables in the default schema.
    TRUSTED_CONNECTION
    For Microsoft SQL Server. Indicates whether to connect to Microsoft SQL Server through a trusted connection. If this parameter is empty, the installer uses Microsoft SQL Server authentication.
    Set this parameter only if you are installing on Windows.
    DB2_TABLESPACE
    For IBM DB2. Name of the tablespace in which to create the tables. Specify a tablespace that meets the pageSize requirement of 32768 bytes.
    In a single-partition database, if DB2_TABLESPACE is empty, the installer creates the tables in the default tablespace. In a multi-partition database, define the tablespace in the catalog partition of the database.
    DB_CUSTOM_STRING_SELECTION
    Determines whether to use a JDBC URL or a custom connection string to connect to the domain configuration database.
    If the value is 0, the installer creates a JDBC URL from the database properties you provide. If the value is 1, the installer uses the custom connection string you provide. If you create the domain configuration repository on a secure database, set this parameter to 1.
    DB_SERVICENAME
    Required if DB_CUSTOM_STRING_SELECTION=0.
    Service name for Oracle and IBM DB2 databases.
    Database name for Microsoft SQL Server and Sybase ASE.
    DB_ADDRESS
    Required if DB_CUSTOM_STRING_SELECTION=0.
    Host name and port number for the database instance in the format
    HostName
    :
    Port
    .
    ADVANCE_JDBC_PARAM
    You can set this parameter if DB_CUSTOM_STRING_SELECTION=0.
    Optional parameters to include in the JDBC URL connection string. Verify that the parameter string is valid. The installer does not validate the parameter string before it adds the string to the JDBC URL. If this parameter is empty, the installer creates the JDBC URL without additional parameters.
    DB_CUSTOM_STRING
    Required if DB_CUSTOM_STRING_SELECTION=1.
    Valid custom JDBC connection string.
    DOMAIN_NAME
    If you create a domain, name of the domain to create.
    If you join a domain, name of the domain to join that was created in a previous installation.
    The default domain name is Domain_<
    MachineName
    >. The name must not exceed 128 characters and must be 7-bit ASCII only. It cannot contain a space or any of the following characters: ` % * + ; " ? , < > \ /
    DOMAIN_HOST_NAME
    If you create a domain, this is the host name of the machine on which to create the node. The node host name cannot contain the underscore (_) character. If the machine has a single network name, use the default host name. If the machine has multiple network names, you can modify the default host name to use an alternate network name. Optionally, you can use the IP address.
    If you join a domain, this is the host name of the machine that hosts the gateway node of the domain you want to join.
    Note: Do not use localhost. The host name must explicitly identify the machine.
    NODE_NAME
    Required if CREATE_DOMAIN=1.
    Name of the node to create on this machine. The node name is not the host name for the machine.
    DOMAIN_PORT
    If you create a domain, this is the port number for the node to create. The default port number for the node is 6005. If the default port number is not available on the machine, the installer displays the next available port number.
    If you join a domain, this is the port number of the gateway node of the domain you want to join.
    DOMAIN_USER
    User name for the domain administrator.
    If you create a domain, you can use this user name to initially log in to Informatica Administrator. Use the following guidelines:
    • The name is not case sensitive and cannot exceed 128 characters.
    • The name cannot include a tab, newline character, or the following special characters: % * + \ / ' . ? ; < >
    • The name can include an ASCII space character except for the first and last character. Other space characters are not allowed.
    If you join a domain, this is the user name to use to log in to the domain that you want to join.
    DOMAIN_PSSWD
    Password for the domain administrator. The password must be more than 2 characters but cannot exceed 16 characters.
    DOMAIN_CNFRM_PSSWD
    Enter the password again to confirm.
    SAML_AUTHENTICATION
    Required if ENABLE_KERBEROS=0.
    Set this parameter to True to configure Security Assertion Markup Language (SAML)-based single sign-on (SSO) support for web-based Informatica applications in an Informatica domain. If this parameter is set to True, you must provide the IDP URL.
    Default is true (0).
    IDP_URL
    Required if ENABLE_KERBEROS=0 and SAML_AUTHENTICATION=True.
    Enter the Identity Provider URL for the domain.
    JOIN_NODE_NAME
    Required if JOIN_DOMAIN=1.
    Name of the node that you are joining to the domain. The node name is not the host name for the machine.
    JOIN_HOST_NAME
    Required if JOIN_DOMAIN=1.
    Host name of the machine on which to create the node that you are joining to the domain. The node host name cannot contain the underscore (_) character.
    Note: Do not use localhost. The host name must explicitly identify the machine.
    JOIN_DOMAIN_PORT
    Required if JOIN_DOMAIN=1.
    Port number of the gateway node of the domain that you want to join.
    ADVANCE_PORT_CONFIG
    Indicates whether to display the list of port numbers for the domain and node components. If the value is 0, the installer assigns default port numbers to the domain and node components. If the value is 1, you can set the port numbers for the domain and node components.
    MIN_PORT
    You can set this parameter if ADVANCE_PORT_CONFIG=1.
    Lowest port number in the range of dynamic port numbers that can be assigned to the application service processes that run on this node.
    MAX_PORT
    You can set this parameter if ADVANCE_PORT_CONFIG=1.
    Highest port number in the range of dynamic port numbers that can be assigned to the application service processes that run on this node.
    TOMCAT_PORT
    You can set this parameter if ADVANCE_PORT_CONFIG=1.
    Port number used by the Service Manager on the node. The Service Manager listens for incoming connection requests on this port. Client applications use this port to communicate with the services in the domain. This is the port that the Informatica command line programs use to communicate to the domain. This is also the port for the SQL data service JDBC/ODBC driver. Default is 6006.
    AC_PORT
    You can set this parameter if CREATE_DOMAIN=1 and ADVANCE_PORT_CONFIG=1.
    Port number used by Informatica Administrator. Default is 6007.
    SERVER_PORT
    You can set this parameter if ADVANCE_PORT_CONFIG=1.
    Port number that controls server shutdown for the domain Service Manager. The Service Manager listens for shutdown commands on this port. Default is 6008.
    AC_SHUTDWN_PORT
    You can set this parameter if CREATE_DOMAIN=1 and ADVANCE_PORT_CONFIG=1.
    Port number that controls server shutdown for Informatica Administrator. Informatica Administrator listens for shutdown commands on this port. Default is 6009.
    ENABLE_USAGE_COLLECTION
    Enables Informatica DiscoveryIQ, a product usage tool that sends routine reports on data usage and system statistics to Informatica. Informatica DiscoveryIQ uploads data to Informatica 15 minutes after you install and configure Informatica domain. Thereafter, the domain sends the data every 30 days. You can choose to not send any usage statistics to Informatica. For more information on how to disable sending usage statistics, see the
    Informatica Administrator Guide
    .
    You must set the value to 1 to apply the hotfix.
  5. Optionally, create a Model Repository Service and a Data Integration Service during installation.
    The following table describes the properties that you set if you want to create a Model Repository Service and a Data Integration Service during installation:
    Property
    Description
    CREATE_SERVICES
    Enables creation of Model Repository Service and Data Integration Service during installation.
    Set the value to 1 to enable service creation during installation. Default is 0.
    KERBEROS_SECURITY_DOMAIN_NAME
    Kerberos security domain name.
    You must enter the Kerberos security domain name if the domain is enabled for Kerberos authentication.
    KERBEROS_DOMAIN_PSSWD
    Kerberos security domain password.
    You must enter the Kerberos security domain password if the domain is enabled for Kerberos authentication.
    MRS_DB_TYPE
    The Model repository database type.
    Enter one of the following values:
    • Oracle
    • DB2
    • MSSQLServer
    MRS_DB_UNAME
    Database user account name for the Model repository database.
    MRS_DB_PASSWD
    Password for the database user account.
    MRS_DB_SSL_ENABLED
    Indicates whether the database for the Model repository database is secure. To create the Model repository database in a secure database, set this parameter to True. If this parameter is set to True, you must provide the JDBC connection string with the secure database parameters.
    MRS_SSL_DEFAULT_STRING
    Security parameters for the JDBC connection string used to connect to the Model repository database. For example:
    EncryptionMethod=SSL;HostNameInCertificate=;ValidateServerCertificate=
    TRUSTSTORE_MRS_DB_FILE
    Path and file name of the truststore file for the secure Model repository database.
    TRUSTSTORE_MRS_DB_PASSWD
    Password for the truststore file for the secure Model repository database.
    MRS_SQLSERVER_SCHEMA_NAME
    For Microsoft SQL Server. Name of the schema that will contain the Model repository tables. If this parameter is empty, the installer creates the tables in the default schema.
    MRS_DB2_TABLESPACE
    For IBM DB2. Name of the tablespace in which to create the tables for the Model repository. Specify a tablespace that meets the pageSize requirement of 32768 bytes.
    In a single-partition database, if DB2_TABLESPACE is empty, the installer creates the tables in the default tablespace. In a multi-partition database, define the tablespace in the catalog partition of the database.
    MRS_DB_CUSTOM_STRING_SELECTION
    Determines whether to use a JDBC URL or a custom connection string to connect to the Model repository database.
    If the value is 0, the installer creates a JDBC URL from the database properties you provide. If the value is 1, the installer uses the custom connection string you provide. If you create the Model repository database on a secure database, set this parameter to 1.
    MRS_DB_SERVICENAME
    Service or database name for the Model repository database. Required if MRS_DB_CUSTOM_STRING_SELECTION=0.
    If the Model repository is on an Oracle or IBM DB2 database, set the property to the service name. If the Model repository is on a Microsoft SQL Server or Sybase ASE database, set the property to the database name.
    MRS_DB_ADDRESS
    Required if MRS_DB_CUSTOM_STRING_SELECTION=0.
    Host name and port number for the database instance in the format
    HostName
    :
    Port
    .
    MRS_ADVANCE_JDBC_PARAM
    You can set this parameter if MRS_DB_CUSTOM_STRING_SELECTION=0.
    Optional parameters to include in the JDBC URL connection string. Verify that the parameter string is valid. The installer does not validate the parameter string before it adds the string to the JDBC URL. If this parameter is empty, the installer creates the JDBC URL without additional parameters.
    MRS_DB_CUSTOM_STRING
    Required if MRS_DB_CUSTOM_STRING_SELECTION=1.
    Valid custom JDBC connection string.
    MRS_SERVICE_NAME
    Name of the Model Repository Service.
    MRS_KEYTAB_FILELOC
    Required if ENABLE_KERBEROS=1 and SPN_SHARE_LEVEL=PROCESS
    Directory where the keytab file for the Model Repository Service is stored. The name of a keytab file in the Informatica domain must follow a format set by Informatica.
    DIS_SERVICE_NAME
    Name of the Data Integration Service.
    DIS_KEYTAB_FILELOC
    Required if ENABLE_KERBEROS=1 and SPN_SHARE_LEVEL=PROCESS
    Directory where the keytab file for the Data Integration Service is stored. The name of a keytab file in the Informatica domain must follow a format set by Informatica.
    DIS_PROTOCOL_TYPE
    HTTP protocol type of the Data Integration Service.
    Use one of the following values:
    • http
    • https
    • both
    DIS_HTTP_PORT
    Required if DIS_PROTOCOL_TYPE is http or both.
    HTTP port of the Data Integration Service.
    DIS_HTTPS_PORT
    Required if DIS_PROTOCOL_TYPE is https or both.
    HTTPS port of the Data Integration Service.
    DIS_CUSTOM_SELECTION
    Optional parameter if you set the value of DIS_PROTOCOL_TYPE to https or both.
    If you set the value to true, you provide the SSL certificates to secure the Data Integration Service. You must provide the keystore and truststore files to use to secure the Data Integration Service.
    DIS_KEYSTORE_DIR
    Required if DIS_CUSTOM_SELECTION is set to true.
    Location of the keystore file for the Data Integration Service.
    DIS_KEYSTORE_PASSWD
    Required if DIS_CUSTOM_SELECTION is set to true.
    Password of the keystore file for the Data Integration Service.
    DIS_TRUSTSTORE_DIR
    Required if DIS_CUSTOM_SELECTION is set to true.
    Location of the truststore file for the Data Integration Service.
    DIS_TRUSTSTORE_PASSWD
    Required if DIS_CUSTOM_SELECTION is set to true.
    Password for the truststore file for the Data Integration Service.
  6. On Windows, specify whether to run the Informatica service under the same user account as the account used for installation.
    The following table describes the properties that you set if you want to run the Informatica service under a different user account:
    Property
    Description
    USE_LOGIN_DETAILS
    Indicates whether to run the Windows service under a different user account. If the value is 0, the installer configures the service to run under the current user account. If the value is 1, the installer configures the service to run under a different user account.
    WIN_USER_ID
    User account with which to run the Informatica Windows service.
    Use the following format:
    <domain name>\<user account>
    This user account must have the Act as operating system permission.
    WIN_USER_PSSWD
    Password for the user account with which to run the Informatica Windows service.
  7. Save the properties file with the name SilentInput.properties.