Advanced ETL Processor Professional 5.7.2.2

v5.7.1.3 [05-07-13]

+ Introduced Repository Synchronization wizard
- Addressed problems with "If in List" Function

v5.7.0.10 [04-21-13]

+ Addressed problems with updating Oracle blob fields
+ Addressed some grouper issues
+ HL7 Examples were added
+ Undo/Redo Functionality was improved
+ Documentation update

v5.7.0.7 [04-09-13]

HL7 samples were added
Compare values function was added
IF Functions were introduced
Total number of functions now 500+
Comments were added to Literal function
Various bug fixes and interface improvements
Documentation update
Addressed some regular expressions bugs

v5.6.3.4 [03-03-13]

Added align left, align top, align right, and align bottom buttons
Dedupicator Lookup and InLinst functions are up to 20 percent faster
Ability to link output fields was introduced
Hints were added to Lookup object
Better object selection for packages and mappings
Support for HL7 was introduced

v5.6.2.9 [02-15-13]

+ Added Keep Characters Function
+ Added Epoch to Date Function
+ Added Date to Epoch Function
+ Interface improvements
+ Documentation update
- Various bug fixes

v5.6.2.3 [01-28-13]

+ Improved support for MS SQL Server 2012
+ Improved support for BDE
+ Logging improvements for Connection type, connection name and connection details
- Agent bug fixes
- Various bug fixes

v5.6.2.0 [01-11-13]

+ Support for BDE and Paradox was introduced
- Various bug fixes

v5.6.1.4 [12-17-12]

+ Added copy paste functionality to IMAP connections
+ OLE Reports Dialog is resizable now
- Various bug fixes

v5.6.0.0 [11-24-12]

+ Support for stored procedures as data target was introduced
+ Performance improvements for MS SQL Server Connection
+ Various Bug Fixes
+ Documentation Update

v5.5.2.3 [11-01-12]

+ Added option to ignore XML tags between Table tag and Record tag
+ Documentation Update
- Fixed set variables bugs

v5.5.1.3 [10-15-12]

+ Support for Stored procedures as data targets was introduced for OleDB connection
- Various bug fixes

v5.5.1.0 [09-15-12]

+ Added new object Log which can be used to analyze data quality issues
+ Reader Parameter Object was renamed to Metadata object
+ Ability to extract package name, OS user name, computer name, transformation name and Application name was introduced
+ Documentation Update
- Various bug fixes

v5.5.0.0 [09-01-12]

+ Support for QlikView QVD files was introduced
- Various bug fixes

v5.4.3.2 [08-11-12]

+ New Version control tab was introduced
+ Version control can submit several objects now
+ Version control dialog can delete multiple objects now
- Various bug fixes

v5.4.3.0 [07-22-12]

+ New package object was introduced = Case
+ Massive performance improvement up to 10+ times for some data sources/targets
- Various bug fixes

v5.4.0.0 [06-25-12]

+ Support for BrightPearl was introduced
+ Support for IMAP4 was introduced
+ Support for Sales Force was introduced
+ Support for JDBC was introduced
+ Support for IP Sockets was introduced
+ Additional filters for file/zip and check file operations
+ Documentation update
- Various bug fixes

v5.3.1.2 [05-30-12]

+ Support Excel named ranges was introduced
- Various bug fixes

v5.3.0.2 [05-15-12]

+ Uses 10 times less memory for large excel files
+ Support for loading data from RSS, Google spread sheets and windows event logs was introduced
+ Dynamic Excel sheet names
+ Documentation update

v5.2.0.9 [04-07-12]

+10x performance increase for generating QVX files
- Addressed some SMTP problems
+ Documentation update

v5.2.0.1 [03-23-12]

+ New arithmetical functions were added Add,Subtract,Divide,Multiply,Max and Min
+ Union ALL transformation object was created
+ Documentation update
+ Support for Dynamic SQL for ETL transformations was introduced
- Various bug fixes
- Addressed some SMTP problems

v5.1.0.0 [02-22-12]

+ Read and write QlikView QVX files
+ Support for QVX_QV_DUAL fields type was introduced
- Addressed some issues related to working with MS Sql Server Compact edition
- Various bug fixes

v5.0.1.2 [01-27-12]

+ Timeout was added to SQL Scripts
+ Documentation update
+ First Record flag, Last Record flag, First Record flag for file/table/sheet, Last Record for file/table/sheet were added to Reader parameter data transformation function
+ Sequence and Running total transformation function improvement

v5.0.1.0 [01-14-12]

Even smaller executable
SMTP testing was fixed for SSL connection
Export Dialog alignment problem was corrected
Main windows alignment problem was corrected
Position saving problem was addressed for validator/transformer/package editor
Corrected some repository creation scripts

