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.
