Move Windows User variables to the Windows ProgramData area.
Simplifies running ETL+ and its auto refresh processes regardless of Windows users.
Collaboration: When a user is editing an ETL+ entity, other users can only log, view or copy its settings. To release editing to other users, Save the entity or close ETL+.
Other users trying to edit it will receive the message: “username is currently editing this entity. You can only view it. To re-load the modified entity, exit and re-enter ETL.”
Collaboration: When a user tries to edit ETL+ but the metadata has changed by another user, ETL+ gives the message: ETL+ metadata has changed. In order to edit your ETL+, please exit and re-enter to re-load your metadata.
Allowing users to open more than one ETL+ at the same time.
When running Refresh Schedules in parallel, log each of them on their own block (easier to read log file).
Table Load Types in Refresh Schedules: Refresh Schedules can run the default table load type (Refresh All, Replace with Control, Update, Append), or force a "Replace All". This helpful when using delta refreshes on a frequent schedule, and then forcing a replace all on a less frequent schedule to capture old records that have been deleted or modified.
ETL+ lets the same Refresh Schedule run in parallel, but might issue the error message: [DS ERROR : 0902] ETL+ cloud log conflict. Two or more ETL+ are running the same Refresh Schedule at the same time. The data refresh might be ok.
ETL+ allows the refreshing of the same data warehouse table in parallel. Users need to understand the implications of using this feature since it can lead to data consistency issues. Ex.: it’s Ok to append different data sets in parallel, but a full refresh in parallel is likely not desirable.
When editing ETL+, add an * to the Save button to indicate changes haven’t been saved yet. Clicking Save removes the * flag.
Support to OData v4. First release. Test it before using it for production.
Resized ETL+ UI to fit small resolutions down to 800x600.
ETL+ UI can be switched between default size, full screen mode and minimized.
New redesigned ETL+ metadata for better auto documentation, faster performance and reporting.
Upgrade from prior ETL+ versions requires the re-creation of entities, users and statements.
When refreshing tables on ETL+ UI, the refresh progress indicator shows the Refresh Schedule name at the top, the table counter and % progress inside of the circle, and the table being imported at the bottom.
Show ETL version and 32/64bits on the main page.
Ability to define MS SQL Server data warehouse’s database schema. The default schema = ETL+ EntityID. ETL+ admin users can set the schema to any other value (such as dbo). Multi-tenant data warehouses' ID=1 will always have schema = ETL+ EntityID.
RWC and Update will do the first refresh in full refresh mode.
Removed dozens of locally saved variables that are no longer used (they were used before metadata moved to the cloud).
"Leave without saving?" when a user tries to close ETL+ without saving changes.
For users with access to multiple entities, ETL+ remembers the last entity opened.
Show ETL version and 32/64bits on the top right of main pages.
Strong encryption of ProgramData info.
Log changes to the source system’s connection string.
Left and right trim to all user input fields (avoids spaces in usernames and passwords).
ETL+ captures who saved an ETL SQL Statement version. Currently, only available in the ETL+ metadata.
More informative error message when ETL+ cannot connect to its metadata or data warehouse.
If two or more ETL try to refresh the same table at the same time, if the table has RWC or Update, it might give the error message: [DS ERROR : 0910] Two or more ETL+ tried to refresh the XYZ data warehouse table at the same time. This can cause data consistency issues. Please run a full refresh for this table again.
ETL+ version number set to YYYY.MM.DDNN (NN is sequential starting on 01).
ETL+ EULA and About pages inform the latest ETL+ version and URL for download (in case users are installing an older version accidentally).