NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

History


8.3.8.17

+ Added support for dinamic file names in attachments
+ Up to 5 percent faster now

8.3.8.14

+ Up to 5 percent performance increase

8.3.8.12

- MySQL date preocessing bugs fixes
- Addressed some copy/paste issues

8.3.8.11

- Minor bugs fixes

8.3.8.10

+ Added library of objects

8.3.8.9

- Addressed issues of empty date fields

8.3.8.8

- Addressed issues of loading data from Excel files

8.3.8.7

+ Added snap to grid option
+ Added RichText object to the Report Designer
+ Addded Data Port option to FTP Connection

8.3.8.4

- Addressed issues with sending emails

8.3.8.1

+ Added following variables





+ Documentation Update
+ Extended functionality of send email action
- Addressed issues with loading data into MySQL

8.3.8.0

- Addressed some FTP Package dialogue issues

8.3.7.27

- Addressed issues of loading data from flat files

8.3.7.25

- Addressed issues with long object names

8.3.7.24

+ HTTP Form package object was introduced
+ Documentation update
+ ,, system variables we added

8.3.7.23

- Corrected issues with FTP automation

8.3.7.22

- Addressed issues with auto-save functionality

8.3.7.21

+ Progress dialogue shows now execution log as well
+ Progress dialogue has option to clear log first
+ Support for Zoom in/Out was introduced
+ Better printing support
- Email processing bug fixes

8.3.7.20

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

8.3.7.19

- Addressed issues of loading data from flat files

8.3.7.17

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

8.3.7.15

+ Better handling of large Salesforce tables
+ Support for multiple Salesforce environments was introduced
+ Emails are send as HTML now
- Addressed issues with updating data

8.3.7.14

- QVD reading bug fixes

8.3.7.13

+ Incremental Object search works with comments and connections now
+ Better handling of empty Salesforce tables
+ Support for GreenPlum was introduced

8.3.7.12

+ Added ability to hide tabs on main screen
+ 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

8.3.7.10

+ Added option to resize objects selector

8.3.7.9

+ Added search functionality to package editor
- Salesforce bug's fixes

8.3.7.7

+ Better source connection errors handling

8.3.7.6

+ Extended Global variables scope
- Salesforce bug's fixes
- Fixed problem with zip files locking
- Resolved Synchronization problem

8.3.7.5

- Fixed data preview screen
- Addressed issues with loading data from Salesforce
- Addressed issues with loading data into NTEXT fields

8.3.7.4

+ 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

8.3.7.2

- Addressed problem with ping object

8.3.7.1

+ Minor Interface improovments
- Addressed problems with excel date formatting

8.3.7.0

- Addressed problems with SalesForce connection
+ Documentation update

8.3.6.12

- Addressed problems with formating dates

8.3.6.11

+ 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

8.3.6.6

+ Up to 10 percent performance increase
+ Up to 3 times faster comparing to version 8.3.5.0

8.3.6.4

+ Up to 100 percent performance increase

8.3.6.3

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

8.3.6.2

+ Global Variables (very useful for switching from development to production)
+ Further 10 percent performance increase for loading data from text files
+ Documentation update
- Various bug fixes and interface improvements

8.3.6.1

Another performance boost

+ Up to 50 percent increase for loading data via OleDB
+ Up to 40 percent increase when using stored procedures for loading the data
- Various bug fixes and interface improvements

8.3.6.0

Massive performance boost

+ ODBC to SQL Server up to 48.51%
+ Text to ORACLE via Conventional Path Loading up to 27.10%
+ Text to ORACLE via Direct Path Loading up to 34.99%
+ Text to PostgreSQL up to 32.60%
+ Text to SQL Server via BCP up to 33.89%
+ Package Objects Selector is movable and resizeable now
- Various bug fixes and interface improvements

8.3.5.12

- Various bug fixes and interface improvements

8.3.5.9

Massive performance boost:

+ 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

+ Multiple files decompression was introduced
+ File Rename with mask was introduced
- Undo/Redo bugs were fixes
- New object creation bugs were fixed

8.3.5.6

+ QVD generation bugs fixes
+ Added option to save scripts without opening them

8.3.5.3

+ Option to schedule execution on the last/first day of the month was added
+ Documentation update

8.3.5.2

+ Connection mapping dialogue was added to repository synchronisation wizard

8.3.5.1

