Run the Extract, Transform, and Load Process
The Extract, Transform, and Load (ETL) process enables you to move data from your drug safety database, reformat the data, and then load the data into another database (data mart) for querying, drill-down analysis, and report generation.
Beginning with Oracle Argus Insight 7.0, ETL Scheduler is a user role defined in the Security tab on the ADMINISTRATION TOOLS page. This role is available across all enterprises at a global level.
The ETL Scheduler screen can be displayed, updated, and audit logged from the default enterprise in a multi-tenant installation. Only those users who have been assigned the ETL Scheduler role can view this screen.
Oracle Argus Insight application has been enhanced to run on Oracle Argus Mart database now. With changing time, Oracle Argus Mart database may be used as a primary database in future for all querying and reporting purpose as it contains useful information related to different case revisions. With this information, you can create and execute point-in-time queries in Oracle Argus Insight for a deep dive into historical data.
If you do not wish to use Oracle Argus Insight database along with Oracle Argus Mart, a new feature has been introduced in ETL process for copying only configuration tables from Oracle Argus Insight database. These configuration tables are still required for proper functioning and use of Oracle Argus Insight UI with Oracle Argus Mart database. Population of Case tables data can be turned off which will help save the Oracle Argus Insight ETL time if its data is not used anymore for querying and reporting purpose. For list of case tables, see Appendix: Oracle Argus Insight Case Tables.
To turn off Oracle Argus Insight case table population, use profile switch POPULATE CASE/CONFIGURATION DATA.
To fetch Oracle Argus Insight specific data in Oracle Argus Mart, enable profile switch ENABLE_AI_PROCESSING before running Oracle Argus Mart ETL. See Table 12-1.
Note:
The instructions given in this chapter are specific to Oracle Argus Insight ETL only and will not populate the Oracle Argus Mart database. For instructions on how to run Oracle Argus Mart ETL, refer to the Oracle Argus Mart Installation and Administration Guide.
For more information, see: