Define the JDBC data source within WebSphere

Create new data source
- Select Resources/JDBC/JDBC Providers
- Create a new JDBC Driver of the appropriate type for your database.
- Enter the path for the .jar containing your jdbc driver in the Classpath textbox.
  Note: The .jar is typically ojdbc14.jar for Oracle and jtds.jar for SQL. The oracle_jdbc_driver_path WebSphere variable can be set in Environment/Manage WebSphere Variables.
- Create a data source for the JDBC Provider
- Enter a JNDI Name (e.g. JDBC/”ExpereDoc”
Create a JAAS Authentication Alias
- Select or create a J2C authentication
- Select or create an Alias
  - User ID – Expere Data Model schema owner
  - Password – Expere Data Model schema owner
- Save
- Select DefaultPrincipalMapping from the Mapping-Configuration Alias drop down
- Click Custom Properties for the data source
- Perform one of the following (depending on your database)
  - Create the custom property URL with the value (for Oracle): jdbc:oracle:thin:@<database_host>:<port>:<oracle_sid>
  - For SQL: jdbc:jtds:sqlserver://<hostname>:<port>/<database name>
- Finish the process and save
- Click the checkbox next to Name. Click Test the connection.