Create JDBC Datasource for 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. Click on your newly created Data source. Then click on Custom properties located under the Additional properties section, on the right side. Add the following properties:

   Oracle Connectivity Properties

   Property	Value
   serverName	Your Database server host name.
   portNumber	Your Database server TCP listener port.
   SID	Your Oracle Database instance SID.

   DB2 Connectivity Properties

   Property	Value
   ServerName	The name or IP address of the database server.
   Database Name	The name of the database to which you want to connect.
   User	The case-sensitive user name used to connect to your DB2 database.
   Password	A case-sensitive password used to connect to your DB2 database.

   SQL Server Connectivity Properties

   Property	Value
   ServerName	Specifies either the IP address or the server name (if your network supports named servers) of the primary database server.
   User	The case-insensitive user name used to connect to your Microsoft SQL Server database.
   Password	A case-insensitive password used to connect to your Microsoft SQL Server database.

   For more information on using the JDBC drivers provided with BEA products, see JDBC Drivers.

8. Click on Save to persist your WebSphere configuration changes.