Configure the Topology in Oracle Data Integrator Studio

1. Open the Oracle Data Integrator Studio and connect as Oracle Argus Analytics Work Repository.
2. Navigate to Topology.
3. Select the Physical Architecture tab.
4. Expand the tree structure to expose the following:

   Technologies > Oracle >

5. Edit the node DS_AN_ArgusAnalytics.
6. Edit the following fields in the Definition window:

   • Instance/dblink (Data Server):

     The complete TNS entry of the DWH server should be pasted here in a single line:

     (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <DWH_DB_SERVER>)(PORT = <DWH_DB_LISTENER_PORT>)) (CONNECT_DATA =(SERVICE_NAME=<DWH_DB_SERVICE_NAME>)))

   • Connection:

     • User: <AN_DWH_WRK> [the DWH work schema user created during installation]
     • Password: <AN_DWH_WRK_PASS> [The password for the DWH Work schema]
7. In the JDBC window, edit one of the following fields:
   • JDBC URL: jdbc:oracle:thin: <DWH_DB_SERVER>:<DWH_DB_LISTENER_PORT>:<DWH_DB_SID>
   • jdbc:oracle:thin: <DWH_DB_SERVER>:<DWH_DB_LISTENER_PORT>/<DWH_DB_SERVICE_NAME>
   Use the jdbc connection string with database SERVICE_NAME in case the Oracle Database version is 19c.
8. Save the details and click Test Connection to validate it.
9. Expand the tree below DS_AN_ArgusAnalytics to expose the tree node DS_AN_ArgusAnalytics.AN_DWH.
10. Edit the node DS_AN_ArgusAnalytics.AN_DWH.
11. Change the Schema by selecting from the drop-down list for the following fields:
    • Schema (Schema): <AN_DWH>
    • Schema (Work Schema): <AN_DWH_WRK>
12. Save the changes.
13. Similarly, edit the node DS_AN_ARGUS_SAFETY to provide information on the Oracle Argus Safety DB Server.
14. Edit the following fields in the Definition window:

    • Instance/dblink (Data Server):

      The complete TNS entry of the DWH server should be pasted here in a single line:

      (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <AS_DB_SERVER>)(PORT = <AS_DB_LISTENER_PORT>)) (CONNECT_DATA =(SERVICE_NAME=<AS_DB_SERVICE_NAME>)))

    • Connection:

      • User: <AN_SRC_WRK> [the AN Source Work Schema user created during installation]
      • Password: <AN_SRC_WRK_PASS> [The password for the AN Source Work Schema]
15. In the JDBC window, edit one of the following fields:
    • JDBC URL: jdbc:oracle:thin: <AS_DB_SERVER>:<AS_DB_LISTENER_PORT>:<AS_DB_SID>
    • jdbc:oracle:thin: <AS_DB_SERVER>:<AS_DB_LISTENER_PORT>/<AS_DB_SERVICE_NAME>
    Use the jdbc connection string with database SERVICE_NAME in case the Oracle Database version is 19c.
16. Save the details and click Test Connection to validate it.
17. Expand the tree below DS_AN_ArgusSafety to expose the tree node DS_AN_ArgusSafety.AN_SRC.
18. Edit the node DS_AN_ArgusSafety.AN_SRC.
19. Change the Schema by selecting from the drop-down list for the following fields:
    • Schema (Schema): <AN_SRC>
    • Schema (Work Schema): <AN_SRC_WRK>
20. Save the changes.