Advanced ETL Processor 3.7.0.9

v3.7.0.7 [04-20-13]

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

v3.7.0.3 [04-04-13]

+ 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

v3.6.3.3 [03-04-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 mappings
- Various bug fixes

v3.6.2.8 [02-14-13]

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

v3.6.2.0 [01-12-13]

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

v3.6.1.3 [12-16-12]

+ Introduced Auto complete functionality
- Addressed some issues related to loading data from QVD files
- Various bug fixes

v3.6.0.0 [11-25-12]

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

v3.5.1.4 [10-29-12]

+ Added option to ignore XML tags between Table tag and Record tag
+ Documentation Update

v3.5.1.3 [10-15-12]

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

v3.5.1.0 [09-16-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

v3.5.0.0 [08-31-12]

+ Support for QVD files was introduced
- Various bug fixes

v3.4.4.3 [07-23-12]

- Various bug fixes

v3.4.4.0 [07-06-12]

+ Massive performance improvement up to 10+ times for some data sources/targets
- Various bug fixes

v3.4.3.7 [06-26-12]

+ Support for BrightPearl was introduced
+ Support for IMAP4 was introduced
+ Documentation update
- Corrected some problems related to dynamic file names
- Various bug fixes

v3.4.3.6 [06-20-12]

+ Support for BrightPearl was introduced
+ Support for IMAP4 was introduced
- Corrected some problems related to dynamic file names
- Various bug fixes

v3.4.2.1 [05-16-12]

+ Uses 10 times less memory for large excel files
+ Documentation update

v3.4.1.0 [05-01-12]

+ Support for loading data from RSS, Google spread sheets and windows event logs was introduced
+ Dynamic Excel sheet names
+ 10+ performance increase when working with Excel files
- Various bug fixes

v3.4.0.3 [04-06-12]

+ New arithmetical functions were added Add,Subtract,Divide,Multiply,Max and Min
+ Documentation update

v3.4.0.0 [03-18-12]

+ Union ALL transformation object was created
+ Documentation update
+ Support for Dynamic SQL for ETL transformations was introduced
- Various bug fixes

v3.3.1.0 [02-21-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

v3.3.0.11 [01-26-12]

+ 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 trasformation function
+ Sequence and Running total transformation function improvements
- Various bug fixes

v3.3.0.9 [01-10-12]

+ After and Before transformation functions
+ Added support for CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,Whirlpool checksums
+ Documentation update
- Various AV fixes
- Addressed problem with arranging objects

v3.3.0.1 [12-02-11]

- Various Access violation fixes

v3.3.0.0 [11-18-11]

+ On win64 can now access 3 gb of memory
+ Support for themes
+ Documentation update
- Text writer unicode fixes
- Various bug fixes

v3.2.7.2 [10-23-11]

- "Program" file was created on drive c
- XML XSLT transformation fix
- Some auto format issues were addressed
- Minor interface tweaks
- Memory leaks and AV fixes

v3.2.7.0 [10-10-11]

+ Null function
+ Interface Improvements
+ Standard print preview
+ Support for scrolling in transformation editor
- Boolean fix for MySql
- Better error handling for ADO and MS Sql scripts
- Command line parameter transformation function save problems

v3.2.6.7 [09-22-11]

FormatStrToDate was added to calculation transformation
ReformatDate, Set variable, Get variable transformation functions were added
SQL execution log functionality was greatly enhanced
Execution log was added to data transformation/validation screen
Format field names dialog box was introduced

v3.2.6.2 [09-04-11]

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

v3.2.5.10 [08-08-11]

Added File name and Directory name extraction transformation functions
Data splitter modifications
Various bug fixes

v3.2.5.9 [08-03-11]

Added Fields Selector transformation function
Various bug fixes

v3.2.5.6 [07-26-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

v3.2.5.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

v3.2.5.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

v3.2.4.2 [06-03-11]

Incremental Transformation function search was introduced

v3.2.4.1 [05-27-11]

Transformation editor Fixes
Various Bug Fixes

v3.2.4.0 [05-13-11]

Lookup Improvements and Fixes
Data preview improvements
Clear log shows dialog box first
Transformer and Validator have names now
Added Save, Save As, Open and New items to menu
Direct Latest Version downloads from application
Various Bug Fixes

v3.2.3.11 [04-14-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

v3.2.3.8 [03-31-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

v3.2.3.6 [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

v3.2.3.3 [02-25-11]

Addressed number of problems related to working with uniqueidentifier fields in sql server
Fixed bug loading zero length files
Various bug fixes

v3.2.3.1 [02-08-11]

New Reader parameter: Source File Creation Date
Various bug fixes

v3.2.3.0 [01-25-11]

Support for Sql Server Compact Edition was introduced
Various bug fixes

v3.2.2.14 [12-13-10]

Calculation was not showing result correctly in preview mode
Corrected problem with duplicated source fields

v3.2.2.10 [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

v3.2.2.3 [11-16-10]

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

v3.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

v3.2.1.1 [10-01-10]

Supports multiple end line delimiters now

v3.2.0.8 [09-05-10]

It is possible now to pass variables between transformations
Keep value transformation function
Shows PK information for access target and ole db target
No more duplication in transformation and validator grids
Table browser loads data much faster
Various Excel related bugs fixes

v3.2.0.0 [08-03-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

v3.1.0.9 [07-30-10]

Various interface improvements
Various access violations were fixed
Problem with duplicated fields was resolved

v3.1.0.7 [07-20-10]

Various interface improvements
Popup menu was added to data grouper.
New options for unpivot and pivot data transformation object
Documentation update
Various bugs were fixed

v3.1.0.5 [06-29-10]

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

v3.1.0.4 [05-23-10]

Fixed Loading data into DBF files

v3.1.0.3 [04-27-10]

Various bug fixes

v3.1.0.2 [04-16-10]

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

v3.1.0.1 [04-10-10]

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

v3.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
Secure Email

v2.4.3.5 [03-01-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

v2.4.3.4 [02-21-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

v2.4.3.3 [01-31-10]

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

v2.4.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

v2.4.2.12 [12-19-09]

Minor Bug Fixes

v2.4.2.11 [12-07-09]

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

v2.4.2.10 [11-17-09]

Minor Bug Fixes

v2.4.2.8 [10-25-09]

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

v2.4.2.6 [09-15-09]

Minor bug fixes

v2.4.2.4 [08-27-09]

Minor bug fixes

v2.4.2.0 [07-19-09]

We are proud to announce that Advanced ETL Processor Standard version 2.4.2.0
In this version we added support for PostgreSQL and Interbase/Firebird

v2.4.0.14 [06-30-09]

Minor bug fixes

v2.4.0.7 [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

v2.4.0.2 [04-15-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

v2.3.0.6 [02-25-09]

Various bug fixies

v2.3.0 [12-22-08]

Updated SQL Query Builder
Support for Oracle 11g