DataSelf ETL+ Web Release Notes & History

• https://etl.dataself.com

• Release date: 05/22/2026

ETL+ WEB

• ETL Page

  • Python Scripts

    • Integrated as External Objects

    • The first release runs in the DataSelf Cloud

    • Allows installation of Python requirements

    • Provides Environment Variables for ETL metadata and data warehouse access

  • Power BI: support for the following environment/tenant types:

    • Commercial (standard)

    • DoD

    • GCC

    • GCC High

  • Tableau:

    • Enhanced integration with Tableau Server and Tableau Cloud

    • Tableau bulk publishing of projects, data sources, and workbooks from zipped files

    • Tableau data source reporting extractor

  • New icons/features for left panel

    • Details toggle for easy viewing of target table's ID, row count, and last refresh date/time

    • Groups toggle for Source Grouping

    • Source Favorites (brings favorites to the top of the source lists)

    • Schema toggle for Source SQL Schemas

  • Simple Live Log: Live Log can be duplicated and pinned into SQL right-panel tabs.

  • Target Table Metadata - right panel:

    • Top section with Row Count and Loaded At.

    • Relayout of the Load Types panel:

      • Vertically compacted

      • Wider boxes for columns and filter expressions

      • Easier to view and adjust the configuration

    • Extraction Sort Configuration:

      • Extract Sort Expression for custom sorting

      • Configuration of the Extraction Sort Type:

        • -1: No extraction sort

        • 0: Default (from the Design’s page Key configuration)

        • 1: Uses the field from the Replace filter + the Design’s page Key configuration.

        • 2: Uses the field from the Replace filter.

        • 3: Customized based on the Extraction Sort Expression

  • Export target table metadata to CSV (only for 99 users).

  • Comprehensive Find/Replace feature across all sources:

    • Search for single and multiple lines of code

    • Replace with single and multiple lines of code

    • Toggle for case sensitive search

    • Checkboxes for where to find matches:

      • Source Alias

      • Table Name

      • SQL Statement

    • Match counter

    • Replace one at a time, or Replace All

    • Checkbox to select all data sources or select one at a time

    • Search/Replace boxes grouped by Source

      • Collapse/expand each source

      • Checkbox for each source

      • Expand/collapse each table

  • Expand/collapse tabs are remembered within a logged session for:

    • ETL+ Overview

    • Left panel

    • Target Table Metadata

    • Bottom Log panel

  • Save and ETL+ AI buttons moved to the top left area.

  • KB AI Bot removed.

• Target Table Design:

  • Mirrors the functionality from ETL+ Desktop Design page

  • Lists Source PK, ETL Key, Column Name, Source Data Type, Force, DW Data Type, Metadata, T-SQL Expression.

  • Allows configuration for Key, Force, DW Data Type, Metadata, and T-SQL Expression.

  • Creates a recommended T-SQL Expression based on DW Data Types changes by users.

• Seetings Page

  • General

    • Configuration for: Entity ID, Entity Name, Phone, Debug Level, License Type, User Emails, Job Notification Subject / Email / When Notify.

  • Data Warehouse

    • Lists ID, ServerName, DBName, Schema, Authentication, Login, Multi-tenant toggle.

    • Add New Data Warehouse

    • Edit configuration

  • Devices

    • Lists Status, Master radio button, Alias, Host/Port, Device Address, Activate toggle, Version, DS Cloud flag.

    • Users can change individual settings for the Master and Activate.

    • For users 99, provides list of DataSelf Cloud Devices to allocate to the entity.

  • Data Sources

    • Lists ID, Name, and selected Device

    • Allows users to change Device dropdown

  • Jobs

    • List ID, Name, Device, Actions

    • Edit which Device to run the Job (Master or Command Line)

  • Tags

    • Lists Selected Tags, ID, Description, Type

    • Allows user to assign Tags to the entity

  • Advanced

    • Refresh Settings toggles: 0_Entity Column, 0_UnionID, 0_InvalidData, TableName_InvalidData.

    • Before reloading target tables with Load All

    • Default connection timeout

    • Time Zone, and Add minutes to metadata clock

    • Template settings: Reporting Template, Reporting Date, FYear Start, CYE Value

  • About

