Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Using the DAC's Data Warehouse Configurator Wizard >

Configuring the Informatica Repository (in DAC's Data Warehouse Configurator)

---

Use this procedure to configure the Informatica repository in the Data Warehouse Configurator.

To configure the Informatica Repository in the Data Warehouse Configurator

1. From the DAC menu bar, click Tools > ETL Management > Configure.
2. Select the Configure Informatica Repository check box.
3. Select the Informatica Repository tab.
4. Enter the appropriate information, and then click Start.

NOTE:  The Informatica repository cannot be configured 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 Workflow Manager to specify the source and target databases as Unicode. 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. Start 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. Start the Informatica WorkFlow Manger.
2. Connect to the repository.
3. Select Connections > Relational.

   A new window appears.

4. Select the appropriate OLTP connection (DB2_OLTP for DB2, ORA_OLTP for Oracle, ODBC_OLTP for MSSQL).
5. For the Code Page, select UTF-8 encoding of Unicode or the appropriate code page, and click OK.
6. Select the OLAP connection (DB2_OLAP for DB2, ORA_OLAP for Oracle, ODBC_OLAP for MSSQL).
7. For the Code Page select UTF-8 encoding of Unicode or the appropriate code page, and click OK.
8. Select the Informatica Repository tab.
9. Enter the appropriate information, and then click Start.

Bookshelf Home | Contents | Index | Search | PDF