ETL status for enterprise products

You can view the data migration status (ETL) from the Argus Safety source system to the Enterprise Edition application target systems: Argus Insight, Argus Mart, and Argus Analytics. This ETL status is displayed in a dashboard. The ETL Status dashboard is available for both Argus English and Argus Japan users.

To view the ETL status, click Dashboards > ETL Status.

Note:

This menu option appears only when it is enabled from Argus Console > Access Management > Groups > Menus > File > ETL Status.

• The ETL Status dashboard displays the most recent row from the frequently executed ETL processes.
• For Argus Safety Standard Edition, a message appears as No ETL runs available.
• For Argus Safety Enterprise Edition, both new installations and post upgrade:
  • ETL status of the subscribed products is displayed. Unsubscribed product row does not appear in the dashboard.
  • When an ETL is not started, or no records are present for the product, then Not Startedstatus is displayed.

Note:

When the ETL logs are cleaned up, the Not Started status is displayed in the dashboard.

General information—field descriptions

Field	Description
Product	Displays the name of the Enterprise Edition application: Argus Analytics Argus Insight Argus Mart Note: If any product is not integrated, then that option is not displayed.
Database Name	Displays the database names of the enterprise product.
ETL Type	Displays the ETL execution type. Initial—Performed initially, a full copy of the data set is transferred from the source to the target system. Incremental—Performed on regular basis, changes made to the ICSR cases in the Argus Safety source database are captured from the last migration, including new records, updates to existing records, and deletions.
Start Date (GMT)	Displays start date and time of the initial or incremental ETL execution. Date is displayed in the DD-MMM-YYYY H24:MM: SS GMT format. Note: When the ETL Status is Not Started, the Start Date column remains blank.
End Date (GMT)	Displays end date and time of the initial or incremental ETL execution. Date is displayed in the DD-MMM-YYYY H24:MM: SS GMT format. Note: When the ETL status is In-Progress, Not Started, or Unknown, the End Date column remains blank. When the ETL status is Completed or Failed, the End Date displays the date and time. For Argus Insight, when the ETL status is Failed, the End Date column remains blank.
Status	Displays the data migration status. Green circle—ETL execution has completed successfully. Yellow circle—ETL execution is in-progress. Red circle—ETL execution has failed and stopped due to errors. Blue circle—ETL execution has not started. Grey circle—ETL execution status is unknown and cannot be retrieved due to communication link error. When the status is Failed (red circle), an error link appears in the Status column. Click this error link to view details.
Refresh	Click Refresh to retrieve the recent ETL execution status from the respective databases.