Create 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.

Before creating the JDBC Datasources you must have defined:

A new JDBC provider containing the drivers provided by BEA, as explained in Create BEA JDBC Provider.
Two authentication data entries: one for the ALBPM Directory Database and one for ALBPM Engine's backend database, as explained in Add Authentication data for JDBC.

To create a JDBC datasource for the directory DB:

Login to WebSphere's Administration Console. By default, it runs on http://host:9060/ibm/console.
Go to Resources > JDBC > JDBC Providers and click on the BEA JDBC Provider you created previously.
Click on Data sources, located in the Additional properties section.

Click New to create a new Data source for ALBPM Directory database. Enter the following configuration information for the new data source:

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

Option

Value

Data source name

ALBPM Directory Datasource

JNDI name

FDIDS

Component-managed Authentication Alias

Select the Authentication entry you defined previously for ALBPM Directory database. Example:

<node>/ALBPM Directory DB Auth

Click Next and enter the following Data store helper class name: albpm.jdbc.websphere.ALBPMDataStoreHelper .
Click Next, then Finish after reviewing all selected options.
Select the data source you just created.
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.

Configure the following required 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.

Click Save to persist your WebSphere configuration changes.
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

The JDBC datasources for the ALBPM Directory database is configured.