Softpedia >Windows >Internet >Servers >Database Utils >Advanced ETL Processor Standard >  Changelog

Advanced ETL Processor Standard Changelog

What's new in Advanced ETL Processor Standard 3.9.8.39

Apr 29, 2024
  • Added: "Lookup RegEx" and "Lookup Contains" transformation functions

New in Advanced ETL Processor Standard 3.9.8.38 (Apr 22, 2024)

  • Improved: "Fields Order" Error Handndling.

New in Advanced ETL Processor Standard 3.9.8.37 (Apr 15, 2024)

  • Improved: "Fields Order" transformation object interface

New in Advanced ETL Processor Standard 3.9.8.35 (Apr 11, 2024)

  • Added: "Fields Order" transformation object

New in Advanced ETL Processor Standard 3.9.8.33 (Mar 22, 2024)

  • Added: Delimiter, Text Qualifier, Skip Empty Values and Ignore Duplicates options to Accumulate Strings transformation function

New in Advanced ETL Processor Standard 3.9.8.32 (Mar 17, 2024)

  • Fixed: Issues with viewing/editing very large numbers (MySQL, Postgress, Interbase/Firebird and SQLite)
  • Fixed: Print preview issues
  • Fixed: Multitab search issues
  • Improved: Print preview dialogue is closed on ESC

New in Advanced ETL Processor Standard 3.9.8.30 (Mar 14, 2024)

  • Updated: SSH components

New in Advanced ETL Processor Standard 3.9.8.28 (Mar 11, 2024)

  • Added: "Proper Name" option to Format Fields dialogue
  • Improved: Groups handling of UnPivot dialogue

New in Advanced ETL Processor Standard 3.9.8.27 (Mar 11, 2024)

  • Added: "Proper Name" option to Format Fields dialogue
  • Improved: Groups handling of UnPivot dialogue

New in Advanced ETL Processor Standard 3.9.8.26 (Mar 5, 2024)

  • Updated: Excel components

New in Advanced ETL Processor Standard 3.9.8.25 (Feb 29, 2024)

  • Added: Fixed Automap feature of Union all dialogue

New in Advanced ETL Processor Standard 3.9.8.24 (Feb 29, 2024)

  • Added: Automap button to Union all dialogue.

New in Advanced ETL Processor Standard 3.9.8.23 (Feb 28, 2024)

  • Added: Automap button to Union all dialogue.

New in Advanced ETL Processor Standard 3.9.8.22 (Feb 25, 2024)

  • Fixed: Minor transformation interface bugs

New in Advanced ETL Processor Standard 3.9.8.21 (Feb 22, 2024)

  • Fixed: Split Dialogue AV

New in Advanced ETL Processor Standard 3.9.8.20 (Feb 22, 2024)

  • Fixed: SQLite data reader bug
  • Improved: Workinng with JSON Pairs

New in Advanced ETL Processor Standard 3.9.8.19 (Feb 22, 2024)

  • Removed: TelAPI SMS Support (The company no longer exists)

New in Advanced ETL Processor Standard 3.9.8.18 (Feb 22, 2024)

  • Updated: Third party components

New in Advanced ETL Processor Standard 3.9.8.17 (Dec 10, 2023)

  • Updated: Excel components

New in Advanced ETL Processor Standard 3.9.8.16 (Dec 5, 2023)

  • Added: Refresh Tables list menu item to Table Browser dialogue

New in Advanced ETL Processor Standard 3.9.8.15 (Nov 30, 2023)

  • Fixed: Minour interface issues

New in Advanced ETL Processor Standard 3.9.8.14 (Nov 28, 2023)

  • Improved: Lookup transformations error handling

New in Advanced ETL Processor Standard 3.9.8.1213 (Nov 17, 2023)

  • Added: Support for python 3.11 and 3.12.

New in Advanced ETL Processor Standard 3.9.8.12 (Nov 3, 2023)

  • Updated: Excel engine

New in Advanced ETL Processor Standard 3.9.8.11 (Nov 1, 2023)

  • Added: Ignore nulls and keep original values option to Excel Writer

New in Advanced ETL Processor Standard 3.9.8.10 (Oct 25, 2023)

  • Improved: Calculation engine update

New in Advanced ETL Processor Standard 3.9.8.8 (Sep 25, 2023)

  • Added: Incremental search to Expression editor dialogue

New in Advanced ETL Processor Standard 3.9.8.7 (Sep 13, 2023)

  • Fixed: Issues with inserting default values within the data grid. (MySQL, Postgress, Interbase/Firebird and SQLite)

New in Advanced ETL Processor Standard 3.9.8.6 (Sep 11, 2023)

  • Fixed: Issues with inserting default values within the data grid. (MySQL, Postgress, Interbase/Firebird and SQLite)

New in Advanced ETL Processor Standard 3.9.8.5 (Jul 25, 2023)

  • Disabled: ODATA Connection as no longer necessary

New in Advanced ETL Processor Standard 3.9.8.4 (May 16, 2023)

  • Improved: Updated documentation link

New in Advanced ETL Processor Standard 3.9.8.3 (Mar 4, 2023)

  • Improved: Increased Data writer fields' dedifintions widths

New in Advanced ETL Processor Standard 3.9.8.2 (Feb 8, 2023)

  • Fixed: Field is not mapped issue

New in Advanced ETL Processor Standard 3.9.8.1 (Jan 15, 2023)

  • Added: Support for SSH Connections to MySQL,Postgres and MongoDDB
  • Improved: Data writer error handling

New in Advanced ETL Processor Standard 3.9.8.0 (Jan 4, 2023)

  • Added: Support for SSH Connections to MySQL,Postgres and MongoDDB

New in Advanced ETL Processor Standard 3.9.7.39 (Dec 9, 2022)

  • Added: Rest Writer

New in Advanced ETL Processor Standard 3.9.7.38 (Nov 24, 2022)

  • Fixed: Office 35 Email Writer AV.

New in Advanced ETL Processor Standard 3.9.7.37 (Nov 21, 2022)

  • Fixed: UID was missing from Office 35 Email Reader

New in Advanced ETL Processor Standard 3.9.7.36 (Nov 20, 2022)

  • Added: Office 35 Email Writer

New in Advanced ETL Processor Standard 3.9.7.34 (Aug 26, 2022)

  • Renamed: "Split RegX" to Split RegX Static
  • Added: Split RegX Dynamic transformation function

New in Advanced ETL Processor Standard 3.9.7.33 (Jul 12, 2022)

  • Fixed:
  • Issue with Replace RegX transformation function

New in Advanced ETL Processor Standard 3.9.7.32 (Jun 28, 2022)

  • Fixed: Viewing Views Issues while browsing the data
  • Improved: Loading data into smalldatetime fields

New in Advanced ETL Processor Standard 3.9.7.31 (Jun 28, 2022)

  • Fixed: AV when adding new field to Joiner properties dialogue

New in Advanced ETL Processor Standard 3.9.7.30 (May 18, 2022)

  • Fixed: Databuffer double procession bug.

New in Advanced ETL Processor Standard 3.9.7.28 (Feb 15, 2022)

  • Added: Support for dynamic field names (delimited files only)
  • Added: Support for RabbitMQ to data writer and reader

New in Advanced ETL Processor Standard 3.9.7.27 (Feb 3, 2022)

  • Fixed: Is value In Database transformation function bug

New in Advanced ETL Processor Standard 3.9.7.26 (Jan 13, 2022)

  • Improved: Look and feel on high definition monitors
  • Added: New themes Office 2016 White, Office 2016 Gray and Office 2016 Black
  • Improved: default theme is set to Office 2016 White

New in Advanced ETL Processor Standard 3.9.7.24 (Dec 17, 2021)

  • Improved: Note's custom colours are persisted across user sessions

New in Advanced ETL Processor Standard 3.9.7.22 (Jul 23, 2021)

  • Improved: XML Reading performance

New in Advanced ETL Processor Standard 3.9.7.21 (Jul 16, 2021)

  • Fixed: Issues with closing ODBC connection when refreshing target fields list

New in Advanced ETL Processor Standard 3.9.7.19 (Jun 22, 2021)

  • Fixed: Windows log message format

New in Advanced ETL Processor Standard 3.9.7.18 (Jun 11, 2021)

  • Mproved: Split RegX transformation function

New in Advanced ETL Processor Standard 3.9.7.17 (Jun 3, 2021)

  • Fixed: Issues with lookup error handling

New in Advanced ETL Processor Standard 3.9.7.16 (Apr 11, 2021)

  • Improved:
  • Various cosmetic changes
  • Changed table search from case sensitive to not case sensitive
  • Working with HTML tables
  • Fixed:
  • Undo/Redo issues while working with source/target grid

New in Advanced ETL Processor Standard 3.9.7.15 (Apr 4, 2021)

  • Fixed:
  • Access violations when reading excel files
  • Licensing issues when running the software on AWS servers.

New in Advanced ETL Processor Standard 3.9.7.14 (Mar 22, 2021)

  • Improved: Tableau hyper error handling
  • Fixed: Minor mapping designer bug fixes and improvements

New in Advanced ETL Processor Standard 3.9.7.13 (Mar 5, 2021)

  • Added: Extract Attachments option to IMAP4 and POP3 reader

