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 Content Management Service Parameters and Database

Configure the Content Management Service Parameters and Database

After you configure the profiling warehouse, you can configure the content management service parameters and database properties.
  1. Enter configuration parameters for the Content Management Service.
    The following table lists the parameters for the Content Management Service:
    Prompt
    Description
    Content Management Service name
    Name of the Content Management Service.
  2. Enter the following service parameter information:
    Port
    Description
    HTTP protocol type
    Type of connection to the Data Integration Service. Select one of the following options:
    • HTTP. Requests to the service uses an HTTP connection.
    • HTTPS. Requests to the service uses a secure HTTP connection.
    HTTP port
    Port number to used for the Data Integration Service. Default is 9085.
    HTTPS port
    Port number to used for the Data Integration Service. Default is 9085.
  3. Enter database information for the reference data warehouse.
    The following table lists the database information for the reference data warehouse.
    Prompt
    Description
    Database type
    Type of database for reference data warehouse. Select from the following options:
    1 - Oracle
    2 - Microsoft SQL Server
    3 - IBM DB2
  4. 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 reference data warehouse database user account.
    User password
    Password for the profiling warehouse database user account.
  5. Based on the database type selected, 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 address
        Host name and 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=
        Microsoft Azure SQL Database
        jdbc:Informatica:sqlserver://host_name:port_no;SelectMethod=cursor;DatabaseName=database_name;SnapshotSerializable=true;EncryptionMethod=SSL;HostNameInCertificate=*.database.windows.net;ValidateServerCertificate=false
        Sybase
        jdbc:Informatica:sybase://host_name:port_no;DatabaseName=
        Verify that the connection string contains all the connection parameters required by your database system.
    5. Enter the data access connection string.
The
Cluster and Application Service Options
section appears.