Create the Data Sources

  1. The following data sources must be created:
    1. ORACLEDATASTOREDS
    2. STAGINGDATASTOREDS
    3. TARGETDATASTOREDS
  2. A readonly database user should be used for STAGINGDATASTOREDS, TARGETDATASTOREDS. Repeat the following steps for each data source, replacing <DATASOURCE_NAME> with the specific data source being configured.
    1. Select Resources>JDBC>Data sources.

    2. Click New.

    3. For the data source name, enter <DATASOURCE_NAME>.

    4. For the JNDI name, enter <DATASOURCE_NAME>.

    5. Click Next.

    6. Select the JDBC provider created in the last step.

    7. Click Next.

    8. Enter the database connection information.

      • For Oracle, enter the database information in the following format:

      jdbc:oracle:thin:@hostname:port:SID

      • For DB2, enter the database name, hostname and port. Uncheck the checkbox for Use this data source in container managed persistence.

    9. Click Next.

    10. On the Setup security aliases screen, click Next.

    11. Click Finish.

    12. Select <DATASOURCE_NAME> from the list of data sources that appears.

    13. Select Custom Properties.

    14. Click New to create new variables for each property listed below.

      • For Oracle:

      Name: user; Value: database user name

      Name: password; Value: database password

      • For DB2:

      Name: user; Value: database user name

      Name: password; Value: database password

      Name: currentSchema; Value: schema name (only needed for readonly data source)

    15. In the Messages area at the top of the screen, click the link for Save to the master configuration.

    16. Once complete, return to the Datasources screen and use the Test Connection button on the main data source list to confirm that the settings were successful for each data source.

 

 

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