Creating data sources in the web application server for Opportunity Detect

The Opportunity Detect web application uses JDBC connections to communicate with the system table database and with the HCL® Marketing Platform system table database..

About this task

You can skip this procedure if you allow the installer to create this data source when you install Opportunity Detect. To enable automatic data source creation during installation, on the Datasource Creation panel, select the Create Opportunity Detect Datasource check box and supply information about your WebSphere profile.

  • The installer creates the data source using OpDetectionDS as the JNDI name.
  • The installer also sets the driver classpath in WebSphere.

If you do not want to allow the installer to create the data source, then you must create this data source by performing the following procedure.

Procedure

  1. Before you create data sources, ensure that the JDBC provider type for Opportunity Detect is correct. Complete the following steps to specify the JDBC provider:
    1. Log into the WebSphere console
    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 the database type you are using.
    5. In the Provider type field, select the type appropriate for your database.
    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.
  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 the type appropriate for your database.
  5. Click Next to see the Enter database specific properties for the data source window.
  6. Enter the appropriate values in all the fields.
  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:

    1. Click the Global J2C alias Security domains link.
      Important: 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.
    2. Click New.
    3. Enter the required information in the General Properties window.
    4. Click OK and then click Save in the Data sources window.
  9. Select WSLogin in the Mapping-configuration alias field.
  10. Click Finish to create the OpDetectionDS data source.