Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Initializing and Populating the Siebel Customer-Centric Enterprise Warehouse >

Configuring the Database Parameter for the Source System

You must configure your database parameter for your source system in the M_Z_SESS_PAR_FILE_GENERATE mapping in the Siebel Applications folder.

NOTE:  If you are using the Configuration for Oracle 11i and the Configuration for SAP R/3 folders, then you do not have to configure the database parameter. For SAP R/3, the extracts are done using ABAP codes, and the initial and incremental filters do not depend on any specific back-end database. For Oracle 11i, you use the ORACLE RDBMS.

To configure the database parameter for the source system

1. Start the Designer.
2. Connect to your repository.
3. Open the Siebel Applications folder.
4. Open the M_Z_SESS_PAR_FILE_GENERATE mapping with Mapping Designer.
5. Double-click the EXP_PARAMETERS Expression transformation to open the Edit Transformation box.
6. Click the Ports tab.
7. Set the expression for the port DATABASE_NAME_VAR with the database value you are using for your source system:
   • If the source system database is Oracle, set the value to ORACLE.
   • If DB2, set the value to DB2.
   • If MS SQL SERVER, set the value to MSSQL.
8. Validate the mapping and save the repository.