Creating an ETL Load Plan (ODI Only)

Though Oracle Argus Analytics includes ETL Load Plans for extracting data from Oracle Argus Safety to Oracle Argus Analytics data mart, you may want to create your own ETL Interfaces/Mappings to extract data from other data sources.

Note:

The value of DATASOURCE_NUM_ID is set to 1 for Oracle Argus Safety and is taken from the view VW_DATASOURCE present in the Oracle Argus Analytics Source Schema (AN_SRC). Update this view to change the DATASOURCE_NUM_ID number, only if desired.

Also, ensure that this change (if needed) is done prior to running the Full Load for Oracle Argus Analytics. By default, we advise not to change this value (view).

See Also:

• Oracle ® Fusion Middleware Developer's Guide for Oracle Data Integrator 11g/12c

To add one or more tables or columns along with the associated ETL Load Plans to populate data into these tables, perform the following tasks:

1. Create the new Datastore for source and target table metadata inside the appropriate ODI Models.
2. Work in ODI Studio and create the ETL components (Interface/Mapping and its Scenario) for this program to populate the table or column appropriately.
3. Edit or create an existing Load Plan.
4. Add the scenario generated at the appropriate hierarchical level and position where it needs to be executed, in the Load Plan.
5. Save the Load Plan.