New in Advanced ETL Processor Standard 3.9.7.12 (Feb 27, 2021)

  • Improved: It is now possible to use a single transformation to write data into multiple excel sheets of the same file

New in Advanced ETL Processor Standard 3.9.7.10 (Feb 4, 2021)

  • Added: HTML Table reader
  • Added: Recalculate Excel File check box to excel writer
  • Fixed: Field selector access vialation
  • Improved: Field selector performance
  • Updated: Digital signature

New in Advanced ETL Processor Standard 3.9.7.9 (Dec 22, 2020)

  • Fixed: Loading data from FoxPro

New in Advanced ETL Processor Standard 3.9.7.8 (Dec 19, 2020)

  • Added: GetSystemDate function returns the fractions of a second now
  • Added: IMAP4 writer can move messages to a different folder now
  • Fixed: Licence management issues

New in Advanced ETL Processor Standard 3.9.7.7 (Dec 1, 2020)

  • Added: To, ReplyTo, Cc and Bcc fields to POP3 and IMAP4 readers

New in Advanced ETL Processor Standard 3.9.7.6 (Nov 23, 2020)

  • Fixed: Issues with special characters inside sql server database names

New in Advanced ETL Processor Standard 3.9.7.5 (Nov 22, 2020)

  • Added: Replace String Wizard
  • Improved: Setup look and feel
  • Fixed: Issues with special characters inside field names

New in Advanced ETL Processor Standard 3.9.7.3 (Nov 1, 2020)

  • Added: Support Excel formulas creation

New in Advanced ETL Processor Standard 3.9.7.1 (Oct 2, 2020)

  • Added: Owner field to file system reader
  • Added: FileOwner scripting language function

New in Advanced ETL Processor Standard 3.9.7.0 (Sep 26, 2020)

  • Added: Variables: ,,,,,,

New in Advanced ETL Processor Standard 3.9.6.28 (Jul 28, 2020)

  • Added: Variables

New in Advanced ETL Processor Standard 3.9.6.26 (Jul 5, 2020)

  • Improved: Support for DATETIME2 Fields

New in Advanced ETL Processor Standard 3.9.6.24 (Jun 11, 2020)

  • Improved: Support for DATETIME2 Fields

New in Advanced ETL Processor Standard 3.9.6.23 (May 18, 2020)

  • Improved: Software registration process
  • Fixed: Issues with Australian Post Code validation

New in Advanced ETL Processor Standard 3.9.6.22 (May 18, 2020)

  • Improved: JSON Data Handling

New in Advanced ETL Processor Standard 3.9.6.21 (Apr 10, 2020)

  • Added: Support for SQL Server 2017
  • Fixed: Issues with loading data into varchar(max) field
  • Improved: SQL Server error handling

New in Advanced ETL Processor Standard 3.9.6.20 (Feb 14, 2020)

  • Added: colors to notes
  • Fixed: issues with aborting joiner tranformation on error

New in Advanced ETL Processor Standard 3.9.6.19 (Feb 14, 2020)

  • Added: Support for PostgreSql 12

New in Advanced ETL Processor Standard 3.9.6.18 (Jan 30, 2020)

  • Added: IMAP4 as data writer connection
  • Fixed: IMAP4 reader shows UID correctly now
  • Fixed: Fixed issue with loosing transformations while closing transformation tab

New in Advanced ETL Processor Standard 3.9.6.17 (Jan 30, 2020)

  • Fixed: SplitRegX transformation function bug
  • Fixed: Lookup transformation function bug
  • Added: Checks for source and target structure changes

New in Advanced ETL Processor Standard 3.9.6.16 (Jan 30, 2020)

  • Added: Select Objects with no links menu option
  • Added: Select Inputs menu option
  • Added: Select Outputs menu option
  • Added: Select Linked Objects menu option

New in Advanced ETL Processor Standard 3.9.6.15 (Jan 30, 2020)

  • Added: Ability to pull license from the license server
  • Fixed: Last record flag issue for files with two lines

New in Advanced ETL Processor Standard 3.9.6.14 (Aug 19, 2019)

  • Added: Case sensitive option to Lookup transformation object

New in Advanced ETL Processor Standard 3.9.6.12 (Aug 19, 2019)

  • Fixed: Issues with joining empty files

New in Advanced ETL Processor Standard 3.9.6.11 (Aug 19, 2019)

  • Improved: Various bug fixes and improvements
  • Improved: Salesforce connection uses TLS 1.2 now
  • Fixed: Excel data reading problems
  • Improved: Third party components update:
  • Excel processing libraries

New in Advanced ETL Processor Standard 3.9.6.10 (Aug 19, 2019)

  • Fixed: Decode JSON Object and Decode JSON Array error handling issues

New in Advanced ETL Processor Standard 3.9.6.9 (Aug 19, 2019)

  • Added: Syslog datasource

New in Advanced ETL Processor Standard 3.9.6.8 (Aug 19, 2019)

  • Fixed: JSON Data reader AV

New in Advanced ETL Processor Standard 3.9.6.7 (Aug 19, 2019)

  • Improved: Software Installation Process
  • Improved: Thrird Party Components Update
  • Fixed: Minor Python Integration Issues

New in Advanced ETL Processor Standard 3.9.6.6 (Aug 19, 2019)

  • Improved: Extracts data from OLE Db up to 4 times faster
  • Improved: Extracts data from SQLite up to 2 times faster
  • Improved: The application starts much faster
  • Fixed: Issues with reading google spreadsheet data
  • Software registration changes:
  • Starting from this release users would need to enter license key and control number to register the software.

New in Advanced ETL Processor Standard 3.9.6.5 (Jan 23, 2019)

  • Added: Support for calculations inside source reader source file
  • Fixed: Copy/Paste issues with SQL Lookup transformation

New in Advanced ETL Processor Standard 3.9.6.4 (Jan 4, 2019)

  • Added: New datasource - Twitter
  • Improved: Loads data into SQL server up to 25 percent faster
  • Improved: Generating Tableau hyper files up to 25 percent faster
  • Improved: Generating Tableau tde files up to 30 percent faster
  • Improved: Active Directory Connection look and feel

New in Advanced ETL Processor Standard 3.9.6.3 (Nov 22, 2018)

  • Improved: Slight performance improvement

New in Advanced ETL Processor Standard 3.9.6.2 (Oct 3, 2018)

  • Fixed:
  • Log tab issues

New in Advanced ETL Processor Standard 3.9.6.0 (Aug 21, 2018)

  • Added: Loading data into Google Spreadsheets
  • Improved: Third party components update

New in Advanced ETL Processor Standard 3.9.5.15 (Aug 13, 2018)

  • Fixed: Issues with loading data into Varchar(MAX) fields (SQL Server)
  • Improved: transformer fields metadata

New in Advanced ETL Processor Standard 3.9.5.14 (Jul 27, 2018)

  • Added: Added Get Excel Cell Value Dynamic transformation function
  • Improved: Object selection visibility

New in Advanced ETL Processor Standard 3.9.5.13 (Jul 23, 2018)

  • Improved: Third party components update

New in Advanced ETL Processor Standard 3.9.5.12 (Jul 17, 2018)

  • Improved: loading data into sql server is up to 10 percent faster
  • Fixed: Addressed issues with loading data into XML,Image and Identity fields (SQL Server)

New in Advanced ETL Processor Standard 3.9.5.11 (Jul 14, 2018)

  • Improved: Up to two times faster loading data into sql server
  • Added: Support for TLS 1.2 SQL Server connections

