Table of Contents

Search

  1. Installation Getting Started
  2. Before You Install the Services
  3. Run the Big Data Suite Installer
  4. After You Install the Services
  5. Install the Developer Tool
  6. Uninstallation
  7. Starting and Stopping Informatica Services
  8. Connecting to Databases
  9. Updating the DynamicSections Parameter of a DB2 Database
  10. Silent Input Properties File

Installation and Configuration Guide

Installation and Configuration Guide

Configure the Model Repository Database Connection Details

Configure the Model Repository Database Connection Details

If you choose to create a Model Repository Service to associate with Enterprise Data Lake, specify the connection details for the Model repository database.
  1. If you create a Model Repository Service, specify the connection details for the Model repository database.
    The following table describes the parameters you set:
    Property
    Description
    Database Type
    Database for the Model repository managed by the Model Repository Service.
    Database User ID
    User name of the database user account to use to log in to the Model repository database.
    User Password
    Password for the Model repository database user account.
    Tablespace
    Configure for a IBM DB2 database. Name of the tablespace in which to create the tables. The tablespace must be defined on a single node, and the page size must be 32K.
    This option is required for a multi-partition database. If this option is not selected for a single partition database, the installer creates the tables in the default tablespace.
    Schema Name
    Configure for a Microsoft SQL Server database. Name of the schema that will contain domain configuration tables. If not selected, the installer creates the tables in the default schema.
  2. Specify the truststore details required to access a secure Model repository database.
    The following table describes the properties you set:
    Property
    Description
    Database Truststore File
    Path and file name of the truststore file for the secure database.
    Database Truststore Password
    Password for the truststore.
  3. Choose whether to configure the database connection using a JDBC URL or a custom JDBC connection string.
    • Press
      1
      to configure the database connection using a JDBC URL.
      The following table describes the properties you set:
      Property
      Description
      Database Address
      Host name and port number for the database in the format
      <host name>:<port>
      .
      Database Service Name
      Service name for Oracle and IBM DB2 databases, or database name for Microsoft SQL Server.
      JDBC Parameters
      The JDBC connection string used to connect to the Model repository database.
      You can use the default parameters or add or modify the parameters based on your database requirements. 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 without additional parameters.
      Use the following JDBC connect string syntax for each supported database:
      • IBM DB2.
        jdbc:informatica:db2://<host name>:<port>;DatabaseName=<database name>;BatchPerformanceWorkaround=true;DynamicSections=3000
      • Microsoft SQL Server that uses the default instance.
        jdbc:informatica:sqlserver://<host name>:<port>;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
      • Azure SQL Server.
        jdbc:informatica:sqlserver://<host name>:<port>;DatabaseName=<database name>;SnapshotSerializable=true; SnapshotSerializable=true;EncryptionMethod=SSL;HostNameInCertificate=*.<host name in certificate>;ValidateServerCertificate=true
      • Oracle.
        jdbc:informatica:oracle://<host name>:<port>;SID=<database name>;MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true
    • Press
      2
      to configure the database connection using a custom JDBC connection string.
      The following table describes the properties you set:
      Property
      Description
      EncryptionMethod
      Required. Indicates whether data is encrypted when transmitted over the network. This parameter must be set to SSL.
      ValidateServerCertificate
      Optional. Indicates whether Informatica validates the certificate that is sent by the database server. If this parameter is set to True, Informatica validates the certificate that is sent by the database server. 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 is sent by the database server. Informatica ignores any truststore information that you specify.
      HostNameInCertificate
      Optional. 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.
The Service Parameters section appears.