Extract, Transform and Load (ETL) page
ETL+ main page upon login
Displays and allows creation and editing of an entity’s (cloud) metadata from any ETL+ installation
ETL+ licensed user
(Other rights are encrypted within the ETL+ metadata)
Gear icon in upper right corner of most pages
Client info, Data Warehouse options, and other parameter settings
Administrator user required to create new entities, and manager user and Data Warehouse settings
Listed on Source Objects
(Left panel in main ETL+ page)
Provides connection configurations for importing from outside source systems (data sources or source types) and to reimport from the DataSelf Data Warehouse.
Once entered by client, source data passwords are encrypted within the ETL+ metadata
Data access details and permissions
any additional software that is required by the source
a person to enter source user/password information
Right panel in main ETL+ page
SQL statement (or other data format) to be sent to Source Container for the initial data extraction
Pane at the bottom of the right (Extract SQL Statement) panel
Options for various partial load types
Alert tech’s if a source table’s standard Primary Key has been customized
Center panel of main ETL+ page
Add and maintain the tables that will load into the Data Warehouse
Open from Target Object’s menu
Open from Target Objects panel.
Usually associated to an entity of an organization. For instance, a company’s domain (xyzcorp), or a data source (xyzcorp_erp), or a department (xyzcorp_sales).
It includes the ETL+ metadata such as the access to data sources, target data warehouse, which tables are extracted and more.
ETL+ users have named user licenses to open and maintain one or more specific entities.
Each ETL+ page lists its currently open Entity in the lower left corner.