Creating data sources for Opportunity Detection
You can use the WebSphere Integrated Solutions Console to create a data source for Opportunity Detection.
Before creating data sources, make sure that the JDBC provider type for Opportunity Detection is the DB2 using IBM JCC driver. Complete the following steps to specify the JDBC provider:
1.
2.
Go to Resources > JDBC > JDBC Providers .
3.
Click New to open the Create new JDBC provider window.
4.
In the Database type field, select DB2.
5.
In the Provider type field, select DB2 using IBM JCC driver.
6.
In the Implementation type field, select Connection pool data source.
7.
Click Next and enter the required information.
8.
Click Next to view the summary.
9.
Click Finish to configure the JDBC provider.
*
The data source and the JNDI name for Opportunity Detection must be OpDetectionDS.
1.
2.
In WebSphere Integrated Solutions Console, go to Resources > JDBC > Data sources and click New.
3.
In the Create a data source window, enter OpDetectionDS in the Data source name and the JNDI name fields and click Next.
4.
Select the Select an existing JDBC provider check box, and select DB2 using IBM JCC driver in the corresponding list.
5.
Click Next to see the Enter database specific properties for the data source window.
6.
7.
Clear the Use this data source in container managed persistence (CMP) check box and click Next.
8.
In the Component-managed authentication alias field, select your global J2C authentication alias.
If a global J2C authentication alias does not exist, complete the following steps to create a global J2C authentication alias:
a.
Click the Global J2C alias Security domains link.
Clicking the Global J2C alias Security domains cancels the Create a data source wizard, and all your selections are lost. You must create the data source again after you create a global J2C authentication alias.
b.
Click New.
c.
Enter the required information in the General Properties window.
d.
Click OK and then click Save in the Data sources window.
9.
Click Finish to create the OpDetectionDS data source.