- Created by Cortlandt _, last modified by Joni Girardi on Jan 03, 2023
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 229 Next »
✅ v2022.08
Click here for instructions to upgrade your ETL+.
2023.01 *** Beta Release ***
Download Links:
ETL+ 64 bits: DataSelf ETL Plus.exe
DataSelf Agent: DataSelf Agent.exe
Release: TBD
New Features
ETL processes run dramatically faster when source MS SQL databases and the data warehouse are hosted on the same SQL instance. This also applies for zData Warehouse re-imports.
Source Metadata: Upon connecting to a source database, ETL+ retrieves and stores the source database’s table and column metadata.
Source Metadata: During ETL+ loads, ETL+ uses the stored source metadata to build and execute extraction queries. In prior ETL+ versions, ETL+ first read the column list and formatting, built the extraction query, and then executed it. This new approach reduces the time to extract tables. From a fraction of a second to several seconds per table depending on the speed of the source database.
Source Metadata: Since ETL+ can now store the source database’s metadata, users will be able to add tables and columns to their ETL processes without the need to connect live to source systems to read what’s available.
Design page: Redesigned page from scratch.
Design page: Page and its column sizes can be adjusted by users.
Design page: Source PK column(s) added.
Design page: Source PK column(s) (when available) are now numbered based on the source PK definition.
Design page: Source Data Type added. It shows the data type received from the source database.
Design page: VarChar(max) column with checkboxes added. This allows users to force the extraction of a source column into a varchar(max) data type in MS SQL. This is helpful when MS SQL might have issues accepting the values from a given source data type. Example: a date column with invalid amounts in SQL. Or a source numeric column with dirty data (like strings in some rows).
Design page: Dw KPs checkbox column moved to the right.
Design page: Dw KPs are now numbered to set the sequence of multi-column PKs.
Design page: Logged-in username added at the bottom-left corner.
Design page: Entity ID in session added at the bottom-left corner.
Remote Upgrade: Ability to upgrade ETL+ and Agent remotely in Agent-active installations.
Remote Upgrade: The Agent has a new function to upgrade its ETL+ install.
Remote Upgrade: ETL+ has a new command line function to upgrade its Agent.
OData v4 Refinements: Redesign a part of the processing of OData v4 metadata.
OData v4 Refinements: Ability to read a broader range of OData v4 tables and columns.
OData v4 Refinements: Prior ETL+ versions couldn’t list some regular tables on the Source Panel. This is now fixed.
OData v4 Refinements: Prior ETL+ versions couldn’t automatically list many available columns from some tables during the table mapping. This is now fixed.
OData v4 Refinements: Ability to list and read PX_ tables.
Source Engine: The code has been refactored into classes for cleaner execution and maintenance.
Ability to configure the location of the metadata database for a given ETL+ installation.
Job Scheduling: Next date/time to run a Job uses a more refined algorithm.
Job Scheduling: Next date/time to run a Job can use scheduling based on weekly and monthly parameters (configurable via ETL+ Web - beta release).
Logging: Many user actions are now logged on the zETL_Log table.
Configurable UI: New logging and error messages can be edited by ETL+ admin users.
ETL+ Web: Released for super admin users.
Fixed Issues
Known Issues
2022.08.2901 *** LATEST RELEASE ***
Download Links:
- ETL+ 64 bits: DataSelf ETL Plus.exe (16MB)
- ETL+ 32 bits: DataSelf ETL Plus.exe (6MB)
- DataSelf Agent: DataSelf Agent.exe (60KB)
Released: 08/29/2022
New Features
ETL page: title shows the connected “Data Warehouse: [<SqlServerName>].[<Database>]”
ETL page: Settings icon updated.
ETL Page - Find: Added
Find
feature to quickly highlight matches on sources, data warehouse tables, and SQL Statements.ETL Page - Find: Click the
Find
icon to expose/collapse the search box.ETL Page - Find: Find is case insensitive for source, table, and column names, and is case sensitive for ETL SQL Statements (to be improved in future releases).
ETL Page: click (Ctrl + F) to open the Find box.
ETL Page: click (Ctrl + G) to open the Log page.
ETL Page: click (F1) to go to Help.
ETL page, left panel renamed to “ETL Source”.
ETL Source - MS Access: Added MS Access as a new source type.
ETL Source - MS Access: Enter file path and password if required.
ETL Source - MS Access: Replace delta refresh available.
ETL Source - MS Access: Upsert delta refresh available.
ETL Source - PostgreSQL: Added PostgreSQL as a new source type.
ETL Source - PostgreSQL: Enter server address, port, credentials, and database name.
ETL Source - PostgreSQL: Replace delta refresh available.
ETL Source - PostgreSQL: Upsert delta refresh available.
ETL Source - BigQuery ODBC: Support and adjustments to BigQuery ODBC.
ETL Source - Google Sheet (beta): Support to extract data from Google Sheets. 64bit beta version.
ETL Source - Google Sheet (beta): Enter Spreadsheet ID, Target (optional). More instructions to be provided.
ETL Source - Google Sheet (beta): Date fields are automatically converted to varchar(max) to prevent failures with invalid dates in MS SQL. Users can enter SQL Expressions on the Design page to convert invalid dates to valid values.
ETL Source - MySQL (beta): Support to extract data from MySQL. 64bit beta version.
ETL Source - MySQL (beta): Enter server name, port, credentials, and database name.
ETL Source - Oracle (beta): Support to extract data from Oracle. 64bit beta version.
ETL Source - Oracle (beta): Enter Default or TNS, host name, port, credentials, and service name.
ETL Source: Deleting ETL+ Sources deletes its mapped tables on the center panel and now also the physical data warehouse tables. User is prompted to confirm the physical table deletion.
ETL Source: select a source → (Ctrl + i) opens its Properties.
ETL Source: double-click a table to add/map it to the load process.
ETL Source: (F5) to refresh a source.
ETL Page, center panel: Renamed to
ETL Objects
. More descriptive of what the panel is about. Objects currently include source headings (to group sources' tables together), SQL schemas, tables, and table columns.ETL Objects: Renaming tables on the center panel renames the physical data warehouse tables.
ETL Objects: Duplicating tables on the center panel duplicates the physical data warehouse tables. This is helpful when users want to perform tests on a table without affecting the official one.
ETL Objects: Deleting tables on the center panel deletes the physical data warehouse tables. User is prompted to confirm the physical deletion.
ETL Objects:
zData Warehouse
heading renamed tozData Warehouse (Reimports)
.ETL Objects: Job icon updated.
ETL Objects: select a table → (Ctrl + Del) key to delete.
ETL Objects: select a table → (Ctrl + 2) key to duplicate.
ETL Objects: select a table → (F2) key to rename.
ETL Objects: select a table → (Ctrl + D) key to open Design.
ETL Objects: select a table → (Ctrl + O) key to re-load and show Columns and data types.
ETL Objects: select a table → (Ctrl + P) key to preview.
ETL Objects: select a table → (Ctrl + L) key to Load Now.
ETL Objects: click (Ctrl + J) to open the Job page.
ETL Objects: Added
...
icon to the panel header for additional non-popular actions.ETL Objects: select a table →
...
→ Show Columns.ETL Objects: select a table →
...
→ Download to CSV.ETL Objects:
...
→ Load All Columns.ETL Objects:
...
→ Expand All / Collapse All for expanding/collapsing the source headers.ETL Objects - CSV: Added Export to CSV tables that have been loaded to the data warehouse.
ETL Objects - CSV: Right-click an ETL Object table →
More Actions
→Download to CSV
downloads data in CSV format into the folder:ETL+ folder/DS_Downloads/<EntityID>.<TableName>.csv
(ex.: abcinc.TName1.csv).ETL page: click (Ctrl + S) to Save.
ETL page: click (Ctrl + O) inside of ETL SQL Statement to Confirm.
Job page: “Refresh Batch” renamed to “Job” - this feature can run scripts that are not “refreshes”.
Design page: When changing the
Data Type
of a column, ETL+ posts the SQL expressions automatically applied. Users can edit the expression.Design page: After a SQL expression is posted to a column, if a user changes the column’s
Data Type
again, ETL+ will prompt if it should update the SQL expression.Design page: Loading of MS SQL Timestamp columns automatically converted to char(23).
DataSelf Agent: Greatly anticipated ETL+ auxiliary application to execute scheduled and remote tasks. Long-term vision: a user runs ETL+ on her laptop at a hotel and requests a data refresh from her on-premises ETL+ install, and orders a margarita (drink orders not included in ETL+ lol). Their on-prem DS Agent receives and executes the request on the on-prem ETL+. And then it notifies the user when the refresh is complete. Magic happens while the margarita buzz kicks in!
Agent: A locally deployed Agent can run scheduled jobs.
Agent: A locally deployed Agent can run on-demand jobs.
Agent: Because of the Agent framework, users can now stop a running job no matter if it’s running via ETL+ UI or via an Agent.
Agent: An ETL+ Job can be associated with one Agent or to WTS.
Agent: ETL+ Production installs must have direct access to source systems and have the Agent locally deployed and running with a local Windows Admin user.
Agent: ETL+ will capture in the metadata the Windows Device name to associate the ETL+ Entity and Job IDs to run by the Agent.
Agent: When assigning a computer to run the Agent for the first time, ETL+ assigns the username and password saved on the Job → Properties → Agent credentials. This user must have local Windows Admin Rights.
Agent: Runs as a Windows service (in the background) and checks the cloud metadata every 10 secs for instructions to execute.
Agent: Checks the cloud metadata if there are Jobs to run now. The rule is: (Jobs associated to run by this Agent) & Enabled & (Next Run Time <= now).
Agent: Checks the cloud metadata if there are on-demand tasks to execute. Currently, it can execute two tasks: run a Job now, and kill the execution of a running Job.
Agent: DateTime values related to the Agent are fixed in PST. Next release will add flexibility to this setting.
Agent Auto Start: When assigning a computer to run the Agent for the first time, ETL+ creates a WTS task to automatically run the Agent.
Agent Auto Start: On a given computer, only one Agent runs at a time. Attempts to run a second session in parallel will only log the attempt.
Agent Auto Start: The WTS that runs the Agent is scheduled to run every hour. This can be manually changed to run on Windows Startup, and change Setting to stop the app after 3 days.
Agent Protocol: The communication between the Agent and the cloud is via a single metadata table.
Agent Protocol: The Agent and ETL+ use the metadata table to monitor actions such as terminating a running Job.
Agent Scheduling: Once per day schedules.
Agent Scheduling: Repeat task every X days.
Agent Scheduling: Repeat task every X minutes within Y hours.
Agent Scheduling: Future schedules (ex.: run it next year).
Agent app: Right-click on the Agent on Windows Explorer → Properties → Details, see the Agent version on
File version
.Agent app - Agent Log.txt: Creates
Agent Log.txt
log file on the same directory where the Agent is. This file contains high-level Agent debugging and monitoring logs.Agent app - Agent Log.txt: Logs the Agent version upon its start.
Agent app - Agent Log.txt: Logs failed attempts to run the Agent (it’s usually ok since only one Agent can run on each computer).
Agent app - Agent Log.txt: Logs the ETL+ command line running a Job.
Agent app - Agent Log.txt: Logs the end of a Job run.
Job: Added
Status
column on the job list to show which app runs the Job. Options: WTS (Windows Task Scheduler) to DataSelf Agent.Job:
Status
column = WTS Enabled: The job is assigned to run via Windows Task Scheduler like in prior ETL+ versions.Job:
Status
column = WTS Disabled: The job is assigned to run via Windows Task Scheduler like in prior ETL+ versions. However, ETL+ will not run the Job because it’s disabled even if/when WTS tries to run it.Job:
Status
= Agent Offline: The Job is assigned to an Agent that is either not running, or is unable to access DataSelf cloud.Job:
Status
= Agent Ready: The Job is assigned to an Agent and is ready to run scheduled or on-demand Jobs.Job:
Status
= Agent Disabled: The Job is assigned to an Agent but it won’t run the Job.Job:
Status
= Agent Running: The Job is running.Job:
Status
= Agent Stopping: The Job is/was running, but the user just clickedEnd Job
in ETL+.Job: Added
Load
column showingDefault
orForced Load All
.Job: Added
Start at
column showing a summary of the schedule description.Job: Moved
Run Job
icon to the left panel header.Job: Added
Job Properties
icon on the left panel header.Job: Added
...
(More Actions) icon.Job: Added
...
→Run Job via Agent
icon. This sends a message to the Agent to run the Job on demand.Job: Added
...
→End Job
icon.Job: Moved
Rename Job
icon under the...
icon.Job: Moved
Delete Job
icon under the...
icon.Job: Moved
Create Win Shortcut
icon under the...
icon.Job - Right-click: Same changes as the icons above.
Job - Pop up: Shows
Job name
Job - Pop up: Shows
Agent
to run the Job.Computer Name
if DataSelf Agent will run the Job.Job - Pop up: Shows
Job Schedule
.Job - Pop up: Shows
Load Type
.Job - Pop up: Shows
Last Run Time
.Job - Pop up: Shows
Next Run Time
.Job: Removed
Windows Task Scheduler (WTS)
section.Job: Removed
WTS Settings
.Job: Clicking the
Job Properties
icon shows a section for Schedule, Load Type, and App.Job: Settings icon updated.
Job - Find: Added
Find
feature to quickly highlight matches on Jobs and Job Steps.Job: click (Ctrl + F) to open the Find box.
Job: click (Ctrl + G) to open the Log page.
Job: click (F1) to go to Help.
Job: Standardized user interaction as main ETL page so right-clicking on panel objects pops up the available features. Ex.: right-click a job →
Run Job
.Job: Added
Refresh
icon that updates Job status.Job: Added
Expand
icon to show additional scheduling columns.Job:
Expand
additional column:Last Run
.Job:
Expand
additional column:Next Run
.Job:
Expand
additional column:Server
.Job: The
Refresh
feature enters in a 10-sec auto-refresh mode when the columns are expanded.Job Steps: now shows the Job <ID> on the header.
Job Steps: Added
Move to Top
icon/feature.Job Steps: Added
Move to Bottom
icon/feature.Job Steps: select a script → (Ctrl + i) to open its properties.
Job Steps: select a script → (Ctrl + Del) key to delete.
Job Steps: select a row → (Ctrl + D) key to push it down one row.
Job Steps: select a row → press and hold the (Ctrl + D) key to push it down.
Job Steps: select a row → (Ctrl + U) key to push it up one row.
Job Steps: select a row → press and hold the (Ctrl + U) key to push it up.
Job Steps: (Ctrl + T) to create a new Tableau Extract Refresh script.
Job Steps: New script
Download to CSV
to run on a schedule. Select aJob
→+
on theSteps
panel →Download to CSV
→select a table
->Save
.Job Steps: Right-click on a Job Step shows a popup with the icons/actions above.
Job Properties - Schedule: Layout re-arranged.
Job Properties - Schedule: Added Enabled checkbox. Unchecking it will prevent the Job from running via the command line (typically, this is done by the Agent and WTS).
Job Properties - Schedule: The
Start
time zone shows PST when the Agent is selected.Job Properties - Schedule: The
Start
doesn’t show a time zone when WTS is selected. This assumes it’ll be run based on the time zone of the WTS running the Job.Job
Start at
column shows PST when the Agent is selected. It doesn’t show a time zone when WTS is selected (this assumes it’ll be run based on the time zone of the WTS running the Job).Job
Last Run
column shows PST when the Agent is selected. It doesn’t show a time zone when WTS is selected (this assumes it’ll be run based on the time zone of the WTS running the Job).Job
Next Run
column shows PST when the Agent is selected. It doesn’t show a time zone when WTS is selected (this assumes it’ll be run based on the time zone of the WTS running the Job).Job App: New section to manage the application running Jobs.
Job App: In a new installation, the App dropdown has the following options:
Deploy the Agent on this device (<DeviceName>)
WTS.
Job App: To deploy the Agent on a device, select
Deploy the Agent on this device (<DeviceName>)
on the dropdown, enter credentials with local Windows Admin rights on the right panel, checkAssign the Agent on this device for all Jobs
if applicable, pressApply
. If the Agent hasn’t been downloaded yet to the ETL+ folder, this will download the Agent to the ETL+ folder, create a WTS task to run the Agent automatically during reboots, and run the Agent as a service.Job App: Repeat the step above to re-deploy the Agent - in case the Agent is running as expected.
Job App: To upgrade the Agent, delete
DataSelf Agent.exe
from the ETL+ folder and deploy the Agent again.Job App: Once an Agent is assigned to a Job, its App dropdown shows
Agent on <DeviceName>
orAgent on <DeviceName> (this device)
. This informs the Agent is assigned to a Job and the Windows Computer name running that Agent.Job App: If there are multiple Agents available to run a Job, if required, use the App dropdown to assign a different Agent to a Job. For instance, the production server will be down for a few days, and the user assigns a Job to a backup server to run the Job during that period.
Job App: ETL+ and Job refresh will work the same way as in prior versions when the App dropdown shows
WTS
.Job App: When the App =
WTS
, the right panels shows the credentials for the local Windows Admin user and theApply
button (similar to prior versions).Job App: When the App =
WTS
, users can disable the scheduled refresh of a Job using the Schedule Enable checkbox. This doesn’t affect the WTS activities per se, but it’ll prevent ETL+ from actively running such disabled Jobs.Load Engine: Depending on the source system, loading of Date and DateTime columns automatically converts invalid values to NULL.
Load Engine: The delta filter column now creates a physical index in the data warehouse.
Load Engine: PK columns used in delta loads now create physical indexes in the data warehouse.
Load Engine: Adjustments when recalculating MS SQL indexes for the filter column used in tables with Replace. Resulting in significant performance improvement when processing deltas in large tables.
Load Engine: Adjustments when recalculating MS SQL indexes for the filter and PK columns used in tables with Upsert. Resulting in significant performance improvement when processing deltas in large tables.
Command Line: parameter -e <EntityID>. Ex.: -e abccorp
Command Line: parameter -j <JobID>. Ex.: -j 1
Command Line: New command syntax: -e <EntityID> -j <JobID> -ui <Page> <action>.
Command Line: parameter -e <EntityID> -ui
load
-j <JobID>. Ex.: this runs JobID on a new Load session. This automatically closes once the job completes the refresh.Command Line: parameter -e <EntityID> -ui
log
. Ex.: this opens the Log page on a new ETL+ session. This session stays open until the user closes it. Click theRefresh
icon to view the latest log rows.Command Line: parameter -e <EntityID> -ui
agent
. Ex.: opens the Agent page from an ETL+ session.Command Line: ETL+ uses the latest locally saved encrypted credentials when running command lines.
Load Engine: If an ETL+ entity tries to load a table that is currently being loaded by another entity, it’ll show the message “Another ETL+ is loading this table. Waiting for table release.”
Load Engine: If an ETL+ entity tries to load a table that is currently being loaded by another entity, every 15 secs it’ll show the message “Checking table release…”
Load Engine: If an ETL+ entity tries to load a table that is currently being loaded by another entity, but the other entity isn’t active for over 90 seconds, the new entity takes over the table load.
Load Engine: The mechanism to check for “Another ETL+ is loading this table. Waiting for table release.” checks for which Statement.RefreshRunID is loading the statement and when was the last date/time the loading was active on Statement.LastRefreshBg.
Load Engine: Checking if Log tables exist only during the opening of an entity (instead of during the load of every table).
Load Engine: Shows when the load started (metadata date/time).
Job Loading Page: Runs on its own window (runs via command line).
Agent Monitor Page: Opens Agent page on its own window (runs via command line).
Security: New passwords require at least 12 complex characters (up from 8).
Security: New passwords now accept # @ as part of special characters.
Security: When ETL+ can’t connect to its metadata: "Unable to connect to cloud metadata via https and SSL SQL. ETL+ needs to whitelist your public IP, or your firewall or antimalware is preventing ETL+ connection to the cloud. Start ETL+ IP Whitelisting?"
Security: ETL Page - ETL SQL Statement: For multi-tenant data warehouses, clicking
Confirm
validates that only dbo and entityID schemas can be read from zData Warehouse.Log Page: Runs on its own window (runs via command line). This allows users to keep it open for monitoring the results of load tests.
Log Page: It will remain open even if the user closes the main ETL+ session. This can be useful for using the Log page for monitoring ETL+ loads exclusively.
Log Page: Click
Close
to close it.Log Page: Added
Rows Retrieved
parameter. Enter a new value and pressRefresh
icon.Log Page: (F5) shortcut to refresh Log page.
Log Page: Titles and radio buttons changed to
ETL Log
andTable Stats
.Log Page:
Table Stats
layout rearranged and some labels renamed for easier viewing.Log Page: Default sorting of Log pages is the
Index
column.Log Page: User Admin users have access to an additional column that shows the (unmasked) Source Error message returned by source system.
Log - Table Stats: Table row counting uses SQL metadata (instead of count(*)). Faster performance.
Logging: Checking if Log tables exist only during the opening of an entity (instead of during a load of every table).
Settings - Refresh Email Notification: Removed email attachments. No longer necessary with cloud logging.
Settings:
Debug Level
dropdown shows a summary of what the log level does.Settings:
Debug Off
now removes the log file on the local HD. For saving disk space and avoiding requiring ETL+ toRun as Admin
when running from Windows-protected foldersSettings:
Debug Off
no longer counts and records the number of rows before and after a table load. Performance improvement.Settings: New
Debug Level 0
adds the log file on the local HD plus counts and records the total number of rows before and after a table load.Settings:
Debug Level 1
adds Level 1 log plus Level 0 features.Settings:
Debug Level 2
adds Level 2 log plus Level 0 features.Settings - Restore ETL SQL Statement As Of: New dropdown list on Settings allows users to retrieve prior ETL SQL Server Statements. Useful to recover deleted and changed statements from the past.
Login:
Forgot Password?
button. It’ll email the password when initiated from whitelisted IPs with a valid username (email address).ETL+ Plain Deployment: New framework for an on-premises data warehouse that easily loads the zDateUntreated table from a cloud Excel file.
Cloud Scripts: Increased to up to 7 parallel processes.
Metadata: Redesigned metadata for improved security, reporting, and indexing. This makes prior ETL+ versions incompatible and separated with the new version.
Metadata AWS platform: Doubled the CPU capacity.
Metadata AWS platform: Doubled the RAM capacity.
Login within the same month release: Starting on this version, users will be able to upgrade and downgrade ETL+ seamlessly within the same ETL+ month release.
Login within the same month release: Removed prompt about opening an entity with a different metadata version within the same ETL+ month release.
Login with a newer month’s release: Opening an entity with a newer ETL+ version than the last opened release is seamless.
Login with an older month’s release: ETL+ will suggest the user to upgrade ETL+ and opens the ETL+ Upgrade page.
Creation of .ink files in \ProgramData\DataSelf\ETLplus removed.
zEntity: Process to guarantee that there’s no duplication of EntityID values.
Admin user: Remembers the last admin credentials in DataSelf protected computers.
Admin user: Renamed “Tableau Deploy” to “Cloud Script” on the Client Information page.
Admin user: Added
Unlock Editing
button to release an entity locked by a user.Support to Windows Server 2022.
UI Pages: Data warehouse was removed from the bottom left corner since it’s prominently listed on the ETL main page.
Fixed Issues
Tables with delta refresh no longer log the misleading message: “Error : Column name '<PK_column1,PK_column2,PK_column3etc>' does not exist in the target table or view.”
Regular users: When login in to ETL+, the list of available entities used to show deleted ones as well.
When manually loading a table, it will retry 3 times in case of failure (instead of 12 times).
Tables with delta refresh no longer run into the error: ‘Invalid column name ‘0_UnionID', but ETL+ still processes the delta refresh correctly.
When super users switched to a new entity within the same ETL+ session could create zEntity and zLog tables in the new entity’s data warehouse with the schema from the prior entity.
When super users switched to a new entity within the same ETL+ session could send refresh emails with the prior entity’s refresh email subject.
Deleting all Jobs no longer requires going to the ETL main page and back.
Deleting an entity and recreating it with the same ID would add a new row to zEntity table.
Clicking the
Log
icon after certain tasks (such as running a Job) no longer presents an "Unhandled exception" error.Regular users: Mousing over Sources is now showing the popup with details.
Regular users: When login into ETL+, ETL+ will correctly open the selected entity from the dropdown list.
Known Issues
Replace with filters such as getdate()-30 are duplicating rows on day = getdate()-30.
ETL+ is not automatically converting Timestamp columns to char(23).
Mechanism alerting users to upgrade their ETL+ is not friendly.
ETL+ is trimming leading spaces in column names from Excel sources.
ETL+ dies when opening it for the very first time on a machine. Fix: run it again.
The ODBC delimiters don’t seem to be working.
When importing tables from SAP Hana ODBC, ETL+ is not creating SQL Statements that are case sensitive.
Stopping a Job via Agent sometimes doesn’t log the action.
When configuring a Job schedule with
Repeat every
2 or more days and theStart Date
is in the past, the calculation of the Next Run might be incorrect.Job → Agent Monitor page: no longer needed.
Sometimes still errors out with: “Two or more ETL+ tried to refresh the EntityID TableName data warehouse table at the same time.”
Unable to rename Jobs 2 and onwards (?).
When opening the Job page,
Job <ID> Steps
don't show until selecting another Job on the left.With Providex sources, when linking tables to use a filter from the parent table with Replace, ETL is logging failure because of incorrect column name for the filter name (ex.: H.InvoiceDate).
When Log Level is set to Off, it still creates empty local files when running Jobs via the command line.
ETL+ to create new dws with Containment type = Partial.
Creation of SQL tables many times don’t sort the columns in the same order as in the SQL statement.
Job Status column might not represent its status. Closing and reopening the Job page usually fixes the status column.
Stopping a Job via the Agent sometimes doesn’t log the action.
Upon adding a new table from a NetSuite ODBC, the SQL syntax will have an extra ] at the end of the table name. To fix it: remove ] and save.
The creation of SQL Statement must be case sensitive for ODBC to SAP Hana. The default delimiters are double-quotes “ (?).
Sometimes, trying to configure a Job’s app = WTS right off the bat doesn’t work.
Many SQL Statements for MongoDB ODBC will only load using SELECT *.
Some Acumatica OData v4 tables might show the error “The contents of table TableName are not available for this user“ and fail to import. This is an Acumatica security issue and we’ve requested how to fix it. While we wait for the Acumatica fix, use OData v3 to import such tables.
Adding tables from Sage Intacct might not work.
Job: If a table fails to refresh, the ETL+ might unexpectedly load several tables multiple times.
Sometimes ETL+ will mistakenly flag that the metadata has been changed and you need to exit and re-enter the entity. Just exit and re-enter.
Changing the data warehouse of an entity won’t show on the bottom left corner until the entity is closed and re-opened.
The icon color and type for the column formats on the center panel aren’t 100% consistent yet.
Opening an entity with tables mapped to the zData Warehouse with an older ETL+ version will push such tables to other source databases on the center panel. DataSelf can fix that manually.
Importing large XML content into varchar(max) might run into error: server stack limit has been reached.
A few installs are hitting the error “There is insufficient system memory in resource pool 'internal' to run this query.” once in a while. It happened to only one table in a job, and a different on another job. Load All. First report started in v2021.09.
Sometimes ETL+ is closing unexpectedly after a data load.
Sometimes ETL+ runs into an “Unhandled exception” error. Close and re-open ETL+.
Locking the ETL+ editing when someone else is editing it doesn’t work in some situations.
ETL+ still tries to send email even when set to Cloud notification, or No Notification.
ETL+ delta extraction from NetSuite ODBC might not work when using dates for filtering.
2022.02.0505
Download files:
64 bits: DataSelf ETL Plus 64bits - 2022.02.0505.exe
32 bits: DataSelf ETL Plus 32bits - 2022.02.0505.exe
Released: 02/05/2022
New Features
ETL Log: Log icon now retrieves cloud log. Users can retrieve the log from anywhere.
ETL Log: By default, the Log shows the latest logs at the top of the page (sorted <DateTime> Desc).
ETL Log: Sort the Log page by clicking the Log column headers.
ETL Log: Click
Sequence
header to sort by<RefreshRunID> Desc
&<DateTime> Asc
.ETL Log:
Refresh
icon re-loads the latest log entries.ETL Log: Logged dates now show the time zone (currently, PST only).
ETL Log: Option to view Stats or Summary logs.
ETL Log:
Stats
show row stats, processing time, and refresh criteria by loaded table.ETL Log:
Summary
shows loaded tables, rows, error messages, refresh batch headers (admin user: machine username).ETL Log: Creates and populates the Log Summary in the data warehouse table <dw schema>.<zRefreshLog_Summary>.
ETL Log: Creates and populates the Log Stats in the data warehouse table <dw schema>.<zRefreshLog_Stats>.
ETL Log: Log columns available to Super User only: PK_Entity, MachineUser.
Table labeling: Improved labeling to uniquely identify tables (MS SQL standard):
<Source Name> - <SQL Schema>.<Table Name>
Ex.: ExcelFile - dbo.BudgetTable
Table labeling: In multi-tenant data warehouses (such as in Advanced Analytics), the schema doesn’t show on the center panel since all loaded tables belong to the same schema (<EntityID>).
Table labeling: Refresh Batch Steps don’t show schemas to simplify the table list. Schemas can be seen on a pop up by mousing over tables.
Source - zData Warehouse: The data warehouse automatically shows as a data source for additional data preparations and transformations.
Source - zData Warehouse: “zData ” source is listed at the bottom of the panels.
Source - zData Warehouse: Uses a green source icon to tell it apart from regular sources.
Source - zData Warehouse: This source provides access to all data warehouse tables and views for single-tenant data warehouses.
Source - zData Warehouse: This source provides access to data warehouse tables and views where <SQL schema> = <EntityID> or <SQL schema> = <dbo> in multi-tenant data warehouses (DataSelf Analytics Advanced Edition).
Source - zData Warehouse: Source’s
Properties
disabled.Source - zData Warehouse: Source 's
Delete
disabled.Source - zData Warehouse: Use
Settings
->Data Warehouse
for its configuration.Source Properties: Renamed
Dw Schema
toSchema
. Sets Alias as the source tables' schema.Data Warehouse Panel - zData Warehouse: When importing zData Warehouse tables, they’ll be grouped under a green grouping icon.
Data Warehouse Panel: Renaming a table only applies to its name, not the schema.
Data Warehouse Panel: Tables imported from the data warehouse keep the same SQL schema as the data warehouse default schema.
Data Warehouse Panel - Columns: Double-click a data warehouse table to show:
Column list
Column formatting
Primary key
Data Warehouse Panel - Columns: Click
+
/-
by a table name to expand/collapse its column formatting.Data Warehouse Panel - Columns:
icon for regular columns.
Data Warehouse Panel - Columns:
icon for transformed columns.
Data Warehouse Panel - Columns:
icon for primary key columns.
Data Warehouse Panel - Columns:
icon for primary key transformed columns.
Data Warehouse Panel - Design: added Design icon to access table Design page.
Data Warehouse Panel - Design: For many sources, the list of columns shows even when the SQL Statement involves transformations, table links, table unions and CTEs.
Design: New page for table design:
Configure primary key columns
Change column formats
Apply column transformations
Design: Many sources don’t allow transformations during the extraction, or extraction transformations are limited and/or slow. The data is extracted and loaded into a temporary data warehouse table, and then transformed into to official table. These transformations happen in the data warehouse engine, therefore they are fast, efficient and provide a broad range of MS SQL transformation functions.
Design: Select a data warehouse table →
Design
to open the Design page.Design: New page shows
PK
(primary key),Column Name
,Dw Data Type
,Transform SQL Expression
.Design: List shows gray and white banded lines.
Design: To change a Column’s format, use its
Dw Data Type
dropdown menu, or double-click the dropdown and type in the new format.Design: Column MS SQL transformations available on
Transform MS SQL Expression
. Ex.: LEFT(ColumnName,5).Design: Click the column header for
Column Name
orSource Data Type
to sort the list.Design: Press & hold & drag with the right button of a mouse on the border of a column to change its width/height.
Design: ETL+ will execute the Design changes when user clicks
Confirm
.Design: If issues are found during Design changes execution, ETL+ will report which columns were successfully changed and which ones failed.
Design - PK: PK check boxes define a table’s primary key columns. Currently:
PKs are necessary to process Upsert delta refreshes.
No validation if the PK columns are the correct primary key.
No creation of the physical PKs in the data warehouse.
If physical PKs are needed, please create them directly in SQL after the first ETL+ import.
Design - PK: When importing a new MS SQL or Odata table that has PK in the source, ETL+ will automatically recognize and pre-configure its PK.
Design - PK: Check the PK check boxes to change/define the table’s primary key columns.
Design - PK: For text-based sources like OData, varchar(max) columns are automatically changed to varchar(50). We recommend reviewing the varchar size.
Design - PK: ETL+ logs the following when MS SQL can’t create/recalculate a PK: "Primary Key failure. PK requires rows with unique values and no NULLs. Review the PK fields.". This means the selected PK columns are not the table’s correct primary key - review/fix the PK configuration.
Design - PK: When upgrading an ETL+ entity,
Primary Index
columns automatically becomePrimary Key
columns.Column Formats: On the data warehous panel (center panel),
double-click
or right-click on a table name ->Show Columns
to enable the expansion of this table’s column names and formats.Column Formats: Click
+
/-
by a column name to expand/collapse its column names and formats.Column Formats: To reload column names and formats,
Double-click
again or right-click on a table name ->Show Columns
again.ETL Page - Load Type: Load Type section now only uses vertical real estate needed.
ETL Page - Load Type:
Replace All
has been renamed toLoad All
.ETL Page - Load Type:
Replace with Control
has been renamed toReplace
.ETL Page - Load Type:
Update
has been renamed toUpsert
.ETL Page - Load Type: Hovering over the Load Type options shows its function.
ETL Page - Load Type: Hover over
Load All
:1st: Load all. Ongoing: Reload all.
ETL Page - Load Type: Hover over
Replace
:1st: Load all. Ongoing: Replace filtered rows.
ETL Page - Load Type: Hover over
Upsert
:1st: Load all. Ongoing: Update modified, insert new rows.
ETL Page - Load Type: Hover over
Append
:1st: Load all. Ongoing: Append all.
ETL Page - Load Type: Selecting Replace or Upsert expands its settings section.
ETL Page - Replace: Filter column now is a drop down.
ETL Page - Replace: The filter expression is automatically set to Max(FilterColumn).
ETL Page - Replace: Users can customize the filter variable. For instance:
Constant: 1000
Date constant: ‘02/15/2021’ (use quotes around the MM/DD/YYYY date format)
SQL Expressions: for instance, getdate()-30
ETL Page - Upsert: Renamed
Primary Index
toPrimary Key
.ETL Page - Upsert:
Primary Key
lists the PK columns (from theDesign
page).ETL Page - Upsert:
Primary Key
lists the PK columns in the same order they appear in the SQL Statement.ETL Page - Upsert: To edit the PK columns, click the
Edit
icon by the Primary Key or theDesign
icon on the table.ETL Page - Upsert: Use the dropdown to select the Column with Last Modified Value.
ETL Page - Upsert: The Update filter is automatically set to Max(LastModifiedValueColumn).
ETL Page - SQL Statement: Support to MS SQL Server CTE (Common Table Expressions).
ETL Page - SQL Statement: Support to SQL statement comments. Syntax /* comment text */. This can only be used after an initial SELECT statement.
ETL Version Control: When opening an entity with a different ETL version than the last one used for the entity, ETL will notify and prompt what to do next.
ETL Version Control: When using a newer ETL+ version than the last one used on an entity, users will be prompted to upgrade or cancel.
ETL Version Control: When using an older ETL+ version than the last one used on an entity, users will be prompted to download the older version (by going to our download page) or cancel.
Load Engine: Ability to apply transformations after the load (previously, only available during extraction when the source SQL syntax allowed).
Load Engine: Source loading adds a 0_UnionID column with content = table schema. This is helpful for multi-company table linking. This new column will be further refined when more multi-company features become available.
Load Engine: Settings
0_Entity
now creates 0_<EntityID> column (instead of 0_<schema>).Load Engine: If the source table already has a 0_<EntityID> column, load engine will import this column (instead of creating it).
Load Engine: If the source table already has a [0_UnionID] column, load engine will import this column (instead of creating it).
Load Engine: ETL+ retries 3 times upon running into a load error in the UI, and then proceeds. In a multi table refresh, use the
Cancel
button to stop the refresh (Cancel applies before the next table load).Load Engine - zEntity: Creates a <dw schema>.zEntity table with the following columns: PK_Entity, EntityID, EntityName, CYE_Value, DT_LatestLoadStart, FYrStart_Int2, PnLType, ReportingDate, 0_UnionID, 0_<EntityID>.
Load Engine - zEntity: If <dw schema>.zEntity already exists, ETL+ doesn’t overwrite it.
Load Engine - zEntity Columns: PK_Entity, EntityID and EntityName defining the entity.
Load Engine - zEntity.CYE_Value: It’s populated by
Settings
page ->CYE Value
. This is used by many Financials templates to set up a description or a GL number to Current Year Earnings.Load Engine - zEntity.DT_LatestLoadStart: At the start of a new load (individual or group of tables), ETL+ writes the current date & time on this column. Use case: to populate report DataAsOf fields.
Load Engine - zEntity.FYrStart_Int2: It’s populated by
Settings
page ->FYear Start: Mmm
. A number between 0 and 12that defines the 1st calendar month of the first fiscal year (assumes period starts on the 1st of the month). Ex.: 2 for Feb 1st. 0 means a custom fiscal year. Use case: this field controls part of the logic on DataSelf’s 5_Date and 6_DatePeriod date tables.Load Engine - zEntity.PnLType: It’s populated by
Settings
page ->P&L: Type
. This column controls how DataSelf P&reports work: S → Standard P&L or E → EBIDTA type.Load Engine - zEntity.ReportingDate: For customers that want to customize the actual reporting date. For instance, show this fiscal period metrics based on the end of last month’s date. It’s populated by
Settings
page ->Reporting Date
. Options:0 -> Today. 1 -> Yesterday, 2 -> Last month's end
.Load Engine - Load All: The load happens on a temporary table to allow users to query the official table with minimum interruption. Once the load completes, the temporary table becomes the official one. The temporary table is named Schema.TableName_TEMP.
Load Engine - Load All: The transition between temporary to official table happens very quickly when there are no transformations performed (delete official, rename temporary to official, create <0_EntityID> when applicable).
Load Engine - Load All: The transition between temporary to official table happens quickly when there are transformations performed (delete official, insert into official from temp table applying transformations).
Load Engine - Replace and Upsert: When user changes the mappings of a delta refresh table, and the table already has data, user is promped with:
Column mappings modified. The delta refresh needs one "Load All" data load to sync up OR manual adjustments to the physical table.
Force one "Load All" in the next load (manual or scheduled)?
Yes/No/Cancel
Load Engine - Replace and Upsert: When user clicks
Yes
to the prompt above, ETL+ will force aLoad All
in the next table load (manual or scheduled), and then resumes the delta refresh.Refresh Batch:
Rename
icon added for Refresh Batch Names.Refresh Batch: Removed
Run Refresh Batch
icon from header (cleaner UI).Refresh Batch: Removed
Delete Refresh Batch
icon from header (cleaner UI).Refresh Batch - Steps: Select a step and Click & Hold the Up or Down icon to quickly move it.
Refresh Batch - Steps: Hover over Up and Down icons to show quick help pop up.
Refresh Batch - WTS: Repeat Task checkbox unchecked by default.
Refresh Batch - Steps: Pop up when hovering steps has been cleaned up and re-organized the layout to make it clearer what the step is about.
Data prep: If the source data brings in a Date and or DateTime value that is incorrect for SQL (common in text based data sources like Excel or OData, and Providex), apply transformations to fix the issue. Examples:
Invalid date values (ex.: Feb 30): Convert the field to a character field.
A date/time column has more characters than accepted by SQL. Remove the extra characters: CAST(LEFT(DateColumn),19) as DATETIME).
OData Extraction - Load All: ETL+ process the data extraction sorted based on the PK (usually available) or a key available from the OData metadata.
OData Extraction - Replace and Upsert: ETL+ process the data extraction sorted based on the delta refresh filter (ex.: InvoiceDate) plus the PK (usually available) or a key available from the OData metadata.
OData Extraction - Replace and Upsert: When starting a new load and there’s no dw.TableName_Temp2, ETL+ checks the delta refresh filter value from dw.TableName, applies the filter value into the source data extraction process, and loads the data into TableName_Temp. If the end of the extraction is reached before 100 pages, ETL+ deletes TableName, and renames TableName_Temp to TableName_Temp.
OData Extraction - Replace and Upsert: Starting an extraction like listed in the prior feature above, but if 100 pages are loaded without the end of the extraction, ETL+ moves/append TableName_Temp onto TableName_Temp2, deletes TableName_Temp, logs off Acumatica, logs in Acumatica again, and resumes the load into TableName_Temp. This process repeats until the end of the extraction, then TableName_Temp is appended onto TableName_Temp2, TableName is deleted, and TableName_Temp2 is renamed into TableName.
OData Extraction - Replace and Upsert: When starting a new load and there’s a TableName_Temp2 on the data warehouse, ETL+ starts the delta load from TableName_Temp2 (instead of from TableName) and processes the load as per the prior feature.
OData Extraction - Upsert: Be sure to configure the order of PK columns in the SQL statement to guarantee an ascending extraction. Failing to do this might cause delta data extraction inconsistencies. We highy recommend adding a date (like CreateDate) as the first column of a PK controlling an Upsert.
OData Extraction - Upsert: When executing OData extractions, the order of the PK columns in the OData extraction URL following the order of the columns the SQL statement (instead of alphabetical).
ODBC Configuration: Added an explanation about adding credentials to an ODBC driver.
ODBC Configuration: Added an explanation about potential reason for missing ODBCs is because of mismatch of ETL+ and ODBC 32/64-bit builds.
ODBC Extraction: Support to Pervasive ODBC.
Installation: For every entity, usually only one ETL+ installation requires setting up the connection to data sources. Therefore, we removed the installation step to connect every ETL+ to its data sources.
Installation: We removed the Windows Task Schedule step from the installation. Cleaner install.
All Users: On the user credentials screen, the Login button is preselected. Once credentials are entered, press
Enter
to login or click theLogin
button.All Users - ETL+ Version Control: ETL+ flags its metadata with the ETL+ version used to maintain it.
All Users - ETL+ Version Control: When a user opens an entity with a different version than what’s on the metadata, ETL+ will prompt the user if he/she wants to proceed with the different version or
Cancel
.All Users - ETL+ Version Control: If a user wants to open an entity with a newer or older ETL+ version than what’s in the metadata, the ETL+ will proceed and update the metadata ETL+ version information.
All Users - ETL+ Version Control: If a user doesn’t want to open an entity with a newer or older ETL+ version than what’s in the metadata, the ETL+ will prompt if the user wants to open ETL+ Release History webpage to download other versions.
Admin User: ETL+ admin user page now shows the ETL+ metadata version.
All Users: The new ETL+ installation flow no longer has a WTS step. This was confusing for many users.
Client Info: ETL+ license is now part of the metadata.
All Users: When opening an entity, the center panel cursor goes to the top of the page.
All Users: Added
Send
button onClient Info
page to re-send product registration email.All Users: Added
Send
button onClient Info
page to re-send product registration email that now copies sales@ and support@ dataself emails.Admin User: metadata.EntityAttribute new table to host customer and tech support information.
Admin User: Entities page has a search box - enter characters to find and select matching EntityIDs and Names.
Admin User: When landing on the Entities page, the cursor goes to the search box.
Admin User: When leaving the ETL page back to the Entities page, the prior Entity will pre-selected in the new Search box.
Admin User: When a single entity shows on the Entities page, just click
Enter
to Edit it (or clickEdit
with mouse).Admin User: Tableau Script Deployment removed from Refresh Batch page (it was confusing).
Admin User- Duplicate Entity: Upon duplication of an Entity, ETL+ finds & replaces <OriginalEntityID> with <NewEntityID> in all SQL Statements. This is needed for many out of the box data warehouse table data manipulations. Ex.: for properly processing zEntity and zCalendarTable tables.
Admin User: ETL+ Customer Portal with easy access to consolidated metadata information.
Admin User: ETL+ Customer Portal can only be accessed from behind DataSelf’s firewall.
Admin User: Deployment of Advanced, Pro and Enterprise share the same foundation (ETL+ templates, Tableau tds, Tableau main and QA twb workbooks).
Admin User: Deployment of Pro and Enteprise replaces EntityID in SQL Statements with dbo (which is the default schema for such deployments).
Admin User: For Pro and Enterprise deployments, ETL+ will automatically create a
SYSTEM_Date
table in the data warehouse. Required for certain internal analytics processes.Admin User: For Pro and Enterprise deployments, ETL+ will automatically create the
zDateUntreated
table for date manipulations.Admin User: For Pro and Enterprise deployment, ETL+ will automatically create auxiliary tables for source database specific data manipulations (such as document types and GL Financials data sets).
Admin User: ETL+ License field controls the cloud template deployment script.
Admin User:
Client Info
page allows the configuration of the ETL+License
type: DataSelf ETL+, VAR, DIY, Advanced, Pro, Enterprise.Admin User: On the
Client Info
page, checking theTableau Deploy
checkbox +License
=VAR
+ clickingSave
will deploy a DataSelf Advanced Analytics NFR system on https://bi1.dataself.com.Admin User: On the
Client Info
page, checking theTableau Deploy
checkbox +License
=Advanced
+ clickingSave
will deploy a DataSelf Advanced Analytics system on https://dataselfbi.com.Admin User: On the
Client Info
page, checking theTableau Deploy
checkbox +License
=Pro
+ clickingSave
will deploy a DataSelf Pro Analytics system on https://dataselfbi.com.Admin User: On the
Client Info
page, checking theTableau Deploy
checkbox +License
=Enterprise
+ clickingSave
will deploy a DataSelf Enterprise Analytics system on https://dataselfbi.com.Admin User:
Analytics Settings
is now part of the ETL+ metadata. It contains information such as Analytics type (Tableau, soon Power BI as well) and other settings to automate maintenance tasks such as the deployment of their templates and extract refresh.Admin User: New Stored Procedure to automate the maintenance of analytics tasks such as the deployment of Analytics templates and extract refresh.
Admin User: The Analytics Server URL from
Analytics Settings
shows at the bottom of the Tableau Extract Refresh page.Upgraded Microsoft Code Signing with RSA4096 encryption.
Compatible with Windows 11.
Fixed Issues
Product registration email missed the token information. Fixed.
Adding a source table to the data warehouse was disabling the center panel’s icons for that table. The user had to click another table and go back to the new table to enable the icons. Fixed.
WTS was automatically pre-checking the
Repeat task every
feature. Fixed.WTS was not setting
Run whether user is logged on or not
. This is actually a security issue, be sure to enter a local Windows admin username and password in the ETL+ WTS page to create the WTS task with the setting above.Upon installing ETL+ on a new computer, if it doesn’t start, right-click ETL+ → Run as administrator. This is a required security feature to kick off the IP whitelisting process.
Mapping of Acumatica OData columns with spaces in their names in GIs will come without spaces in OData. Ex.: “Geo Customer” in GI comes as “GeoCustomer” in OData.
Known Issues
Tables with delta refresh will present an error: ‘Invalid column name ‘0_UnionID', but ETL+ still processes the delta refresh correctly. To prevent the error message from happening, manually create a new column 0_UnionID varchar(100) on tables with that error message.
Clicking the
Log
icon after certain tasks (such as running a Refresh Batch) might present a "Unhandled exception" error. ClickQuit
and re-open. It mostly only happens once.Upon adding a new table from a NetSuite ODBC, the SQL syntax will have an extra ] at the end of the table name. To fix it: remove ] and save.
Some Acumatica OData v4 tables might show error “The contents of table TableName are not available for this user“ and fail to import. This is an Acumatica security issue and we’ve requested how to fix it. While we wait for the Acumatica fix, use OData v3 to import such tables.
When manually loading a table, it will retry 12 times in case of failure.
Adding tables from Sage Intacct might not work.
Deleting all Refresh Batches requires going to ETL main page and back to get a new one created.
Opening an entity from an older metadata version with the new one using a regular user (non Admin) will not update the metadata version in the cloud. Work around: open it with an Admin user.
Refresh Batch: If a table fails to refresh, the ETL+ might unexpectedly load several tables multiple times.
Sometimes ETL+ will mistakenly flag that the metadata has been changed and you need to exit and re-enter the entity. Just exit and re-enter.
Changing the data warehouse of an entity won’t show on the bottom left corner until the entity is closed and re-opened.
Regular users: Mousing over Sources doesn’t show the pop up with details.
Regular users: When login to ETL+, in the first attempt, ETL+ will only open the first entity even when one uses another entity on the dropdown list.
The icon color and type for the column formats on the center panel isn’t 100% consistent yet.
Opening an entity with tables mapped to the zData Warehouse with an older ETL+ version will push such tables to other source databased on the center panel. DataSelf can fix that manually.
Importing large XML content into varchar(max) might run into error: server stack limit has been reached.
Sometimes ETL+ is closing unexpectedly after a data load.
Sometimes ETL+ runs into an “Unhandled exception” error. Close and re-open ETL+.
Locking the ETL+ editing when someone else is editing it doesn’t work in some situations.
ETL+ still tries to send email even when set to Cloud notification, or No Notification.
ETL+ delta extraction from NetSuite ODBC might not work when using dates for filtering.
When opening an entity created in prior ETL+ versions, the data warehouse panel will show the source header blank. To fix this, open the entity in the prior ETL+ version, make any modification and save it. Now open the entity in the latest ETL+ and the source header appears.
2021.09.1301
Download file
64 bits: https://dataself.com/etl_plus/DataSelf ETL Plus 64bits - 2021.09.1301.exe
32 bits: https://dataself.com/etl_plus/DataSelf ETL Plus 32bits - 2021.09.1301.exe
Released: 09/13/2021
New Features
ETL UI: Added '?' help icon on main pages.
ETL UI: User Guide available at DataSelf ETL+ User Guide .
ETL UI: Many buttons have been replaced by icons.
ETL UI: Hover over icons to view their functions.
ETL UI: Hover over data structures such as data sources and tables to view metadata.
ETL 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).
ETL page: Right clicking on the left two panels pops up the icon functions. The pop ups show the icons and their function names.
ETL page: Clean up of the ETL+ main page (some functions have been moved to other pages).
ETL page: ETL SQL Statement’s title shows the selected TableName (or Source.TableName when multiple sources are mapped).
ETL page: ‘Log File’ icon to open local log file in Notepad.
ETL page: ‘Refresh Schedule’ button changed/renamed to ‘Refresh Batch’ icon.
ETL page: ‘Refresh Batch Now’ function moved to the 'Refresh Batch' page.
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).
Multiple data sources: Configuration of data sources now includes an editable Alias (DSN Alias).
Multiple data sources: Added ‘Save’ button (saves and closes without trying to connect to source).
Multiple data sources: When creating a new DSN, the Alias is auto populated as following:
MS SQL: Database name.
ODBC: ODBC name.
Excel: File name.
CSV: Windows Folder name.
OData: Last word of the OData URL.
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: Ability to import data from the data warehouse for further data prep.
Multiple data sources: When adding a table from a source, the cursor selects it on the center panel.
Load UI: The load UI page is now integrated in the ETL+ application (not a detached layer).
Load UI: Cancel button stops the load process when the table currently loading ends.
Load UI: Cancel button stops the load process between OData extraction blocks and tables.
Load UI: Shows how many rows have been loaded from the table being extracted now.
Load UI: Shows how many rows per table have been loaded: (X rows <action>).
Load UI: Shows the type of load: the <action> variable in (X rows <action>):
Replace All: loaded
Replace with Control: replaced
Update: updated
Append: appended
Load UI: Refreshing a long list of steps scrolls up showing the latest steps at the bottom of the list.
Load UI: Shows at the bottom of the table list when waiting (sleep mode) versus extracting data.
Load UI: Shows when refreshing each Tableau Extract.
Load UI: New background and font colors provide better contrast.
Load UI: Shows Source.TableName when multiple sources are available, otherwise only TableName.
Load UI: Creates MS SQL indexes for the filter column used in tables with Replace.
Load UI: Creates MS SQL indexes for the filter and PK columns used in tables with Upsert.
Cloud Watchdog: Monitors ETL+ scheduled refresh cloud logging and sends email notifications.
Cloud Watchdog: Notifies “Missed execution?” when a scheduled Refresh Batch hasn’t started 120 seconds after the scheduled time.
Cloud Watchdog: Notifies “Taking too long?” when a scheduled Refresh Batch takes longer than (10 mins + 1.5 x Last Refresh Time) to complete. This might be an indication that the refresh will not complete.
Cloud Watchdog: Always notifies when ETL+ “Notification Email” is set to “Cloud - Always Notify”.
Cloud Watchdog: Notifies on error when ETL+ “Notification Email” is set to “Cloud - Notify on Error”.
Settings: Creation of the Settings page and added its icon on ETL+ main page.
Settings: ETL version posted.
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: ‘Refresh Batch Notification Email’ includes dropdown for:
Always Notify: ETL+ always sends notification email.
Notify on Error: ETL+ only sends email on error.
Cloud - Always Notify: Cloud Watchdog always sends notification email.
Cloud - Notify on Error: Cloud Watchdog only sends email on error.
No Notification: No notifications from ETL+ nor Watch Watch Dog.
Settings: “Create Now” button added to “New Data Warehouse” page.
Refresh Batch: Renaming ‘Refresh Schedule’ to ‘Refresh Batch’.
Refresh Batch: Re-layout of the page.
Refresh Batch: Bottom left section shows WTS summary configuration.
Refresh Batch: ‘WTS Settings’ button provides access to WTS settings and Apply button.
Refresh Batch: To run a Batch either click the ‘Refresh Now' icon on a batch name, or select the Batch and click 'Refresh Now’ icon on the panel header.
Refresh Batch: Click the 'Delete' icon on a batch name to delete it.
Refresh Batch: ‘Add’ and ‘Create Shortcut’ became icons on the batch name list.
Refresh Batch: List of Refresh Batch Steps shows twice as much vertical real estate.
Refresh Batch: Clearer description of ‘All Data Warehouse Tables (include new ones)’ checkbox.
Refresh Batch: Click a refresh step and ‘Move Up’ & ‘Move Down’ icons to re-order the refresh steps.
Refresh Batch: New step types for ‘Tableau Extract Refresh', ‘Cloud Script’, 'Command Line’.
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 requires the extract name.
Refresh Batch: ‘Tableau Extract Refresh’ default values for other fields:
Project = <EntityID>
Parent Project = NULL
Tableau Site = <EntityID>
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: Removed ‘Refresh Type' since this can now be done directly in 'Refresh Batch Steps’.
Refresh Batch: Moved ‘Debug’ drop down to Settings page.
Refresh Batch: Removed ‘Enabled’ from batch list (not functional yet).
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 their functions and name and/or metadata.
Refresh Batch: Mousing over a table pops up its metadata (DSN and refresh settings).
Refresh Batch: Removed ‘On Demand Data Refresh’ UI with delay start - no longer needed.
Refresh Batch: Shows ETL+ version on the top right.
Refresh Batch: With multiple data sources, Batch Steps show DataSourceName.TableName.
Refresh Batch: Added ‘Tableau Template Deployment’ icon - available to admin users only.
Refresh Batch: ‘Log File’ icon to open local log file in Notepad.
Engine: Notifies when ETL+ doesn’t find the required .NET installed.
Engine: When an extraction errors out, retry 3 times (3 seconds apart).
Engine: When manually running extractions, connection errors prompt for Retry, Cancel or Skip.
OData Extraction: For OData tables without built-in indexes, ETL+ will only extract data in blocks when indexes have been configured in ETL+. Without indexes, such extractions will be continuous (not in blocks).
OData Extraction: Character fields are loaded into varchar(max) in the data warehouse and are limited to the first 250 characters (next release will give users control of target column format).
OData Extraction: When running an RWC or Update extraction from large datasets, ETL+ logs to Acumatica, loads in sets of up to 100 extraction blocks into a temp table, loads the temp table to the target table, logs off, and then repeats this process for the next set of extraction blocks. This helps Acumatica rendering speed, and provides intermediary starting points in case of issues in the middle of the extraction process.
OData Extraction: When processing delta refreshes, the page size will automatically expand when the delta filter cannot get over the next page of data. The expanded page size only applies to the table being loaded. Message: The delta extraction filter requires an Extraction Pagination expansion from <current> to <new> rows.
OData Extraction: Ability to insert texts that include SQL special characters (such as ' \* *\).
OData Extraction: Debug Log file includes OData URLs executed when Debug is set to Level 2.
Acumatica OData v3 delta refreshes: Acumatica does NOT accept GI formula fields (ex.: =[GLHistoryByPeriod.FinPeriodID]) as filter for RWC and Update.
Acumatica OData v4 delta refreshes: Acumatica requires that filters for RWC and Update must not have NULLs and ETL+ extraction blocks must be bigger than the max number of records for each block of records with the same filter value.
OData v4 Extraction: Changed extraction process for large tables when OData v4 refused to render data.
OData v4 Extraction: When working with RWC or Update and using date filters, ETL+ filtering adapts to the date format of the source Acumatica.
OData v4 Extraction: If a table doesn’t have a native OData index, ETL+ errors out and logs “Extraction time out. Table without native OData index. Please create one via Replace with Control or Update.”
ODBC Extraction: Sage Intacct ODBC support.
ODBC Extraction: Quickbooks Online ODBC support.
OBDC Extraction: MongoDB ODBC support (non-relational database).
OBDC Extraction: Using native MondoDB ' (single quote) or ANSI [] (brackets) around reserved words and nested collections.
ODBC Extraction: Support to views from source system (previously, only tables).
Logging: ETL+ logs description and time for new functions/scripts (Tableau Extract Refresh, etc).
Logging: When launching ETL+ via command line, add the 3rd parameter “1” and ETL+ will log locally “Start ETL+” even before loading the cloud metadata.
Logging: Posts Source.TableName when multiple sources are available, otherwise only TableName.
Logging: Posts the number of rows loaded.
Logging: Posts the type of load: the <action> variable in (X rows <action>):
Replace All: loaded
Replace with Control: replaced
Update: updated
Append: appended
Logging: For large OData tables with RWC or Update, logs when 100 extraction blocks are loaded.
Logging: Posts 32 or 64bit ETL+ version on log refresh headers.
Client Information: ETL version posted.
Client Information: The following fields were moved to more relevant pages: Data source, Settings, 0_EntityID Column, Notification Email.
Client Information: Creation of a Dropdown for DataSelf License type (DataSelf ETL+, VAR, DIY, Advanced, Pro, Enterprise). Only available for super admin.
Client Information: Addition of checkbox to deploy out-of-the-box Tableau Templates for Advanced Analytics.
User Logging Page: ETL version posted.
Error handling: Notifies and logs incorrect Column names used in 'Replace with Control' or 'Update'.
Error Handling: Improved message description when ETL+ can’t connect to its data warehouse.
Error Handling: Added message describing that MS SQL doesn’t accept insert in timestamp columns.
Error Handling: For certain extraction errors, retry the extraction 3 times.
New Deployments: Removed step to load data now (it caused confusion).
New Deployments: ‘Deploy Tableau Script’ runs on dw3 cloud server the following command line: “C:\DataSelf\<SourceSystem>\Deploy.Bat <EntityID> <DwServer> <DwDbName>”
Super admin: ‘Client Info’ and ‘Refresh Batch’ pages allow the deployment of out-of-the-box ‘Tableau Templates’ (site, tdsx, twb) for Advanced Analytics and QA templates for Pro and Enterprise.
Super admin: Entity creation populates EntityID in Refresh Batch Email Notification’s Subject.
Super admin: Entity creation populates user email in Refresh Batch Email Notification’s Email.
Resolved Issues
Counter of Load UI page fixed (it was always counting 1 extra item).
Handling of OData v4 having more than one table with the same name.
Creation of EntityID now requires a unique ID.
Errors out in case of an attempt to create a duplicated data warehouse Schema.TableName.
Tagging of the NextRefreshTime metadata field wasn’t populating correctly.
More than 4 index fields in Update was looping in some OData extractions.
OData XML extraction of non-standard characters fixed.
Known Issues
Importing large XML content into varchar(max) might run into error: server stack limit has been reached.
Deleting all Refresh Batches requires going to ETL main page and back to get a new one created.
Changing the data warehouse of an entity won’t show on the bottom left corner until the entity is closed and re-opened.
Sometimes ETL+ is closing unexpectedly after a data load.
Sometimes ETL+ runs into an “Unhandled exception” error. Close and re-open ETL+.
Locking the ETL+ editing when someone else is editing it doesn’t work in some situations.
ETL+ still tries to send email even when set to Cloud notification, or No Notification.
ETL+ delta extraction from NetSuite ODBC might not work when using dates for filtering.
When opening an entity created in prior ETL+ versions, the data warehouse panel will show the source header blank. To fix this, open the entity in the prior ETL+ version, make any modification and save it. Now open the entity in the latest ETL+ and the source header appears.
Importing tables from the data warehouse works correctly but it might incorrectly log an error message.
2021.03.3103
Release date: 03/31/2021
Download Files
64 bits: https://www.dataself.com/etl_plus/DataSelf ETL Plus 64bits - 2021.03.3103.exe
32 bits: https://www.dataself.com/etl_plus/DataSelf ETL Plus 32bits - 2021.03.3103.exe
New Features
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.
Resolved Issues
Super admin: Issues when creating new entities.
The 32-bit version wasn’t saving ODBC credentials.
Known Issues
When configuring Acumatica OData delta refreshes, in the case that OData doesn’t render the indexes of a table (Acumatica bug?), you might get an “invalid type for an index” or “invalid for use as a key column” error message. To fix it, keep the delta configuration as is, change the “Load Type” to “Replace All”, do a table refresh, and switch back to delta refresh.
Failing to entering correct credentials 5 times in a row closes ETL+ but allows immediate 5 new re-attempts. The correct process is to force a 5 minute wait after 5 failed attempts.
2021.02.2803
Release date: 02/28/2021
Download Files
64 bits: https://www.dataself.com/etl_plus/DataSelf ETL Plus 64bits - 2021.02.2803.exe
32 bits: https://www.dataself.com/etl_plus/DataSelf ETL Plus 32bits - 2021.02.2803.exe
New Features
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).
Resolved Issues
New features number 1 and 2 resolve several auto refresh friction points.
Fixed data auto refresh not running from some servers via command line.
Fixed a testing feature that prevented ETL+ from connecting to the cloud from some servers.
Fixed the auto email of new product registrations.
Fixed ETL+ Excel and CSV data sources to include headers on row 1.
Fixed Update and Replace with Control refresh from ODBC sources.
Fixed error message showing data warehouse structure names.
2021.1.001.1301
Release date: 01/13/2021
Download Files
64 bits: https://www.dataself.com/etl_plus/DataSelf ETL Plus 64bits - 2021.1.001.1301.exe
32 bits: https://www.dataself.com/etl_plus/DataSelf ETL Plus 32bits - 2021.1.001.1301.exe
New Features
Multiple refresh schedules.
Add Debug Mode dropdown to Batch page. Levels: Debug Off, Debug L1, Debug L2. The debug applies to each DSBI site, and all of its refreshes and users.
Allow ETL+ to run multiple refreshes of the same Entity in parallel.
Make UI 99 to be sorted by EntityID (not Entity Name).
Add the dw name to the bottom left corner of the ETL+ UI.
Improve UI titles and descriptions for clarity and self documentation.
Resolved Issues
Test "Communications" and "User" tables with all fields from Sage CRM source.
Scheduler isn't remembering the saved schedule settings.
ETL+ was hanging in WTS. Issue with the feature that puts notifications on the system tray.
When trying to upload 2 tables now, on the dw table list: clicking on a table, pressing and holding Crtl and clicking on a 2nd table crashes the ETL.
Log when refresh runs via shortcut shows [DS ERROR: 9997] - Thread was being aborted.
2020.4.012.1402
Release date: 12/14/2020
Download Files
64 bits: https://www.dataself.com/etl_plus/DataSelf_ETL_Plus_64bits_2020_4_012_1402.exe
32 bits: https://www.dataself.com/etl_plus/DataSelf_ETL_Plus_32bits_2020_4_012_1402.exe
New Features
Create button on the Source Tables column for "Include".
When creating the ETL+ password, re-label "Password" to "New Password".
Selecting DBs in the MS SQL credentials page: Refresh Button to reload the list of DBs.
Delete Data Warehouse Table now has a "Confirm Deletion?" prompt.
Password cannot have # as the only special character. Message: Password cannot have # as the only special character.
For CSV Data Sources: "The first row has a Column names" should be checked and grayed out and non-editable.
For CSV Data Sources: "The first row has a Column names" Delimiter should have comma ',' and grayedout and non-editable.
Replace with Control: Order By field box removed. It automatically creates the index based on the Control field.
Debug Mode creates a log file: Log entityID_debug.txt.
Support for NetSuite ODBC.
Download CSV and Excel files with URLs with strings after the file name.
Ability to use subqueries in SQL Statements.
0_EntityID to all tables.
Replace with Control delta refresh.
Update delta refresh.
Download CSV and Excel files from URLs into DS_SourceFiles folder where the ETL+ is, and then extract data to data warehouse.
Resolved Issues
Refresh and Upload buttons fail with THROW Error.
The ETL is not accepting edits in Client Information and Refresh Schedule. DS ERROR 04000 - Transaction Failed.
When saving a data warehouse table, ETL shows: "Do you want to cancel all changes made in this section?".
In the Microsoft Excel data source, "the first row has a Column names" should be checked.
It takes too long to enable other functions after saving a SQL Statement.
Fixed OData extract: DSID: nfr_wac_acumatica1, Dw Table: 'TST jn - Prod Order Detail - In Process Released', Upload fails.
It wasn’t running the Tbl refresh at the end of the auto refresh.
The data refresh email should only be sent when running the full refresh.
Mapping of Odata fields failed.
When adding New Table, the cursor will allow to change this new table name. However, it can only save the new name if all other table names listed are above "New Target Table".
The ODBC Data Source box had two Connect buttons.
Using Preview in OData on some tables causing closing, freezing or error message.
2020.4.010.2701
Release date: 10/27/2020, First Release
Download Files
64 bits: https://www.dataself.com/etl_plus/DataSelf_ETL_Plus_64bits_2020_4_010_2701.exe
32 bits: https://www.dataself.com/etl_plus/DataSelf_ETL_Plus_32bits_2020_4_010_2701.exe
Released Features
Minimum system requirements: 1 CPU, 2GB of RAM, 5GB of free diskspace, Windows 10, Windows Server 2012 R2 or newer, 32 and 64bit.
Installation process: EULA, user credentials and token, IP whitelisting, connection to data source, scheduling the data auto refresh via Windows Task Scheduler (WTS), refreshing data now, and optionally maintaining ETL+ metadata.
Microsoft certified application.
Creation of Windows Task Scheduler (WTS) task to run the data auto refresh, including schedule and user to run WTS service.
Cloud-based ETL+ metadata allows remote maintenance.
Cloud uptime of 99.9%.
Data source built-in connectors:
ODBC (32 and 64 bits)
MS SQL Server
Odata version 3
Excel (will prompt to install MS Access driver if required)
CSV (will prompt to install MS Access driver if required)
Refresh of tables and subsequent Tableau data sources via encoded batch files.
Auto data refresh email notification.
Data load type: Replace all.
Create evolution bar for the data extraction when running via ETL+ UI.
Add refresh evolution process in system tray when running as a service.
Stores data and metadata in SSL secured multi-tenant AWS MS SQL Server data warehouse.
Upload data to AWS cloud servers via SSL secured IP-to-IP connection.
Locally encrypt user credentials to ETL+ and on-promises systems.
Credentials using user token, and requiring user to create an user with their email and complex password (minimum of 8 characters with lower/upper case, numbers and special characters).
If a users fails to enter correct credentials 5 times in a row, block access for 5 minutes.
ETL+ UI panes: source tables, data warehouse tables, SQL Statements.
About page to show EULA and product release.
Data warehouse table functions: new, duplicate, rename, delete, preview, upload now.
Refresh Now with options to Refresh Full, DW only, Tableau only.
Refresh Now with counter of 9 seconds (configurable), and buttons for Cancel, Pause, Run Now.
ETL SQL Statement with Edit Mode and Confirm button.
Locally saved ETL+ log file with refresh steps.
Email refresh process log to maintenance users.
Creates shortcut on Desktop to run ETL+ auto refresh processes.
Keywords: DataSelf ETL+ Release Notes. DataSelf ETL+ Upgrade. Versions. Latest Versions.
- No labels