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 Data Preparation Repository Database Details

Configure the Data Preparation Repository Database Details

Specify the Data Preparation repository database connection details. You can choose to use an Oracle database or a MySQL database for the Data Preparation repository database.
If you do not have the database details, you can enter placeholder values, and then create the Data Preparation Service. If you continue without specifying the database connection details, you cannot enable the Data Preparation Service.

Oracle

  1. To use an Oracle database for the Data Preparation repository, press
    1
    .
  2. Enter the connection properties for the database.
    The following table describes the connection properties:
    Property
    Description
    Database Host Name
    Host name of the machine that hosts the database.
    Database Port Number
    Port number for the database.
    JDBC Parameters
    Parameters required to connect to the database.
    Custom JDBC Connection String
    JDBC connection string to connect to the database. Format the string as follows:
    jdbc:informatica:oracle://<database host name>:<port>;ServiceName=<service name>
  3. To connect to a secure database, press
    2
    , and then enter the secure connection properties.
    The following table describes the secure connection properties:
    Property
    Description
    Truststore File
    Path and file name for the database truststore file.
    Truststore Password
    Password for the database truststore file.
    Secure JDBC Parameters
    List of secure database parameters to connect to the database. Format the parameters as follows:
    EncryptionMethod=SSL;HostNameInCertificate=<secure database host name>;ValidateServerCertificate=true
  4. Press
    2
    to continue.
The Data Preparation Service Details section appears.

MySQL

  1. To use a MySQL database or a MariaDB database for the Data Preparation repository, press
    2
    .
  2. Enter the connection properties for the database.
    The following table describes the connection properties:
    Property
    Description
    Database Host Name
    Host name of the machine that hosts the Data Preparation repository database.
    Database User Name
    Database user account to use to connect to the Data Preparation repository.
    Database User Password
    Password for the Data Preparation repository database user account.
    Database Port Number
    Port number for the database.
    Database Name
    Schema or database name of the Data Preparation repository database.
  3. To connect to a secure database, press
    2
    , and then enter the secure connection properties.
    The following table describes the secure connection properties:
    Property
    Description
    Custom JDBC Connection String
    Connection string to connect to the database.
    To connect to a non-secure database, format the string as follows:
    jdbc:mysql://<database host name>:<port>
    The connection string is optional if you connect to a non-secure database.
    To connect to an SSL-enabled database, format the string as follows:
    verifyServerCertificate=true&useSSL=true&requireSSL=true
    Secure JDBC Parameters
    String containing the path and file name for the database truststore file, and the truststore password. Format the string as follows:
    trustCertificateKeyStoreUrl=file://<truststore path/truststore file name>&trustCertificatekeyStorePassword=<truststore password>
  4. Press
    Enter
    to continue.
The Data Preparation Service Details section appears.