v5.0.0.10 [12-31-11]

MAJOR RELEASE

+ Package Debugging
+ Parallel execution
+ Highly optimized code
+ Execution agent is now only 5 mb (compare this to some java etl tools)
+ Schedule for execution Packages, Transformations and SQL scripts
and much more

v4.2.7.2 [10-26-11]

+ Package debugger was introduced
+ Breakpoints were introduced
+ Execute single package object option was introduced
+ Project Tree View - COLLAPS/EXPAND buttons were added
+ More generic log viewer
+ Ability to group packages, sql scripts reports and emails was added

v4.2.7.0 [10-11-11]

+ Null function
+ Interface Improvements
+ Standard print preview
+ Support for scrolling in Package editor and transformation editor
+ Option "Full tree expand" when unticked objects tree shows list of projects
- Better error handling for ADO and MS Sql scripts
- Command line parameter fix

v4.2.6.17 [09-25-11]

Overwrite all files
Skip existing add create new ones
Append data to existing files and create new ones
Append data to existing files
Delete Files

v4.2.6.10 [09-05-11]

Added Support for XSLT transformations
Added Get Variable, XML XSLT transformation, Validate XML function
Interface Update
Various bug fixes

v4.2.6.9 [08-07-11]

Ping Server and Check Database connection was introduced
Added File name and Directory name extraction transformation functions
Data splitter modifications
Various bug fixes

v4.2.6.8 [08-03-11]

Added Fields Selector transformation function
Various bug fixes

v4.2.6.5 [07-27-11]

Improved support for spaces in table names and SQL reserved words
Added clear log check box to transformation progress dialog
Added open open execution log button
Added Clone Row, Base64 Encode, Base64 Decode, GUID, Random transformation functions
Various bug fixes

v4.2.6.3 [07-11-11]

Range lookup transformation function was introduced
When data is exported into excel file numeric values are stored as numbers
Various bug fixes

v4.2.6.0 [06-28-11]

Major ETL tools update

This release changes the way the Data Validator works

It allows the user to validate and transform the data at the same time.
To update:
Open Data Validator and map validation rules to output fields.
Save Data transformation.
Repeat for all transformations

v4.2.5.3 [06-03-11]

Incremental Transformation function search was introduced

v4.2.5.2 [05-31-11]

Packages and Transformation editor Fixes
Various Bug Fixes

v4.2.5.0 [05-12-11]

Lookup Improvements and Fixes
Data preview improvements
Clear log shows dialog box first
Transformer and Validator have names now
Direct Latest Version downloads from application
Various Bug Fixes

v4.2.4.14 [04-13-11]

Script language extension:

DeleteCharacters(S,CharactersToDelete) Deletes specific characters from the string
Delete(S,Start,End) Deletes part of string S
EnsureNoPrefix(S,Prefix) Removes prefix from the string when present
EnsureNoSuffix(S,Suffix) Removes Suffix to the string when present

v4.2.4.11 [04-01-11]

Command line support for errorlevel was introduced
Zip library update and fixes
Added post changes button to table browser
Added Optimize Column Width button
Fixed number of problems related to working with data groupper

v4.2.4.9 [03-13-11]

Fixed number of problems related to working with InList and Lookup functions
Fixed number of problems related to working with uniqueidentifierfileds in sql server

v4.2.4.4 [02-24-11]

Data Sorter bug fixes
FTP Log is more compact now
More useful error messages from copy and move file operations

v4.2.4.2 [02-09-11]

New Reader parameter: Source File Creation Date
SFTP bug fixes
Repository scripts update

v4.2.4.0 [01-26-11]

Support for Sql Server Compact Edition was introduced
Various bug fixes

v4.2.3.6 [01-16-11]

Fixed Issues with SQLite imports
Support for zip files > 4 gigs was introduced
Some issues related to SMTP and POP3 connections were resolved
Support for Charts, Bar codes and OLE objects was added to report

v4.2.3.0 [12-13-10]

Support for SFTP was introduced
Export of empty tables was fixed
Various problems related to working with very large files were resolved
Copy and Move file operations can also rename multiple files
Calculation was not showing result correctly in preview mode

v4.2.2.9 [11-30-10]

Major update

Powerful data transformation language was introduced
Lots of new functions, procedures, bug fixes
Copy field names form data reader to data writer
Documentation update

v4.2.2.3 [11-26-10]

Works correctly with mixed case objects in PostgreSQL
Scripting language was extended
Various bug fixes
FTP bug fixes
Documentation update

v4.2.2.1 [10-23-10]

Loads Data from XML files
Exports data into XML
Works correctly with multiple PosgreSQL schemes
Support for PosgreSQL 9 was introduced
Support for German Locale was introduced
Select all and copy from data grids
Documentation update
Various bug fixes

