Advanced ETL Processor Standard History

Recent changes, fixes, and improvements for Advanced ETL Processor Standard.

Showing 513 releases

3.10.1.4
  • + Improved: Loading data into Oracle performance by approximately 10 percent
  • - Fixed: Oracle timestamp import bug
  • - Fixed: Oracle timestamp and date fields formatting
3.10.1.3
  • + Improved: "Data Reader" performace by approximately 5 percent
3.10.1.3
  • + Updated: Help, Support and Order links
3.10.1.2
  • + Improved: "Data Writer Dialogue" interface behaviour (SQL Server only)
3.10.1.1
  • + Improved: "Is In List" Validation Function Interface
  • - Fixed: Sql Server 2025 connection issues
3.10.1.0
  • + Improved: Range Lookup Transformation Performance (Up to 5 Times Faster)
  • + Improved: Lookup Transformation Performance
  • + Improved: Writer Data Grid Calculated Names Handling
  • - Fixed: Excel Writer AV
3.10.0.0
  • + Added: Support for Clarion TPS Files
3.9.10.5
  • + Improved: Formula Calcualtion Inside Excel Tables
3.9.10.4
  • + Improved: Minor Interface Fixes
3.9.10.3
  • - Fixed: Arrange objects bug (Mapping Editor)
  • - Fixed: Vertical aligment bug (Mapping Editor)
  • - Fixed: Spelling Errors
3.9.10.2
  • + Improved: Support for international characters
3.9.10.1
  • + Improved: Set Excel formula field size to 8k (Excel Writer)
3.9.10.0
  • + Added: Parquet Source to Reader
  • + Improved: Datawriter Error Handling
3.9.9.84
  • + Updated: Interbase client
  • + Added: Firebird client to setup
3.9.9.83
  • + Added: Interbase/Firebird client to setup
3.9.9.82
  • + Improved: Parsing Delimited Strings
3.9.9.81
  • - Fixed: Sort Delimited Values Transformation function additional delimiter bug
  • - Fixed: Deduplicate Delimited Values Transformation function additional delimiter bug
3.9.9.80
  • + Added: Sort Delimited Values Transformation function
  • + Added: Deduplicate Delimited Values Transformation function
3.9.9.79
  • + Added: Default Sorting to Case Transformation Function
  • - Fixed: Text Writer bug
3.9.9.77
  • + Improved: Renamed Get Line Transformation function to Get Field
  • + Added: Set Field Transformation Function
3.9.9.76
  • + Improved: MS SQL Server Reader error handling
3.9.9.75
  • + Added: Escape Qualifier to Text Writer
3.9.9.74
  • + Improved: Minor Interface Tweaks
3.9.9.73
  • + Improved: JSON Reader Error Handling
3.9.9.72
  • - Fixed: Issue with reading complex JSON
3.9.9.71
  • + Improved: JSON To XML Transformation function Renamed Node to Tag
3.9.9.70
  • + Added: JSON To XML Transformation function
  • + Added: XML To JSON Transformation function
3.9.9.69
  • + Improved: When transformation fails progress dialogue is not closed automatically
3.9.9.68
  • - Fixed: Transformation Designer Object Movement Bug
3.9.9.67
  • - Fixed: Transformation Designer Vertical Scroll Bug
  • + Added: Move to the top menu item the Transformation Designer
3.9.9.66
  • + Improved: Working with Excel templates
3.9.9.65
  • - Fixed: Joiner AV
3.9.9.64
  • - Fixed: AV while obtaining file owner
3.9.9.63
  • + Improved: Set background to white
3.9.9.62
  • + Improved: Notes Object Height and Width handling
3.9.9.61
  • + Improved: Notes Object Interface
  • + Added: Font Color selection to Notes Object
3.9.9.59
  • - Fixed: Excel 2 Reader Bug
3.9.9.58
  • + Improved: Data Preview For Subtransformation Transformation
3.9.9.57
  • - Fixed: Excel Reader Bug
3.9.9.56
  • - Fixed: SQL Server Reader Table name with space bug
3.9.9.55
  • - Fixed: SQL Server taget bug
3.9.9.54
  • + Added: Format Field Function To XML Writer
3.9.9.53
  • - Fixed: Joiner Transformation Bug
3.9.9.52
  • - Fixed: Sub Transformation copy paste bug
3.9.9.51
  • - Fixed: RegX Replace Hint
3.9.9.50
  • + Added: Support for python 3.13 and 3.14
3.9.9.49
  • + Improved: Minor Data Transformation Performance boost
3.9.9.48
  • - Fixed: POP3 and IMAP4 Reader Bugs
3.9.9.47
  • - Fixed: Joiner Transformation Empty Files Bug
3.9.9.46
  • + Improved: Table Browser Search performace while working with large list of tables
3.9.9.45
  • - Fixed: Joiner Transformation Empty File Bug
3.9.9.44
  • - Fixed: Minor issue with the Round transformation function dialogue
3.9.9.43
  • - Fixed: Fixed Google Spreadsheet reader bugs
3.9.9.42
  • - Fixed: HTML Table Reader AV
3.9.9.41
  • - Fixed: Oracle reader bugs
3.9.9.40
  • - Fixed: Oracle writer bugs
3.9.9.39
  • + Added: Additional Parameters to MongoDB connection
  • + Updated: MongoDB client
3.9.9.37
  • - Fixed: Validator UI Bug
  • - Fixed: Validator and Transformer UI bug fixes
3.9.9.36
  • - Fixed: BIGINT Field Issue
3.9.9.35
  • - Fixed: Minor Interface Bugs
  • - Fixed: Joiner AV
3.9.9.34
  • + Added: Concatenate options to groupper transformation
3.9.9.33
  • + Improved: Round transformation functionality
3.9.9.32
  • - Fixed: Lookups bugs
3.9.9.31
  • - Fixed: Excel Date write bug
  • - Fixed: Transformation copy/paste bug
3.9.9.30
  • + Added: Count Delimited Values Transformation Function
  • + Updated: Hidden Save button within Sub Transformation screen
3.9.9.29
  • + Added: Count String Transformation function
  • - Fixed: Transformation tabs bug
3.9.9.28
  • - Fixed: Validation creation bug
  • + Improved: Input and Output objects automatic positioning
3.9.9.27
  • - Fixed: Transformation creation bug
3.9.9.26
  • + Added: Support for Windows Arm (Experimental)
  • + Improved: Sub transformation test data support
  • - Fixed: Undo/Redo bugs
  • - Fixed: Search bugs
  • - Fixed: Sub transformation bugs
