DataSelf ETL Release Notes

From DataSelf Knowledge Base
Revision as of 20:26, 1 April 2014 by Dataself (talk | contribs)
Jump to navigation Jump to search

ETL Upgrade Links - ETL Upgrade Installation files

ETL Release 2014.1.xxx

New Features

  • A new Refresh Wizard Refresh Type which allows to easily run external applications as part of the ETL’s refresh process.
  • A significantly simplified DataSelf ETL installer will facilitate the solution installation. During the installation process, the installer will automatically apply the latest ETL engine upgrade version as well as properly installing the solution’s templates on disk. This is the first step in a series of improvements targeted to automate the complete solution procedure as much as possible.
  • The built-in backup procedure will skip locked files, and notify the user about that. Often, locked files are not critical in the backup process.

Fixes

  • Modify Table Structure Wizard: the validation of duplicated field names is performed after the field name has been completed.
  • The creation of sorts/indexes are performed right after clicking 'Save', not after the table is refreshed.
  • The ETL no longer freezes when performing remapping of fields that are no longer existent in source tables.
  • Adjustments to the Replace with Control (RWC) engine: Control Field selection was unavailable, and tables with over 10 million records could have conflict with the garbage collector preventing new records to be imported.

ETL Release 2013.4.xxx

Release 2013.4 is a major release of DataSelf's ETL.

Support for more Types of Data Source Connections

Import Table Wizard - Data Source Settings window. This screen shot shows settings for a MS SQL SERVER connection.

In recent releases several new data source connection types have been added to the Import Table Wizard. The data source types recently added are:

  • MS SQL SERVER
  • MS Excel
  • MS Access

Changes have been made to several Import Table Wizard windows and a new window, Import Table Wizard - Data Source Settings, was added.

Modify Structure Window Replaced

The Modify Table wizard was completely redesigned to simplify the process of changing table names, field names, and field data types. The naming scheme for the data types was changed to reflect those used in Microsoft SQL Server. Support for the new integer data types was added. The number of keystrokes required to make changes was cut about %50.

Modify Structure window can change data warehouse table names, field names and their data types.

ETL Supports Integer Data Types

Prior to this release all integer data was written to a fixed decimal point, numeric data type. Integer data types now supported include:

  • Int - 4 byte integer, +2.14 billion to -2.14 billion
  • SmallInt - 2 byte integer; +32,768 to -32,767
  • TinyInt - 1 byte integer; 0 to 255

NOTE: Both the int and numeric data types are exact data types. They store an exact representation of the number; there is no approximation of the stored value.

Refresh Report Email Configuration Improved

Tools > Refresh Report Email Configuration

The Refresh Report Email Configuration window was redesigned to streamline the process. A new Test Configuration Account button was added that sends a test email using the configuration.

Added Protocol Box to FTP Configuration Window

Tools > FTP > FTP Configuration

<under construction>

Fixes

  • Table Union wizard must remember table name when adding new unions.
  • Improved speed to import Excel files.
  • Improved speed to release cursor after refreshing a table.
  • Improved speed to see list of tables to import.
  • Improved speed to build list of available fields to import.
  • Improved speed to close/shut down the ETL.
  • Table browsing is working again with tables up to 2GB big.
  • Fixed the creation of primary keys.
  • Improved speed and use of disk space by RWC.
  • Find ways to time out SQL Jobs.
  • Failure in formulas pulling table summaries from fields with M size in the source.
  • ETL upgrade could delete relationships using indexes of different formats.
  • Update product icons.
  • Update Splash pictures.

ETL Release 2013.2.xxx

Import Directly from Excel Files and Access Databases

New connections to Microsoft Excel files and Microsoft Access databases are now available. These new data source types no longer require an external ODBC (DSN) connection. More

Changes were made to several Import Table Wizard windows and a new window, Import Table Wizard - Data Source Settings, was added.

Support of Primary Keys

<under construction>