Create the Data Source for ORACLEDATASTOREDS

  1. Select Services> Data Sources.
  2. In the configuration section on the right, click New and Select Generic Data Source.
  3. In the JDBC Data Source Properties pane that appears:
    1. 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.
    2. Change the JNDI Name to ORACLEDATASTOREDS.

    Note: This name cannot be anything other than ORACLEDATASTOREDS.

    1. Select the Oracle database type.
  4. Click Next.
  5. Select the driver "*Oracle Driver (Thin XA) for Service Connections; Version:Any"
  6. Select Next.
  7. Select Next again when Transaction options are displayed.
  8. In the Connection Properties pane:
    1. Enter the Database Name.
    2. Enter the Host Name of the database server.
    3. Enter the Port number of the database server.
    4. Enter the Database user name. This can be obtained from the database administrator who installed the databases.
    5. Enter both password entries. This can be obtained from the database administrator who installed the databases.

                                        

  1. Select Next.
  2. Test the database connection.

  3. Select Next.

  4. 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.

  5. Select Finish.

           

 

 

 

Oracle Insurance Logo Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us