3.9.9.25
  • + Improved: Transformation Dialogs were made resizable
3.9.9.24
  • + Added: Ability to delete transformation links by clicking the output button.
3.9.9.23
  • + Improved: Removed unused button in data browser screen
3.9.9.22
  • - Fixed: Minor bugs
3.9.9.21
  • + Added: Template option to excel writer
3.9.9.20
  • - Fixed: Lookup Transformation Bug
3.9.9.19
  • + Added: Incremental Search to Transformation log
  • + Added: Sorting to Transformation log
  • + Added: Copy ability to Transformation log
3.9.9.18
  • - Fixed: Split RegX Static Bug
3.9.9.17
  • + Improved: Round property functionality
3.9.9.16
  • + Added: Application name to Registration Dialogue and Trial Expired message
3.9.9.15
  • - Fixed: Unpivot group duplication bug
3.9.9.12
  • - Fixed: Autoformat Excel Bug
3.9.9.11
  • + Improved: Parsing python parameters
3.9.9.11
  • - Fixed: Writing to multiple excel tables bug
3.9.9.11
  • - Fixed: Writing to hidden excel sheet bug
3.9.9.10
  • + Improved: Copy fields writer functionality
3.9.9.9
  • + Added: Clear table option to excel import
3.9.9.8
  • - Fixed: Data sorter bug
3.9.9.7
  • - Fixed: Data writer errors
3.9.9.6
  • + Improved: Set Field size to 1024 chracters for sorter, groupper, pivot and unpivot transformation objects
3.9.9.5
  • - Fixed: Excel writer bugs
3.9.9.4
  • - Fixed: Bug with saving objects positions
3.9.9.3
  • + Added: Support for Excel tables
3.9.9.2
  • + Improved: Working with excel files ranges
3.9.9.1
  • + Added: Default variable to "Create New File" transformation function
  • - Fixed: Create New File transformation function AV
3.9.9.0
  • + Added: "HTML Table" data writer target
3.9.8.44
  • + Added: "Create New File" transformation function
3.9.8.43
  • + Added: New themes
  • + Improved: Set default theme to white
3.9.8.42
  • - Fixed : Fixed autoformat grid bugs
3.9.8.41
  • - Fixed : Lookup Contains transformation function case sensitive bug
3.9.8.40
  • + Improved: "Lookup RegEx" and "Lookup Contains" transformation functions functinality
  • + Added: Open file button to Lookup dialogue
3.9.8.39
  • + Added: "Lookup RegEx" and "Lookup Contains" transformation functions
3.9.8.38
  • + Improved: "Fields Order" Error Handndling
3.9.8.37
  • + Improved: "Fields Order" transformation object interface
3.9.8.36
  • + Improved: License server error handling
3.9.8.35
  • + Added: "Fields Order" transformation object
3.9.8.34
  • + Improved: String delimiter handling
3.9.8.33
  • + Added: Delimiter, Text Qualifier, Skip Empty Values and Ignore Duplicates options to Accumulate Strings transformation function
3.9.8.32
  • - 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
3.9.8.31
  • - Fixed: Data Preview Hint Problem
3.9.8.30
  • + Updated: SSH components
3.9.8.29
  • + Improved: Case transformation function functionality
3.9.8.28
  • - Fixed: Issues with reading Excel files
3.9.8.27
  • + Added: "Proper Name" option to Format Fields dialogue
  • + Improved: Groups handling of UnPivot dialogue
3.9.8.26
  • + Updated: Excel components
3.9.8.25
  • + Added: Fixed Automap feature of Union all dialogue
3.9.8.24
  • + Added: Automap button to Union all dialogue
3.9.8.22
  • - Fixed: Minor transformation interface bugs
3.9.8.21
  • - Fixed: Split Dialogue AV
3.9.8.20
  • - Fixed: SQLite data reader bug
  • + Improved: Workinng with JSON Pairs
3.9.8.19
  • - Removed: TelAPI SMS Support (The company no longer exists)
3.9.8.18
  • + Updated: Third party components
3.9.8.17
  • + Updated: Excel components
3.9.8.16
  • + Added: Refresh Tables list menu item to Table Browser dialogue
3.9.8.15
  • - Fixed: Minour interface issues
3.9.8.14
  • + Improved: Lookup transformations error handling
3.9.8.13
  • + Added: Support for python versions 3.10, 3.11 and 3.12
3.9.8.12
  • + Updated: Excel engine
3.9.8.11
  • + Added: Ignore nulls and keep original values option to Excel Writer
3.9.8.10
  • + Improved: Calculation engine update
3.9.8.9
  • + Improved: Components update: SSL, SSH, SFTP, MySQL, Postgre, SQLite, Interbase/Firebird
3.9.8.8
  • + Added: Incremental search to Expression editor dialogue
3.9.8.7
  • - Fixed: Issues with inserting default values within the data grid. (MySQL, Postgress, Interbase/Firebird and SQLite)
3.9.8.5
  • + Disabled: ODATA Connection as no longer necessary
3.9.8.4
  • + Improved: Updated documentation link
3.9.8.3
  • + Improved: Increased Data writer fields' dedifintions widths
3.9.8.2
  • - Fixed: Field is not mapped issue
3.9.8.1
  • + Added: Support for SSH Connections to MySQL,Postgres and MongoDDB
  • + Improved: Data writer error handling
3.9.7.39
  • + Added: Rest Writer
3.9.7.38
  • - Fixed: Office 35 Email Writer AV
3.9.7.37
  • - Fixed: UID was missing from Office 35 Email Reader
3.9.7.36
  • + Added: Office 35 Email Writer
3.9.7.35
  • + Added: Office 35 Email Reader
3.9.7.34
  • - Renamed: "Split RegX" to Split RegX Static
  • + Added: Split RegX Dynamic transformation function
3.9.7.33
  • - Fixed: Issue with Replace RegX transformation function
3.9.7.32
  • - Fixed: Viewing Views Issues while browsing the data
  • + Improved: Loading data into smalldatetime fields
3.9.7.31
  • - Fixed: AV when adding new field to Joiner properties dialogue
3.9.7.30
  • - Fixed: Databuffer double procession bug
3.9.7.29
  • + Added: Ignore null option to Date format, Date part, Reformat date, Date diff, Local Date to UTC,UTC to Local Date,Date to Epoch transformation functions
3.9.7.28
  • + Added: Support for dynamic field names (delimited files only)
  • + Added: Support for RabbitMQ to data writer and reader
3.9.7.27
  • - Fixed: Is value In Database transformation function bug
3.9.7.26
  • + 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
3.9.7.24
  • + Improved: Note's custom colours are persisted across user sessions
3.9.7.23
  • + Added: GUIDNB Transformation language function, it returns clean GUID value without brackets and underscores
3.9.7.22
  • + Improved: XML Reading performance
  • + Improved: Excel components update
  • - Fixed: Issues with long month names
  • + Improved: Third party components update
  • - Fixed: Installation Issues
3.9.7.21
  • - Fixed: Issues with closing ODBC connection when refreshing target fields list
  • - Fixed: Issues with reading windows event log
3.9.7.19
  • - Fixed: Windows log message format
3.9.7.18
  • + Improved: Split RegX transformation function
3.9.7.17
  • - Fixed: Issues with lookup error handling
3.9.7.16
  • + Improved: Various cosmetic changes
  • + Improved: Changed table search from case sensitive to not case sensitive
  • + Improved: Working with HTML tables
  • - Fixed: Undo/Redo issues while working with source/target grid
  • - Fixed: Could not find any File(s) to read error when refreshing target grid
3.9.7.15
  • - Fixed: Access violations when reading excel files
  • - Fixed: Licensing issues when running the software on AWS servers.
3.9.7.14
  • + Improved: Tableau hyper error handling
  • + Added: IP Location and URL Location transformation functions
  • + Fixed: Minor mapping designer bug fixes and improvements
3.9.7.13
  • + Added: Extract Attachments option to IMAP4 and POP3 reader
  • + Added: Email footer message
  • + Added: Cache option to "Get Excel Cell Value Dynamic" transformation function
  • - Removed: IP Location, URL Location and Url Shortener transformation functions
  • - Removed: Transformation type toolbar from the mapping designer
  • - Fixed: Licence management issues
3.9.7.12
  • + Improved: It is now possible to use a single transformation to write data into multiple excel sheets of the same file
3.9.7.11
  • + Improved: transformation designer response time while working with very large files
  • + Improved: removed excess data refreshes within transformation designer this resulted in overall screen performance improvement
  • + Improved: underscore characters can be seen in preview mode now
  • + Improved: Updated hyper api to the latest version
  • - Fixed: Various tableau related bugs
3.9.7.10
  • + Added: HTML Table reader
  • + Added: Recalculate Excel File check box to excel writer
  • - Fixed: Field selector access violation
  • + Improved: Field selector performance
  • + Updated: Digital signature
3.9.7.9
  • - Fixed: Loading data from FoxPro
3.9.7.8
  • + 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
3.9.7.7
  • + Added: To, ReplyTo, Cc and Bcc fields to POP3 and IMAP4 readers
Earlier release 3.9.7.6
  • - Fixed: Issues with special characters inside SQL Server database names
Earlier release 3.9.7.5
  • + Improved: Setup look and feel
  • - Fixed: Issues with special characters inside field names
Earlier release 3.9.7.3
  • - Fixed: Access violations while using Get Excel Cell Value Dynamic
Earlier release 3.9.7.2
  • + Added: Support Excel formulas creation
  • + Improved: Writer SMS connection
Earlier release 3.9.7.1
  • + Added: Owner field to file system reader
  • + Added: FileOwner scripting language function
Earlier release 3.9.7.0
  • + Added: Support for reading Tableau Hyper files
  • + Added: Support for creating Tableau Hyper tables
  • + Added: Support for python version 3.8 and 3.9
  • + Improved: Tableau hyper client update
  • - Fixed: Note object color bug
Earlier release 3.9.6.28
  • + Added: Variables:
  • ,
  • ,
  • ,
  • ,
  • ,
  • ,
Earlier release 3.9.6.26
  • + Improved: Support for DATETIME2 Fields
Earlier release 3.9.6.25
  • - Fixed: Issues with Accumulate String transformation function
  • - Fixed: Issues with reading JSON objects
Earlier release 3.9.6.24
  • + Improved: Support for DATETIME2 Fields
Earlier release 3.9.6.23
  • + Improved: Software registration process
  • - Fixed: Issues with Australian Post Code validation
Earlier release 3.9.6.22
  • + Improved: JSON Data Handling
Earlier release 3.9.6.21
  • + Added: Support for SQL Server 2017
  • - Fixed: Issues with loading data into varchar(max) field
  • - Improved: SQL Server error handling
Earlier release 3.9.6.20
  • + Added: colors to notes
  • + Added: "Complex JSON" check box to JSON datasource
  • - Fixed: issues with aborting joiner transformation on error
Earlier release 3.9.6.19
  • + Added: Support for PostgreSql 12
Earlier release 3.9.6.18
  • + Added: IMAP4 as data writer connection
  • - Fixed: IMAP4 reader shows UID correctly now
  • - Fixed: Fixed issue with loosing transformations while closing transformation tab
Earlier release 3.9.6.17
  • - Fixed: SplitRegX transformation function bug
  • - Fixed: Lookup transformation function bug
  • + Added: Checks for source and target structure changes
Earlier release 3.9.6.16
  • + Added: Select Objects with no links menu option
  • + Added: Select Inputs menu option
  • + Added: Select Outputs menu option
  • + Added: Select Linked Objects menu option
Earlier release 3.9.6.15
  • + Added: Ability to pull license from the license server
  • - Fixed: Last record flag issue for files with two lines
Earlier release 3.9.6.14
  • + Added: Case sensitive option to Lookup transformation object
Earlier release 3.9.6.12
  • - Fixed: Issues with joining empty files
Earlier release 3.9.6.11
  • + Improved: Third party components update:
  • Excel processing libraries
  • + Improved: Various bug fixes and improvements
  • + Improved: Salesforce connection uses TLS 1.2 now
  • - Fixed: Excel data reading problems
Earlier release 3.9.6.10
  • - Fixed: Decode JSON Object and Decode JSON Array error handling issues
Earlier release 3.9.6.9
  • + Added: Syslog datasource
Earlier release 3.9.6.8
  • - Fixed: JSON Data reader AV
Earlier release 3.9.6.7
  • + Improved: Software Installation Process
  • + Improved: Third Party Components Update
  • - Fixed: Minor Python Integration Issues
Earlier release 3.9.6.6
  • Software registration changes:
  • Starting from this release users would need to enter license key and control number to register the software.
  • + 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
Earlier release 3.9.6.5
  • + Added: Support for calculations inside source reader source file
  • - Fixed: Copy/Paste issues with SQL Lookup transformation
Earlier release 3.9.6.4
  • + 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
Earlier release 3.9.6.3
  • + Improved: Slight performance improvement
Earlier release 3.9.6.2
  • - Fixed: Log tab issues
