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
  10. Appendix C: Connecting to Databases from Windows
  11. Appendix D: Updating the DynamicSections Parameter of a DB2 Database

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

Configure Model Repository Service Database

Configure Model Repository Service Database

After you configure the domain and the node, you can configure the Model repository database properties.
  1. On the
    Model Repository Service Database
    page, enter the database and user account information for the Model repository.
    The image describes about configuring the Model Repository database.
    The following table describes the properties that you specify for the database and user account:
    Property
    Description
    Database type
    Database for the repository. Select one of the following databases:
    • Oracle
    • IBM DB2
    • Microsoft SQL Server
    • PostgreSQL
    Database user ID
    User account for the repository 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 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.
    If you enable secure communication for the domain, you can create the Model repository in a database secured with the SSL protocol. To create a secure Model repository, skip to step 3.
  2. Enter the database connection information.
    If you do not create a secure Model repository, 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.
      The following table describes the JDBC URL properties that you specify:
      Property
      Description
      Database address
      Host name and port number for the database in the format
      host_name:port
      .
      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.
      • PostgreSQL: Enter the database 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.
      IBM DB2
      jdbc:Informatica:db2://<host name>:<port number>;DatabaseName=
      Oracle
      jdbc:Informatica:oracle://<host name>:<port number>;ServiceName=
      Use the following connection string to connect to the Oracle database through the Oracle Connection Manager:
      jdbc:Informatica:oracle:TNSNamesFile=<fully qualified path to the tnsnames.ora file>;TNSServerName=<TNS name>;
      Microsoft SQL Server
      jdbc:Informatica:sqlserver://<host name>:<port number>;SelectMethod=cursor;DatabaseName=
      Microsoft Azure SQL
      jdbc:Informatica:sqlserver://<host name>:<port number>;SelectMethod=cursor;DatabaseName=<database name>;SnapshotSerializable=true;EncryptionMethod=SSL;HostNameInCertificate=*.database.windows.net;ValidateServerCertificate=false
      Azure SQL Database with Active Directory authentication
      jdbc:informatica: sqlserver://<host_name>:<port_number>;database=<database_name>;encrypt=true;AuthenticationMethod=ActiveDirectoryPassword;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=<seconds>
      PostgreSQL
      jdbc:Informatica:postgresql://<host name>:<port number>;DatabaseName=
      Verify that the connection string contains all the connection parameters required by your database system.
  3. Choose whether to create a secure Model repository.
    If you create the repository on a secure database, you must provide the truststore information for the database. You must also provide a JDBC connection string that includes the security parameters for the database.
    The following table describes the properties you must set for a secure database:
    Property
    Description
    Database truststore file
    Path and file name of the truststore file for the secure database.
    Database truststore password
    Password for the truststore file.
    Custom JDBC Connection String
    JDBC connection string to connect to the secure database, including the host name and port number and the security parameters for the database.
    For information about the security parameters you must include in the JDBC connection for a secure database, see Connection String to a Secure Database.
  4. Click
    Test Connection
    to verify that you can connect to the database, and then click
    OK
    to continue.
  5. Click
    Next
    .
The
Service Parameters
section appears.

0 COMMENTS

We’d like to hear from you!