+ Data reader timeout was introduced for ODBC,Access,MS Sql Server, OleDB, PostgreSQl, MySQl and MS Sql Server CE connections

8.3.5.0

+ Smaller executable
+ Memory usage was reduced for Excel files (50-25 percent less)
+ Added ObjectId label to data target properties dialogue
- Various bug fixes and interface improvements

8.3.4.9

- Addressed Repository Synchronization wizard bugs

8.3.4.8

- Various bug fixes

8.3.4.6

+ Introduced Repository Synchronization wizard

8.3.4.5

+ Addressed problems with updating Oracle blob fields

8.3.4.3

+ Undo/Redo Functionality was improoved
+ Documentation update

8.3.4.2

+ Various bug fixes
+ Documentation update

8.3.4.1

+ Documentation update
- Addressed some regular expressions bugs

8.3.3.8

+ Added support to Redo and Undo to package designer
+ Added Register option to help menu
+ Various bug fixes and interface improvements

8.3.3.5

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

8.3.3.2

+ Added align left, align top, align right, and align bottom buttons
+ Better object selection for packages
+ Various bug fixes and interface improvements

8.3.2.11

+ Support for PGP was introduced
- Various bug fixes

8.3.2.10

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

8.3.2.6

+ Improved support for MS SQL Server 2012
+ Improved support for BDE
+ Logging improvements for Connection type, connection name and connection details
+ Executable is smaller now
+ Support for Excel 2013 was itroduced
- Agent bug fixes
- Various bug fixes

8.3.2.2

+ New function was introduced ExecuteObject(ObjectId)
+ Documentation update
- Various bug fixes

8.3.2.0

+ Support for BDE was introduced
+ Documentation update
- Various bug fixes

8.3.1.4

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

8.3.1.0

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

8.3.0.0

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

8.2.0.4

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

8.2.0.2

- Repository Scripts fix
- Various bug fixes

8.2.0.0

+ Support for QVD files was introduced
- Various bug fixes

8.1.2.3

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

8.1.2.1

+ New package object was introduced = Case
+ New variables ,,'
- Various bug fixes

8.1.1.2

- Various bug fixes

8.1.1.0

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

8.1.0.0

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

8.0.3.2

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

8.0.3.1

+ 10x performance increase for generating QVX files
- Addressed some issues related to working scheduler
- Various bug fixes

8.0.2.6

- Addressed some SMTP problems

8.0.2.1

+ Support for Dynamic SQL for ETL transformations was introduced

8.0.1.5

- Addressed some issues related to working with integrated scheduler

8.0.1.4

- Addressed some issues related to working with MS Sql Server Compact edition

8.0.1.2

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

8.0.1.1

+ Timeout was added to sql scripts

8.0.1.0

+ Support for decompression of following file formats was introduced:

Zip archive *.zip;*.jar;*.ear;*.war;*.cbz;*.apk;*.wsz;*.wal;*.xpi;*.crx;*.dfsz;*.pcv;*.bsz;*.mskin;*.wmz;*.ipa;*.docx;*.xlsx;*.pptx;*.sxw;*.sxi;*.sxt;*.sxd;*.sxc;*.sxm;*.sxg;*.stw;*.sti;*.std;*.stc;*.odh;*.odd;*.odt;*.odm;*.ods;*.ots;*.odg;*.otg;*.odp;*.otp;*.odf;*.odb
BZip2 archive *.bz2;*.bzip2;*.tbz2;*.tbz
Rar archive *.rar;*.r00;*.cbr
Arj archive *.arj
Z archive *.z;*.taz
Lzh archive *.lzh;*.lha
7z archive *.7z
Cab archive *.cab;*.fwp
Nsis archive *.nsis
Lzma archive *.lzma
Lzma86 archive *.lzma86
Pe archive *.exe;*.dll;*.sys;*.bpl
Elf archive *.
Mach-O archive *.
Udf archive *.iso;*.img
Xar archive *.xar;*.safariextz
Mub archive *.
Hfs archive *.hfs
Dmg archive *.dmg
Compound archive *.msi;*.msp;*.doc;*.xls;*.ppt
Wim archive *.wim;*.swm
Iso archive *.iso;*.img
Chm archive *.chm;*.chi;*.chq;*.chw;*.hxs;*.hxi;*.hxr;*.hxq;*.hxw;*.lit
Split archive *.001
Rpm archive *.rpm
Deb archive *.deb
Cpio archive *.cpio
Tar archive *.tar
GZip archive *.gz;*.gzip;*.tgz;*.tpz
Ntfs archive *.ntfs;*.img
Fat archive *.fat;*.img
Mbr archive *.mbr
Vhd archive *.vhd
MsLZ archive *.
Flv archive *.flv
Swf archive *.swf
Swf archive *.swf
APM archive *.
PPMD archive *.pmd
Terse Executable *.te
UEFIc archive *.scap
UEFIs archive *.
SquashFS archive *.squashfs
CramFS archive *.cramfs