Earlier release 3.9.6.1
  • + Improved: JSON null values handling
Earlier release 3.9.6.0
  • + Added: Loading data into Google Spreadsheets
  • + Improved: Third party components update
Earlier release 3.9.5.15
  • - Fixed: Issues with loading data into Varchar(MAX) fields (SQL Server)
  • + Improved: transformer fields metadata
Earlier release 3.9.5.14
  • + Added: Added Get Excel Cell Value Dynamic transformation function
  • + Improved: Object selection visibility
Earlier release 3.9.5.13
  • + Improved: Third party components update
Earlier release 3.9.5.12
  • - Fixed: Addressed issues with loading data into XML,Image and Identity fields (SQL Server)
Earlier release 3.9.5.11
  • + Improved: Up to two times faster loading data into SQL Server
  • + Added: Support for TLS 1.2 SQL Server connections
Earlier release 3.9.5.10
  • + Improved: Made Calculation dialogue box resizable`
  • - Fixed: Issues with exporting data into csv and tab files from grids
Earlier release 3.9.5.9
  • + 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
Earlier release 3.9.5.8
  • - Fixed: Loading Data Into Time Fields
Earlier release 3.9.5.7
  • + Added: Data Buffer Transformation Function
  • + Improved: Transformation Error Handling
Earlier release 3.9.5.5
  • + Improved: Google Spreadsheet import
  • + Improved: SQL Lookup transformation dialogue
  • - Fixed: Salesforce Bulk API load issues
  • - Fixed: SQL Lookup transformation issues
Earlier release 3.9.5.3
  • - Fixed: Round Transformation Function issues
  • - Fixed: Issues with exporting very large grids into excel files
Earlier release 3.9.5.2
  • - Fixed: Python Scripting issues
Earlier release 3.9.5.1
  • - Fixed: Salesforce Bulk API load issues
Earlier release 3.9.5.0
  • + Added: Support fot Hyper Tableau files (64 bit version)
  • + Improved: Third party components update
Earlier release 3.9.4.3
  • - Fixed : Loading data into Google spreadsheet
  • + Added: Ansi Driver checkbox to odbc connections
Earlier release 3.9.4.2
  • + Added: Support For MongoDB
Earlier release 3.9.4.1
  • + 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)
Earlier release 3.9.4.0
  • + 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
Earlier release 3.9.3.29
  • - Fixed : Issues with JSON transformations
Earlier release 3.9.3.27
  • - Fixed : Issues with reading JSON data
Earlier release 3.9.3.26
  • - Fixed : Fixed AV's
Earlier release 3.9.3.25
  • - Fixed : Issues with reading brightpearl data
Earlier release 3.9.3.24
  • - Fixed : Issues with assigning default values to lookup
Earlier release 3.9.3.23
  • + Improved: Functionality of Running totals transformation function
Earlier release 3.9.3.22
  • + Improved: Open SSL libraries update
  • + Improved: Up to 30 percent faster
Earlier release 3.9.3.21
  • + Added : Support for SFTP Private Keys
  • - Fixed : Issues with QVX Files reading
Earlier release 3.9.3.20
  • + Added :Paste functionality to target definitions (writer fields grid)
  • - Fixed : Issues with loading version info
Earlier release 3.9.3.19
  • - Fixed : Tableau Datetime fields processing issues
Earlier release 3.9.3.18
  • - Fixed : Fixed QVD reading issues
Earlier release 3.9.3.17
  • + Improved: Setup has an option to download Tableau client now
  • + Added : SQL Lookup Transformation Function
  • - Fixed : Scrolling issues
  • - Fixed : Change date dynamic bug
Earlier release 3.9.3.15
  • + Improved: Setup procedure
Earlier release 3.9.3.14
  • - Fixed : Issues with loading version info
Earlier release 3.9.3.13
  • + Improved: Maximum ODBC Connection String is 4K now
  • - Fixed : One Row QVD creation bug
Earlier release 3.9.3.12
  • + Improved: Look and feel of object joins
Earlier release 3.9.3.9
  • + Improved: Updated Salesforce API to v38
Earlier release 3.9.3.8
  • + Improved: Query Builder components update
  • + Improved: SSL components update
Earlier release 3.9.3.7
  • + Added : FTP Files list as datasource
  • - Fixed : Issues with updating data via table browser
Earlier release 3.9.3.6
  • + 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
Earlier release 3.9.3.5
  • - Fixed : Issues with reading data from SalesForce
  • + Added : Table generation option to writer grid
Earlier release 3.9.3.3
  • + Added : Option to disable record count
  • + Improved : Once deleted packages are disabled in the scheduler
  • - Fixed : Fixed issues with reading XML files
Earlier release 3.9.3.2
  • + Improved: Up to 10 percent performance increase while loading data into date/time fields
Earlier release 3.9.3.1
  • + Improved: Support for JSON as data source
Earlier release 3.9.3.0
  • + Added: Support for JSON as data source and target
  • + Improved : Lookup transformation supports JSON as datas source now
Earlier release 3.9.2.9
  • - Fixed : BDE Datasource issues
  • + Improved : MySQL Error handling
Earlier release 3.9.2.8
  • - Fixed : Problems with reading delimited text files when delimiter is more than one character log
Earlier release 3.9.2.7
  • - Fixed : Problems with clone row transformation object
Earlier release 3.9.2.6
  • - Fixed : Problems with reading data from Salesforce
Earlier release 3.9.2.5
  • - Fixed : Problems with refreshing list of Oracle Tables
Earlier release 3.9.2.4
  • - Fixed : Problems with AM/PM Date conversion
Earlier release 3.9.2.3
  • + Improved : JDBC Processing
Earlier release 3.9.2.2
  • + Improved : JDBC Errors Handling
Earlier release 3.9.2.1
  • - Fixed : Problems with reading data from unicode files
Earlier release 3.9.2.0
  • + Third party components 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
  • + 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
Earlier release 3.9.1.4
  • - Address issues with Change Date Static,Change Date Dynamic and If WeekDay functions
  • - Addressed Salesforce data update issues
Earlier release 3.9.1.3
  • - Addressed Salesforce data update issues
Earlier release 3.9.1.2
  • + Improved support for RSS feeds
Earlier release 3.9.1.0
  • + Calculation transformation function support Python now
Earlier release 3.9.0.15
  • - Addressed issues with Running Total transformation
Earlier release 3.9.0.14
  • + Support for latest tableau api was introduced
  • - Log Object bugs fixes
Earlier release 3.9.0.13
  • + Added Write to File transformation function
Earlier release 3.9.0.12
  • + Minor transformation designer improvements
Earlier release 3.9.0.11
  • - Date fields processing bugs fixes
Earlier release 3.9.0.10
  • - Joiner Object bugs fixes
Earlier release 3.9.0.8
  • - SalesForce data processing fixes
Earlier release 3.9.0.7
  • - Addressed DTD is prohibited issues
Earlier release 3.9.0.6
  • + Added End of line customisation for text data target
Earlier release 3.9.0.5
  • + Improved support for very large QVD files
Earlier release 3.9.0.4
  • - Addressed Date validation and conversion problems
Earlier release 3.9.0.3
  • + SSL Libraries update
  • + Third party components update
  • + SalesForce connection uses TLS 1.1 now
Earlier release 3.9.0.1
  • + Uses tableau API 9.2 now
  • - Addressed issues with print preview screen
  • - Addressed issues flicking
Earlier release 3.9.0.0
  • + 64 bit version initial release
  • + Added MRU List to data entry grid
Earlier release 3.8.2.12
  • - Addressed issues with getting stored procedures parameters
Earlier release 3.8.2.11
  • + 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
  • - 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
Earlier release 3.8.2.10
  • + Addressed issues with creating Excel files
Earlier release 3.8.2.8
  • + 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
Earlier release 3.8.2.7
  • + Faster QVD files processing
  • - Addressed issues with reading very large QVD files
  • - Addressed issues with creating QVD files
Earlier release 3.8.2.6
  • + Third party components update
  • + Reduced memory usage for QVD files processing
  • - Addressed issues with clone row object
Earlier release 3.8.2.5
  • + Better support for QVD's Timestamp and Date fields
  • - Addressed issues with union and sorter objects
Earlier release 3.8.2.4
  • - Addressed issues with subtransformation function
Earlier release 3.8.2.3
  • + Added Ignore Data Format option to Excel Data reader
  • - Addressed issues with split function
Earlier release 3.8.2.2
  • + Added Lookup Replace Transformation function
  • - Addressed issues with Running Totals functions
  • - Addressed issues with joining empty files
Earlier release 3.8.2.0
  • + Added support for Active Directory as data source
  • - Addressed issues with filtering data
  • - Addressed issues with exporting data into excel files
Earlier release 3.8.1.11
  • - Addressed issues with loading empty date fields into MySQL
  • - Addressed issues with Split Transformation Function
Earlier release 3.8.1.9
  • + Smaller Executable
  • + Updated regular exression Engine
  • + Added Replace RegX and Split RegX transformation functions
Earlier release 3.8.1.7
  • + Added Field Value transformation function
Earlier release 3.8.1.5
  • + 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
Earlier release 3.8.1.3
  • + Added Save button to Transformer and Validator
  • + Added FileLine transformation function
  • - Addressed issues with Slemma Import
Earlier release 3.8.1.2
  • + Added support for Clarion dat files
Earlier release 3.8.1.1
  • - Addressed issues with sorter
Earlier release 3.8.1.0
  • + Added support for Slemma
  • + All documentation is in wiki format now
Earlier release 3.8.0.40
  • + 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
  • + Added Encode JSON String and Decode JSON String
  • - Addressed issues with exporting data as excel from data grids
  • - Addressed issues with deduplicator
  • - Addressed issues with deleting records
Earlier release 3.8.0.39
  • + Added trim option to format field names dialogue
  • + Updated set fields' names functionality
Earlier release 3.8.0.38
  • + Extended Date Diff functionality
Earlier release 3.8.0.37
  • + Google spreadsheet API update
  • + Support for Salesforce Bulk API was introduced
  • + Added MONTH_EXACT to DateDiffS function
Earlier release 3.8.0.35
  • - IMAP4 and POP3 fixes
  • - Various bugs fixes and improvements
Earlier release 3.8.0.34
  • + Support for salesforce BULK API was introduced
Earlier release 3.8.0.33
  • - Addressed issues with loading null values into salesforce
Earlier release 3.8.0.32
  • - Addressed issues with loading data from SQL Server CE
Earlier release 3.8.0.31
  • - Addressed issues with loading data from delimited files
Earlier release 3.8.0.30
  • - Addressed issues with groupper transformation
  • - Various bugs fixes and improvements
Earlier release 3.8.0.29
  • + Documentation update
  • + Added GetExcelCellValue calculation function
  • + Sorter improvements
Earlier release 3.8.0.27
  • + Improved performance of Join Transformation.
  • - Addressed issues with memory management
Earlier release 3.8.0.26
  • - Addressed issues with Is Number validation function
Earlier release 3.8.0.25
  • + Added ability to swap reader and writer
  • + Added support for 255 length fields names in Union All object
Earlier release 3.8.0.24
  • + GetExcelCellValue function provides more detailed information about errors now
  • - Addressed issues with retrieving information about Primary keys
  • - Addressed issues with parallel sorting
Earlier release 3.8.0.22
  • + Added ability to delete and insert items in the middle of Split, Join and calculation object
Earlier release 3.8.0.21
  • + Documentation update
  • - Addressed issues with processing of delimited files
  • - Addressed issues with date formats
Earlier release 3.8.0.18
  • + 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
Earlier release 3.8.0.17
  • + 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
Earlier release 3.8.0.16
  • + 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
Earlier release 3.8.0.14
  • - Addressed problems with reading googlespreasheet data
  • - Addressed Transformer AV's
Earlier release 3.8.0.13
  • + 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
  • - Addressed issues with Joiner object
  • - Various bug fixes and improvements
Earlier release 3.8.0.12
  • + Up to 10 percent faster text file processing
  • - Addressed issues with processing end of line characters inside delimited files
Earlier release 3.8.0.11
  • + Up to 7 times faster data sorting
  • - Addressed issues with salesforce data processing
  • - Fixed problems with data preview
  • - Various bug fixes and improvements
Earlier release 3.8.0.10
  • - Addressed issues with creating rejected records file
Earlier release 3.8.0.9
  • - Addressed issues with running ODBC Manager from application
Earlier release 3.8.0.7
  • + SSL libraries update
  • - Various bug fixes and improvements
Earlier release 3.8.0.6
  • Massive performance increase
  • + Working with text files - is more than 2 times faster
  • + Creating QVD files - up to 30 percent faster
  • + 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
Earlier release 3.8.0.4
  • + Support for MS SQL Server 2014 was extended
Earlier release 3.8.0.3
  • - Addressed issues with sequence transformation object
  • - Addressed issues with subtransformation object
  • - Addressed issues with sending SMS messages
Earlier release 3.8.0.2
  • - Addressed issues with theme management
  • - Loads recent history of changes by default now
  • (Full history is to big and slows down the application)
Earlier release 3.8.0.1
  • - Addressed issues with metadata object
  • + Added Vertical Grid
  • + Third party components update
Earlier release 3.8.0.0
  • + 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
Earlier release 3.7.9.8
  • - Addressed issues with GetExcelCelValue transformation function
Earlier release 3.7.9.7
  • + Setup and executable are digitally signed now
  • - Minor bugs fixes
Earlier release 3.7.9.6
  • + Added Reset height option
Earlier release 3.7.9.5
  • + Up to 10 percent faster
  • + License Update
  • + Documentation Update
Earlier release 3.7.9.4
  • - Addressed issues with XML encoding
Earlier release 3.7.9.3
  • - Addressed some validator issues
Earlier release 3.7.9.2
  • + 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
Earlier release 3.7.9.0
  • + Added support for tableau tde files
Earlier release 3.7.8.17
  • + Added option to generate table creation script to the transformer source grid
  • + Log redirect object improvements
  • + Various bugs fixes
Earlier release 3.7.8.16
  • + Setup Update
  • - Addressed Splitter dialogue issues
Earlier release 3.7.8.15
  • + Added new transformation field values
  • + Documentation Update
Earlier release 3.7.8.14
  • + Added two new fields to File Sytem datasource last modification date and last access date
  • + Documentation Update
Earlier release 3.7.8.13
  • + Minor interface improvements
Earlier release 3.7.8.12
  • + Added Is Null or Empty string validation function
  • + Added If Null or Empty string transformation function
  • + Documentation Update
  • - Mapping editor bug fixes
Earlier release 3.7.8.10
  • - Addressed CASE transformation issues
Earlier release 3.7.8.7
  • - MySQL bugs fixes
  • - Bug fixes
Earlier release 3.7.8.6
  • + Added Support for Message Queuing (MSMQ)
  • + Documentation Update
  • + Better Data Reader Memory Management
Earlier release 3.7.8.5
  • - Addressed issues with BIGINT fields
Earlier release 3.7.8.3
  • - Addressed issues with Get Excel Cell Value transformation function
  • - Addressed issues with copy paste functionality
Earlier release 3.7.8.2
  • + Further improvements to Sending SMS functionality
  • - Date Format bugs fixes
  • - Addressed problem with keep characters functions
Earlier release 3.7.8.0
  • + Support for Sending SMS messages was introduced
  • + Documentation Update
Earlier release 3.7.7.13
  • + 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
Earlier release 3.7.7.11
  • + Interface improvements
  • - Addressed issues with CASE transformation function
Earlier release 3.7.7.10
  • + Added CASE transformation function
  • + Added Delete Leading Characters
  • + Added Delete Trailing Characters
  • + Added support for special characters
  • + Interface improvements
  • + Documentation Update
Earlier release 3.7.7.9
  • + Ability to move objects between different tabs was introduced
  • - Subtransformation bugs fixes
Earlier release 3.7.7.8
  • + Introduced support for salesforce QueryAll interface
  • + Documentation Update
  • - Addressed problems with batch import via ODBC
Earlier release 3.7.7.7
  • + Excel processing engine update
Earlier release 3.7.7.6
  • + Extended functionality of Get Excel Cell Value and Get File Context functions
  • - Addressed issues with Undo Redo buttons
  • - Addressed excel' files locking problems
Earlier release 3.7.7.4
  • + Added two new transformation functions Get Excel Cell Value and Get File Context
  • + Documentation Update
Earlier release 3.7.7.3
  • + Support for latest version of Google spreadsheets was introduced
  • - Minor XML processing fixes
Earlier release 3.7.7.2
  • + Up to 50 percent faster working with QVD files
Earlier release 3.7.7.0
  • + Renamed Web Service Lookup to HTTP Post
  • + Added HTTP Get Transformation function
  • + Documentation Update
Earlier release 3.7.6.12
  • - Web Service Lookup issues were addressed
Earlier release 3.7.6.11
  • + up to 10 times faster data sorting
Earlier release 3.7.6.10
  • - Addressed issues of loading data from the files with old creation date
  • + Smaller Setup
Earlier release 3.7.6.8
  • - XML and ODBC fixes
Earlier release 3.7.6.7
  • - Addressed file update problems
Earlier release 3.7.6.6
  • + Up to 5 percent performance increase
  • - MySQL date processing bugs fixes
Earlier release 3.7.6.4
  • - MySQL date processing bugs fixes
Earlier release 3.7.6.2
  • - Addressed union object issues
Earlier release 3.7.6.1
  • - Addressed some subtransformation issues
Earlier release 3.7.5.26
  • - Fixed Copy/Paste problems with Sub Transformation object
Earlier release 3.7.5.25
  • - Addressed issues of loading data from Excel files
Earlier release 3.7.5.24
  • + Added option to set defaults
  • + Added option to filter target fields
  • - Addressed some sqlite issues
Earlier release 3.7.5.21
  • - Addressed issues with day of the week checking
  • - Addressed issues with loading data into MySQL
Earlier release 3.7.5.20
  • + Updated regular expression for US SSN
Earlier release 3.7.5.19
  • - Addressed issues of loading data from flat files
Earlier release 3.7.5.18
  • + Minor interface fixes
  • + Autoformat fixes (Some mappings may need to be updated)
  • + When new output field is added field id is assigned automatically
  • + Documentation update
Earlier release 3.7.5.17
  • - Addressed issues with loading empty Date fields into MS SQL Server
Earlier release 3.7.5.16
  • + 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
Earlier release 3.7.5.15
  • - Addressed issues of loading data from flat files
Earlier release 3.7.5.14
  • + Added send as HTML option
  • - Addressed issues of loading data from flat files
  • - Fixed bugs related to loadig data in to VARCHAR(MAX) fields.
Earlier release 3.7.5.12
  • + Better objects positioning while working with multiple tabs
  • + Emails are send as HTML now
  • - Addressed issues with updating data
Earlier release 3.7.5.11
  • + Better handling of large Salesforce tables
  • + Support for multiple Salesforce environments was introduced
Earlier release 3.7.5.8
  • - Deduplicator AV fix
  • - QVD reading bug fixes
Earlier release 3.7.5.6
  • + Better handling of empty Salesforce tables
  • + More detailed information about Salesforce fields by data reader
  • + Support for GreenPlum was introduced
Earlier release 3.7.5.5
  • + 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
Earlier release 3.7.5.3
  • + Added search functionality to transformation editor
  • - Addressed some issues of working with default values
  • - Salesforce bug's fixes
Earlier release 3.7.5.1
  • + Better source connection errors handling
Earlier release 3.7.5.0
  • + Salesforce is supported as datatarget
  • - Addressed more autoformat problems
Earlier release 3.7.4.9
  • - Salesforce bug's fixes
  • - Addressed autoformat problems
Earlier release 3.7.4.8
  • - Addressed issues with Salesforce processing
Earlier release 3.7.4.7
  • - 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
Earlier release 3.7.4.5
  • + Salesforce 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
Earlier release 3.7.4.4
  • - Addressed problems with excel date formatting
Earlier release 3.7.4.3
  • + New datasource HTTP
  • + Documentation update
  • - Addressed issues with salesforce connection
  • - Addressed problems with fixed width files
Earlier release 3.7.4.2
  • - Addressed problems with formating dates
Earlier release 3.7.4.1
  • - Addressed problems with autoformat option
Earlier release 3.7.3.12
  • + 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
Earlier release 3.7.3.6
  • + Up to 20 percent performance increase
Earlier release 3.7.3.3
  • + Up to 70 percent performance increase
Earlier release 3.7.3.2
  • + Further 20 percent performance increase for loading data from text files
Earlier release 3.7.3.1
  • + 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
Earlier release 3.7.3.0
  • 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
Earlier release 3.7.2.1
  • - Addressed some lookup issues
Earlier release 3.7.2.0
  • 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
Earlier release 3.7.1.5
  • + Functionality of Splitter and Get Line functions was improoved
  • + Documentation update
  • - Various bug fixes and interface improvements
Earlier release 3.7.1.4
  • + QVD generation bugs fixes
Earlier release 3.7.1.3
  • + "Is Value in Database" and "If Value in Database" were added
  • + Documentation update
Earlier release 3.7.1.2
  • + Support for the web services was introduced (SOAP)
  • - Various bug fixes and interface improvements
Earlier release 3.7.1.1
  • + 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
Earlier release 3.7.1.0
  • + Smaller executable
  • + Memory usage was reduced for Excel files
  • - Adressed some HL7 issues
  • - Various bug fixes and interface improvements
Earlier release 3.7.0.10
  • + Format field name dialogue improvements
  • + Datareader minor improvements
Earlier release 3.7.0.9
  • - Addressed problems with "If in List" Function
Earlier release 3.7.0.7
  • + Addressed problems with updating Oracle blob fields
Earlier release 3.7.0.6
  • + Addressed some groupper issues
Earlier release 3.7.0.5
  • + Undo/Redo Functionality was improoved
  • + Documentation update
Earlier release 3.7.0.3
  • + 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
Earlier release 3.6.3.8
  • + Added parameter names to calculation object
Earlier release 3.6.3.7
  • + Added Undo an Redo functionality
  • - Various bug fixes
Earlier release 3.6.3.6
  • + Added Register option to help menu
  • + Various bug fixes and interface improvements
Earlier release 3.6.3.5
  • + Added snap to grid to functionality
  • + Various bug fixes and interface improvements
Earlier release 3.6.3.3
  • + 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
Earlier release 3.6.2.11
  • - Various bug fixes
Earlier release 3.6.2.9
  • + Added Keep Characters Function
  • + Added Epoch to Date Function
  • + Added Date to Epoch Function
  • + Interface improvements
  • + Documentation update
  • - Various bug fixes
Earlier release 3.6.2.6
  • + Improved support for MS SQL Server 2012
  • + Improved support for BDE
  • + Executable is smaller now
  • + Support for Excel 2013 was itroduced
  • + Logging improvements for Connection type, connection name and connection details
  • - Various bug fixes
Earlier release 3.6.2.2
  • + Support for BDE was introduced
  • + Documentation update
  • - Various bug fixes
Earlier release 3.6.1.3
  • - Various bug fixes
Earlier release 3.6.1.0
  • + Introduced Auto complete functionality
  • - Addressed some issues related to loading data from QVD files
  • - Various bug fixes
Earlier release 3.6.0.0
  • + Support for stored procedures as data target was introduced
  • + Performance improvements for MS SQL Server Connection
  • + Various Bug Fixes
  • + Documentation Update
Earlier release 3.5.1.7
  • + Added option to ignore XML tags between Table tag and Record tag
  • + Documentaiton Update
Earlier release 3.5.1.1
  • - Various bug fixes
Earlier release 3.5.1.0
  • + 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
Earlier release 3.5.0.0
  • + Support for QVD files was introduced
  • - Various bug fixes
Earlier release 3.4.4.3
  • - Various bug fixes
Earlier release 3.4.4.0
  • + Massive performance improvement up to 10+ times for some data sources/targets
  • - Various bug fixes
Earlier release 3.4.3.8
  • + Documentation Update
  • - Various bug fixes
Earlier release 3.4.3.4
  • + Support for IMAP4 was introduced
  • - Various bug fixes
  • - Corrected some problems related to dynamic file names
Earlier release 3.4.3.1
  • + Support for Excel named ranges was introduced
Earlier release 3.4.3.0
  • + Support for JDBC was introduced
  • - Various bug fixes
Earlier release 3.4.2.7
  • + Support for adding data to existing excel files was introduced
  • + Support for SalesForce was introduced
  • - Various bug fixes
Earlier release 3.4.2.3
  • - Various bug fixes
Earlier release 3.4.2.2
  • + Support for excel formating was introduced
Earlier release 3.4.2.1
  • + Uses 10 times less memory for large excel files
  • + Documentation update
Earlier release 3.4.1.2
  • - Addressed some QVX creation issues
  • - Windows Event log improvments
Earlier release 3.4.1.0
  • + 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
Earlier release 3.4.0.3
  • + New arithmetical functions were added Add,Subtract,Divide,Multiply,Max and Min
Earlier release 3.4.0.0
  • + Union ALL transformation object was created
  • + Documentation update
  • - Various bug fixes
Earlier release 3.3.2.0
  • + Support for Dynamic SQL for ETL transformations was introduced
Earlier release 3.3.1.3
  • + 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
Earlier release 3.3.0.9
  • + Added support for using variables in file header/footer and SQL before and SQL after
  • - Addressed problem with arranging objects
Earlier release 3.3.0.7
  • + After and Before transformation functions
  • + CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,Whirlpool checksums
  • + Documentation update
  • - Various AV fixes
Earlier release 3.3.0.5
  • + Documentation update
  • - Various AV fixes
Earlier release 3.3.0.4
  • + Documentation update
  • + Import and Export functionality were added to Pivot and Unpivot objects
  • - Reader fixes
  • - Sorter bug fixes
  • - Various AV fixes
Earlier release 3.3.0.2
  • - Various AV fixes
  • + Documentation update
Earlier release 3.3.0.1
  • + Added incremental search for expressions editor
  • + Added filesize transformation function
  • + Added filesize option to Reader parameter transformation function
Earlier release 3.3.0.0
  • + On win64 can now access 3gb of memory
  • + Support for themes
  • + Documentation update
  • - Text writer unicode fixes
  • - Various bug fixes
Earlier release 3.2.7.2
  • - "Program" file was created on drive c
  • - XML XSLT tranformation fix
  • - Some auto format issues were addressed
  • - Minor interface tweaks
Earlier release 3.2.7.0
  • + 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
Earlier release 3.2.6.9
  • + 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
Earlier release 3.2.6.7
  • - Various bug fixes
Earlier release 3.2.6.6
  • 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
Earlier release 3.2.6.5
  • Quote all menu item was added
  • Format field names dialog box was introduced
  • Various bug fixes
Earlier release 3.2.6.4
  • File data writer have following new options now
  • 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
Earlier release 3.2.6.3
  • Added Support for XSLT transformations
  • Added Get Variable, XML XSLT transformation, Validate XML function
  • Interface Update
  • Various bug fixes
Earlier release 3.2.5.11
  • Documentation Update
  • Support for dynamic file names was improved
Earlier release 3.2.5.10
  • Added File name and Directory name extraction transformation functions
  • Data splitter modifications
  • Various bug fixes
Earlier release 3.2.5.9
  • Added Fields Selector transformation function
  • Various bug fixes
Earlier release 3.2.5.8
  • 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
Earlier release 3.2.5.5
  • 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
Earlier release 3.2.5.3
  • Range lookup transformation function was introduced
  • When data is exported into excel file numeric values are stored as numbers
  • Various bug fixes
Earlier release 3.2.5.2
  • Added "Search in subdirectories" option to data reader
Earlier release 3.2.5.1
  • Major 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
Earlier release 3.2.4.2
  • Incremental Transformation function search was introduced
Earlier release 3.2.4.1
  • 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
Earlier release 3.2.3.14
  • Now user can double click on *.ats file to open it
Earlier release 3.2.3.12
  • 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
Earlier release 3.2.3.11
  • 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
Earlier release 3.2.3.10
  • Various bug fixes
Earlier release 3.2.3.7
  • Added post chages button to table browser
  • Added Optimize Column Width button
  • Fixed number of problems related to working data groupper
Earlier release 3.2.3.6
  • Fixed number of problems related to working with InList and Lookup functions
Earlier release 3.2.3.5
  • Fixed number of problems related to working with uniqueidentifierfileds in SQL Server
Earlier release 3.2.3.4
  • Addressed number of problems related to working with uniqueidentifierfileds in SQL Server
  • Fixed bug loading zero length files
Earlier release 3.2.3.2
  • Fixed some data sorting bugs
Earlier release 3.2.3.1
  • New Reader parameter: Source File Creation Date
  • Various bug fixes
Earlier release 3.2.3.0
  • upport for SQL Server Compact Edition was introduced
  • Various bug fixes
Earlier release 3.2.2.16
  • Fixed some Issues with SQLite
Earlier release 3.2.2.15
  • Calculation was not showing result correctly in preview mode
Earlier release 3.2.2.13
  • Corrected problem with duplicated source fields
Earlier release 3.2.2.11
  • Various bugs fixes
Earlier release 3.2.2.5
  • Major update
  • Calculations and scripting language changes
  • Syntax is slightly different now
  • 1 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])
  • 2 use single quotes instead of double quotes
  • eg GetSystemVariable('SYSTEM_DATE') GetSystemVariable("SYSTEM_DATE")
  • 3 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
Earlier release 3.2.2.4
  • MD5 transfornation function was added
  • Scripting language was extended
  • Various Excel related bug fixes
  • Documentation update
Earlier release 3.2.2.3
  • Works correctly with mixed case objects in PostgreSQL
  • Scripting language was extended
  • Various bug fixes
  • Documentation update
Earlier release 3.2.2.2
  • Data grid grouping access violations fixes
  • Send email to support fixed
Earlier release 3.2.2.1
  • 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
Earlier release 3.2.1.1
  • Supports multiple text line delimiters now
Earlier release 3.2.1.0
  • 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
Earlier release 3.2.0.10
  • Various bug fixes
Earlier release 3.2.0.8
  • 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
Earlier release 3.2.0.7
  • 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
Earlier release 3.2.0.3
  • Various Excel related bugs fixes
Earlier release 3.2.0.0
  • 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
Earlier release 3.1.0.9
  • Various interface improvements
  • Various access violations were fixed
  • Problem with duplicated fields was resolved
Earlier release 3.1.0.8
  • Various access violations were fixed
  • Problem with duplicated fields was resolved
Earlier release 3.1.0.7
  • Various interface improvements
  • Popup menu was added to data grouper.
  • New options for unpivot and pivot data transformation object
  • Documentation update
  • Various bug fixes
Earlier release 3.1.0.5
  • Some problems were addressed related to loading data into varchar(max),nvarchar(max),varbinary(max)
Earlier release 3.1.0.3
  • Various bug fixes
Earlier release 3.1.0.1
  • Support for SQL Server 2005/2008 was improved
Earlier release 3.1.0.0
  • 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
Earlier release 2.4.3.4
  • 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
Earlier release 2.4.3.3
  • Various bug fixes
  • Documentation Update
Earlier release 2.4.3.2
  • Now you can use Advanced ETL Processor to generate SQL Insert Scripts from any table
Earlier release 2.4.3.1
  • Support for Ole Db was Introduced
  • InList and Lookup ETL objects bugs were fixed
  • Support for text files footer and header was added
  • New tab was added to data reader properties dialog called "Data reading restrictions"
  • Documentation update
Earlier release 2.4.2.11
  • 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'}
Earlier release 2.4.2.6
  • Support for MySQL, PostgreSQL and Interbase/Firebird
  • Updated sequence transformation object
  • Running totals
  • Updated documentation
  • Minor bug fixes
Earlier release 2.4.0.15
  • Minor bug fixes
Earlier release 2.4.0.13
  • you can use
  • for default vaues
  • for example Bad date
  • will expand into Bad date 014200
  • Minor bug fixes
Earlier release 2.4.0.12
  • Some spelling errors were corrected
  • Minor bug fixes
Earlier release 2.4.0.11
  • ODBC 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

Need help with an upgrade?

If you are upgrading an older repository, review the repository update notes and test the upgrade on a copy first.