• Self-service Deployment Form

  • Support/integration with the following Power BI environments/tenants:

    • Commercial (standard)

    • DoD

    • GCC

    • GCC High

• Log Page

  • ETL Web User Actions have their own Log Type = 101.

• Job Page

  • Log: ETL Web User Actions have their own Log Type = 101.

  • Support of maintenance of multiple entities on a single page.

  • Job properties layout rearrangement.

  • Job Steps: availability to add Python Scripts

• Misc Features

  • Mousing over the ETL logo shows the package version and release date, as well as its 5 engines and their individual versions.

  • Header shows critical Company and Entity notes to 99 users.

  • Utility → Power BI Bulk Publishing: support to Commercial, DoD, GCC, and GCC High tenant/environments.

MCP SERVER (Model Context Protocol)

• MCP support for:

  • MCP Server for MS SQL Server (Data Warehousing)

  • MCP Server for Power BI

  • MCP Server for Tableau

Contact support@dataself.com if you run into issues.

• Release date: 03/14/2026

New Features

• Log Page

  • Faster Log loads!

  • New user action type for Web ETL+ users. Now we can tell if a user action was done on EDesktop (100) or EWeb (101)

  • Far left index column starts with 1 at the bottom.

  • Tableau refresh duration is now available in the logs. Only available when deployed via the new deployment form.

  • Livelog filters are no longer lost when reloading (parameters remain in the URL).

  • Bugs fixed: RefreshRunID column fixed; Websocket deadlocks suppressed.

• Job Page

  • Implemented Run Missed Jobs checkbox.

  • Bug fixed: Large device names show overlapping text

• ETL Page

  • On the Extract SQL panel, click Ctrl + F to use the following helpful Find/Replace features

    • Next, Previous, All

    • Checkboxes for Match Case, Regexp, By Word

    • Replace, and Replace All

  • When closing pages with unsaved changes, a confirmation warning is displayed.

  • SQL Mirroring:

    • Bug Fix – Table filter in the SQL Mirroring corrected.

    • Bug Fix – Source table listing was empty; tables are now displayed correctly.

    • Schema display fixed;

  • Sidebar:

    • Bug Fix – Incorrect NextRun value in the jobs list.

    • Bug Fix – DW section was always expanded.

    • Schema display option has been implemented.

    • DataSources grouping has been implemented.

  • Fixed variables in the log when reimporting a transformation

  • Infinite loading of the load icon, even after completion

  • Replace confirm fixed

  • Bug when trying to select all reimports

  • Saving issues fixed

• Self-service Deployment Form

  • Simplified flow (while we are the only ones filling it out):

    • No need to wait for new deployment request confirmation email. 

    • Non-critical steps disabled and/or reordered.

    • The payment step has been removed.

  • Tags have been implemented and are now entity-related.

    • Only statements, DataSources, and scripts related to the selected tags will be displayed for the entity.

  • Automatic removal of '/' at the end of Acumatica URL sources.

  • IP whitelisting can now be configured directly during deployment.

  • Data Source passwords are saved unlocked in ETL+.

  • HubSpot authentication has been implemented.

  • Scroll at the bottom fixed

  • A new last page for the deployment steps and maintenance:

    • The deployment process has been split into four parts. Each part shows the individual tasks executed:

      • ETL

      • DW

      • IP

      • Analytics

    • Partial redeployment has been implemented (ETL, Analytics, DW, IP). 

      • Redeploying ETL or DW will delete and recreate the selected part.

      • Redeploying Power BI or Tableau will not overwrite published templates, just add new ones

    • PowerBI Bulk Publishing now consider the tags to deploy or not

    • Corrected listing of PowerBI publication status.

    • Fixed status of the Resume/Deploy all button

    • Fixed DW database user permission

    • Metadata database user creation;

    • Fixed the metadata database user roles;

    • Metadata token sent by email

    • Bug fixed: Password displayed by email is missing the first char

    • Bug fixed: Entity duplication is copying the PBI server from the master entity

    • Fixed the execution flow when items must be skipped.

• Bulk Publish Page

  • Improved behavior: if an error occurs, the process continues.

  • Success or failure status is displayed for each file.

• IP Whitelisting

  • IP Whitelisting support for Azure SQL

  • Duplicate IP entries are now prevented.

  • Existing rules are reused instead of generating errors when duplicates are detected.

