# ETLs Interface

1. Open a browser.
2. Append /etl to the OvalEdge environment's base URL.\
   **Example:** <mark style="color:$tint;"><https://ovaledgetest.xxx.xxxx/ovaledge/#nav/etl></mark>
3. The ETLs interface will load.

   <figure><img src="/files/zjkiLcAj3zwtbLFnK6IM" alt=""><figcaption></figcaption></figure>
4. The ETLs Home Page provides a centralized view of all configured ETL pipelines used to prepare and load data into staging tables for reporting and analytics. ETLs serve as the data pipeline layer between OvalEdge and external reporting tools such as Tableau and Power BI, enabling structured, reliable data consumption.
5. This page helps users review existing ETL pipelines, monitor schedules, track ownership details, and perform operational actions from a single location.

**Fields & Description**

<table><thead><tr><th width="164.66668701171875">Field</th><th>Description</th></tr></thead><tbody><tr><td>ETL Name</td><td>Displays the name of the ETL pipeline. Use this field to identify and access a specific ETL configuration.</td></tr><tr><td>Description</td><td>Displays the business purpose or summary of the ETL pipeline.</td></tr><tr><td>Staging Tables</td><td>Displays the staging tables associated with the ETL pipeline.</td></tr><tr><td>Cron Entry</td><td>Displays the configured cron expression used for scheduled execution.</td></tr><tr><td>Next Execution On</td><td>Displays the next scheduled run date and time for the ETL pipeline.</td></tr><tr><td>Added By</td><td>Displays the user who created the ETL configuration.</td></tr><tr><td>Added On</td><td>Displays the date and time when the ETL configuration was created.</td></tr><tr><td>Last Updated By</td><td>Displays the user who last modified the ETL configuration.</td></tr><tr><td>Last Updated On</td><td>Displays the date and time of the most recent update.</td></tr></tbody></table>

**More Actions**

Click the 9-Dots Menu to perform the following actions.

<table><thead><tr><th width="158.00006103515625">Action</th><th>Description</th></tr></thead><tbody><tr><td>Create ETL</td><td>Opens the Create ETL pop-up to configure a new ETL pipeline.</td></tr><tr><td>Run ETLs</td><td>Executes the selected ETL pipeline immediately.</td></tr><tr><td>Clone ETL</td><td>Creates a copy of an existing ETL configuration for reuse.</td></tr><tr><td>Delete ETLs</td><td>Removes the selected ETL configuration.</td></tr><tr><td>Clear Data from Staging Tables</td><td>Removes existing records from staging tables while retaining table structures.</td></tr></tbody></table>

### ETL Pipeline Creation

Click Create ETL. The Create ETL pop-up is displayed. \
![](/files/1yIIJeO633BxyKAdJWVY)

The Create ETL pop-up allows users to configure a new ETL pipeline to create staging tables and load data for reporting and analytics. It provides a guided setup to define connection details, SQL scripts, execution preferences, and scheduling information for automated or on-demand processing.

Users can define the ETL Name and Description, select a Connector, and configure scripts required to create, load, clear, and delete staging data structures.

The pop-up includes built-in validations to ensure mandatory fields are completed and values are correctly formatted before the ETL configuration is saved.

<table><thead><tr><th width="198.6666259765625">Field</th><th>Description</th></tr></thead><tbody><tr><td>ETL Name</td><td>Enter a unique name for the ETL pipeline. This name helps users identify the ETL configuration.</td></tr><tr><td>Description</td><td>Enter the business purpose or summary of the ETL pipeline.</td></tr><tr><td>Connector</td><td>Select the connector used to run the ETL process and access the target database.</td></tr><tr><td>Staging Tables Creation SQL Scripts</td><td>Enter SQL scripts used to create staging tables, schemas, or required database objects.</td></tr><tr><td>Data Insertion SQL Scripts</td><td>Enter SQL scripts used to extract, transform, and load data into staging tables.</td></tr><tr><td>Clear Existing Data SQL Scripts</td><td>Enter SQL scripts used to remove existing records from staging tables while retaining structures.</td></tr><tr><td>Staging Tables Deletion SQL Scripts</td><td>Enter SQL scripts used to drop staging tables or related database objects when no longer required.</td></tr><tr><td>Clear Data Before Running</td><td>Enable this option to clear existing staging data before the ETL load process starts.</td></tr><tr><td>Schedule</td><td>Enter a cron expression to configure automated ETL execution.</td></tr><tr><td>Time Zone</td><td>Displays the local time zone used for schedule execution.</td></tr></tbody></table>

Click the **Save/Submit** button to validate the entered details and create the ETL configuration.

Click the **Cancel** button to close the pop-up without saving changes.

### Running the ETL Pipeline

{% hint style="info" %}
Always verify database connectivity and system settings before running ETL scripts. Clear scripts can be used before reprocessing data to prevent duplication.<br>
{% endhint %}

**First Run:**

1. After saving, select the newly created ETL job.
2. Click on the 9-Dot menu and select Run ETL(s)
3. The Creation Scripts run first to create staging tables.
4. Data loads using the ETL Script.

**Subsequent Runs:**

1. Creation Scripts are disabled (tables already exist).
2. Only the ETL Script runs to refresh data.

***

Copyright © 2026, OvalEdge LLC, Peachtree Corners, GA, USA.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ovaledge.com/release8.1/advanced-tools/etls/etls-interface.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.