Create the Data Source for STAGINGDATASTOREDS
- Select Services> Data Sources.
- In the configuration section on the right, click New and then 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 OIPA instance on the server, each instance should have a unique name.
- Change the JNDI Name to STAGINGDATASTOREDS.
- Select the database type.
- Select the driver type.
- Select the driver "*Oracle Driver (Thin XA) for Service Connections; Version:Any"
- 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 for a staging user. 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 servers that were was created.
- Select Finish.