Creating a JDBC Datasource for the Engine Database

After creating a JDBC datasource for the directory database, you another JDBC resource to provide database connectivity to ALBPM applications for the ALBPM engine 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 Engine database. Enter the following configuration information for the new data source:

   Option	Value
   Data source name	ALBPM Engine Datasource
   JNDI name	XAEngineDS
   Component-managed Authentication Alias	Select the Authentication entry you defined previously for ALBPM Engine database. Example: <node>/ALBPM Engine DB Auth

5. Click Next and enter the following Data store helper class name: albpm.jdbc.websphere.ALBPMDataStoreHelper.
6. Click Next again, and Finish after reviewing all selected options.
7. Select your newly created Data source.
8. Click Custom properties located under the Additional properties section.
9. 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.
10. Click on Save to persist your WebSphere configuration changes.