v4.2.1.1 [10-06-10]

Supports multiple text line delimiters now

v4.2.1.0 [09-19-10]

Works directly with SQLite now
Various Interbase/Firebird related bug fixes
Fixed bug with import of MS Access tables with spaces in names
Minor Interface Changes
Fixed FTP list command for WindowsNT
Memory leaks were fixed

v4.2.0.0 [08-07-10]

Data grids:
Grouping panel was added
Advanced filter dialog was introduced
Record number
New look and feel
Excel
Works directly with Excel 3.0-2007
No ODBC, OleDB or MS Jet Required
Works correctly with mixed data types
Works correctly with cells with more 255 characters

v4.1.0.12 [07-29-10]

Massive performance improvement for large data repositories
Various access violations were fixed
Problem with duplicated fields was resolved

v4.1.0.9 [07-16-10]

Various bug fixes

v4.1.0.7 [07-03-10]

Some problems were addressed related to loading data into varchar(max),nvarchar(max),varbinary(max)

v4.1.0.6 [06-06-10]

ETL Package Variables
Package Script
HTTP Download Object
Documentation Update
Unlimited Email Attachments
System variables

v4.1.0.5 [05-24-10]

Print reports directly to printer
Several new report export formats - Excel, Rtf, Csv and Pdf
Fixed Loading data into DBF files

v4.1.0.2 [04-18-10]

Support for SQL Server 2005/2008 was improved
Various bug fixes

v4.1.0.0 [03-30-10]

Database to Email and Email to Database transformations
Transform files into blob fields and Export of blob fields
Secure Email
Improved support for blobs
Detailed log for POP3,SMTP, and FTP

v3.3.3.7 [02-28-10]

Secure email is now supported
More detailed log for SMTP,POP3 and FTP objects
Project Restore

v3.3.3.6 [02-22-10]

7 new ETL Transformation functions were added

In Place Replace
Encode Xml Element
Decode Xml Element
Encode Xml Attribute
Decode Xml Attribute
Encode Xml String
Decode Xml String

Total number of Data transformation functions is now 48

Documentation Update+minor bug fixes

v3.3.3.5 [02-11-10]

Support for FTPS and FTPES was introduced

v3.3.3.4 [01-25-10]

Now you can use Advanced ETL Processor to generate SQL Insert Scripts from any table or file
Various bug fixes
Documentation Update

v3.3.3.2 [01-13-10]

Now you can use Advanced ETL Processor to generate SQL Insert Scripts from any table

v3.3.3.0 [01-03-10]

Support for Ole Db was Introduced (this part is still in beta stage)
InList and Lookup ETL objects bugs were fixed

v3.3.2.18 [12-16-09]

Minor Bug Fixes
Documentation Update
Support for Dynamic file names was extended
Now you can use calculations in target file names
{GetSystemVariable('SOURCE_FILE_NAME')+'.good'}
{GetSystemVariable('SOURCE_FILE_NAME')+'.very_very_bad'}
FTP Improvements

v3.3.2.17 [11-15-09]

Two new transformation functions were added
Replace Characters and Delete Characters
Minor Bug Fixes
Documentation Update

v3.3.2.16 [11-03-09]

Two new transformation functions were added
Replace Characters and Delete Characters
Minor Bug Fixes
Documentation Update

v3.3.2.12 [10-10-09]

Some issues related to zip object and repository backup were resolved

v3.3.2.6 [09-23-09]

New package object called "Data Export" was introduced
Now you can export 3000+ tables from the database with couple of clicks
Now you can filter incoming emails based on sender ans subject

v3.3.2.1 [08-21-09]

Minor Bug Fixes
Documentation Update

v3.3.2.0 [07-26-09]

Updated sequence transformation obejct
Running totals
Updated documentation
Minor bug fixes

v3.3.0.19 [06-21-09]

Minor bug fixes

v3.3.0.12 [05-12-09]

This version works up to 30 percent faster comparing to the previous release

More information:
* Full support for unicode
* Support for sql functions and oracle sequences
* It is now possible to pull data directly from Oracle database without ODBC.
* Various bug fixes

v3.3.0.3 [04-16-09]

This version works up to 30 percent faster comparing to the previous release

More information:
* Full support for unicode
* Support for sql functions and oracle sequences
* It is now possible to pull data directly from Oracle database without ODBC.
* Various bug fixes

v3.2.0.8 [03-23-09]

Updated SQL Query Builder
Support for Oracle 11g

v3.2.0.6 [02-25-09]

Updated SQL Query Builder
Support for Oracle 11g

v3.2.0 [12-26-08]

Updated SQL Query Builder
Support for Oracle 11g