Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Connecting to Databases from UNIX or Linux

Installation for Enterprise Data Preparation

Installation for Enterprise Data Preparation

Creating the Model Repository Service

Creating the Model Repository Service

Perform the following steps to create the Model Repository Service:
  1. Name of the Model Repository Service.
  2. Name of the node on which the Model Repository Service must run.
  3. The license that you want to associate with the Model Repository Service.
  4. Select the database that you want to configure for the Model repository from the following options:
    • Oracle
    • SQL Server
    • DB2
    • PostgreSQL
    Default is Oracle.
  5. Type the username to access the database in the
    Database user ID
    parameter and press
    Enter
    . Default is
    admin
    .
  6. Type the password for the username in the
    User password
    parameter and press Enter.
  7. Press
    1
    if the database is secured with SSL.
    If you selected the option to specify that the database is SSL-enabled, provide the following parameters:
    Secure Database Parameter
    Description
    EncryptionMethod
    Indicates whether data is encrypted when transmitted over the network. This parameter must be set to SSL.
    ValidateServerCertificate
    Indicates whether Informatica validates the certificate that the database server sends.
    If this parameter is set to True, Informatica validates the certificate that the database server sends. If you specify the HostNameInCertificate parameter, Informatica also validates the host name in the certificate.
    If this parameter is set to False, Informatica does not validate the certificate that the database server sends. Informatica ignores any truststore information that you specify.
    HostNameInCertificate
    Host name of the machine that hosts the secure database. If you specify a host name, Informatica validates the host name included in the connection string against the host name in the SSL certificate.
    cryptoProtocolVersion
    Specifies the cryptographic protocol to use to connect to a secure database. You can set the parameter to cryptoProtocolVersion=TLSv1.1 or cryptoProtocolVersion=TLSv1.2 based on the cryptographic protocol used by the database server.
    TrustStore
    Path and file name of the truststore file that contains the SSL certificate for the database.
    If you do not include the path for the truststore file, Informatica looks for the file in the following default directory:
    <Informatica installation directory>/tomcat/bin
    TrustStorePassword
    Password for the truststore file for the secure database.
  8. Press
    1
    to specify the JDBC URL to connect to the database.
  9. Specify the database address in the following format for the
    Database address
    parameter:
    <Fully qualified domain name of the host>:<port>
  10. Specify the database service name in the following format for the
    Database service name
    parameter:
    <Fully qualified domain name of the service>
  11. Press
    1
    to specify that you want to configure the JDBC parameters.
  12. Specify the required values for the parameters or press
    Enter
    to apply the default values. Press
    Enter
    to retain the default values.
    Use the following syntax for the connection string of the selected database type:
    Database Type
    Connection String Syntax
    IBM DB2
    jdbc:informatica:db2:// <host_name>:<port_number>;DatabaseName=<database_name>;BatchPerformanceWorkaround=true;DynamicSections=3000
    Microsoft SQL Server
    • Microsoft SQL Server that uses the default instance
      jdbc:informatica:sqlserver:// <host_name>:<port_number>;DatabaseName=<database_name>;SnapshotSerializable=true
    • Microsoft SQL Server that uses a named instance
      jdbc:informatica:sqlserver://<host_name> \<named_instance_name>;DatabaseName=<database_name>;SnapshotSerializable=true
    Oracle
    jdbc:informatica:oracle:// <host_name>:<port_number>;SID=<database_name>;MaxPooledStatement s=20;CatalogOptions=0;BatchPerformanceWorkaround=true
    The installer validates the node name and license, and then creates the Model Repository Service. The installer proceeds to create the Data Integration Service.