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 Content Management Service

Creating the Content Management Service

Provide the following details to create the Content Management Service:
  1. Name of the Model Repository Service that you want to associate with the service.
  2. Name of the Data Integration Service that you want to associate with the service.
  3. Name of the node on which the Content Management Service must run.
  4. The license that you want to associate with the Content Management Service.
  5. Name of the Content Management Service.
  6. Choose to use http or https for the service.
    If you select
    https
    as the protocol for the service, provide the following details:
    • HTTPS port. Default is 17466.
    • Specify the SSL certificate that you want to use to secure the Content Management Service. You can use the default SSL certificates in the default keystore or use custom SSL certificates. If you choose custom SSL certificates, specify the path that includes the filename of the keystore file and the password to access the keystore file.
  7. Select the database that you want to configure for the Content Management Service from the following options:
    • Oracle
    • SQL Server
    • DB2
    Default is Oracle.
  8. Type the username to access the database in the
    Database user ID
    parameter and press
    Enter
    . Default is
    admin
    .
  9. Type the password for the username in the
    User password
    parameter and press Enter.
  10. 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.
  11. Press
    1
    to specify the JDBC URL to connect to the database.
  12. Specify the database address in the following format for the
    Database address
    parameter:
    <Fully qualified domain name of the host>:<port>
  13. Specify the database service name in the following format for the
    Database service name
    parameter:
    <Fully qualified domain name of the service>
  14. Press
    1
    to specify that you want to configure the JDBC parameters.
  15. 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 creates and enables the Content Management Service and proceeds to configure the cluster and application service options.