• Misc Features

  • Header

    • Time Zone: Metadata, Customized, Browser.

    • TAM update (formerly CAM):

      • Display on the header of all pages

      • Click it to open an email to the TAM.

  • Utility:

    • Power BI Bulk Publishing: for semantic models and workbooks

    • Tableau:

      • Bulk Publishing for data sources and workbooks

      • tds Metadata report extraction

  • After login, users are redirected to the page they originally requested.

  • Bug fixed: When switching between entities, the system returns error

  • Bug fixed: Master isn't loading

WATCHDOG

• Date format has been updated.

• Time zone (TZ) is now considered.

• Added information:

  • Master Device

  • Version

  • Metadata

  • Job description

• Information now adapts according to the version.

• Bug Fix

  • Status corrected for v26.

  • WITH NO LOCK removed from all statements

WEBSOCKET

• More stable engine:

  • "SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED" removed from all transactions;

  • Selects are made without transaction

Contact support@dataself.com if you run into issues.

• Release date: 01/24/2026

• Requirements:

  • An active ETL+ license; and a Microsoft 365 Business (or guest) account.

  • Your ETL processes assigned to ETL+ v2026.

New Features

• User authentication via Microsoft Entra

• User can access their own entity(ies)

• Header:

  • ETL page, Log Page, Tags, Dw, Entity, Filter Reset, ETL Desktop Metadata Server, User, ETL Web Metadata and version label

  • Utility

    • Client Info: Information about the company, entity, contacts, subscription, and billing.

    • IP Whitelisting: Easy IP Whitelisting management for the cloud metadata and data warehouse.

    • Transfer: Upload/download of files by entity.

    • VM: DataSelf Cloud VM status run / stop / reboot.

• Log Page

  • Log table header: Index, Entity ID, Job #, DateTime, Duration (in seconds), Desc, Type, Run ID, Dw, Device/user

  • Sorting and filtering available for most table headers

  • Hide/unhide columns

  • Resize columns

  • Type dropdown: Default: 0 – Job Start, 1 – Job Step, 2 - Refresh Start, 3 – Refresh End, 4 - Upload Now, 100 – User Action. Others: 5 – Data Warehouse, 6 – Refresh on Demand, 20 – User and Entity Mismatch, 40 – Log Error, 60 – Command Line, 5001 – Agent PID

  • Check All, Uncheck All, Apply

  • Rows are colored by RunID

  • Mousing over table values show the whole text (including hidden parts of it)

  • Clicking on a table value copies its content to the Clipboard

  • Hiding and resizing columns are remembered via web browser cookies

  • Click the Filters header to reset Log filters

  • Parametrized URL

    • Core URL: <https://etl.dev.dataself.com/logs?e=<EntityKey>>&m=<MetadataKey>

    • &rows=<Count>

    • &filter%5BJob_Key%5D=<Job#>

    • &filter%5BDesc%5D=<text no quotes needed>

  • Live Log.

• Job Page

  • Clicking the Properties icon opens a tab on the right panel:

    • Table with: Job, Actions, Status, Name, Last Refresh, Next Run, Load, App

    • Clicking the Properties icon opens:

      • Schedule toggle

      • Frequency dropdown

      • Start box, Recurs every box, Repeat task every toggle, time in min box, For a duration of X hours.

      • Load Type. App. Watchdog Alert.

      • Confirm / Discard buttons.

  • Job Step icon opens:

    • A tab showing Job Step configuration

    • A header with Discard / Confirm buttons, All Tables checkbox, Select checkbox, icons to sort the Job objects, and icons: Hide/Show for the following Job objects:

      • Checked items

      • Tables

      • Tableau data sources

      • Cloud scripts

      • Command Line scripts

      • CSV downloads

      • Power BI semantic models

      • Labels

      • A list of objects with a checkbox, the object icon, object name.

      • Select a group of items to move them up/down

  • Live Log: Expand/collapse the tab to view/hide a live feed of logs.

