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.
ETL+ Web: Jobs page created mimicking and improving part of 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: Users page created to manage SSO.