Installation Guide for Oracle Self-Service E-Billing > Configuring IBM WebSphere > Process of Configuring the IBM WebSphere Application Server for the Customer Service Representative Application >

Configuring the Data Sources

You must configure three data source for the Customer Service Representative application on IBM WebSphere.

This task is a step in Process of Configuring the IBM WebSphere Application Server for the Customer Service Representative Application.

To configure the data sources

1. Select Resource, JDBC, and Data Source.
2. Select the following scope from the list:

   Node=Node_Name, Server=Server_Name

   where:

   • Node_Name is the Customer Service Representative application server node.
   • Server_Name is the name of the Customer Service Representative application server.
3. Click New, and click the Create a new J2C authentication alias link. You must create J2C authentication aliases to store the user name and password of the OLTP and OLAP databases.
4. Click New, and create a J2C authentication alias to store the user name and password of the OLTP database. In the Alias field enter OLAP, enter oltp5 for the User ID and password, and enter OLTP User for the description.

   The user ID and password are the database schema user ID and password the alias uses to connect to the database.

5. Click Apply, then click Save to save change directly to the master configuration.
6. Repeat from Step 3 to create a J2C authentication alias for the OLAP database. In the Alias field enter OLAP, enter olap5 for the User ID and password, and enter OLAP User as the description.
7. Select Resource, JDBC, and Data Source. Select the following scope from the list:

   Node=Node_Name, Server=Server_Name

   where:

   • Node_Name is the Customer Service Representative application server node.
   • Server_Name is the name of the Customer Service Representative application server.
8. Click New. You must create three data sources for the Customer Service Representative application as shown in the following table. Specify the data source name (edxAdminDataSource), JNDI name (edx.databasePool), and J2C authentication alias (OLTP) for the first data source.

   Data Source Name	JNDI Name	J2C Alias	Transaction
   edxAdminDataSource	edx.databasePool	OLTP	Oracle JDBC Driver (XA)
   edxXMADataSource	edx.xma.databasePool	OLTP	Oracle JDBC Driver (XA)
   reportDataSource	edx.report.databasePool	OLAP	Oracle JDBC Driver (XA)

9. Click Next, select an existing JDBC provider option, and select Oracle JDBC Driver from the list.
10. Click Next, and specify the URL for the database in the form:

    jdbc:oracle:thin:@Host name:Port name:Database

    where:

    • Host_Name is the name of the server where the Customer Service Representative application is installed.
    • Port_Name is the name of the port where the Customer Service Representative is installed.
    • Database is the name of the database SID.

      For example:

    • OLTP: jdbc:oracle:thin:@sdcbd80a036:1521:oltp10g
    • OLAP: jdbc:oracle:thin:@sdcbd80a036:1521:olap10g
11. Select Oracle 10g data store helper as the data store helper class name. The data source helper must be consistent with the database that you connect to. For example, if the current database version you connect to is Oracle Database 11g, then choose Oracle 11g data store helper as the data store helper class name.
12. Click Next to view a summary of the data source you just created, then click Finish. Click Save to save the new data source directly to the master configuration.
13. To test the newly created data source, select the data source, and click Test connection.
14. Repeat from Step 8 to create the remaining data sources.