Set up the Oracle Non-XA Database Driver Data Source

Navigate to Resources->JDBC->Data Source.
Choose the scope appropriate for your environment
Start the process for creating a new data source.
Click New to add a new data source.
Set the fields as follows:
- Data source name: curamdm
- JNDI Name: jdbc/curamdm
- Click Next.
- Select an existing JDBC driver, the driver created in Section "Setup the XA Database Driver" and hit next.
Set the URL Value field to the value below where serverName is the name of the server hosting the database. Port is the port number the database is listening on and databaseName is the SID of the database. This is the URL to connect using Oracle SID name:
jdbc:oracle:thin:@serverName:port:databaseName
Set the Data store helper class name to be Oracle,e.g for Oracle 10g data store helper.
Leave all other fields untouched unless a specific change is required and click Next:
- Set the Component-managed authentication alias drop down value to <none>.
- Set the Mapping-configuration alias drop down value to <none>.
- Set the Container managed-configuration alias drop down value to <Alias created in Section "Setup the non-XA Database Driver" >
Leave all other fields untouched unless a specific change is required and click Next.
Click Finish to confirm the changes and continue.