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 Monitoring Model Repository Database Details

Configure Monitoring Model Repository Database Details

If you chose to create a monitoring Model Repository Service, you can provide connection information about the repository database.
  1. Select the database for the monitoring Model repository.
    The following table lists the database type for monitoring Model repository:
    Prompt
    Description
    Database type
    Type of database type for monitoring Model repository. Select from the following options:
    1 - Oracle
    2 - Microsoft SQL Server
    3 - IBM DB2
  2. Enter the properties for the database user account.
    The following table lists the properties for the database user account:
    Property
    Description
    Database user ID
    Name for the monitoring Model repository database user account.
    User password
    Password for the Monitoring model repository database user account.
  3. Select whether to create a secure monitoring Model repository.
    You can create a monitoring Model repository in a database secured with the SSL protocol. To create a monitoring Model repository in a secure database, press 1 and skip to step 4.c.
    To create a monitoring Model repository in an unsecured database, press 2.
  4. If you do not create a secure monitoring Model repository, enter the parameters for the database.
    1. If you select IBM DB2, select whether to configure a tablespace and enter the tablespace name.
      The following table describes the properties that you must configure for the IBM DB2 database:
      Property
      Description
      Configure tablespace
      Select whether to specify a tablespace:
      1 - No
      2 - Yes
      In a single-partition database, if you select No, the installer creates the tables in the default tablespace. In a multi-partition database, you must select Yes.
      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 you select Yes to configure the tablespace, enter the name of the tablespace in which to create the tables.
      In a multi-partition database, specify the name of the tablespace that resides in the catalog partition of the database.
    2. If you select Microsoft SQL Server, enter the schema name for the database.
      The following table describes the properties that you must configure for the Microsoft SQL Server database:
      Property
      Description
      Schema name
      Name of the schema that will contain domain configuration tables. If this parameter is blank, the installer creates the tables in the default schema.
    3. To enter the JDBC connection information using the JDBC URL information, press
      1
      . To enter the JDBC connection information using a custom JDBC connection string, press
      2
      .
    4. Enter the JDBC connection information.
      • To enter the connection information using the JDBC URL information, specify the JDBC URL properties.
        The following table describes the database connection information:
        Prompt
        Description
        Database host name
        Host name for the database.
        Database port number
        Port number for the database.
        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.
        Configure JDBC Parameters
        Select whether to add additional JDBC parameters to the connection string:
        1 - Yes
        2 - No
        If you select Yes, enter the parameters or press Enter to accept the default.
        If you select No, the installer creates the JDBC connection string without parameters.
      • To enter the connection information using a custom JDBC connection string, type the connection string.
        Use the following syntax in the JDBC connection string:
        IBM DB2
        jdbc:Informatica:db2://host_name:port_no;DatabaseName=
        Oracle
        jdbc:Informatica:oracle://host_name:port_no;ServiceName=
        Microsoft SQL Server
        jdbc:Informatica:sqlserver://host_name:port_no;SelectMethod=cursor;DatabaseName=
        Sybase
        jdbc:Informatica:sybase://host_name:port_no;DatabaseName=
        Verify that the connection string contains all the connection parameters required by your database system.
The
Service Parameters
section appears.