Process Analytics > Administration Guide > Overview > ETL Process

ETL Process

The command line program of Process AnalyticsAn Automic graphical analysis tool that displays the activities, statistical data and forecast data per Automation Engine system client in a bar diagram and that can be used to calculate the critical path. [Formerly called "ClearView," "Graphical Workload Analyzer," or "JobMonitoringStudio (JMS)."] Admin starts the ETL process (data-loading process). The following steps define the ETL process).

(1) Extraction

The AE databaseA database is an organized collection of data including relevant data structures. stores the meta data of tasks (executable objects such as workflows or jobs) in the AE system. It is stored in the following AE database tables and can be called by using the ETL process.

(2) Transformation

Depending on the taskAn executable object that is running. Tasks are also referred to as activities. model, the data is converted accordingly. Each task is converted in a way that it can be displayed in Process Analytics as a long-running task, a single task or as a parentThere are different ways of activating objects. The originator of an activation is referred to as the superordinate task (parent). See also: Child; Children objectAutomation Engine controlled activities and processes are structured in the form of objects. See also: Task.

(3) Loading

The task model data is loaded to the Process Analytics Database. The following Process Analytics database tables refer to the ETL process and store the following information:

ETL Process

You can determine the source database (AE database) and the target database (Process Analytics database) during the Process Analytics Admin configuration process.

 


Automic Documentation - Tutorials - Automic Blog - Resources - Training & Services - Automic YouTube Channel - Download Center - Support

Copyright © 2016 Automic Software GmbH