/
ETL+ Extract, Transform and Load (ETL) Page

ETL+ Extract, Transform and Load (ETL) Page

  1. Data Warehouse info: The target database/data warehouse that is loaded with data extracted from the ETL Sources and ETL Objects. Name of the data warehouse connected to this ETL+ session. The info shows as [<MS SQL Instance Name>].[<Database name>].

  2. Find. Click to open the search box. (shortcut: Ctrl + F)

  3. Log. Click to open the ETL Log page. (shortcut Ctrl + G)

  4. Help. Click to open documentation for this ETL+ page in a web browser (shortcut F1)

  5. Settings. Click to open the Settings page.

  6. Version number: format: vYYYY.MM.DDBB.

    • Example: v2022.08.2901 means the 1st build on 08/29/2022.

  7. ETL+ User name and Entity for the current session.

    • User: the ETL+ username (email address) that is currently logged to ETL+.

    • Entity: the Entity identifies the mappings shown on this page.

  8. Close. Click to close the current ETL+ session.
    To close without saving changes click Close and click Yes to the ‘Leave without saving?' prompt.

  9. Save. Click to save changes (shortcut Ctrl + S).

    • An asterisk indicates there are unsaved changes.

    • Create Table, Delete Table, Load Now and other functions automatically save changes.

  10. ETL Source panel.

  11. ETL Objects panel.

  12. ETL SQL Statement panel.

NOTES: Hover over and/or right-click icons and objects on ETL+ to view their functions and/or metadata.


ETL Source Panel

Names and maintains connections to data sources.

ETL Source panel of ETL+ Extract, Transform and Load (ETL) window.

  1. Add Table: Select a table under a data source and click Add Table.

  2. Add Data Source: Click to add a new data source. More at ETL+ Source Types | Adding Data Sources

  3. Delete Source.
    Select a data source and click to delete.

  4. Refresh. Select a data source and click to refresh it's list of tables. (F5)

  5. Properties. Select a data source and click to change the settings.
    Similar to Add Data Source. More at ETL+ Data Sources | Configuring a Data Source


data sources. Select a data source and click Properties to configure. (Ctrl + I)