Advanced ETL Processor 3.7.8.14

Advertisements

Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. A unique technology called "What You See Is What You Load" saves a lot of time during testing and design of validation and transformation processes. It shows you how the data will be transformed and loaded into the data warehouse or database without actually loading it. At any time, you can press the "Preview" button and see what the results of an ETL flow would look like.

Advanced ETL Processor can help you extract data from an Excel file, validate date formats, sort data, deduplicate it and load it into the database, run stored procedure or SQL script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS, Advanced ETL Processor can also add new and update old records based on the key defined by user.

Advanced ETL Processor works directly with Excel, MS Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL, SQLite, QVD, QVX, Salesforce, Brightpearl,RSS Google Spreadsheets or any ODBC compliant database.

Another benefit of using Advanced ETL Processor its unique ability to load data from multiple files or even tables using mask

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

User's rating:

  • Currently 1.00/5
  • 1
  • 2
  • 3
  • 4
  • 5
Enlarge the screenshot of Advanced ETL Processor
[ Enlarge Image ]

Download alternate to Advanced ETL Processor solution

Look at the free or trial alternatives and similar apps to Advanced ETL Processor software by the tags. It's possible also to find substitutes for the most popular titles in the Software Development category.

| Sql Loader | Powerful Etl Tool | Oracle | Odbc | Ms Sql Server | Extract Transform Load | Data Transformation | Business Automation | Bcp |

History updates (Complete changelogs since the listing on this site)

3.7.8.14 [10-26-14]

+ Added two new fields to File Sytem datasource last modification date and last access date
+ Minor interface improvements

Other versions : 3.7.8.12 3.7.8.6 3.7.8.4 3.7.8.2 3.7.7.10 3.7.7.7 3.7.7.0 3.7.6.10 3.7.6.6 3.7.6.2 3.7.5.24 3.7.5.20 3.7.5.19 3.7.5.18 3.7.5.15 3.7.5.14 3.7.5.0 3.7.1.5 3.7.1.2 3.7.0.9 3.7.0.7 3.7.0.3 3.6.3.3 3.6.2.8 3.6.2.0 3.6.1.3 3.6.0.0 3.5.1.4 3.5.1.3 3.5.1.0 3.5.0.0 3.4.4.3 3.4.4.0 3.4.3.7 3.4.3.6 3.4.2.1 3.4.1.0 3.4.0.3 3.4.0.0 3.3.1.0 3.3.0.11 3.3.0.9 3.3.0.1 3.3.0.0 3.2.7.2 3.2.7.0 3.2.6.7 3.2.6.2 3.2.5.10 3.2.5.9 3.2.5.6 3.2.5.3 3.2.5.0 3.2.4.2 3.2.4.1 3.2.4.0 3.2.3.11 3.2.3.8 3.2.3.6 3.2.3.3 3.2.3.1 3.2.3.0 3.2.2.14 3.2.2.10 3.2.2.3 3.2.2.1 3.2.1.1 3.2.0.8 3.2.0.0 3.1.0.9 3.1.0.7 3.1.0.5 3.1.0.4 3.1.0.3 3.1.0.2 3.1.0.1 3.1.0.0 2.4.3.5 2.4.3.4 2.4.3.3 2.4.3.0 2.4.2.12 2.4.2.11 2.4.2.10 2.4.2.8 2.4.2.6 2.4.2.4 2.4.2.0 2.4.0.14 2.4.0.7 2.4.0.2 2.3.0.6 2.3.0

v3.7.8.12 [10-12-14]

+ Added Is Null or Empty string validation function
+ Added If Null or Empty string transformation function
+ Documentation Update
- Mapping editor bug fixes
- Addressed CASE transformation issues

v3.7.8.6 [09-15-14]

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

v3.7.8.4 [08-28-14]

- Addressed issues with BIGINT fields
- Addressed issues with Get Excel Cell Value transformation function
- Addressed issues with copy paste functionality

v3.7.8.2 [08-14-14]

