Bookshelf Home | Contents | Index | PDF     

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse on Windows > Creating, Restoring, and Configuring the Informatica Repository >

Configuring the Informatica Repository in the DAC

Follow this procedure to configure the Informatica repository in the DAC's Data Warehouse Configurator.

If you are using a Teradata database, you need to configure the source and data warehouse database relational connections in the Informatica Workflow Manager. You cannot use the DAC's Data Warehouse Configurator to configure relational connections. For instructions, see To configure the Informatica repository in the Workflow Manager for Teradata installations.

To configure the Informatica repository in the Data Warehouse Configurator

  1. From the DAC menu bar, click Tools > ETL Management > Configure.
  2. Select the database platform for the target, source, and Informatica repository databases.
  3. Check the Configure Informatica Repository check box, and click Next.
  4. Enter the appropriate information, and then click Start.

NOTE:  The Informatica repository cannot be configured using the Data Warehouse Configurator if the source or target database is Unicode. Therefore, make sure the Is Unicode check box is not checked in the Data Warehouse tab and in the Transactional Database tab of the Data Warehouse Configurator. You then need to configure the Informatica repository in the Informatica Workflow Manager to specify the source and target databases as Unicode. For instructions, see To set the database connection code page in Workflow Manager.

If your source or target database is on SQL Server and you have non-ASCII data, you must manually create database connections in the Informatica repository and replace the connections.

To replace database connections for SQL Server databases that have non-ASCII data

  1. Launch the Informatica Workflow Manager.
  2. Connect to the repository.
  3. Select Connections >Relational.

    A new window appears.

  4. Click Add, and then select ODBC.
  5. If your source database is on SQL Server, create a connection using the following values:
    Field
    Value

    Name

    ODBC_OLTP

    Code Page

    UTF-8 encoding of Unicode
  6. If your target database is on SQL Server, create a connection using the following values:
    Field
    Value

    Name

    ODBC_OLAP

    Code Page

    UTF-8 encoding of Unicode

    The connections you created appear in the Replace Connections list.

  7. Select Connections > Replace.
  8. Click Add a New Connection Pair.
  9. If your source database is SQL Server, enter MSSQL_OLTP in the From field, and ODBC_OLTP in the To field.
  10. If your target database is SQL Server, click Add a New Connection Pair, and enter MSSQL_OLAP in the From field, and ODBC_OLAP in the To field.
  11. Click Replace.

The database connection code page also has to be set manually through the Informatica Workflow Manager for Unicode/Non-Latin code pages.

To set the database connection code page in Workflow Manager

  1. Launch the Informatica WorkFlow Manager.
  2. Connect to the repository.
  3. Select Connections > Relational.

    The Relational Connection Browser window appears.

  4. Configure the code page for the source connection:
    1. Double-click the appropriate OLTP connection (DB2_OLTP for DB2, ORA_OLTP for Oracle, ODBC_OLTP for MSSQL).

      The Connection Object Definition dialog box opens.

    2. For the Code Page, select UTF-8 encoding of Unicode or the appropriate code page, and click OK.
  5. Configure the code page for the target connection:
    1. Double-click the appropriate OLAP connection (DB2_OLAP for DB2, ORA_OLAP for Oracle, ODBC_OLAP for MSSQL).
    2. For the Code Page, select UTF-8 encoding of Unicode or the appropriate code page, and click OK.

To configure the Informatica repository in the Workflow Manager for Teradata installations

  1. Launch the Informatica Workflow Manager.
  2. In the Repositories list, select the Informatica repository. The recommended repository name is SIEBEL_DW_Rep_Teradata for Teradata databases. This value should match the value you entered in Step 5 of the procedure To configure the Informatica Server.
  3. In the menu bar, select Repository > Connect.
  4. Log in using the username and password you entered in Step 5 of the procedure To configure the Informatica Server. Click Connect.
  5. Configure the relational connections.
    1. In the menu bar, select Connections > Relational.
    2. In the Objects window, select Olap_Teradata, and then click Edit.
    3. Edit the User Name, Password, Database Name, and Data Source Name, and then click OK.
    4. If you cannot use the existing source connection (the default source connection is for an Oracle database), you need to create a new relational connection and then use the Replace Connections functionality (Connections > Replace) to replace the relational database connection.
    5. Click Close to close the Relational Connection Browser.
  6. Configure the external loader connection.
    1. In the menu bar, select Connections > Loader.
    2. In the Objects window, select Teradata_Tpump_Upsert, and then click Edit.
    3. Edit the User Name, Password, TDPID, Database Name, and other attributes as necessary.
    4. Repeat these steps for the following objects:
      • Teradata_Tpump_Update
      • Teradata_Tpump_Insert
      • Teradata_Tpump_Delete
      • Teradata_FastLoad
    5. For Unicode environments, append -c UTF8 to the value for the External Loader Executable attribute for each external loader.

      For example:

    fastload -c UTF8

    tpump -c UTF8

    1. Click Close to close the Relational Connection Browser.
    
Siebel Data Warehouse Installation and Administration Guide