Extraction Performance: ETL processes run dramatically faster when extracting from MS SQL sources that are hosted in the same SQL instance as the data warehouse.
This improvement also applies to zDataWarehouse re-imports.
ETL+ Configurable Metadata: Now the ETL+ metadata location is configurable. This allows the deployment of the complete ETL+ engine (server, client, and agent) behind a client’s firewall, as well as having an ETL+ solution for testing purposes (with no effect on the production stack).
ETL+ Metadata: Ability to configure the location of the metadata database for a given ETL+ installation.
ETL+ Metadata: Run ETL+ in a command line with -md parameter to configure a custom metadata location.
ETL+ Metadata: When configuring a custom metadata location, click the Default button to set the metadata back to its default location (dw3), and close the dialog.
Saving a Copy of Source Metadata: Now a copy of sources' metadata is saved in ETL+. This copy might contain a list of tables, columns, column formatting, and primary keys if available. This allows users to map new tables and columns more quickly and without the need to be connected to the source database.
Source Metadata: On the Source page, clicking Connect retrieves and stores the source database’s table and column metadata.
Source Metadata: On the Source panel, clicking Refresh 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.
Source Metadata: On this release, ETL+ only uses the in-memory source metadata when adding tables as new objects. If the user edits the Extract SQL Statement, ETL+ will use other methods to resolve column formatting.
Source Metadata: Hovering the mouse over a Source on the Source Objects panel shows when its metadata was loaded to the cloud.
Source Metadata: Hovering the mouse over a Source on the Target Objects panel shows when its metadata was loaded to the cloud.
Source Metadata: When loading a table, ETL+ will load the source metadata to the cloud if that hasn’t been done before.
Saving Mapped Tables' Column Metadata: Now each mapped table has its source and target column metadata saved in ETL+. Users can quickly see that data on the redesigned Design page, this is helpful for maintenance and troubleshooting. Also, this saved metadata allows ETL+ to execute table loads more quickly (in prior versions, it had to read the source and target column formatting before executing a load).
Design page: Redesigned page from scratch.
Design page: The page and its column sizes can be manually adjusted.
Design page: Source PK column(s) added.
Design page: Source PK column(s) (when available) are now numbered based on the source’s PK definition.
Design page: Source Data Type added. It shows the data type received from the source database.
Design page: VarChar column with checkboxes added. This allows users to force the extraction of a source column into a varchar(max) data type in the temp table 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 PK renamed to Key+.
Design page: Key+ tooltip provides clearer information about this column.
Design page: Key+ is now numbered to set the sequence of multi-column unique keys and PK.
Design page: By default, when available, the Key+ comes preconfigured to match the source table’s PK from MS SQL Server.
Design page: By default, when available, the Key+ comes preconfigured to match the source table’s PK from Oracle.
Design page: By default, when available, the Key+ comes preconfigured to match the source table’s PK from OData.
Design page: Logged-in username added at the bottom-left corner.
Design page: Entity ID in session added at the bottom-left corner.
Design page: When changing the Dw Data Type
, there’s a revised message to notify users about setting a new T-SQL expression: “Changed data type from <source type> to <target type>. Overwrite T-SQL to: <new T-SQL expression>. Confirm? Recommended: Yes)”.
Design page: When converting a char data type to date, ETL creates TRY_CONVERT. This converts invalid date values into NULL.
Design page: When converting a char data type to datetime, ETL creates TRY_CONVERT. This converts invalid datetime values into NULL.
Design page: Clicking Confirm no longer requires clicking Confirm on the ETL page.
Removed Target Objects → … → Load All Columns. This feature became obsolete.
Remote Upgrade: Now admin users can trigger the upgrade of ETL+ and its Agent remotely (without the need to be logged into the computer with ETL+). This requires an active Agent on the target computer.
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.
User Authentication: SQL Source passwords now have new actions: View/Hide Password, Lock/Unlock Password.
SQL Passwords: On an unlocked SQL password, users can view and hide the password.
SQL Passwords: Users can click the Lock Password icon to permanently lock it. Locked passwords cannot be viewed.
SQL Passwords: Unlocking a password will require password re-entry. From that point on, users can view and hide the password.
Data Warehouse SQL Authentication: Support to Azure Active Directory - Password
.
Source MS SQL Authentication: Support to Azure Active Directory - Password
.
Saved ETL+ user credentials are now encrypted and stored in C:\Users\<username>\AppData\Local\DataSelf_Corporation\ds_lg_info.ds
OData Refinements: Now ETL+ can map and extract PX_ tables and columns that before weren’t directly available via the ETL+ mapping wizard.
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.
The mapping of OData v3 and 4 tables mimics the source’s column formatting.
The extraction of OData v3 and 4 tables no longer truncates string fields to 255 characters.
Extraction of large OData tables now uses the data stored on the TableName_Temp2 to reset the OData filter to extract the next block of 100 pages. This addresses an Acumatica issue when rendering data from large tables via OData.
For OData with delta extractions based on date filters, the JSON/XML time zone is now ignored. This eliminates the need to read the time zone before the extraction starts (removed Currency table extraction that was previously used to read the default time zone of an Acumatica tenant).
When adding new OData sources, the default page size is 5,000 rows (up from 1,000).
Extraction Engine: The code has been refactored into classes for cleaner execution and maintenance.
The mapping of tables from non-structured sources (like Excel, CSV, and ODBC) mimics the source’s column formatting.
The extraction of tables from non-structured sources (like Excel, CSV, and ODBC) no longer truncates string fields to 255 characters.
ODBC Source Page: Added credentials section.
ODBC Source Page: Made it clearer that the list of available DSNs is 32 or 64 bits.
Now users can open and edit ODBC Sources even on computers that don’t have any DSN.
Replace Delta Refresh: Dedicated metadata filter column (no longer shared with Upsert).
Replace Delta Refresh: Updated the feature description “1st: Insert rows based on the condition. Ongoing: Replace rows based on the condition”.
Replace Delta Refresh: changed labels from “Field” to “Source Field”, and blank to “Target Value or Constant”.
Upsert Delta Refresh: Dedicated metadata filter column (no longer shared with Replace).
Upsert Delta Refresh: Renamed Primary Key
to Unique Key
.
Refinements/adjustments to extract Salesforce.com data via ODBC.
Refinements/adjustments to extract Snowflake databases via ODBC.
Refinements/adjustments to extract NetSuite data via ODBC.
Refinements/adjustments to extract Oracle data via ODBC.
Refinements/adjustments to extract Oracle data via native driver.
Google Sheets sources will automatically download the DataSelf JSON Google Sheets file if not available locally.
Now you can add other expressions outside of CTEs (ex.: a table union).
Extract SQL Statement Parsing: Initial Parsing release.
SQL Parsing: Tries to capture the target table’s column list and data types and stores them in the metadata.
SQL Parsing: A new toggle icon on the SQL Statement sets if parsing is on or off.
Parsing ON: Clicking Confirm on a changed SQL Statement will try to execute parsing.
Parsing OFF: Clicking Confirm on a changed SQL Statement will just save the statement to the metadata - no parsing.
Parsing ON: Clicking Confirm on the Design page will try to execute parsing.
Parsing OFF: Clicking Confirm on the Design page will just save the Design changes.
Freeze Table: Added a checkbox to the More Actions target object menu to freeze a table’s content.
For more see ETL+ Freeze
Freeze Table Loads: Frozen tables can’t be changed via ETL+, unless the table is unfrozen. For more see ETL+ Freeze
Frozen tables retain their delta refresh configurations (if needed again).
Log will show “Skip table” for frozen tables that are part of refresh Jobs.
Hovering over a frozen table shows Load Type = Frozen.
Job Refinements: Fixing some scheduling bugs as well as incorporating weekly and monthly scheduling.
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 parameters (configurable via ETL+ Web - beta release).
Job Scheduling: Next date/time to run a Job can use scheduling based on monthly parameters (configurable via ETL+ Web - beta release).
Job App: Simplified process to select an Agent app. Select it from the dropdown, and click Save.
Job Load Type: Changed to a dropdown list with a new option: Force Replace when Upsert, default for others.
UI Improvements: Source types now have their own icons on the ETL page.
Source Icon: Google Sheets dedicated icon.
Source Icon: MySQL dedicated icon.
Source Icon: MS Access dedicated icon.
Source Icon: MS Excel dedicated icon.
Source Icon: MS SQL Server dedicated icon.
Source Icon: OData dedicated icon.
Source Icon: ODBC dedicated icon.
Source Icon: Oracle dedicated icon.
Source Icon: PostgreSQL dedicated icon.
Source Icon: CSV dedicated icon.
ETL Page: Source types now have their own icons on the Target Object panel (smaller than source icons).
Target Object Source Grouping Icon: Google Sheets dedicated icon.
Target Object Source Grouping Icon: MySQL dedicated icon.
Target Object Source Grouping Icon: MS Access dedicated icon.
Target Object Source Grouping Icon: MS Excel dedicated icon.
Target Object Source Grouping Icon: MS SQL Server dedicated icon.
Target Object Source Grouping Icon: OData dedicated icon.
Target Object Source Grouping Icon: ODBC dedicated icon.
Target Object Source Grouping Icon: Oracle dedicated icon.
Target Object Source Grouping Icon: PostgreSQL dedicated icon.
Target Object Source Grouping Icon: CSV dedicated icon.
Source Properties Page: Source types now have their own icons.
The bottom left corner of ETL+ pages now shows the EntityKey value and metadata URL.
The Job page now shows the data warehouse information.
The data warehouse information under the ETL page title now has a tooltip with more details.
The data warehouse information under the Job page title now has a tooltip with more details.
ODBC Data Sources page: layout re-organized for clarity.
ETL Source
panel was renamed to Source Objects
.
ETL Objects
panel was renamed to Target Objects
.
ETL SQL Statement
panel was renamed to Extract SQL Statement.
Target Object icons: Dedicated icon to represent tables with Replace.
Target Object icons: Dedicated icon to represent tables with Upsert.
Target Object icons: Dedicated icon to represent tables with Append.
Target Object icons: Dedicated icon to represent tables with Freeze.
Settings page: Layout reorganized.
When clicking actions, the mouse cursor goes to “waiting mode” until the action completes (ex.: on Save buttons).
Source Objects - New Source menu: Removed (Beta) tag from Google Sheets, MySQL, Oracle, and PostgreSQL.
When an entity is open, by default, all objects on the Target Objects are collapsed.
Client Information’s Cloud Script
checkbox moved to a better position.
When importing a table from the zData Warehouse, by default, the table is renamed (to be sure it’s not overwritten in case the table hasn’t been mapped as a target object in ETL+).
It’s now possible open/edit existing ODBC sources even when there are no local DSNs.
Target Object icons: A small red dot notifies modified tables that haven’t been saved to the metadata.
User Action Logging and Debugging: Now many ETL+ user actions are logged. This should help collaboration and troubleshooting.
Logging: Many user actions are now logged on the zETL_Log table.
Logging: New logging type = 100 for user actions.
Logging: Saved data warehouse configuration.
Logging: Saved a table’s Extract SQL Statement panel.
Logging: Saved Job page.
Logging: Settings page saved.
Logging: Client Info page saved.
Logging: Table added.
Logging: Table deleted.
Logging: Table renamed.
Logging: Job added.
Logging: Job deleted.
Logging: Job script added.
Logging: Job script deleted.
Logging: Source added,
Logging: Source deleted.
Logging: Agent on a machine added.
Logging: Job App selected.
Logging: Entity duplicated.
Command Line -d (debug mode): Runs ETL+ in local debug mode on the local hard drive.
Command Line -d: There’s a new local file Log_Debug.txt showing information about the environment where ETL+ is running.
Command Line -d: Information logged: OS version.
Command Line -d: Information logged: OS local language.
Command Line -d: Information logged: .NET version.
Command Line -d: Information logged: 32/64-bit platform.
Command Line -d: Information logged: Test the https access to dataself.com.
Command Line -d: Information logged: Outbound port testing.
Command Line -d: Information logged: Available local hard drives total and available space.
Command Line -d: Information logged: Test access to ETL+ metadata - if fails, test access to a test database on the same SQL instance where ETL+ metadata is.
ETL+ Multi-session Mode: When there’s more than one ETL+ Desktop session running with the same entity, each session shows “Other session(s) open: <# of sessions>” on the ETL and Job pages. This feature notifies of other users on the same entity and prevents configuration overwrite conflicts.
Hovering the mouse over “Other session(s) open” message will show the other session’s usernames.
The message above is auto-refreshed every 15 seconds.
This feature monitors open sessions on pages: ETL, Job, Settings, Client Info, and Data Sources.
When one of the sessions saves a change to the metadata, the other sessions will receive a notification that they are outdated. Those sessions turn into a Runtime mode (no ability to change, just view and run loads and scripts), and the Save buttons become disabled.
When a session turns into a Runtime mode, close and re-open the entity to make changes to it.
ETL+ Runtime mode: ETL+ can only execute pre-configured templates, and configure the pre-configured data sources, and job schedules.
ETL+ Limited mode: ETL+ can only work and modify pre-configured templates.
ETL+ admin improvements: Admin users can configure many of the texts used in the ETL+ user interface such as error messages and log descriptions.
When duplicating an entity for Pro and Enterprise, the 99 user can now deploy the Tableau script when saving the Client Info page.
Double-clicking an entity on the Entity list will open it.
When the debug mode is on, the Job Refresh Start log line shows the .NET version installed on the host computer.
Data Warehouse admin refinements: When duplicating an entity, 99 users select the data warehouse prior to filling out the Client Info page.
Data Warehouse key=1 (multi-tenant) is no longer editable via the ETL+ UI (security reasons). 99 users can view it, but not edit it. IT users can edit its settings directly in the metadata database.
Regular users: they can now modify their single-tenant data warehouse settings.
Regular users: from the ETL page, click Settings → Data Warehouse → fill out the data warehouse settings → Save.
When creating a new entity (or duplicating a new one), there’s no need to close it. One can use it right off the bat.
ETL+ Watchdog: A new Linux-based engine to monitor ETL+ processes.
ETL+ WatchDog: Email notification of Job start failures is sent 5 mins from the scheduled start time.
ETL+ WatchDog: Email includes DeviceName, Agent status, Job status, and other metadata info.
ETL+ WatchDog: Email contains a link to open the ETL+ Web Job page with expanded logging.
ETL+ Installer: The new installer easily sets up the DataSelf ETL+ and Agent Service environment in Windows computers.
By default, the ETL+ is installed in the following folder (the user can change the folder):
C:\Program Files\DataSelf ETL Plus
When applicable, the ETL+ saves its working files in the following Log and Working Files
folder:
C:\Users\Public\DataSelf
Settings Page: New entry to customize the location of the Log and Working Files
folder.
Settings Page: Icon to configure the Log and Working Files
folder location.
When applicable, these are the folders that are saved in the Log and Working Files
folder:
DS_Credentials
DS_Downdows
DS_SourceFiles
OlderVersions
ETL page: Added Log and Working Files
icon on the top right. Clicking it gives you ways to reach that folder as well as the folder where ETL+ is running from.
Job page: Added Log and Working Files
icon on the top right. Clicking it gives you ways to reach that folder as well as the folder where ETL+ is running from.
The installer also installs and deploys the new DataSelf Agent Service.
DataSelf Agent Service: Now the Agent runs as a Windows Service.
The Agent is automatically installed and run as a Windows Service upon installing DataSelf ETl+.
By default, the Agent Service runs with the LOCAL SERVICE
Windows account.
The Agent can be maintained (stop, start, pause, credentials change) in the Windows Services app.
The Agent local log file has been moved to the Log and Working Files folder.
The Agent now logs: when the service starts and its version.
The Agent now logs: when the service shuts down.
The Agent now logs: successful connection to the ETL+ metadata.
The Agent now logs: if using the default or a custom ETL+ metadata.
The Agent now logs: successful connection to the ETL+ metadata.
The Agent now logs: failure connecting to the ETL+ metadata.
The Agent now logs: date & time when a new task runs.
The Agent now logs: date & time when a new task ends.
ETL+ Web - Beta version: New web UI allows admin users to monitor and make changes to certain ETL+ processes anytime and anywhere.
ETL+ Web: Released for super admin users.
ETL+ Web: User authentication using Azure AD, SAML-based, Single Sign-on (SSO) enabled.
ETL+ Web: User authentication is locked to @dataself.com users.
ETL+ Web: Jobs page created mimicking the equivalent ETL+ Desktop features.
ETL+ Web: ETL Log page created mimicking and improving the equivalent ETL+ Desktop features.
ETL+ Web: Settings page created mimicking part of ETL+ Desktop features.
ETL+ Web: Client Info page created mimicking part of ETL+ Desktop features.
ETL+ Web: A Transfer page to easily exchange files.
ETL+ Web: Users page created to manage SSO.
ETL+ Web: Menu buttons to access ETL+ pages.
ETL+ Web: The menu button has a green background and indicates the ETL+ Page in session.
ETL+ Web: Top-left button shows the Master Entity
filter.
ETL+ Web: Top-left shows the selected entity’s data warehouse information.
ETL+ Web: Top-right shows username logged in.
ETL+ Web: Top-right shows ETL+ Web version.
ETL+ Web: Top-right shows ETL+ Web's metadata's SQL instance name.
ETL+ Web - Master Entity
filter: Shows a description of the selected entity(ies) and the number of entities when more than one is selected.
ETL+ Web - Master Entity
filter: Allows searching.
ETL+ Web - Master Entity
filter: Check/Uncheck All icons.
ETL+ Web - Master Entity
filter: When a single entity shows on the list, press Enter to select it.
ETL+ Web - RESET FILTER button clears filters to their default values.
ETL+ Web - User page: Contains columns for email, actions, first and last name, token, user key, type, status, default entity, created at.
ETL+ Web - User page: One can sort the page by the page headers.
ETL+ Web - User page: Email search box.
ETL+ Web - Job page: Contains columns for Entity ID - Key, Job, Actions, Agent, Job Status, Job Name, Last Run, Next Run, Load, App.
ETL+ Web - Job page: One can sort the page by the page headers.
ETL+ Web - Job page: Search box for the name of the App running the Job schedule.
ETL+ Web - Job page: Agent column filter with values: Offline, Active, WTS.
ETL+ Web - Job page: Job Status column filter with values: Running, WTS Assigned, ETL+ Desktop Only, Scheduled, Unscheduled.
ETL+ Web - Job page: Load column filter with values: Default, Forced.
ETL+ Web - Job page: Action: Run Job.
ETL+ Web - Job page: Action: Clicking Run Job will prompt confirmation.
ETL+ Web - Job page: Action: Stop Job.
ETL+ Web - Job page: Action: Clicking Stop Job will prompt confirmation.
ETL+ Web - Job page: Action: Job Properties.
ETL+ Web - Job page: Action: Job Properties icon toggles the Properties panel on and off.
ETL+ Web - Job page: Action: Selecting a Job Properties highlights the Job with green.
ETL+ Web - Job page: Job Properties - Schedule toggle icon.
ETL+ Web - Job page: Job Properties - Dropdown for schedule frequency: Daily, Weekly, Monthly.
ETL+ Web - Job page: Job Properties - Weekly options provide checkboxes to run the Job on Sun, Mon, Tue, Wed, Thu, Fri, Sat.
ETL+ Web - Job page: Job Properties - Monthly options provide checkboxes to run the Job on each day of the month from the 1st to the 28th, Last day, Check All, Uncheck All.
ETL+ Web - Job page: Job Properties - Dialog for setting the Job’s Start’s Date/Time
.
ETL+ Web - Job page: Job Properties - Repeat task every
toggle icon.
ETL+ Web - Job page: Job Properties - Text box for min.
ETL+ Web - Job page: Job Properties - Text box for For a duration of X hours.
ETL+ Web - Job page: Job Properties - Load Type radio button.
ETL+ Web - Job page: Job Properties - Dropdown to select the App to run the Job schedule. Options: WTS and Agents assigned to this Job.
ETL+ Web - Job page: Job Properties - Save button.
ETL+ Web - Job page: Job Properties - Save button enabled only when changes are pending saving.
ETL+ Web - Job page: Job Properties - Closing properties without saving changes will prompt confirmation.
ETL+ Web - Job page: Job Properties - Saving a Job’s Properties will update the Job’s columns Agent, Job Status, Next Run, Load, and App.
ETL+ Web - Job page: Action: Job Steps.
ETL+ Web - Job page: Action: Job Steps icon opens the Steps panel on the right.
ETL+ Web - Job page: Action: Job Steps icon toggles the Steps panel on and off.
ETL+ Web - Job page: Job Steps - Close and Save buttons.
ETL+ Web - Job page: Job Steps - Save button enabled when there are changes to save.
ETL+ Web - Job page: Job Steps - Closing panel without saving prompts confirmation.
ETL+ Web - Job page: Job Steps - HIDE UNCHECKED icon. To hide all rows that are unchecked.
ETL+ Web - Job page: Job Steps - HIDE TABLE icon. To hide all Table rows.
ETL+ Web - Job page: Job Steps - HIDE TABLEAU icon. To hide all Tableau rows.
ETL+ Web - Job page: Job Steps - HIDE CLOUD SCRIPT icon. To hide all Cloud Script rows.
ETL+ Web - Job page: Job Steps - HIDE COMMAND LINE icon. To hide all Command Line rows.
ETL+ Web - Job page: Job Steps - HIDE CSV DOWNLOAD icon. To hide all CSV Download rows.
ETL+ Web - Job page: Job Steps - Move to Top
icon. Select rows, and click this icon to move them to the top.
ETL+ Web - Job page: Job Steps - Move Up
icon. Select rows, and click this icon to move them one row up.
ETL+ Web - Job page: Job Steps - Move Down
icon. Select rows, and click this icon to move them one row down.
ETL+ Web - Job page: Job Steps - Move to Bottom
icon. Select rows, and click this icon to move them to the bottom.
ETL+ Web - Job page: Job Steps - Selected
Check/Uncheck icon. Select multiple steps and click this icon to check/uncheck their checkboxes in bulk.
ETL+ Web - Job page: Job Steps - Tables
Check/Uncheck icon.
ETL+ Web - Job page: Job Steps - Scripts have the Properties icon enabled.
ETL+ Web - Job page: Job Steps - Scripts Properties icon toggles its settings panel on and off.
ETL+ Web - Job page: Job Steps - Clicking the Properties icon of a Script allows one to view and change the script settings.
ETL+ Web - Job page: Job Steps - Drag & Drop Steps position - Select one or multiple steps (use Ctrl or Shift), drag and drop them up or down on the Step list.
ETL+ Web - ETL Log page: Contains columns for Entity, DateTime, Desc, Source Error, Type, RunID, Device/User, Job.
ETL+ Web - ETL Log page: One can sort the page by the page headers.
ETL+ Web - ETL Log page: Search boxes for Desc, Source Error, Device/User.
ETL+ Web - ETL Log page: Center-top: 250 Rows Retrieved.
ETL+ Web - ETL Log page: Change the number of Rows Retrieved and press Enter. Prompt to confirm if the row count to retrieve is over 10K.
ETL+ Web - ETL Log page: By default, the log list is sorted by DateTime where the most recent log row is at the bottom of the list.
ETL+ Web - ETL Log page: Log Desc that is longer than 200 characters will show an icon on the far right. Click the icon to see the whole Desc.
ETL+ Web - ETL Log page: Log SourceError that is longer than 20 characters will show an icon on the far right. Click the icon to see the whole SourceError desc.
ETL+ Web - Settings page: Client Info - shows Entity, Name, Users, Source System, Phone, License dropdown.
ETL+ Web - Settings page: Has an Entity dropdown filter with the entities available from the Entity Master filter. The Setting’s Entity filter can only show one entity at a time. By default, it shows the first of the list.
ETL+ Web - URL parameters: Syntax: https://etl.dataself.com/<page>?parameter1¶meter2&etc
ETL+ Web - URL parameters: <page> can be logs, jobs, users, settings, clientinfo, transfer, and use cmd for commands (like run a Job).
ETL+ Web - URL parameters: ? separates URL from parameters
ETL+ Web - URL parameters: & parameter separator
ETL+ Web - URL parameters: e=<EntityKey> (e.g.: e=12)
ETL+ Web - URL parameters: Sort ascending sort=<ColumnName> (e.g.: e=12&sort=EntityID)
ETL+ Web - URL parameters: Sort descending sort=-<ColumnName> (e.g.: e=12&sort=-EntityID)
ETL+ Web - URL parameters: filter[<ColumnName>]=<Value>, requires e= (e.g.: e=12&filter[Job_Key]=1)
ETL+ Web - URL parameters: Expand job properties jxp=<JobID>, requires e= (e.g.: e=12&jxp=1)
ETL+ Web - URL command: Run Job jr=<JobID> requires cmd?e= (e.g.: cmd?e=12&jr=1)
ETL+ Web - URL command: Stop Job js=<JobID> requires cmd?e= (e.g.: cmd?e=12&js=1)