Use Schema Creation Tool

You create the Oracle Argus Insight data mart structure, and create a link between the source Oracle Argus Safety database and the new Oracle Argus Insight data mart. The Extract Transform and Load (ETL) process uses this link to transfer data from your Oracle Argus Safety database to the Oracle Argus Insight data mart for reporting purposes.

During the schema creation process, you create four database users: one user for logging in to the Oracle Argus Insight application, two other users who are schema owners, and one user for supporting private database links (DB Links).

The Schema Creation Tool provides the following options:

  • Initial ETL—Runs the initial process of extracting, transforming, and loading data.
  • Exit—Exits from the Schema Creation Tool.

For detailed information about using the Schema Creation Tool to create the Oracle Argus Insight data mart structure, including the database link, users, and roles, see the Oracle Argus Insight Installation Guide.