ETL Summary
In the ETL Home page, click the required ETL Name. The Summary page is displayed. It provides a centralized view of the selected ETL pipeline, including configuration details, execution settings, SQL scripts, and audit history.
This page helps users review and manage the ETL setup, monitor configuration changes, verify scheduling details, and understand the pipeline's structure for staging and reporting workflows.
The Audit History section tracks updates made to the ETL configuration, including user and timestamp details.
Description
Displays the business purpose, functional scope, or usage details of the ETL configuration. It helps users understand why the ETL job was created, what type of data it processes, and how it supports reporting or analytics requirements.
ETL Metadata
Displays audit and ownership details related to the ETL configuration. It helps users identify who made the latest changes and when the configuration was modified.
ETL Connection Info
Displays the connector details associated with the ETL job. It helps users verify which connection is used to run the ETL process, including connector identifiers and names used for source or target database access.
ETL Configuration
Displays the execution settings configured for the ETL job. It helps users review schedule details such as the cron expression, next execution time, and other run-time preferences that control when and how the ETL job is executed.
Staging Tables Creation SQL Scripts
Displays the SQL scripts used to create staging tables, schemas, or required database objects before the ETL load process begins. It helps users understand the structures required for ETL processing.
Staging Tables Creation SQL Scripts Pop-up
Displays a detailed and expanded view of the staging table creation scripts. It helps users review the full SQL statements used to create tables, indexes, schemas, or related database objects required for ETL processing.
Data Insertion SQL Scripts
Displays the SQL scripts used to extract, transform, and load data into the staging tables. It helps users understand the logic behind populating reporting structures.
Data Insertion SQL Scripts Pop-up
Displays a detailed and expanded view of the data insertion scripts. It helps users review the complete SQL logic used during ETL execution to load and refresh staging data.
Clear Existing Data SQL Scripts
Displays the SQL scripts for removing existing records from staging tables while retaining the table structures. It helps users clear staged data before reprocessing or refreshing records.
Clear Existing Data SQL Scripts Pop-up
Displays a detailed and expanded view of the scripts used to clear existing data from staging tables. It helps users review, truncate, delete, or clean up statements configured for pre-load processing.
Staging Tables Deletion SQL Scripts
Displays the SQL scripts for dropping staging tables, schemas, or other related database objects when the ETL configuration is no longer required. It helps users remove obsolete staging structures.
Staging Tables Deletion SQL Scripts Pop-up
Displays a detailed and expanded view of the deletion scripts. It helps users review the SQL statements for removing staging tables and related structures from the database.
Clear Data Before Running
Use the toggle button to define whether existing data in staging tables will be cleared before the ETL load process starts. It helps users avoid duplicate records during reprocessing or refresh operations.
Audit History
Displays the history of changes made to the ETL configuration. It helps users track updates with user and timestamp details.
More Actions
Click the 9-Dots Menu to perform the following actions.
Run ETL
Executes the selected ETL pipeline immediately.
Clone ETL
Creates a copy of the current ETL configuration for reuse.
Delete ETL
Removes the selected ETL configuration from the system.
Clear Data From Staging Tables
Removes existing records from staging tables while retaining table structures.
Copyright © 2026, OvalEdge LLC, Peachtree Corners, GA, USA.
Last updated
Was this helpful?