UI: Many buttons have been replace by icons.
UI: Mousing over icons shows tooltips with the icon function name and/or metadata.
UI: Contextual icons - they are grayed out when they don’t apply to selected objects (ex.: selecting a table on the Source panel disables Delete Data Source).
UI: Right clicking on the left two panels pops up the icon functions. The pop ups show the icons and their function names.
UI: Clean up of the ETL+ main page (some functions have been moved to other pages).
Multiple data sources: When opening ETL+, the data source(s) will not list its table names by default. This enables a fast opening of ETL+ since it doesn’t have to wait to list source system table names dynamically. Click a data source and the ‘Refresh’ icon to list its table names - this process can take several seconds if the source system is slow to render its table name list.
Multiple data sources: Imports data from multiple data sources within the same ETL+ entity.
Multiple data sources: Source panel shows all data sources created.
Multiple data sources: Data sources are represented by a cylinder icon, and their table name list can be expanded or collapsed with the +/- icon by the data source icon. Tables are represented by a square window icon.
Multiple data sources: Select a table from a data source and click the ‘Add Table’ icon/function to map it to the ETL process.
Multiple data sources: Click the ‘Add Data Source’ icon/function, select a data source type (CSV, MS Excel, MS SQL Server, OData, ODBC), configure the connection information, click Connect (or Save if available).
Multiple data sources: Configuration of data sources now includes an Alias (DSN Alias).
Multiple data sources: Configuration of data sources now includes a ‘Dw Schema’ checkbox. When checked, tables from this data source will be stored in the data warehouse using a SQL schema = DSN Alias. When unchecked, tables will be stored in the default data warehouse SQL schema.
Multiple data sources: In the DSN configuration page, use the ‘Change Data Source’ icon to replace it to another type (ex.: from OData to MS SQL).
Multiple data sources: The DSN pages have a Save button (helpful when doing remote DSN maintenance without access to the DSN).
Multiple data sources: Select a data source and click the ‘Delete Data Source’ icon/function to delete.
Multiple data sources: Select a data source and click the ‘Refresh’ icon/function to reconnect to the data source and list its tables.
Multiple data sources: Select a data source and click the ‘Properties’ icon/function to configure its settings.
Multiple data sources: Mousing over the left panel’s data source icons shows its metadata.
Multiple data sources: Mousing over the left panel’s tables from a data source shows its metadata.
Multiple data sources: The center panel organizes the data warehouse tables by data source alias.
Multiple data sources: The center panel data source alias icon is a square with 3 objects in it. You can expand/collapse the list of data warehouse tables with the +/- icon by this icon.
Multiple data sources: Mousing over the center panel’s data source alias icons shows its metadata.
Multiple data sources: Mousing over the center panel’s tables shows its metadata.
Multiple data sources: When a data source has its table names listed on the left panel, and the user clicks that same table on the center panel, the cursor will select the table on the source system list.
Multiple data sources: Clicking on a center panel’s data source alias icon and the ‘Load Now’ icon will load all of its mapped tables to the data warehouse.
Multiple data sources: ‘Refresh Schedule’ button changed/renamed to ‘Refresh Batch’ icon.
Multiple data sources: ‘Refresh Batch Now’ has been moved to the 'Refresh Batch' page.
Multiple data sources: Ability to import data from the data warehouse for further data prep.
Load UI: The load UI page is now integrated in the ETL+ application (not a detached layer).
Load UI: The load UI page now has the Cancel button. In a multi-table load process, clicking Cancel stops the load process when the table currently loading ends.
Load UI: For OData, it shows how many records have been extracted.
Cloud Watchdog: Monitors ETL+ scheduled refresh logging in the cloud and notifies administrators:
On error
When a scheduled refresh doesn’t start
When a scheduled refresh takes longer than expected
Cloud Watchdog: Emails notifications when ETL+ Notification Email = Always Cloud (for cases when ETL+ has no access to its SMTP server - deployments with tight firewall rules).
Settings: Creation of the Settings page and added its icon on ETL+ main page.
Settings: Page provides access to ‘Client Info’, notification about ‘3 secs between error retries', ‘Debug’ drop down, ‘0_EntityID Column’, ‘Data Warehouse’ configuration, ‘About’, 'Notification Email’.
Settings: Notification Email includes dropdown for:
Default: ETL+ always sends notification email)
On Error: ETL+ only sends email on error
Always Cloud: Cloud Watchdog always sends notification
Refresh Batch: Renaming Refresh Schedule to Refresh Batch, re-layout and clean up.
Refresh Batch: Bottom left section shows WTS summary configuration.
Refresh Batch: ‘WTS Settings’ button provides means to configure and apply WTS settings.
Refresh Batch: Click a 'Refresh Now' icon on the batch list to run it.
Refresh Batch: Add, Delete, Create Shortcut, and Enable became icons on the batch list.
Refresh Batch: List of Refresh Batch Steps shows twice as much vertical real estate (lists twice as many objects).
Refresh Batch: Refresh Batch Steps includes 3 new functions/scripts: ‘Tableau Extract Refresh', ‘Cloud Script’, 'Command Line’.
Refresh Batch: Clearer description of ‘All Data Warehouse Tables (include new ones)’ checkbox.
Refresh Batch: Click a step and ‘Move Up’ and/or ‘Move Down’ icons to re-order refresh sequence.
Refresh Batch: Click ‘+' icon ('Add Script’), and select a script type to create.
Refresh Batch: Select ‘Tableau Extract Refresh’ to configure an extract to be refreshed. These extracts must be hosted at https://dataselfbi.com and pull data from DataSelf's cloud data warehouses.
Refresh Batch: ‘Tableau Extract Refresh’ script needs the extract name. If the extract is not in the default Project (named ETL+'s Entity ID), enter the ‘Project’ name. If the extract is in a sub project, enter the 'Parent Project' name.
Refresh Batch: Select ‘Cloud Script’ to provide its name. Consult DataSelf to discuss your cloud script options (such as running other cloud ETL+ extractions, DataSelf Automatic Distribution, and Python custom applications).
Refresh Batch: Select ‘Command Line’ to provide its name and parameters. This will run the configured command line locally. Example of use cases: running locally Tableau extract refreshes, or on-premises DataSelf Automatic Distribution.
Refresh Batch: Select a script step, and click icons ‘Delete Script’, ‘Configure Script', or 'Run Script’ as needed.
Refresh Batch: Other UI buttons/icons become disabled when editing scripts.
Refresh Batch: Icons on the Steps panel differentiate objects between tables and scripts.
Refresh Batch: Mousing over icons provide its function, name and/or metadata.
Refresh Batch: ‘Run Refresh Batch’ has a simplified UI with a counter starting at 20 secs.
Logging: ETL+ logs description and time for new functions/scripts (Tableau Extract Refresh, etc).
Logging: When launching ETL+, the very first log is “ETL+ launched”.
Engine: Notifies when ETL+ doesn’t find the required .NET installed (.NET v7 or newer).
OData Extraction: When RWC or Update is configured, ETL+ will load in sets of up to 100 extraction blocks, execute the load of that set to the target table, and then run the next set of extraction blocks. This is helpful when extracting data from large tables. It helps Acumatica rendering speed, and provides intermediary starting points in case of failures or extraction quitting in the middle of the process.
OBDC Extraction: Support to MongoDB ODBC. Use native MondoDB ' (single quote) or ANSI [] (brackets) around reserved words and nested collections.
Improved error message description when ETL+ can’t connect to its data warehouse.
Added error message describing that MS SQL doesn’t accept insert in timestamp columns.
Super admin can now trigger the deployment of the out-of-the-box Tableau Site and Extract templates.