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 Profiling Warehouse Database Details

Configure Profiling Warehouse Database Details

If you chose to configure the service parameters, you can provide warehouse information.
  1. Select the database type for the profiling warehouse.
    The following table lists the database type for the profiling warehouse.
    Prompt
    Description
    Database type
    Type of database for the profiling warehouse connection. 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 profiling warehouse database user account.
    User password
    Password for the profiling warehouse database user account.
  3. 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=
        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
Content Management Service Parameters and Database
section appears.