Create the Data Source for ORACLEDATASTOREDS
- Select Services> Data Sources.
- In the configuration section on the right, click New and Select Generic Data Source.
- In the JDBC Data Source Properties pane that appears:
- Change the Name. This name can be anything, but has to be unique for the entire Web-logic server. If you have more than one ODS instance on the server, then each instance should have a unique name.
- Change the JNDI Name to ORACLEDATASTOREDS.
Note: This name cannot be anything other than ORACLEDATASTOREDS.
- Select the Oracle database type.
- Click Next.
- Select the driver "*Oracle Driver (Thin XA) for Service Connections; Version:Any"
- Select Next.
- Select Next again when Transaction options are displayed.
- In the Connection Properties pane:
- Enter the Database Name.
- Enter the Host Name of the database server.
- Enter the Port number of the database server.
- Enter the Database user name. This can be obtained from the database administrator who installed the databases.
- Enter both password entries. This can be obtained from the database administrator who installed the databases.
- Select Next.
-
Test the database connection.
-
Select Next.
-
In the Select Targets pane that appears, check the box for the "ODS_Server" application server. This links the data source to the server that was created.
-
Select Finish.