+ Support for Sending SMS messages was introduced
+ Documentation Update
- Date Format bugs fixes
- Addressed problem with keep characters functions

v3.7.7.10 [07-30-14]

+ Added CASE transformation function
+ Added Delete Leading Characters
+ Added Delete Trailing Characters
+ Added support for special characters
+ Interface improvements
+ Documentation Update

v3.7.7.7 [07-16-14]

+ Excel processing engine update
+ Extended functionality of Get Excel Cell Value and Get File Context functions
+ Documentation update
- Addressed issues with Undo Redo buttons
- Addressed excel' files locking problems

v3.7.7.0 [06-17-14]

+ Renamed Web Service Lookup to HTTP Post
+ Added HTTP Get Transformation function
+ Documentation Update
+ up to 10 times faster data sorting
- Web Service Lookup issues were addressed

v3.7.6.10 [06-01-14]

- Addressed issues of loading data from the files with old creation date

v3.7.6.6 [03-28-14]

+ Up to 5 percent performance increase
- MySQL date processing bugs fixes
- Addressed union object issues

v3.7.6.2 [03-11-14]

+ Added sub transformation object
+ Added option to set defaults
+ Added option to filter target fields
- Addressed union object issues
- Fixed Copy/Paste problems with Sub Transformation object
- Addressed issues of loading data from Excel files
- Addressed some sqlite issues

v3.7.5.24 [02-09-14]

+ Added option to set defaults
+ Added option to filter target fields
- Addressed some sqlite issues
- Addressed issues with day of the week checking
- Addressed issues with loading data into MySQL

v3.7.5.20 [01-20-14]

+ Updated regular expression for US SSN

v3.7.5.19 [01-07-14]

- Addressed issues of loading data from flat files

v3.7.5.18 [12-24-13]

+ 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

v3.7.5.15 [12-10-13]

- Addressed issues of loading data from flat files

v3.7.5.14 [11-30-13]

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

v3.7.5.0 [11-10-13]

+ Salesforce is supported as datatarget
- Addressed autoformat problems

v3.7.1.5 [06-27-13]

+ Functionality of Splitter and Get Line functions was improved
+ QVD generation bugs fixes
+ "Is Value in Database" and "If Value in Database" were added
+ Documentation update

v3.7.1.2 [06-09-13]

+ 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

v3.7.0.9 [05-08-13]

- Addressed problems with "If in List" Function

v3.7.0.7 [04-20-13]

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

v3.7.0.3 [04-04-13]

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

v3.6.3.3 [03-04-13]

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

v3.6.2.8 [02-14-13]

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

v3.6.2.0 [01-12-13]

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

v3.6.1.3 [12-16-12]

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

v3.6.0.0 [11-25-12]

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

v3.5.1.4 [10-29-12]

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

v3.5.1.3 [10-15-12]

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

v3.5.1.0 [09-16-12]

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

v3.5.0.0 [08-31-12]

+ Support for QVD files was introduced
- Various bug fixes

v3.4.4.3 [07-23-12]

- Various bug fixes

v3.4.4.0 [07-06-12]

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

v3.4.3.7 [06-26-12]

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

v3.4.3.6 [06-20-12]

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

v3.4.2.1 [05-16-12]

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

v3.4.1.0 [05-01-12]

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

v3.4.0.3 [04-06-12]

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

v3.4.0.0 [03-18-12]

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

v3.3.1.0 [02-21-12]

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

v3.3.0.11 [01-26-12]

+ Documentation update
+ First Record flag, Last Record flag, First Record flag for file/table/sheet, Last Record for file/table/sheet were added to Reader parameter data trasformation function
+ Sequence and Running total transformation function improvements
- Various bug fixes

v3.3.0.9 [01-10-12]

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

v3.3.0.1 [12-02-11]

- Various Access violation fixes

v3.3.0.0 [11-18-11]

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

v3.2.7.2 [10-23-11]

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

v3.2.7.0 [10-10-11]

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

v3.2.6.7 [09-22-11]

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

