What's new in ETL Framework 4.0-31374
Mar 2, 2015
- Changed:
- Improved support for proxy servers
- Significantly improved SQL parsing for all supported SQL dialects
- Improved support for key-value denormalization transformation
- Latest Java version is bundled with Windows distro
- Bug fixes and performance improvements
- Added:
- Support for NTLM-based authentication
- Ability to merge CSV files of the different structure
- Ability to stream data when performing merge of the CSV files
New in ETL Framework 4.0-29148 (Feb 10, 2015)
- Changed:
- Improved performance and reliability of the ETL engine by adding context-sensitive optimizer
- Improved support for Web services
- Improved support for XML files
- Improved support for JSON files
- Improved support for Excel XLSX files
- Improved logging and error reporting
- Bug fixes and stability improvements
- Added:
- Support for SOAP-based Web Services
- Ability to configure connections for the REST and SOAP Web Services
- Ability to execute XQuery on XML-based datasets
- Ability to perfrom normaliztion and denormalization of the key-value datasets
- Ability to execute JavaScript anywhere in the ETL scenario
- Ability to populate dataset inline, from any fragment of text, using given connector, such as JSON, XML, etc
- Ability to tokenize connection URL and Properties as well as task variables
- Ability to use pre-defined header and footer in the File Merge task
- Ability to pass configuration file name as a command line argument
- New examples
New in ETL Framework 4.0-22541 (Dec 27, 2014)
- Changed:
- JRE 1.8 is now bundled with Windows version of the ETL Framework
- Features of the older version of JavaScript engine (Rhino) are now supported by the ETL Framework when running on JRE 1.8
- Improved performance of the ETL engine
- Improved handling of the HTTP(s) connections
- Improved support for REST based Web services, specifically PUT and DELETE requests
- Added:
- Ability to partition dataset based on combination of key columns or maximum number of rows
- Ability to merge text files into the single file
- New examples
New in ETL Framework 4.0-21700 (Dec 27, 2014)
- Fixed:
- Excel XLS and XLSX workbooks were not created when some columns presented in the source were excluded from the destination
- Delimited and fixed length text files were not properly created when some columns presented in the source were excluded from the destination
- Added:
- Ability to skip empty rows when reading delimited and fixed length text files
New in ETL Framework 4.0-21225 (Dec 27, 2014)
- Fixed:
- Wrong classpath in the Eclipse project for the ETL Framework with a full source code
- Batch files were not executed by ETL engine on Windows 7 and below under non Administrator account
- In some cases ETL Engine was not reporting location of the run-time exception
- Added:
- New modules to the build scrips used by the ETL Framework with a full source code
- New global variables are now available when executing programs in scripting languages from the ETL engine
- Improved performance of the ETL engine when running programs in scripting languages
- Adility to set a data source agnostic limit on number of rows to extract
New in ETL Framework 3.3 (Apr 5, 2013)
- Improved ETL syntax validation
- Added support for long column names to the ETL framework
- Added ability to add column to the destination on the fly and calculate its value using JavaScript or SQL
- Added ability to use destination variable names in the JavaScript to calculate a variable value
- Improved connectors for Excel, text and XML files.
- Improved error validation, added new data types, improved handing of the not standard formatting.
- Improved performance of the ETL engine
- Added examples for all new ETL features
- Bug fixes
New in ETL Framework 3.2 (Apr 5, 2013)
- Improved auto-update functionality
- Test suite and build scripts added to the ETL Framework Eclipse project
- Fixed a bug which was causing automatic transaction commit in some cases