Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring the Siebel Data Warehouse >

Installing Informatica Client Software

---

Informatica client utilities are used throughout the Siebel Data Warehouse.

Informatica Server Manager creates the Siebel Data Warehouse build.
Informatica Repository Manager restores and manages the Siebel Data Warehouse repository.
Informatica Designer configures and updates the Siebel Data Warehouse mappings, transformations, and metadata.

NOTE:  If you are using both SQL Server 2000 and Oracle (for example, Oracle for the Siebel Transaction Database and SQL Server 2000 for the Siebel Data Warehouse), then follow the procedural steps relating to odbcbcp.dll.

Refer to the Informatica Installation and Configuration Guide for the following procedure.

To install PowerMart Client on the Administrator Workstation

Prior to installing the PowerMart Client, rename ODBCbcp.dll in C:\\winnt\system32 by appending .old.
In the Informatica Suite Setup window, check the Install PowerMart Client box.

NOTE:  Oracle users should also check the Install ODBC box.

After installation, delete the ODBCbcp.dll that was installed and rename the old dll file by taking out the .old.
Reboot after installing the PowerMart Client and ODBC drivers.

Data Code Pages Validation

At the end of the Informatica installation, on the Setup Complete page, uncheck the check box for Enable Data Code Pages Validation if either of these two conditions is true:

If the source and target databases are Unicode, or
If the source or target database code page is different from the Informatica server operating system's code page.

NOTE:  Informatica Server must be run on an operating system that uses Code Page 1252. For example, Japanese users need to run the ETL process from a machine that has an English-language version of Windows installed. In addition, use a period (.) as the decimal delimiter for this server to function properly. The data source and target can be on any Siebel Systems-supported code page, including non-European and double-byte, provided that the data source and data target code pages are the same.

Bookshelf Home | Contents | Index | Search | PDF