+ Support for compression of following file formats was introduced:

Zip archive *.zip;*.jar;*.ear;*.war;*.cbz;*.apk;*.wsz;*.wal;*.xpi;*.crx;*.dfsz;*.pcv;*.bsz;*.mskin;*.wmz;*.ipa;*.docx;*.xlsx;*.pptx;*.sxw;*.sxi;*.sxt;*.sxd;*.sxc;*.sxm;*.sxg;*.stw;*.sti;*.std;*.stc;*.odh;*.odd;*.odt;*.odm;*.ods;*.ots;*.odg;*.otg;*.odp;*.otp;*.odf;*.odb
BZip2 archive *.bz2;*.bzip2;*.tbz2;*.tbz
7z archive *.7z
Tar archive *.tar
GZip archive *.gz;*.gzip;*.tgz;*.tpz
Swf archive *.swf

+ ZIP dialog can decompress and compress files now
+ Order of fields was charged in connection dialog: user selects server name, enters the user name and password and finally user selects the database.
+ Even smaller executable now
- SMTP testing was fixed for SSL connection
- Export Dialog alignment problem was corrected
- Main windows alignment problem was corrected
- Position saving problem was addressed for validator/transformer/package editor
- Corrected some repository creation scripts

8.0.0.2

MAJOR RELEASE

+ New repository structure compatible with Database browser,
+ Advanced ETL Processor and Active Table Editor
+ Mutiple SMTP, POP3, and FTP connections
+ Design and Generate Reports
+ Projects
+ Easy agent management
+ Package Debugging
+ Highly optimised code
+ Schedule for execution Packages, Transformations and SQL scripts






+ CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,Whirlpool checksums
+ Simplified Repository management
+ Execution log has Execution time percentage
+ Schedule package execution directly from the package designer
+ Same for sql scripts and data transformations
+ Schedule for execution on specific computer
+ Schedule for execution using agent only as option
+ Easy agent management
+ Simplified Repository management
+ Agent status logging and current agent tasks grid
+ Documentation update
+ Support for themes
+ Open Excel/text/access files from Visual Importer ETL
- Various bugs fixes and improvements

7.7.8.4

+ Package debugger was introduced
+ Breakpoints were introduced
+ Execute single package object option was introduced
+ More generic log viewer
+ Execution agent writes startup error messages in the log file
- Disaprearing tree nodes problem was addressed
- Minor interface tweaks

7.7.8.2

- Double atachment fix

7.7.8.1

+ Support for variables in inport was introduced
+ Better error handling for datasource

7.7.8.0

+ Support for MySQL 5.5 was introduced
+ Interface Improvements
+ Command line parameter transformation function
+ Standard print preview
+ Support for scrolling in Package editor
- Boolean fix for MySql
- Better error handling for ADO and MS Sql scripts

7.7.7.23

Addressed some issues related to processing emails

7.7.7.22

Added pause package execution object

7.7.7.21

Fixed bugs related to working with time fields in MySQL
Export into excel via DDE was introduced

7.7.7.20

Added Support for XSLT transformations
Various bug fixes

7.7.7.16

Ping Server and Check Database connection was introduced
It is also possible to schedule package for execution directly from the package designer
Various bug fixes

7.7.7.15

Data Transformation Package can be run every second now

7.7.7.14

Data import wizard fixes
Import Script can get variables values from packages now

7.7.7.13

Added "Search in subdirectories" option to data reader

7.7.7.12

Fixed number of issues related to loading data from XML file

7.7.7.11

Package editor interface improvements

7.7.7.10

Clear log shows dialog box first
Direct Latest Version downloads from application
Various Bug Fixes

7.7.7.9

Get latest version menu item was added
Support for utf-16 was introduced for XML data reader
Various bug fixes

7.7.7.8

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

7.7.7.7

Fixed number of problems related to working with uniqueidentifierfileds in sql server
Added post changes button
Added Optimize Column Width button for all grids
Some corrections for German Locale were introduced

