Configuring Data Sources on the Oracle WebLogic Server

You use the Oracle WebLogic Server to create the Java Database Connectivity (JDBC) data source for the Siebel database. To query the Siebel database in some of the integration processes, the DbAdapter server component uses this data source. Example processes include the service region migration to Oracle Real-Time Scheduler and retrieving geocodes for multiple addresses. SOA provides the DbAdapter server component as a way to connect to the Siebel database.

To configure the data sources on the Oracle WebLogic Server Console

1. Log in to the Oracle WebLogic server console.

2. Navigate to Services, JDBC, and then Data Sources.

3. To create a new data source, click New.

4. Provide the following details:

   • Data Source Name

   • JNDI Name

   • Database Type

   • Database Driver

5. Click Next.

6. Make sure the Support Global Transactions option does not contain a check mark.

7. Click Next, and then specify the following details for the Siebel data source:

   • Database Name

   • Host Name

   • Port

   • Database Table Owner User Name and Password

8. Click Next, and then click Next again.

9. Choose the relevant target servers to which you are deploying.

   For example, the administration server, BAM server, and the SOA server.

10. Click Finish.

11. Navigate to Services, JDBC, and then Data Sources.

12. Choose the data source you created in Step 3.

13. Click the Connection Pool tab.

14. Change the maximum capacity from 15 to 100.