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

Modifying the Repository Connections

Your server configuration requires that the following database connections be configured to reflect the actual database type that your system is running:

• Source. IA_[SOURCE ABBREVIATION]_SOURCE
• Staging Area. IA_[SOURCE ABBREVIATION]_STAGE
• Data Warehouse. IA_[SOURCE ABBREVIATION]_WAREHOUSE

  NOTE:  If you have more than one source, you must modify the connection for each flat file or database.

Configuring these database connections also helps to make sure that Siebel Customer-Centric Enterprise Warehouse is installed correctly. Configure all three repository connections listed in the preceding paragraph for each of your source types.

Each source type requires a relational database connection, or an application database connection, or both. Relational and application connections have been defined for the following:

• Oracle applications with an Oracle database connection
• PeopleSoft applications with an Oracle database connection
• SAP R/3 with a source connection
• Warehouse with an Oracle database connection
• Staging with an Oracle database connection

If you want to use these connections, you can edit their properties. Otherwise, you must create a new connection. For a list of source types and their connection configuration, see Table 7.

To configure the relational database connections

1. Start the Workflow Manager.
2. On the Connections menu, click Relational....
3. Connect to your repository.
4. Click your target database in the Relational Connection Browser.

   NOTE:  If you want to change the database type, you must:

   1. Click Edit....
   2. Click your database type, and click OK.
5. Click New....
6. In the Connection Object Definition box, type the appropriate Database Name, User Name, Password, Connect String, and Code Page, and click OK.
7. Repeat this procedure for each connection you want to configure:
   • Source
   • Staging area
   • Data warehouse
8. Click Close.

To configure the application database connections

1. Start Workflow Manager.
2. Connect to your repository.
3. On the Connections menu, click Application....
4. Click your target database in the Application Connection Browser.
5. Click New....
6. In the Connection Object Definition box, type the appropriate Database Name, User Name, Password, Connect String, and Code Page for your source connection.
7. Click OK, and then click Close.

To replace relational database connections

1. Start Workflow Manager.
2. Connect to your repository.
3. On the Connections menu, and click Replace Connections.
4. Click Add a New Connection Pair.
5. Enter your source database connection in the From field, and your new source database connection in the To field.
6. Click Replace.

NOTE:  You cannot replace or copy an application database connection. You have to delete the original application connection, and create a new connection with the same name. For example, if you want to extract from a PeopleSoft DB2 database, you have to delete the existing PeopleSoft Oracle application connection called, IA_PSFT8_SOURCE. Create a new application connection using PeopleSoft DB2, with the same name, IA_PST8_SOURCE.