Creating a JDBC Datasource for Directory Database

After creating a JDBC Provider, you must create a JDBC datasource to provide database connectivity to ALBPM applications. The following procedures show you how to create a JDBC datasource for the ALBPM directory database.

1. Login to WebSphere's Administration Console. By default, it runs on http://host:9060/ibm/console.
2. Go to Resources > JDBC > JDBC Providers and click on the BEA JDBC Provider you created previously.
3. Click on Data sources, located in the Additional properties section.
4. Click New to create a new Data source for ALBPM Directory database.
5. Enter the following configuration information for your new data source:

   Option	Value
   Data Source Name	ALBPM Directory Data Source
   JNDI Name	FDIDS
   Component-managed Authentication Alias	Select the Authentication entry you defined previously for ALBPM Directory database. For example: node/ALBPM Directory DB Auth

6. Click Next and enter the following Data store helper class name: albpm.jdbc.websphere.ALBPMDataStoreHelper .
7. Click Next, then Finish after reviewing all selected options.
8. Select the data source you just created.
9. Click Custom properties located under the Additional properties section in the right pane.

   You should see a complete list of all driver properties. If you do not see this list, there is an error with your configuration.

10. Configure the connectivity properties for your database vendor. See Engine and Directory Database Connectivity for more information. For general information on using the JDBC drivers provided with BEA products, see JDBC Drivers.
11. Click Save to persist your WebSphere configuration changes.
12. Test your datasource configuration.
    1. Expand JDBC > JDBC Providers
    2. Select the JDBC datasource you just configured
    3. Click Data sources
    4. Select the checkbox next to the datasource you want to test
    5. Click Test Connection