7.7.7.6

Addressed sftp host key not verified problem

7.7.7.5

Addressed number of problems related to working with uniqueidentifier fields in SQL Server
Fixed bug loading zero length files
Various bugs fixes

7.7.7.4

SFTP bugs fixes

7.7.7.3

Support for MS SQL Server Compact Edition was introduced
Calculations Enhancements
Various bugs fixes

7.7.7.2

Fixed Issues with SQLite imports
Support for zip files > 4 gigs was introduced

7.7.7.0

Support for SFTP was introduced
Various problems related to working with very large files were resolved

7.7.6.8

Various bugs fixes
Repository creation wizard was introduced

7.7.6.6

Problem with null dates was resolved

7.7.6.5

Majour 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 in order to make conversion easier we have added new menu item
"Correct calculations"

4 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

7.7.6.3

MD5 Function was introduced
Various bug fixes

7.7.6.2

Works correctly with mixed case objects in PostgreSQL
Various bug fixes

7.7.6.1

Data grid grouping access violations fixes
Send email to support fixed

7.7.6.0

Loads Data from XML files
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

7.7.5.18

Loads data into PostgreSQL 9.0
Improved Unicode support for Oracle connections
Title menu in data grids was added
Various Data transformation improvements

7.7.5.17

Supports multiple newline delimiters now

7.7.5.16

Memory leaks fixes

7.7.5.15

Works directly with SQLite now
New look and feel
Various Interbase/Firebird related bug fixes
Fixed bug with import of MS Access tables with spaces in names

7.7.5.14

Various bug fixes

7.7.5.12

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
Data grids modifications:
Grouping panel was added
Advanced filter dialog was introduced
Record number
New look and feel
Also:
Table browser loads data much faster
Sql browser loads data much faster
Log screen loads much faster
Various Access violation and bug fixes

7.7.5.11

Various interface improvements
Various access violations were fixed
Problem with duplicated fields was resolved
Application loads much faster now
Large repositories are updated much faster now

7.7.5.9

HTTP Downloads and ETL Package scripts were introduced
System Variables
Documentation Update
Some problems were addressed related to loading data into varchar(max),nvarchar(max),varbinary(max)

7.7.5.7

New button was added to data transformation log
Show first 100 records

7.7.5.6

Various bug fixes

7.7.5.4

Support for SQL Server 2005/2008 was improved

7.7.5.3

Improved support for blobs.
Various bug fixes

7.7.5.1

Fields Notes were added

7.7.5.0

Support for FTPS and FTPES was introduced
Support for Ole Db was added
Minor bug fixes


7.7.4.18

New tab was added to data source properties dialog called "Data reading restrictions"
Find Object dialog was added
Minor bug fixes

7.7.4.17

Various bug fixes

7.7.4.14

Repository Synchronization bugs were fixed
Support for MySql, Intebase and PostgreSql was added to Sql Check Data
Package copy paste bug was fixed
Minor bug fixes

7.7.4.10

Added GetSystemVariable("OUTPUT_RECORDNUMBER")
Aded new calculation function DateDiffS
DecDateS(Date1,Format1, Date2,Format2,Type):String.
Use DateDiffS to calculate Type difference between two dates.
Documentation update

7.7.4.6

Data Export Wizard was introduced
Now you can export 3000+ tables from the database with couple of clicks

7.7.4.5

Two new package objects Show message and Ask question
Additional option of Ftp object Passive/Active
various bugs fixes

7.7.4.4

Support for MySql, PostgreSQL and Interbase was added

7.7.2.9

Minor bug fixes

7.7.2.8

FTP Move files option was added
Move files has "Overwrite files" option now
Minor bug fixes

7.7.2.7

Some spelling errors were corrected
FTP Directory Listing is tab delimited now
Minor bug fixes

7.7.2.6

ODBC Connection String Builder Was Introduces
Support for FTP Directory Listing
Improved support for NonStop ODBC/MX 2.0 ver 3.51.20.126 ODBC Driver
Various Cosmetic Changes and Bug Fixes

7.7.2.5

Automatic Version check was introduced
Various bug fixes
"In my personal view, currently there are no other data transformation tools on the market that provide the same value for money as Advanced ETL Processor. The number of features is constantly increasing and If something is missing the will add it for you  ..."

Gabriell Mellotto, Senior ETL Consultant

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
xerox
Databases we work with