Oracle^® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows > Updating Siebel Transactional Database Schema Definitions >

Process of Applying Siebel (CRM) and Oracle E-Business Suite Schema Changes For Oracle, DB2/UDB, MSSQL

To enable change capture for Oracle's Siebel adaptors, you use the ddlimp control file to apply Siebel (CRM) and Oracle E-Business Suite schema changes, which updates the required image tables in the OLTP.

NOTE:  Using the ddlimp control file to apply schema changes replaces the use of SIF files in Siebel Tools in previous product releases.

How to Apply Oracle's CRM Schema Changes For Oracle, DB2/UDB, MSSQL

1. On the machine where Oracle BI Applications is installed, run the following command:

   ..\OracleBI\dwrep\bin\DDLIMP /U <USER> /P <PASSWORD> /C <ODBC connect string> /G SSE_ROLE /F <..\OracleBI\dwrep\DDL_OLTP.CTL> /L <..\oracleBI\dwrep\DDL_OLTP.log>

   NOTE:  If you are applying schema changes to a Siebel CRM Version 6.3, specify DDL_OLTP_63.CTL as the /F parameter instead of DDL_OLTP.CTL.

   For example:

   DDLIMP /U SADMIN /P SADMIN /C SIEBEL_OLTP /G SSE_ROLE /F <DRIVE>:\OracleBI\dwrep\DDL_OLTP.CTL /L <DRIVE>:\OracleBI\dwrep\DDL_OLTP.log

   Notes:

   • /P <PASSWORD> - The password for Oracle's CRM OLTP.
   • /C <ODBC connect string> - The name of the ODBC connect string.
   • For Oracle databases, use the Oracle Merant ODBC Drivers (installed with Oracle BI Applications).
   • In addition, you can use the following commands:

     /W Y - (if the OLTP database is Unicode).

     /Z Y - (if the OLTP database is DB2 and Unicode or the OLTP database is MS SQL Server and Unicode).

     /B <TABLE_SPACE_NAME> - If you want to create these table in a separate table space.

     /X <INDEX_TABLE_SPACE_NAME> - If you want to create the indexes in a separate table. space.

     /Y - Storage File for DB2/390.

2. Restart all servers.