v3.2.6.2 [09-04-11]

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

v3.2.5.10 [08-08-11]

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

v3.2.5.9 [08-03-11]

Added Fields Selector transformation function
Various bug fixes

v3.2.5.6 [07-26-11]

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

v3.2.5.3 [07-11-11]

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

v3.2.5.0 [06-28-11]

Major ETL tools update

This release changes the way the Data Validator works

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

v3.2.4.2 [06-03-11]

Incremental Transformation function search was introduced

v3.2.4.1 [05-27-11]

Transformation editor Fixes
Various Bug Fixes

v3.2.4.0 [05-13-11]

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

v3.2.3.11 [04-14-11]

Script language extension:

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

v3.2.3.8 [03-31-11]

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

v3.2.3.6 [03-13-11]

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

v3.2.3.3 [02-25-11]

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

v3.2.3.1 [02-08-11]

New Reader parameter: Source File Creation Date
Various bug fixes

v3.2.3.0 [01-25-11]

Support for Sql Server Compact Edition was introduced
Various bug fixes

v3.2.2.14 [12-13-10]

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

v3.2.2.10 [11-30-10]

Major update

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

v3.2.2.3 [11-16-10]

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

v3.2.2.1 [10-23-10]

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

v3.2.1.1 [10-01-10]

Supports multiple end line delimiters now

v3.2.0.8 [09-05-10]

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

v3.2.0.0 [08-03-10]

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

v3.1.0.9 [07-30-10]

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

v3.1.0.7 [07-20-10]

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

v3.1.0.5 [06-29-10]

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

v3.1.0.4 [05-23-10]

Fixed Loading data into DBF files

v3.1.0.3 [04-27-10]

Various bug fixes

v3.1.0.2 [04-16-10]

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

v3.1.0.1 [04-10-10]

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

v3.1.0.0 [03-30-10]

Database to Email and Email to Database transformations
Transform files into blob fields and Export of blob fields
Secure Email
Improved support for blobs
Secure Email

v2.4.3.5 [03-01-10]

7 new ETL Transformation functions were added

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

Total number of Data transformation functions is now 48

Documentation Update+minor bug fixes

v2.4.3.4 [02-21-10]

7 new ETL Transformation functions were added

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

Total number of Data transformation functions is now 48

Documentation Update+minor bug fixes

v2.4.3.3 [01-31-10]

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

v2.4.3.0 [01-03-10]

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

v2.4.2.12 [12-19-09]

Minor Bug Fixes

v2.4.2.11 [12-07-09]

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

v2.4.2.10 [11-17-09]

Minor Bug Fixes

v2.4.2.8 [10-25-09]

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

v2.4.2.6 [09-15-09]

Minor bug fixes

v2.4.2.4 [08-27-09]

Minor bug fixes

v2.4.2.0 [07-19-09]

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

v2.4.0.14 [06-30-09]

Minor bug fixes

v2.4.0.7 [05-12-09]

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

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

v2.4.0.2 [04-15-09]

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

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

v2.3.0.6 [02-25-09]

Various bug fixies

v2.3.0 [12-22-08]

Updated SQL Query Builder
Support for Oracle 11g

Average review rating :

Useful independent reviews and opinions of the users

Review Advanced ETL ProcessorWrite a review « Be the first to post a review for Advanced ETL Processor download!

Predicted future versions and notices:

The doDownload.com constantly monitors the update of all programs, including information from the Advanced ETL Processor 3.7.9.0 changelog file, however sometimes it can happen that data are not complete or are outdated.We assume that author continue's to develop 3.8.0.0 version with further advanced features, and soon you will be informed. Equally important 4.0.0.0 upgrades of the program we will continue to monitor. Full Advanced ETL Processor description has been compared with the overall software database and our algorithm has found the following applications (are showed below).

Click to buy Advanced ETL Processor online

Buy now

Online shop for buying.

Download 8.32MB Advanced ETL Processor

Download Direct

(8.32MB, Extension: ZIP)