New in Advanced ETL Processor Standard 3.9.5.10 (Jul 12, 2018)

  • Improved: Made Calculation dialogue box resizable`
  • Fixed: Issues with exporting data into csv and tab files from grids

New in Advanced ETL Processor Standard 3.9.5.9 (Jul 7, 2018)

  • Added: GetWindowsTemporaryDirectory,GetTemporaryFile,GetTemporaryFileInDirectory,GetTemporaryDirectory transformation language functions
  • Added: Get File Content Dynamic transformation function
  • Improved: Third party components update
  • Improved: Pivot and unpivot performance

New in Advanced ETL Processor Standard 3.9.5.8 (Jul 7, 2018)

  • Fixed: Loading Data Into Time Fields

New in Advanced ETL Processor Standard 3.9.5.7 (Jul 3, 2018)

  • Added: Data Buffer Transformation Function
  • Improved: Transformation Error Handling

New in Advanced ETL Processor Standard 3.9.5.5 (Jun 23, 2018)

  • Improved: Google Spreadsheet import
  • Improved: SQL Lookup transformation dialogue
  • Fixed: Salesforce Bulk API load issues
  • Fixed: SQL Lookup transformation issues

New in Advanced ETL Processor Standard 3.9.5.4 (Jun 21, 2018)

  • Improved: Google Spreadsheet import
  • Improved: SQL Lookup transformation dialogue
  • Fixed: Salesforce Bulk API load issues
  • Fixed: SQL Lookup transformation issues

New in Advanced ETL Processor Standard 3.9.5.3 (Jun 15, 2018)

  • Fixed: Round Transformation Function issues
  • Fixed: Issues with exporting very large grids into excel files

New in Advanced ETL Processor Standard 3.9.5.2 (Jun 7, 2018)

  • Fixed: Python Scripting issues

New in Advanced ETL Processor Standard 3.9.5.1 (May 25, 2018)

  • Fixed: Salesforce Bulk API load issues

New in Advanced ETL Processor Standard 3.9.5.0 (May 10, 2018)

  • Added: Support fot Hyper Tableau files (64 bit version)
  • Improved: Third party components update

New in Advanced ETL Processor Standard 3.9.4.3 (Feb 25, 2018)

  • Fixed : Loading data into Google spreadsheet
  • Added: Ansi Driver checkbox to odbc connections

New in Advanced ETL Processor Standard 3.9.4.2 (Nov 29, 2017)

  • Added: Support For MongoDB

New in Advanced ETL Processor Standard 3.9.4.1 (Oct 23, 2017)

  • Improved: Look and feel of Pivot object on win2008 server
  • Improved: Look and feel of UnPivot object on win2008 server
  • Improved: Third party components update (Data Grid)
  • Improved: Empty Data Grids show message
  • Improved: Execution log within Package editor looks the same way as execution log (Tree)

New in Advanced ETL Processor Standard 3.9.4.0 (Oct 2, 2017)

  • Improved: Third party components update (Excel)
  • Improved: Changed logic fro processing excel files: if software is unable to open file transformation aborted
  • Added: Check file to Excel Operation Action

New in Advanced ETL Processor Standard 3.9.3.28 (Sep 1, 2017)

  • Fixed : Issues with JSON transformations

New in Advanced ETL Processor Standard 3.9.3.26 (Aug 28, 2017)

  • Fixed: Fixed AV's

New in Advanced ETL Processor Standard 3.9.3.25 (Jul 31, 2017)

  • Fixed: Issues with reading brightpearl data

New in Advanced ETL Processor Standard 3.9.3.24 (Jul 19, 2017)

  • Fixed: Issues with assigning default values to lookup

New in Advanced ETL Processor Standard 3.9.3.23 (Jul 15, 2017)

  • Improved: Functionality of Running totals transformation function

New in Advanced ETL Processor Standard 3.9.3.22 (Jun 19, 2017)

  • Improved: Open SSL libraries update
  • Improved: Up to 30 percent faster

New in Advanced ETL Processor Standard 3.9.3.21 (Jun 16, 2017)

  • Added : Support for SFTP Private Keys
  • Fixed : Issues with QVX Files reading

New in Advanced ETL Processor Standard 3.9.3.20 (May 17, 2017)

  • Fixed: Issues with loading version info

New in Advanced ETL Processor Standard 3.9.3.18 (May 12, 2017)

  • Fixed : Fixed QVD reading issues

New in Advanced ETL Processor Standard 3.9.3.17 (Mar 30, 2017)

  • Improved: Setup has an option to download Tableau client now
  • Added : SQL Lookup Transformation Function
  • Fixed : Scrolling issues
  • Fixed : Change date dynamic bug

New in Advanced ETL Processor Standard 3.9.3.15 (Mar 13, 2017)

  • Improved: Setup procedure

New in Advanced ETL Processor Standard 3.9.3.13 (Mar 5, 2017)

  • Improved: Maximum ODBC Connection String is 4K now
  • Fixed : One Row QVD creation bug

New in Advanced ETL Processor Standard 3.9.3.10 (Jan 26, 2017)

  • Improved: Look and feel of object joins

New in Advanced ETL Processor Standard 3.9.3.9 (Jan 16, 2017)

  • Improved: Updated Salesforce API to v38

New in Advanced ETL Processor Standard 3.9.3.8 (Jan 16, 2017)

  • Improved: Query Builder components update
  • Improved: SSL components update

New in Advanced ETL Processor Standard 3.9.3.7 (Dec 13, 2016)

  • Added : FTP Files list as datasource
  • Fixed : Issues with updating data via table browser

New in Advanced ETL Processor Standard 3.9.3.6 (Dec 5, 2016)

  • Added : Added displayName, distinguisedName, initials, mailNickname, publicDelegates, sAMAccountType, scriptPath, showInAddressBook, sn, pager, extensionAttribute1-extensionAttribute15 fields to ActiveDirectory extract
  • Improved : Third party componets update
  • Improved : Table generation

New in Advanced ETL Processor Standard 3.9.3.5 (Nov 24, 2016)

  • Fixed : Issues with reading data from SalesForce

New in Advanced ETL Processor Standard 3.9.3.3 (Nov 24, 2016)

  • Added : Option to disable record count
  • Improved : Once deleted packages are disabled in the scheduler
  • Fixed : Fixed issues with reading XML files

New in Advanced ETL Processor Standard 3.9.3.2 (Nov 13, 2016)

  • Improved: Up to 10 percent performance increase while loading data into date/time fields

New in Advanced ETL Processor Standard 3.9.3.1 (Oct 14, 2016)

  • Improved: Support for JSON as data source

New in Advanced ETL Processor Standard 3.9.3.0 (Oct 10, 2016)

  • Added: Support for JSON as data source and target
  • Improved : Lookup transformation supports JSON as datas source now

New in Advanced ETL Processor Standard 3.9.2.9 (Aug 22, 2016)

  • Fixed : BDE Datasource issues
  • Improved : MySQL Error handling

New in Advanced ETL Processor Standard 3.9.2.8 (Aug 15, 2016)

  • Fixed : Problems with reading delimited text files when delimiter is more than one character log

New in Advanced ETL Processor Standard 3.9.2.7 (Aug 3, 2016)

  • Fixed : Problems with clone row transformation object

New in Advanced ETL Processor Standard 3.9.2.6 (Aug 3, 2016)

  • Fixed : Problems with reading data from Salesforce

New in Advanced ETL Processor Standard 3.9.2.5 (Jul 25, 2016)

  • Fixed : Problems with refreshing list of Oracle Tables

New in Advanced ETL Processor Standard 3.9.2.4 (Jul 21, 2016)

  • Fixed : Problems with AM/PM Date conversion

New in Advanced ETL Processor Standard 3.9.2.3 (Jul 4, 2016)

  • Improved : JDBC Processing

New in Advanced ETL Processor Standard 3.9.2.2 (Jul 4, 2016)

  • Improved : JDBC Errors Handling

New in Advanced ETL Processor Standard 3.9.2.1 (Jun 7, 2016)

  • Fixed : Problems with reading data from unicode files

New in Advanced ETL Processor Standard 3.9.2.0 (May 29, 2016)

  • Third party compoments update
  • Support for the new functions introduced in the Excel 2016 January Update
  • Improved compatibility with thid party xlsx files
  • Improved compatibility with invalid xls and xlsx files
  • Improved : Excel 2010 equations are now preserved in xlsx
  • Improved : Log and rejected records files are no longer using executable location
  • Improved : Log screen refresh logic
  • New : Support SSL v2, v3, v1_1 and v1_2 was introduced
  • New : Support for opening xls versions from 2 to 4
  • Fixed order of records specific for Excel 2010 to workaround a bug in Excel 2010.
  • Some very complex files could raise an error when opened in Excel 2010, even when they were correct by the xlsx spec.
  • Fixed : Xlsx files with 0 bytes xml files inside could throw an "Invalid XML file" error.
  • Fixed : Data validations entered manually in xls files could fail to work when opened in Excel

New in Advanced ETL Processor Standard 3.9.1.4 (Apr 20, 2016)

  • Address issues with Change Date Static,Change Date Dynamic and If WeekDay functions
  • Addressed Salesforce data update issues

New in Advanced ETL Processor Standard 3.9.1.3 (Apr 20, 2016)

  • Addressed Salesforce data update issues

New in Advanced ETL Processor Standard 3.9.1.2 (Apr 12, 2016)

  • Improved support for RSS feeds

New in Advanced ETL Processor Standard 3.9.1.0 (Mar 29, 2016)

  • Calculation transformation funtion support Python now

New in Advanced ETL Processor Standard 3.9.0.15 (Mar 28, 2016)

  • Addressed issues with Running Total transformation

New in Advanced ETL Processor Standard 3.9.0.14 (Mar 23, 2016)

  • Support for latest tableau api was introduced
  • Log Object bugs fixes

New in Advanced ETL Processor Standard 3.9.0.13 (Mar 16, 2016)

  • Added Write to File transformation function

New in Advanced ETL Processor Standard 3.9.0.12 (Mar 14, 2016)

  • Minor transformation designer improvements

New in Advanced ETL Processor Standard 3.9.0.11 (Mar 8, 2016)

  • Date fields processing bugs fixes

New in Advanced ETL Processor Standard 3.9.0.10 (Mar 8, 2016)

  • Joiner Object bugs fixes

New in Advanced ETL Processor Standard 3.9.0.8 (Mar 8, 2016)

  • SalesForce data processing fixes

New in Advanced ETL Processor Standard 3.9.0.7 (Mar 8, 2016)

  • Addressed DTD is prohibited issues

New in Advanced ETL Processor Standard 3.9.0.6 (Feb 6, 2016)

  • Added End of line customisation for text data target

New in Advanced ETL Processor Standard 3.9.0.5 (Feb 6, 2016)

  • Improved support for very large QVD files

New in Advanced ETL Processor Standard 3.9.0.4 (Feb 6, 2016)

  • Addressed Date validation and conversion problems

New in Advanced ETL Processor Standard 3.9.0.3 (Feb 6, 2016)

  • SSL Libraries update
  • Third party components update
  • SalesForce connection uses TLS 1.1 now

New in Advanced ETL Processor Standard 3.9.0.1 (Jan 14, 2016)

  • Addressed issues with print preview screen
  • Addressed issues flicking

New in Advanced ETL Processor Standard 3.9.0.0 (Jan 9, 2016)

  • 64 bit version initial release
  • Added MRU List to data entry grid

New in Advanced ETL Processor Standard 3.8.2.12 (Dec 7, 2015)

  • Addressed issues with getting stored procedures parameters

New in Advanced ETL Processor Standard 3.8.2.11 (Nov 30, 2015)

  • Add refresh databases button to source and target connections
  • Added support for Unicode in server, database and table names
  • ODBC error messages support Unicode now
  • Added processor info to application title
  • Expanded red box size in the status bar
  • Addressed issues with loading data from JDBC data sources
  • Addressed issues with loading data from Windows Event Log
  • Fixed issues with syntax highlighting in Mapping editor

New in Advanced ETL Processor Standard 3.8.2.10 (Nov 14, 2015)

  • Addressed issues with creating Excel files

New in Advanced ETL Processor Standard 3.8.2.8 (Nov 5, 2015)

  • Added ability to extract 'List of groups the user(s) belongs to' from Active Directory
  • Added ability to extract 'List of group(s) members' from Active Directory

New in Advanced ETL Processor Standard 3.8.2.7 (Oct 19, 2015)

  • Faster QVD files processing

New in Advanced ETL Processor Standard 3.8.2.6 (Oct 6, 2015)

  • Addressed issues with clone row object

New in Advanced ETL Processor Standard 3.8.2.5 (Oct 3, 2015)

  • Better support for QVD's Timestamp and Date fields
  • Addressed issues with union and sorter objects

New in Advanced ETL Processor Standard 3.8.2.4 (Oct 3, 2015)

  • Addressed issues with subtransformation function

New in Advanced ETL Processor Standard 3.8.2.3 (Sep 22, 2015)

  • Added Ignore Data Format option to Excel Data reader
  • Addressed issues with split function

New in Advanced ETL Processor Standard 3.8.2.2 (Sep 16, 2015)

  • Added Lookup Replace Transformation function
  • Addressed issues with Running Totals functions
  • Addressed issues with joining empty files

New in Advanced ETL Processor Standard 3.8.2.0 (Sep 16, 2015)

  • Added support for Active Directory as data source
  • Addressed issues with filtering data
  • Addressed issues with exporting data into excel files

New in Advanced ETL Processor Standard 3.8.1.11 (Sep 5, 2015)

  • Addressed issues with loading empty date fields into MySQL
  • Addressed issues with Split Transformation Function

New in Advanced ETL Processor Standard 3.8.1.7 (Aug 28, 2015)

  • Added Field Value transformation function

New in Advanced ETL Processor Standard 3.8.1.5 (Aug 26, 2015)

  • Added Read File Content Option to Reader
  • Added UTC To Local Date and Local Date to UTC script functions
  • Added UTC To Local Date and Local Date to UTC transformation functions
  • Addressed issues with File Creation Dates

New in Advanced ETL Processor Standard 3.8.1.3 (Aug 21, 2015)

  • Added Save button to Transformer and Validator
  • Added FileLine transformation function
  • Addressed issues with Slemma Import

New in Advanced ETL Processor Standard 3.8.1.2 (Aug 11, 2015)

  • Added support for Clarion dat files

New in Advanced ETL Processor Standard 3.8.1.1 (Aug 11, 2015)

  • Addressed issues with sorter

New in Advanced ETL Processor Standard 3.8.1.0 (Jul 20, 2015)

  • Added support for Slemma

New in Advanced ETL Processor Standard 3.8.0.41 (Jul 13, 2015)

  • Excel Import and export from data grids is much faster now
  • Added Encode JSON Object and Decode JSON Object transformation functions
  • Added Encode JSON Array and Decode JSON Array transformation functions
  • Added Encode JSON Pair and Decode JSON Pair transformation functions
  • Addressed issues with exporting data as excel from data grids
  • Addressed issues with deleting records

New in Advanced ETL Processor Standard 3.8.0.40 (Jun 29, 2015)

  • Added Encode JSON String and Decode JSON String
  • Addressed issues with deduplicator

New in Advanced ETL Processor Standard 3.8.0.39 (Jun 23, 2015)

  • Added trim option to format field names dialogue
  • Updated set fields' names functionality

New in Advanced ETL Processor Standard 3.8.0.38 (Jun 23, 2015)

  • Extended Date Diff functionality

New in Advanced ETL Processor Standard 3.8.0.37 (Jun 15, 2015)

  • Google spreadsheet API update
  • Support for Salesforce Bulk API was introduced
  • Added MONTH_EXACT to DateDiffS function

New in Advanced ETL Processor Standard 3.8.0.35 (Jun 4, 2015)

  • IMAP4 and POP3 fixes
  • Various bugs fixes and improvements

New in Advanced ETL Processor Standard 3.8.0.34 (Jun 4, 2015)

  • Support for salesforce BULK API was introduced

New in Advanced ETL Processor Standard 3.8.0.33 (May 27, 2015)

  • Addressed issues with loading null values into salesforce

New in Advanced ETL Processor Standard 3.8.0.32 (May 26, 2015)

  • Addressed issues with loading data from SQL Server CE

New in Advanced ETL Processor Standard 3.8.0.31 (May 19, 2015)

  • Addressed issues with loading data from delimited files

New in Advanced ETL Processor Standard 3.8.0.30 (May 18, 2015)

  • Addressed issues with groupper transformation
  • Various bugs fixes and improvements

New in Advanced ETL Processor Standard 3.8.0.28 (May 8, 2015)

  • Documentation update
  • Added GetExcelCellValue calculation function
  • Sorter improvements

New in Advanced ETL Processor Standard 3.8.0.27 (Apr 30, 2015)

  • Improved performance of Join Transformation.
  • Addressed issues with memory management

New in Advanced ETL Processor Standard 3.8.0.26 (Apr 30, 2015)

  • Addressed issues with Is Number validation function

New in Advanced ETL Processor Standard 3.8.0.25 (Apr 17, 2015)

  • Added ability to swap reader and writer
  • Added support for 255 length fields names in Union All object

New in Advanced ETL Processor Standard 3.8.0.24 (Apr 17, 2015)

  • GetExcelCellValue function provides more detailed information about errors now
  • Addressed issues with retrieving information about Primary keys
  • Addressed issues with parallel sorting

New in Advanced ETL Processor Standard 3.8.0.22 (Apr 14, 2015)

  • Added ability to delete and insert items in the middle of Split, Join and calculation object

New in Advanced ETL Processor Standard 3.8.0.21 (Apr 10, 2015)

  • Addressed issues with date formats

New in Advanced ETL Processor Standard 3.8.0.19 (Apr 8, 2015)

  • Addressed issues with processing of delimited files

New in Advanced ETL Processor Standard 3.8.0.18 (Apr 1, 2015)

  • Up to 6 times faster data deduplication
  • Up to 2 times faster data groupping
  • Groupper is using less memory
  • Up to 2 times faster data extraction from Sql Server
  • Up to 2 times faster data extraction from ODBC sources
  • Up to 2 times faster loading data into SQL Server
  • Up to 2 times faster loading data into ODBC
  • Various bugs fixes and improvements

New in Advanced ETL Processor Standard 3.8.0.17 (Mar 25, 2015)

  • Up to 2 times faster data extraction from Sql Server
  • Up to 2 times faster data extraction from ODBC sources
  • Up to 40 percent faster loading data into SQL Server
  • Up to 40 percent faster loading data into ODBC
  • Up to 10 percent faster QVX files creation
  • Up to 10 percent faster loading data into PostgreSQL
  • Various bugs fixes and improvements

New in Advanced ETL Processor Standard 3.8.0.16 (Mar 18, 2015)

  • Up to 9 times faster QVD files creation
  • Up to 3 times faster reading data from QVD files
  • Up to 2 times faster data sorting
  • Up to 15 percent faster QVX files creation
  • Added thousands separator to transformation objects
  • Various bugs fixes and improvements

New in Advanced ETL Processor Standard 3.8.0.14 (Mar 18, 2015)

  • Addressed problems with reading googlespreasheet data
  • Addressed Transformer AV's

New in Advanced ETL Processor Standard 3.8.0.13 (Mar 9, 2015)

  • Up to 30 percent faster text file processing
  • Up to 10 percent faster QVD generation
  • Up to 10 percent faster QVX generation
  • Up to 5 percent faster Excel Files generation
  • Up to 20 percent faster XML generation
  • Udapded demos
  • Addressed issues with Joiner object
  • Various bug fixes and improvements

New in Advanced ETL Processor Standard 3.8.0.12 (Mar 5, 2015)

  • Up to 10 percent faster text file processing
  • Addressed issues with processing end of line characters inside delimited files

New in Advanced ETL Processor Standard 3.8.0.11 (Mar 4, 2015)

  • Up to 7 times faster data sorting
  • Addressed issues with salesforce data processing
  • Fixed problems with data preview
  • Various bug fixes and improvements

New in Advanced ETL Processor Standard 3.8.0.10 (Feb 28, 2015)

  • Addressed issues with creating rejected records file

New in Advanced ETL Processor Standard 3.8.0.9 (Feb 28, 2015)

  • Addressed issues with running ODBC Manager from application

New in Advanced ETL Processor Standard 3.8.0.7 (Feb 25, 2015)

  • SSL libraries update
  • Various bug fixes and improvements

New in Advanced ETL Processor Standard 3.8.0.4 (Feb 11, 2015)

  • Support for MS SQL server 2014 was extended
  • Working with text files - is more than 2 times faster
  • Creating QVD files -
  • Creating QVX files - up to 30 percent faster
  • Creating Excel files - up to 20 percent faster
  • Loading data into SQL server - up to 10 percent faster
  • Loading data into Oracle - up to 10 percent faster
  • Loading data into PostgreSQL - up to 10 percent faster
  • Various bug fixes and improvements

New in Advanced ETL Processor Standard 3.8.0.3 (Feb 4, 2015)

  • Addressed issues with sequence transformation object
  • Addressed issues with subtransformation object
  • Addressed issues with sending SMS messages

New in Advanced ETL Processor Standard 3.8.0.2 (Feb 2, 2015)

  • Addressed issues with theme management
  • Loads recent history of changes by default now

New in Advanced ETL Processor Standard 3.8.0.1 (Jan 30, 2015)

  • Addressed issues with metadata object
  • Added Vertical Grid
  • Third party components update

New in Advanced ETL Processor Standard 3.8.0.0 (Jan 23, 2015)

  • Support for multiple readers
  • Joiner Renamed to Join
  • Splitter Renamed to Split
  • Joiner Object was introduced
  • Skip empty fields option was introduced to Join object
  • Incremental object search was added to package designer
  • Minor interface improvements
  • Writer and Reader description are mandatory now
  • New option to Include reader name into Rejected records file
  • Documentation update
  • Addressed issue with sending SMS messages

New in Advanced ETL Processor Standard 3.7.9.8 (Dec 11, 2014)

  • addressed issues with GetExcelCelValue transformation function

New in Advanced ETL Processor Standard 3.7.9.7 (Dec 10, 2014)

  • Setup and executable are digitally signed now
  • Minor bugs fixes

New in Advanced ETL Processor Standard 3.7.9.6 (Dec 10, 2014)

  • Added Reset height option

New in Advanced ETL Processor Standard 3.7.9.5 (Dec 10, 2014)

  • Up to 10 percent faster
  • License Update
  • Documentation Update

New in Advanced ETL Processor Standard 3.7.9.4 (Dec 10, 2014)

  • Addressed issues with XML encoding

New in Advanced ETL Processor Standard 3.7.9.3 (Nov 28, 2014)

  • Addressed some validator issues

New in Advanced ETL Processor Standard 3.7.9.1 (Nov 24, 2014)

  • Third party components update
  • Incremental search was added to all grids
  • Export to RTF was introduced
  • Excel export formats improvements
  • Various Interface improvements
  • Documentation update
  • Minor bugs fixes
  • Spelling corrections

New in Advanced ETL Processor Standard 3.7.9.0 (Nov 18, 2014)

  • Added support for tableau tde files

New in Advanced ETL Processor Standard 3.7.8.17 (Nov 10, 2014)

  • Added option to generate table creation script to the transformer source grid
  • Log redirect object improvements
  • Various bugs fixes

New in Advanced ETL Processor Standard 3.7.8.16 (Oct 30, 2014)

  • Addressed Splitter dialogue issues

New in Advanced ETL Processor Standard 3.7.8.15 (Oct 29, 2014)

  • Added new transformation field values

New in Advanced ETL Processor Standard 3.7.8.14 (Oct 23, 2014)

  • Added two new fields to File Sytem datasource last modification date and last access date

New in Advanced ETL Processor Standard 3.7.8.12 (Oct 8, 2014)

  • Added Is Null or Empty string validation function
  • Added If Null or Empty string transformation function
  • Documentation Update
  • Mapping editor bug fixes

New in Advanced ETL Processor Standard 3.7.8.10 (Sep 24, 2014)

  • Addressed CASE transformation issues

New in Advanced ETL Processor Standard 3.7.8.6 (Sep 16, 2014)

  • Added Support for Message Queuing (MSMQ)
  • Documentation Update
  • Better Data Reader Memory Management

New in Advanced ETL Processor Standard 3.7.8.5 (Sep 5, 2014)

  • Addressed issues with BIGINT fields

New in Advanced ETL Processor Standard 3.7.8.3 (Aug 19, 2014)

  • Addressed issues with Get Excel Cell Value transformation function
  • Addressed issues with copy paste functionality

New in Advanced ETL Processor Standard 3.7.8.2 (Aug 14, 2014)

  • Date Format bugs fixes

New in Advanced ETL Processor Standard 3.7.8.1 (Aug 13, 2014)

  • Further improvements to Sending SMS functionality
  • Addressed problem with keep characters functions

New in Advanced ETL Processor Standard 3.7.8.0 (Aug 13, 2014)

  • Support for Sending SMS messages was introduced
  • Documentation Update

New in Advanced ETL Processor Standard 3.7.7.12 (Aug 5, 2014)

  • Added URL shortener transformation function
  • Added URL Location transformation function
  • Added IP Location transformation function
  • Added Accumulate Strings transformation function
  • Extended Metadata transformation function functionality
  • Documentation Update

New in Advanced ETL Processor Standard 3.7.7.11 (Aug 1, 2014)

  • Interface improvements
  • Addressed issues with CASE transformation function

New in Advanced ETL Processor Standard 3.7.7.10 (Jul 28, 2014)

  • Added CASE transformation function
  • Added Delete Leading Characters
  • Added Delete Trailing Characters
  • Added support for special characters
  • Interface improvements

New in Advanced ETL Processor Standard 3.7.7.9 (Jul 22, 2014)

  • Ability to move objects between different tabs was introduced
  • Subtransformation bugs fixes

New in Advanced ETL Processor Standard 3.7.7.8 (Jul 22, 2014)

  • Introduced support for salesforce QueryAll interface
  • Documentation Update
  • Addressed problems with batch import via ODBC

New in Advanced ETL Processor Standard 3.7.7.7 (Jul 15, 2014)

  • Excel processing engine update

New in Advanced ETL Processor Standard 3.7.7.6 (Jul 11, 2014)

  • Extended functionality of Get Excel Cell Value and Get File Context functions
  • Addressed issues with Undo Redo buttons
  • Addressed excel' files locking problems

New in Advanced ETL Processor Standard 3.7.7.4 (Jul 3, 2014)

  • Added two new transformation functions Get Excel Cell Value and Get File Context
  • Documentation Update

New in Advanced ETL Processor Standard 3.7.7.3 (Jun 28, 2014)

  • Support for latest version of Google spreadsheets was introduced
  • Minor XML processing fixes

New in Advanced ETL Processor Standard 3.7.7.2 (Jun 26, 2014)

  • Up to 50 percent faster working with QVD files

New in Advanced ETL Processor Standard 3.7.7.0 (Jun 18, 2014)

  • Renamed Web Service Lookup to HTTP Post
  • Added HTTP Get Transformation function
  • Documentation Update

New in Advanced ETL Processor Standard 3.7.6.12 (Jun 18, 2014)

  • Web Service Lookup issues were addressed

New in Advanced ETL Processor Standard 3.7.6.11 (Jun 6, 2014)

  • up to 10 times faster data sorting

New in Advanced ETL Processor Standard 3.7.6.10 (May 30, 2014)

  • Addressed issues of loading data from the files with old creation date
  • Smaller Setup

New in Advanced ETL Processor Standard 3.7.6.8 (May 15, 2014)

  • XML and ODBC fixes

New in Advanced ETL Processor Standard 3.7.6.7 (May 14, 2014)

  • Addressed file update problems

New in Advanced ETL Processor Standard 3.7.6.6 (May 14, 2014)

  • Up to 5 percent performance increase
  • MySQL date processing bugs fixes

New in Advanced ETL Processor Standard 3.7.6.4 (Mar 17, 2014)

  • MySQL date processing bugs fixes

New in Advanced ETL Processor Standard 3.7.6.2 (Mar 17, 2014)

  • Addressed union object issues

New in Advanced ETL Processor Standard 3.7.6.1 (Mar 17, 2014)

  • Addressed some subtransformation issues

New in Advanced ETL Processor Standard 3.7.5.26 (Mar 5, 2014)

  • Fixed Copy/Paste problems with Sub Transformation object

New in Advanced ETL Processor Standard 3.7.5.25 (Feb 17, 2014)

  • Addressed issues of loading data from Excel files

New in Advanced ETL Processor Standard 3.7.5.24 (Feb 17, 2014)

  • Added option to set defaults
  • Added option to filter target fields
  • Addressed some sqlite issues

New in Advanced ETL Processor Standard 3.7.5.21 (Jan 24, 2014)

  • Addressed issues with day of the week checking
  • Addressed issues with loading data into MySQL

New in Advanced ETL Processor Standard 3.7.5.20 (Jan 24, 2014)

  • Updated regular expression for US SSN

New in Advanced ETL Processor Standard 3.7.5.19 (Jan 3, 2014)

  • Addressed issues of loading data from flat files

New in Advanced ETL Processor Standard 3.7.5.18 (Dec 21, 2013)

  • Minor interface fixes
  • Documentation update

New in Advanced ETL Processor Standard 3.7.5.17 (Dec 17, 2013)

  • Addressed issues with loading empty Date fields into MS SQL server

New in Advanced ETL Processor Standard 3.7.5.16 (Dec 14, 2013)

  • Support fro Zoom in/Out was introduced
  • Target Data tab was introduced to the transformation editor
  • Corrected issues with processing emails send by IPAD
  • Addressed issues of loading data from flat files

New in Advanced ETL Processor Standard 3.7.5.15 (Dec 9, 2013)

  • Corrected issues with processing emails send by IPAD
  • Addressed issues of loading data from flat files

New in Advanced ETL Processor Standard 3.7.5.14 (Nov 30, 2013)

  • Added send as HTML option
  • Addressed issues of loading data from flat files
  • Fixed bugs related to loading data in to VARCHAR(MAX) fields.

New in Advanced ETL Processor Standard 3.7.5.12 (Nov 25, 2013)

  • Better objects positioning while working with multiple tabs
  • Emails are send as HTML now
  • Addressed issues with updating data

New in Advanced ETL Processor Standard 3.7.5.11 (Nov 25, 2013)

  • Better handling of large Salesforce tables
  • Support for multiple Salesforce environments was introduced

New in Advanced ETL Processor Standard 3.7.5.8 (Nov 15, 2013)

  • Deduplicator AV fix
  • QVD reading bug fixes

New in Advanced ETL Processor Standard 3.7.5.6 (Nov 11, 2013)

  • Better handling of empty Salesforce tables
  • More detailed information about Salesforce fields by data reader
  • Support for GreenPlum was introduced

New in Advanced ETL Processor Standard 3.7.5.5 (Nov 11, 2013)

  • Added tabs to transformation editor
  • Added select count(*) from table menu item to sql browser
  • Added Space Horizontally and Space Vertically buttons
  • Search dialogue edit box value is stored in registry now
  • Addressed issues with date fields processing
  • Addressed issues of loading data from delimited files

New in Advanced ETL Processor Standard 3.7.5.3 (Nov 11, 2013)

  • Added search functionality to transformation editor
  • Addressed some issues of working with default values
  • Salesforce bug's fixes

New in Advanced ETL Processor Standard 3.7.5.1 (Nov 11, 2013)

  • Better source connection errors handling

New in Advanced ETL Processor Standard 3.7.5.0 (Nov 11, 2013)

  • Salesforce is supported as datatarget
  • Addressed more autoformat problems

New in Advanced ETL Processor Standard 3.7.4.9 (Nov 11, 2013)

  • Salesforce bug's fixes
  • Addressed autoformat problems

New in Advanced ETL Processor Standard 3.7.4.8 (Oct 17, 2013)

  • Addressed issues with Salesforce processing

New in Advanced ETL Processor Standard 3.7.4.7 (Oct 14, 2013)

  • Addressed issues with HL7 processing
  • Addressed issues with loading data from Salesforce
  • Addressed issues with loading data into NTEXT fields
  • Addressed issues with loading data into MySQL
  • Addressed issues with locking PostgreSQL tables

New in Advanced ETL Processor Standard 3.7.4.5 (Oct 10, 2013)

  • Sales force connection support latest API now
  • Support for MariaDB was introduced
  • Documentation Update
  • Addressed problems with package editor
  • Addressed problems with loading date fields
  • Addressed problem with handling NULLs
  • Fixed AV when loading data into MySQL

New in Advanced ETL Processor Standard 3.7.4.4 (Oct 8, 2013)

  • Addressed problems with Excel date formatting

New in Advanced ETL Processor Standard 3.7.4.3 (Oct 7, 2013)

  • New datasource HTTP
  • Documentation update
  • Addressed issues with salesforce connection
  • Addressed problems with fixed width files

New in Advanced ETL Processor Standard 3.7.4.2 (Oct 3, 2013)

  • Addressed problems with formatting dates

New in Advanced ETL Processor Standard 3.7.4.1 (Sep 30, 2013)

  • Addressed problems with autoformat option

New in Advanced ETL Processor Standard 3.7.3.9 (Sep 19, 2013)

  • Another 10 percent performance increase
  • Addressed problems with scientific numbers in Excel
  • Fixed bug with too many rejected records
  • Smaller executable
  • Addressed problem with non ASCI characters in scripts/transformations/mappings etc

New in Advanced ETL Processor Standard 3.7.3.5 (Sep 10, 2013)

  • Up to 20 percent performance increase

New in Advanced ETL Processor Standard 3.7.3.3 (Sep 5, 2013)

  • Up to 70 percent performance increase

New in Advanced ETL Processor Standard 3.7.3.2 (Sep 2, 2013)

  • Further 20 percent performance increase for loading data from text files

New in Advanced ETL Processor Standard 3.7.3.1 (Sep 2, 2013)

  • Up to 50 percent increase for loading data via OleDB
  • Up to 40 percent increase when using stored procedures for loading the data
  • Further 10 percent performance increase for loading data from text files

New in Advanced ETL Processor Standard 3.7.3.0 (Aug 27, 2013)

  • Massive performance boost:
  • Text to INTERBASE TABLE up to 25.50%
  • Text to MS SQL TABLE via BCP up to 32.64%
  • Text to MS SQL TABLE via OLE DB 2000 CLIENT up to 50.00%
  • Text to MS SQL TABLE via OLE DB 2005 CLIENT up to 50.00%
  • Text to MS SQL TABLE via OLE DB 2008 CLIENT up to 50.00%
  • Text to MS SQL TABLE via OLE DB 2012 CLIENT up to 50.00%
  • Text to MY SQL TABLE up to 20.61%
  • Text to ORACLE TABLE via Conventional Path Loading up to 24.40%
  • Text to ORACLE TABLE via Direct Path Loading up to 30.45%
  • Text to ORACLE TABLE via OLE DB up to 19.52%
  • Text to ORACLE TABLE via OLE DB using ODBC up to 30.00%
  • Text to POSTGRESQL TABLE up to 29.15%
  • Better handling of Target Schema Changes
  • Notes have pop up menu now
  • SQL Statements: Leading comments -- or /**/ cause SQL to error - corrected
  • Transforms Field List: Ctrl-X, C, V, Do not work (but right click does) - corrected
  • Transforms File Names: Ctrl-X, C, V, Do not work (but right click does) - corrected
  • Transforms Data List: Can not Ctrl-C or Right Click Copy - corrected
  • Log Viewer: Can not Ctrl-C or Right Click Copy - corrected

New in Advanced ETL Processor Standard 3.7.2.1 (Aug 13, 2013)

  • Addressed some lookup issues

New in Advanced ETL Processor Standard 3.7.1.8 (Jul 24, 2013)

  • Massive performance boost:
  • text to text up to 100 percent
  • odbc to text up to 20 percent
  • text to PostgreSQL up to 25 percent
  • text to Oracle up to 25 percent
  • text to Oledb up to 25 percent
  • text to MYSQL up to 10 percent
  • text to MS SQL server up to 25 percent
  • QVD to text up to 100 percent
  • Save changes warnings were added to transformer and validator
  • Copy functionality was added to source and target definitions
  • Bug with deleting writers was fixed
  • Pivot bugs were fixed
  • Undo/Redo bugs were fixes

New in Advanced ETL Processor Standard 3.7.1.5 (Jun 26, 2013)

  • Functionality of Splitter and Get Line functions was improved
  • Documentation update
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Standard 3.7.1.4 (Jun 26, 2013)

  • QVD generation bugs fixes

New in Advanced ETL Processor Standard 3.7.1.3 (Jun 18, 2013)

  • "Is Value in Database" and "If Value in Database" were added
  • Documentation update

New in Advanced ETL Processor Standard 3.7.1.2 (Jun 11, 2013)

  • Support for the web services was introduced (SOAP)
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Standard 3.7.1.1 (Jun 11, 2013)

  • Data reader timeout was introduced for ODBC,Access,MS Sql Server, OleDB, PostgreSQl, MySQl and MS Sql Server CE connections
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Standard 3.7.1.0 (May 29, 2013)

  • Smaller executable
  • Memory usage was reduced for Excel files
  • Addressed some HL7 issues
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Standard 3.7.0.10 (May 13, 2013)

  • Format field name dialogue improvements
  • Datareader minor improvements

New in Advanced ETL Processor Standard 3.7.0.9 (May 8, 2013)

  • Addressed problems with "If in List" Function

New in Advanced ETL Processor Standard 3.7.0.7 (May 8, 2013)

  • Addressed problems with updating Oracle blob fields

New in Advanced ETL Processor Standard 3.7.0.6 (Apr 15, 2013)

  • Addressed some groupper issues

New in Advanced ETL Processor Standard 3.7.0.5 (Apr 8, 2013)

  • Undo/Redo Functionality was improoved

New in Advanced ETL Processor Standard 3.7.0.1 (Mar 28, 2013)

  • 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

New in Advanced ETL Processor Standard 3.6.3.8 (Mar 13, 2013)

  • Added parameter names to calculation object

New in Advanced ETL Processor Standard 3.6.3.7 (Mar 12, 2013)

  • Added Undo an Redo functionality

New in Advanced ETL Processor Standard 3.6.3.6 (Mar 12, 2013)

  • Added Register option to help menu
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Standard 3.6.3.5 (Mar 12, 2013)

  • Added snap to grid to functionality
  • Various bug fixes and interface improvements

New in Advanced ETL Processor Standard 3.6.3.3 (Mar 12, 2013)

  • 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 mapings
  • Various bug fixes and interface improvements
  • Support for HL7 messaging was introduced

New in Advanced ETL Processor Standard 3.6.2.8 (Feb 15, 2013)

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

New in Advanced ETL Processor Standard 3.6.2.5 (Feb 1, 2013)

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

New in Advanced ETL Processor Standard 3.6.2.2 (Jan 21, 2013)

  • Support for BDE was introduced
  • Documentation update
  • Various bug fixes

New in Advanced ETL Processor Standard 3.6.2.0 (Jan 11, 2013)

  • Support for BDE and Paradox was introduced
  • Various bug fixes

New in Advanced ETL Processor Standard 3.6.1.0 (Dec 17, 2012)

  • Introduced Auto complete functionality
  • Addressed some issues related to loading data from QVD files

New in Advanced ETL Processor Standard 3.6.0.0 (Dec 17, 2012)

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

New in Advanced ETL Processor Standard 3.5.1.7 (Dec 17, 2012)

  • Added option to ignore XML tags between Table tag and Record tag

New in Advanced ETL Processor Standard 3.5.1.1 (Oct 9, 2012)

  • Various bug fixes

New in Advanced ETL Processor Standard 3.5.1.0 (Sep 14, 2012)

  • Added new object Log which can be used to analyse 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

New in Advanced ETL Processor Standard 3.5.0.0 (Sep 3, 2012)

  • Support for QVD files was introduced
  • Various bug fixes

New in Advanced ETL Processor Standard 3.4.4.0 (Jul 5, 2012)

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

New in Advanced ETL Processor Standard 3.4.3.7 (Jun 27, 2012)

  • Documentation Update
  • Various bug fixes

New in Advanced ETL Processor Standard 3.4.3.4 (Jun 15, 2012)

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

New in Advanced ETL Processor Standard 3.4.3.1 (May 29, 2012)

  • Support Excel named ranges was introduced

New in Advanced ETL Processor Standard 3.4.2.7 (May 25, 2012)

  • Support for adding data to existing excel files was introduced
  • Support for SalesForce was introduced
  • Various bug fixes

New in Advanced ETL Processor Standard 3.4.2.2 (May 16, 2012)

  • Support for excel formating was introduced

New in Advanced ETL Processor Standard 3.4.2.1 (May 16, 2012)

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

New in Advanced ETL Processor Standard 3.4.1.2 (May 12, 2012)

  • Windows Event log improvments

New in Advanced ETL Processor Standard 3.4.1.1 (May 4, 2012)

  • Addressed some QVX creation issues

New in Advanced ETL Processor Standard 3.4.1.0 (May 4, 2012)

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

New in Advanced ETL Processor Standard 3.4.0.1 (Mar 27, 2012)

  • New arithmetical functions were added Add,Subtract,Divide,Multiply,Max and Min

New in Advanced ETL Processor Standard 3.4.0.0 (Mar 16, 2012)

  • Union ALL transformation object was created
  • Documentation update
  • Various bug fixes

New in Advanced ETL Processor Standard 3.3.2.0 (Mar 10, 2012)

  • Support for Dynamic SQL for ETL transformations was introduced

New in Advanced ETL Processor Standard 3.3.0.11 (Jan 23, 2012)

  • 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 trasformation function improvements
  • Various bug fixes

New in Advanced ETL Processor Standard 3.3.0.9 (Jan 10, 2012)

  • Added support for using variables in file header/footer and SQL before and SQL after
  • Addressed problem with arranging objects

New in Advanced ETL Processor Standard 3.3.0.6 (Dec 30, 2011)

  • After and Before transformation functions
  • CRC16, CRC24, CRC32, Adler32, CRC64, eDonkey, eMule, MD4, MD5, RIPEMD160, SHA1, SHA224, SHA256, SHA384, SHA512, Whirlpool checksums

New in Advanced ETL Processor Standard 3.3.0.5 (Dec 19, 2011)

  • Documentation update
  • Various AV fixes

New in Advanced ETL Processor Standard 3.3.0.4 (Dec 19, 2011)

  • Documentation update
  • Import and Export functionality were added to Pivot and Unpivot objects
  • Reader fixes
  • Sorter bug fixes
  • Various AV fixes

New in Advanced ETL Processor Standard 3.3.0.2 (Dec 19, 2011)

  • Various AV fixes
  • Documentation update

New in Advanced ETL Processor Standard 3.3.0.1 (Dec 2, 2011)

  • Added incremental search for expressions editor
  • Added filesize transformation function
  • Added filesize option to Reader parameter transformation function

New in Advanced ETL Processor Standard 3.3.0.0 (Dec 2, 2011)

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

New in Advanced ETL Processor Standard 3.2.7.1 (Oct 20, 2011)

  • "Program" file was created on drive c
  • XML XSLT tranformation fix
  • Some auto format issues were addressed
  • Minor interface tweaks

New in Advanced ETL Processor Standard 3.2.7.0 (Oct 20, 2011)

  • 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

New in Advanced ETL Processor Standard 3.2.6.9 (Sep 26, 2011)

  • Support for MySQL 5.5 was introduced
  • Boolean fix for MySql
  • Better error hadling for ADO and MS Sql scripts
  • Insert and delete colums for excel and and text data source and targets
  • Interface Improvements
  • Better NULL's handling
  • Command line parameter transformation function was introduced

New in Advanced ETL Processor Standard 3.2.6.5 (Sep 12, 2011)

  • Quote all menu item was added
  • Format field names dialog box was introduced
  • Various bug fixes

New in Advanced ETL Processor Standard 3.2.6.2 (Sep 6, 2011)

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

New in Advanced ETL Processor Standard 3.2.6.1 (Sep 3, 2011)

  • Interface improvments
  • Added functions to validate Swiss postcodes, phone numebers and mobile numbers
  • Various bug fixes

New in Advanced ETL Processor Standard 3.2.5.10 (Aug 10, 2011)

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

New in Advanced ETL Processor Standard 3.2.5.9 (Aug 3, 2011)

  • Added Fields Selector transformation function
  • Various bug fixes

New in Advanced ETL Processor Standard 3.2.5.6 (Jul 27, 2011)

  • 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

New in Advanced ETL Processor Standard 3.2.5.4 (Jul 15, 2011)

  • Sorter object allows to define directory to store data in and buffer size
  • New transformation functions
  • Decode HTTPDecode
  • Encode HTTP
  • Encode HTML
  • Decode HTML
  • Unix Path To Dos Path
  • Dos Path To Unix Path

New in Advanced ETL Processor Standard 3.2.5.3 (Jul 11, 2011)

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

New in Advanced ETL Processor Standard 3.2.5.2 (Jul 7, 2011)

  • Added "Search in subdirectories" option to data reader

New in Advanced ETL Processor Standard 3.2.5.1 (Jun 29, 2011)

  • 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:
  • 1. Open Data Validator and map validation rules to output fields.
  • 2. Save Data transformation.
  • 3. Repeat for all transformations

New in Advanced ETL Processor Standard 3.2.5.0 (Jun 28, 2011)

  • 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

New in Advanced ETL Processor Standard 3.2.4.2 (Jun 4, 2011)

  • Incremental Transformation function search was introduced

New in Advanced ETL Processor Standard 3.2.4.0 (May 13, 2011)

  • 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

New in Advanced ETL Processor Standard 3.2.3.15 (May 4, 2011)

  • Various bug fixes
  • Uses MS XML now

New in Advanced ETL Processor Standard 3.2.3.14 (Apr 19, 2011)

  • Now user can double click on *.ats file to open it

New in Advanced ETL Processor Standard 3.2.3.12 (Apr 15, 2011)

  • LeftPad(S,Length,Char):String, Pads Left part of the string with Character Char
  • RightDelete(S,Length):String, Deletes Right part of the string
  • RegularExpression(S,Expression):Boolean, Returns true if string matches expression
  • EncodeXMLElement(S,ElementName):String, Returns XML Element ElementName="S"
  • DecodeXMLElement(S,ElementName):String, Returns XML Element Value
  • EncodeXMLAttribute(S,AttributeName):String, Returns XML Attribute
  • DecodeXMLAttribute(S,AttributeName):String, Returns XML Attribute Value
  • EncodeXMLString(S):String,Returns XML String
  • DecodeXMLString(S):String,Returns XML String Value
  • Two new data transformation fuctions:
  • ReplaceSuffix
  • ReplacePrefix

New in Advanced ETL Processor Standard 3.2.3.11 (Apr 14, 2011)

  • Data transformation language extension
  • Added:
  • 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
  • EnsurePrefix(S,Prefix) Adds prefix to the string when not present
  • EnsureSuffix(S,Suffix) Adds prefix to the string when not present
  • EscapeString(S) C style sring escape
  • UnEscapeString(S) C style sring unescape
  • LeftDelete(S,Length)Deletes Left part of the string

New in Advanced ETL Processor Standard 3.2.3.10 (Apr 14, 2011)

  • Various bug fixes

New in Advanced ETL Processor Standard 3.2.3.8 (Apr 1, 2011)

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

New in Advanced ETL Processor Standard 3.2.3.6 (Mar 13, 2011)

  • Fixed number of problems related to working with InList and Lookup functions

New in Advanced ETL Processor Standard 3.2.3.5 (Mar 13, 2011)

  • Fixed number of problems related to working with uniqueidentifierfileds in sql server

New in Advanced ETL Processor Standard 3.2.3.3 (Feb 25, 2011)

  • Addressed number of problems related to working with uniqueidentifierfileds in sql server
  • Fixed bug loading zero length files

New in Advanced ETL Processor Standard 3.2.3.2 (Feb 25, 2011)

  • Fixed some data sorting bugs

New in Advanced ETL Processor Standard 3.2.3.1 (Feb 9, 2011)

  • New Reader parameter: Source File Creation Date
  • Various bug fixes

New in Advanced ETL Processor Standard 3.2.3.0 (Jan 24, 2011)

  • Support for Sql Server Compact Edition was introduced
  • Various bug fixes

New in Advanced ETL Processor Standard 3.2.2.16 (Jan 9, 2011)

  • Fixed some Issues with SQLite

New in Advanced ETL Processor Standard 3.2.2.15 (Jan 9, 2011)

  • Calculation was not showing result correctly in preview mode

New in Advanced ETL Processor Standard 3.2.2.14 (Dec 13, 2010)

  • Calculation was not showing result correctly in preview mode

New in Advanced ETL Processor Standard 3.2.2.13 (Dec 7, 2010)

  • Corrected problem with duplicated source fields

New in Advanced ETL Processor Standard 3.2.2.6 (Nov 24, 2010)

  • Various bugs fixes

New in Advanced ETL Processor Standard 3.2.2.5 (Nov 20, 2010)

  • Major update:
  • Calculations and scripting language changes
  • Syntax is slightly different now
  • source fields are aways strings
  • a) no need to use "[F1]"
  • b) [F1]+[F2] will concatenate two fields
  • if you want to add them use conversion functions
  • StrtoFloat([F1])+StrtoFloat([F2])
  • use single quotes instead of double quotes
  • eg GetSystemVariable('SYSTEM_DATE') GetSystemVariable("SYSTEM_DATE")
  • Lots of new fuctions, procedures and language changes (see documentation)
  • Date time fields support
  • Default Format was changed to YYYY-MM-DD HH:NN:SS.ZZZ for ODBC and SQL server connections
  • They also support fractions of seconds now
  • Problem with null dates was resolved

New in Advanced ETL Processor Standard 3.2.2.4 (Nov 18, 2010)

  • MD5 transfornation function was added
  • Scripting language was extended
  • Various Excel related bug fixes
  • Documentation update

New in Advanced ETL Processor Standard 3.2.2.3 (Nov 15, 2010)

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

New in Advanced ETL Processor Standard 3.2.2.2 (Oct 26, 2010)

  • Data grid grouping access violations fixes
  • Send email to support fixed

New in Advanced ETL Processor Standard 3.2.2.1 (Oct 22, 2010)

  • 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

New in Advanced ETL Processor Standard 3.2.1.1 (Sep 20, 2010)

  • Supports multiple text line delimiters now

New in Advanced ETL Processor Standard 3.2.1.0 (Sep 20, 2010)

  • 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
  • Memory leaks were fixed

New in Advanced ETL Processor Standard 3.2.0.10 (Sep 2, 2010)

  • Various bug fixes

New in Advanced ETL Processor Standard 3.2.0.8 (Aug 23, 2010)

  • 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
  • Copy,cut,paste from sql log
  • Table browser loads data much faster
  • Various Access violation and bug fixes
  • Documentation update

New in Advanced ETL Processor Standard 3.2.0.7 (Aug 19, 2010)

  • Various bugs fixes
  • Was not saving update key
  • Add column did not refresh data for excel and text data source and target
  • Problem with excel sheets with spaces
  • Delete characters did not show any characters to delete in title
  • Wrong icon for grid grouping in table browser

New in Advanced ETL Processor Standard 3.2.0.3 (Aug 9, 2010)

  • Various Excel related bugs fixes

New in Advanced ETL Processor Standard 3.2.0.0 (Aug 9, 2010)

  • Data grids modifications:
  • 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
  • No need for IMEX=1, HDR=Yes or Registry hacks (TypeGuessRows)
  • Loads data correctly all the time + no need to edit Excel file
  • Can create excel files in Excel 3.0-2007 format
  • Can insert data starting from specific cell
  • Can clear area before adding data into Excel

New in Advanced ETL Processor Standard 3.1.0.9 (Jul 26, 2010)

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

New in Advanced ETL Processor Standard 3.1.0.8 (Jul 26, 2010)

  • Various access violations were fixed
  • Problem with duplicated fields was resolved

New in Advanced ETL Processor Standard 3.1.0.7 (Jul 26, 2010)

  • Various interface improvements
  • Popup menu was added to data grouper.
  • New options for unpivot and pivot data transformation object
  • Documentation update
  • Various bug fixes

New in Advanced ETL Processor Standard 3.1.0.5 (Jun 28, 2010)

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

New in Advanced ETL Processor Standard 3.1.0.4 (May 22, 2010)

  • Fixed Loading data into DBF files

New in Advanced ETL Processor Standard 3.1.0.3 (Apr 24, 2010)

  • Various bug fixes

New in Advanced ETL Processor Standard 3.1.0.1 (Apr 9, 2010)

  • Support for SQL Server 2005/2008 was improved

New in Advanced ETL Processor Standard 3.1.0.0 (Apr 9, 2010)

  • Database to Email and Email to Database transformations
  • Transform files into blob fields and Export of blob fields
  • Detailed SMTP Log
  • Detailed POP3 Log
  • Detailed FTP Log
  • Secure Email
  • It is no longer required to use "SET sql_mode='ANSI'" for MySql Connection
  • Ole db connections works with blobs now
  • Ms Sql Server connection support: TEXT, NTEXT, VARBINARY(MAX), VARCHAR(MAX),XML, NVARCHAR(MAX), IMAGE
  • ODBC Performance Improvements.
  • ODBC Support for BLOBS was improved and tested with various databases
  • Oracle connection support for BLOB,CLOB and NCLOB, LONG RAW data types.
  • PostgresSQL connection works with bytea
  • Interbase/Firebird support for blobs
  • MySQL support for blobs
  • Several MS Access bug fixes
  • Redesign of reader and writer properties dialog boxes.
  • Command line bug fixes
  • Total number of Data transformation functions is now 49
  • Documentation Update+minor bug fixes

New in Advanced ETL Processor Standard 2.4.3.4 (Apr 9, 2010)

  • 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

New in Advanced ETL Processor Standard 2.4.3.3 (Jan 17, 2010)

  • Various bug fixes
  • Documentation Update

New in Advanced ETL Processor Standard 2.4.3.2 (Jan 10, 2010)

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

New in Advanced ETL Processor Standard 2.4.3.0 (Jan 3, 2010)

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

New in Advanced ETL Processor Standard 2.4.2.11 (Nov 29, 2009)

  • 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'}

New in Advanced ETL Processor Standard 2.4.2.10 (Nov 16, 2009)

  • Minor Bug Fixes

New in Advanced ETL Processor Standard 2.4.2.8 (Oct 26, 2009)

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

New in Advanced ETL Processor Standard 2.4.2.7 (Sep 19, 2009)

  • Lookup object supports working with oracle now Documentation Update

New in Advanced ETL Processor Standard 2.4.2.4 (Aug 16, 2009)

  • Minor bug fixes

New in Advanced ETL Processor Standard 2.4.2.3 (Aug 8, 2009)

  • Updated documentation Minor bug fixes

New in Advanced ETL Processor Standard 2.4.1.0 (Jul 6, 2009)

  • Added support for MySql databases. Rest of the products to follow.
  • Working on adding support for PostgreSQL and Interbase/Firebird

New in Advanced ETL Processor Standard 2.4.0.12 (Jun 5, 2009)

  • Some spelling errors were corrected
  • Minor bug fixes

New in Advanced ETL Processor Standard 2.4.0.11 (May 30, 2009)

  • DBC Connection String Builder was introduced
  • Improved support for NonStop ODBC/MX 2.0 ver 3.51.20.126 ODBC Driver Various Cosmetic Changes and Bug Fixes

New in Advanced ETL Processor Standard 2.4.0.10 (May 24, 2009)

  • Automatic Version check was introduced

New in Advanced ETL Processor Standard 2.4.0.2 (Apr 13, 2009)

  • 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

New in Advanced ETL Processor Standard 2.2.5 (Jun 26, 2008)

  • Various bug fixes and performance improvements