• ETL Page

  • Overview with hide/show icon

  • DW Header: Expand/Collapse icon; Dw SQL instance; DB name; Help icon; Replace icon.

  • Clicking on the header or its Expand icon shows one or more yellow groups (Mirroring) and one green (Transformation) group.

  • Add Source Connector: button to add new source connectors: Clicking it opens a dialog with a list of Source Connectors with Name, Driver, and Version.

    • Selecting a Source Connector opens the Source Connector Properties page.

    • Configuring the page and saving/connecting will add the source connector to ETL+.

  • Yellow Group(s) for Source Data Mirroring. Mapped source(s) to the data warehouse:

    • A yellow button for each mapped source with a Checkbox, source icon, alias, (number of mapped objects into ETL+), and the following icons: Help, Load Selected, Add Table, Properties, More Options, Expand objects.

  • Green Group: Transformation: a green button for reimports/transformations with a Checkbox, and the following icons: Help, Load Selected, Add Table, More Options, Expand objects

  • By expanding the yellow or green grouping:

    • Checkbox, object icon, Alias, and icons for Help, Load, More Actions, Expand columns.

    • Help icon shows: ID, Alias, Schema, Load Type, Row Count, Loaded At.

    • Object icon has options for Load All, Replace, Upsert, and Append.

    • More Actions gives access to: SQL Statement; Preview Table; Design; Rename Table; Duplicate Table; Delete Table; Tags, Target Schema -> Schema name options; Freeze.

    • Clicking on an object will open its details on a tab on the right panel:

      • The tab is yellow or green according to its source grouping

      • The tab’s name shows <Source>.<Alias>

      • The tab’s panel has a left and right sections:

        • The left section shows a summary of the object, the Load Type, Load Type Properties icon, Design button, Metadata description, list of columns and their data types plus Metadata description.

        • The right section shows the SQL Statement, when applicable. The SQL statement is color-coded.

        • Each of these panels have a button to collapse/expand to the left

        • When more than one tab is open, one can drag and drop tabs into additional columns or rows of tabs.

        • The panels’ height and width can be adjusted manually.

  • External Objects:

    • Cloud Script: to add new Cloud Scripts

    • Command Line: to add Command Line scripts to run on the Master Device

    • CSV Downloads: to download CSV files on the Master Device

    • Power BI: to add Power BI Semantic Model refreshes (via API)

    • Tableau: To add Tableau Data Source refreshes (via API)

  • ETL+ Jobs

    • Expanding it shows a table with: ID, Actions, Status, Name, Next Run

    • Clicking the Properties icon opens a tab on the right panel:

      • Table with: Job, Actions, Status, Name, Last Refresh, Next Run, Load, App

      • Clicking the Properties icon opens:

        • Schedule toggle

        • Frequency dropdown

        • Start box, Recurs every box, Repeat task every toggle, time in min box, For a duration of X hours.

        • Load Type. App. Watchdog Alert.

        • Confirm / Discard buttons.

    • Job Step icon opens:

      • A tab showing Job Step configuration

      • A header with Discard / Confirm buttons, All Tables checkbox, Select checkbox, icons to sort the Job objects, and icons: Hide/Show for the following Job objects:

        • Checked items

        • Tables

        • Tableau data sources

        • Cloud scripts

        • Command Line scripts

        • CSV downloads

        • Power BI semantic models

        • Labels

        • A list of objects with a checkbox, the object icon, object name.

        • Select a group of items to move them up/down

  • ETL+ AI button

    • Opens the AI dialog so users can query the ETL+ entity’s metadata.

    • ChatGPT LLM powered.

  • KB AI button: Opens the AI Chatbot trained in DataSelf domain

  • Apply button

    • Grayed out if no changes have been applied to the ETL page

    • When changing ETL, the button turns red with a change counter

    • Mousing over the button shows a list of changes not applied yet

    • Reset icon to clear up the ETL page

  • Live Log: Expand/collapse the tab to view/hide a live feed of logs.

• Self-service Deployment Form

  • Use cases: deployment of a new ETL+ system with the data warehouse in DataSelf’s cloud, and analytics in Power BI or Tableau.

  • Creates ETL+ entity and its user, cloud data warehouse and its dbo user, whitelists end-user IP, publishes Power BI or Tableau templates.

WATCHDOG

• Client-facing.

• Release date: 12/30/2025

ETL+ AI+

• Client-facing.

• Release date: 01/24/2026

ETL+ API

• Client-facing.

• Release date: 01/24/2026

Contact support@dataself.com if you run into issues.