Integrated IP Whitelisting. If ETL+ can’t connect to DataSelf cloud servers, it whitelists the new IP once the user enters the correct product registration information.
Friendlier installation. ETL+ is now an executable-only application. One just needs to download and run it. No installer, no changes to the Windows environment, no need to Run as Admin (unless in some systems when creating Windows Task Schedule tasks).
ETL+ automatically sorts columns alphabetically when adding new source system tables.
Enable SELECT * from MS SQL and OData data sources. Preview only works with MS SQL sources.
OData extraction ignores duplicated column names (avoiding OData → SQL extraction errors).
Refresh Schedule page: “All Tables” checkbox to include new tables added to the ETL process.
Refresh Schedule page: “Tableau Subset” checkbox runs a dedicated Tableau refresh batch for the selected Refresh Schedule. Example: the default Refresh Schedule refreshes all Tableau extracts overnight, and a 2nd one refreshes a subset of Tableau extracts hourly. The creation of Tableau refresh batches continues to be a manual process done by DataSelf.
Refresh Schedule page: “Create Shortcut” checkbox to create ETL+ auto refresh shortcuts.
Refresh Schedule page set to 800x600 resolution.
Refresh Schedule page lists Schedule ID (3rd parameter when running ETL+ via command line).
Windows Task Scheduler: “Repeat tasks every” X minutes (ex.: run every 5 mins starting at 8am).
Windows Task Scheduler: “For a duration of” X hours (ex.: run every 5 mins starting at 8am for 12 hours). To configure indefinite tasks, set duration to 24 hours.
Windows Task Scheduler: Enable configuration of “Recurs every” X days (ex.: once a week).
Windows Task Scheduler: Schedules tasks into the future (to prevent users from mistakenly configuring tasks in the past).
Windows Task Scheduler: UI re-layout for better clarity and more real estate for configurations.
Speed: “Update” delta refresh creates data warehouse indexes for the filter and index columns.
Speed: “Replace with Control” delta refresh creates a data warehouse index for the filter column.
SQL Integrity: “Update” delta refresh turns varchar(max) filter and index columns into char(50).
SQL Integrity: “Replace with Control” delta refresh turns a varchar(max) filter column into char(50).
When running ETL+ for the 1st time, the DataSelf cloud servers connection only happens after the user has accepted the EULA.
If ETL+ can’t download the EULA: it’ll show the EULA page blank (probably an internet connection, firewall or antivirus issue).
When ETL+ can’t connect to DataSelf cloud servers: shows error about IP whitelisting and/or firewall and antivirus adjustments. And then tries to whitelist IP (see feature 1 above).
Super admin: Settings page to select, modify or new data warehouse and its SQL schema. Blank schema = EntityID. Enter the new name to change the schema. Ex.: dbo.
Super admin: Data warehouse configuration page has a Multi-Tenant checkbox. Check it for Advanced Analytics data warehouses, and uncheck it for Enterprise Analytics.
Super admin: Client Info page: “0_EntityID Column” checkbox to create this column.
Super admin: ETL+ logging in the cloud.
Super admin: ETL+ cloud auto refresh log includes EntityID, TableName, Begin Date/Time, End Date/Time, Rows Before, Rows Deleted, Rows Updated, Rows Kept, Rows Inserted, Rows After, Refresh Criteria, Result Type, ETL+ User, Refresh Schedule ID, Refresh Schedule Run ID, Windows Computer Name, Windows Username.
Super admin: “Entity” box converts all characters to lower case.
Super admin: Creation of new OData entities sets the OData extraction blocks to 1000 records and 100ms pause (instead of 0 recs and 0ms pause which causes issues).
Super admin: Wider Entity ID column on the Entities page.