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
- From the DAC menu bar, click Tools > ETL Management > Configure.
- Select the Configure Informatica Repository check box.
- Select the Informatica Repository tab.
- 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
- Start the Informatica Workflow Manager.
- Connect to the repository.
- Select Connections >Relational.
- Click Add, and then select ODBC.
- If your source database is on SQL Server, create a connection using the following values:
- If your target database is on SQL Server, create a connection using the following values:
The connections you created appear in the Replace Connections list.
- Select Connections > Replace.
- Click Add a New Connection Pair.
- If your source database is SQL Server, enter
MSSQL_OLTP
in the From field, andODBC_OLTP
in the To field.- If your target database is SQL Server, click Add a New Connection Pair, and enter
MSSQL_OLAP
in the From field, andODBC_OLAP
in the To field.- 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
- Start the Informatica WorkFlow Manger.
- Connect to the repository.
- Select Connections > Relational.
- Select the appropriate OLTP connection (DB2_OLTP for DB2, ORA_OLTP for Oracle, ODBC_OLTP for MSSQL).
- For the Code Page, select UTF-8 encoding of Unicode or the appropriate code page, and click OK.
- Select the OLAP connection (DB2_OLAP for DB2, ORA_OLAP for Oracle, ODBC_OLAP for MSSQL).
- For the Code Page select UTF-8 encoding of Unicode or the appropriate code page, and click OK.
- Select the Informatica Repository tab.
- Enter the appropriate information, and then click Start.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 11 March 2004 |