4 Extract Transform Load Programs

To load data from the source systems to the data mart, Oracle Argus Analytics uses Extract Transform and Load (ETL) programs that

• Identify and read desired data from different data source systems,
• Clean and format data uniformly, and
• Write it to the target data mart.

In Oracle Argus Analytics, Oracle Argus Safety is the source system for which Oracle provides pre-defined ETL.

This chapter contains the following topics:

• ETL Architecture
  
• Executing the ETL Load Plans in ODI
  
• Customizing an ETL Execution Plan/Load Plan (ODI)
  
• Creating an ETL Load Plan (ODI Only)
  
• Modifying an ETL Load Plan (ODI Only)
  
• Scheduling an ETL Load Plan (ODI Only)
  
• Customizable User Exits in Oracle Argus Analytics ETLs