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

Installation and Configuration Guide

Installation and Configuration Guide

Configure the Model Repository Service and Model Repository Database Details

Configure the Model Repository Service and Model Repository Database Details

Choose whether to create a Model Repository Service and a Data Integration Service to associate with the
Enterprise Data Preparation
Service, or to associate existing application services with
Enterprise Data Preparation
. If you create a Model Repository Service, specify the connection details for the Model repository database.
If you choose to create a Model Repository Service, specify the connection details for the Model repository database.
  1. Choose to either create a Model Repository Service and a Data Integration Service to associate with the
    Enterprise Data Preparation
    Service, or to associate existing application services with
    Enterprise Data Preparation
    .
    • To create to create a Model Repository Service and a Data Integration Service to associate with the
      Enterprise Data Preparation
      Service on the node, press
      1
      .
    • To associate an existing Model Repository Service and an existing Data Integration Service with the
      Enterprise Data Preparation
      Service, press
      2
      , and then enter the name of each service.
  2. Enter the name of the Model Repository Service.
    The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters or begin with @. It also cannot contain spaces or the following special characters: ` ~ % ^ * + = { } \ ; : ' " / ? . , < > | ! ( ) ] [
  3. 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.
  4. 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.
  5. 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
      Optional parameters to include in the database connection string. Use the parameters to optimize database operations for the Model repository. 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.
      The following examples show the default connection strings for each database:
      • Oracle. jdbc:Informatica:oracle://host_name:port_no ;ServiceName=
      • IBM DB2. jdbc:Informatica:db2://host_name:port_no ;DatabaseName=
      • Microsoft SQL Server. jdbc:Informatica:sqlserver://host_name:port_no ;SelectMethod=cursor;DatabaseName=
      • Azure SQL Server. jdbc:informatica:sqlserver://host_name:port_number ;DatabaseName=<database_name>;SnapshotSerializable=true; SnapshotSerializable=true;EncryptionMethod=SSL;HostNameInCertificate=*.<hostnameincertificate>;ValidateServerCertificate=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
      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 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
      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.