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: Managing Distribution Packages
  10. Appendix C: Connecting to Databases from UNIX or Linux
  11. Appendix D: Connecting to Databases from Windows
  12. Appendix E: Updating the DynamicSections Parameter of a DB2 Database

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

Content Management Service Parameters and Database

Content Management Service Parameters and Database

After you configure the Data Integration Service, you can configure the parameters for the Content Management Service.
  1. If you chose to create a Content Management Service during the installation, the
    Content Management Service
    page appears.
  2. Enter the Content Management Service parameters.
    The following table describes the service parameters that you must set:
    Port
    Description
    Content Management Service name
    Name of the Content Management Service to create in the Informatica domain.
    HTTP Protocol
    Type of connection to the Content Management Service. Select one of the following options:
    • HTTP. Requests to the service uses an HTTP connection.
    • HTTPS. Requests to the service uses a secure HTTP connection.
    HTTP Port
    Port number to use for the Content Management Service. Default is 8105.
  3. If you select an HTTPS connection, specify whether to use the default Informatica SSL certificates or to use your SSL certificates to secure the connection to the Content Management Service.
    The following table describes the SSL certificate options for securing the Content Management Service:
    Option
    Description
    Use the default Informatica SSL certificate files
    Use the default SSL certificates provided by Informatica.
    If you do not provide an SSL certificate, Informatica uses the same default private key for all Informatica installations. If you use the default Informatica keystore files, the security of your domain could be compromised. To ensure a high level of security for the domain, select the option to specify the location of the SSL certificate files.
    Enter the location of the SSL certificate files
    Use the SSL certificates that you provide. You must specify the location of the keystore files.
    If you provide the certificate, specify the location and passwords of the keystore files.
    The following table describes the parameters that you must enter for the SSL certificate files:
    Property
    Description
    Keystore file
    Required. Path and file name for the keystore file that contains the private keys and SSL certificates for the database.
    Keystore password
    Required. Password for the keystore file for the secure database.
    The keystore certificate types for the Content Management Service depends on the certificate types that the Administrator tool uses:
    • If you used the default keystore certificate for the Administrator tool, you can use either the default or a custom keystore certificate for the Content Management Service.
    • If you used a custom keystore certificate for the Administrator tool, you must use a custom keystore certificate for the Content Management Service.
  4. Click
    Next
    .
  5. On the
    Content Management Service
    page, enter the database and user account information for the reference data warehouse database.
    The following table describes the properties that you specify for the database and user account:
    Property
    Description
    Database type
    Database for the reference data warehouse. Select one of the following databases.
    • Oracle
    • IBM DB2
    • Microsoft SQL Server
    • Microsoft Azure SQL Database
    • PostgreSQL, using JDBC
    Database user ID
    User account for the reference data warehouse database.
    User password
    Password for the database user account.
    If you select IBM DB2, specify the tablespace for the repository tables:
    Property
    Description
    Tablespace
    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 this option is not selected, the installer creates the tables in the default tablespace.
    In a multipartition database, select this option and specify the name of the non-partitioned tablespace that resides in the catalog partition of the database.
    If you select Microsoft SQL Server or PostgreSQL, specify the schema for the repository tables and database connection:
    Property
    Description
    Schema name
    Name of the schema that will contain the repository tables. If not selected, the installer creates the tables in the default schema.
    Trusted connection
    Indicates whether to connect to Microsoft SQL Server through a trusted connection. Trusted authentication uses the security credentials of the current user to make the connection to Microsoft SQL Server. If not selected, the installer uses Microsoft SQL Server authentication.
  6. Enter the database connection information.
    You can specify the connection properties for the JDBC URL or provide the JDBC connection string.
    • To enter the connection information using the JDBC URL, select
      JDBC URL
      and specify the database connection properties.
      Property
      Description
      Database address
      Host name and port number for the database in the format
      <host name>:<port number>
      .
      Database service name
      Service or database name:
      • Oracle: Enter the service name.
      • Microsoft SQL Server: Enter the database name.
      • IBM DB2: Enter the service name.
      JDBC parameters
      Optional parameters to include in the database connection string. Use the parameters to optimize database operations for the database. 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 not selected, the installer creates the JDBC URL string without additional parameters.
    • To enter the connection information using a custom JDBC connection string, select
      Custom JDBC connection string
      and type the connection string.
  7. Click
    Test Connection
    to verify that you can connect to the database, and then click
    OK
    to continue.
  8. Click
    Next
    .

0 COMMENTS

We’d like to hear from you!