QArchive.ORG Main Page
Home | Blog | Terms of service | Sign in
All Vista Win Linux Mac
Related Products

Advanced ETL Processor 3.6.0.0
Download Now
File Size: 8.3 Mb
Buy on ShareIt
Check security certificate

Advanced ETL Processor 3.6.0.0



Released:2012-11-23
License:$340.00
Publisher:DB Software Laborato ry
Language:English
Platform:Vista, Windows
Requirements:Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003,Windows2008,Win7
Install:Install and Uninstall
Downloads:1987
Recommend Advanced ETL Processor Suggest to Friend

Publisher's Description:

Advanced ETL Processor - 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.

List of Changes:

Version 3.6.0.0 from 2012-11-23

Show all changes

Version 3.5.1.4 from 2012-10-27

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

Version 3.5.1.3 from 2012-10-14

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

Version 3.5.1.0 from 2012-09-14

+ 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

Version 3.5.0.0 from 2012-08-31

+ Support for QVD files was introduced
- Various bug fixes

Version 3.4.4.3 from 2012-07-21

- Various bug fixes

Version 3.4.4.0 from 2012-07-04

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

Version 3.4.3.7 from 2012-06-25

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

Version 3.4.3.6 from 2012-06-19

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

Version 3.4.2.1 from 2012-05-14

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

Version 3.4.1.0 from 2012-04-29

+ 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

Version 3.4.0.3 from 2012-04-06

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

Version 3.4.0.0 from 2012-03-17

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

Version 3.3.1.0 from 2012-02-20

+ 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

Version 3.3.0.9 from 2012-01-09

+ 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

Version 3.3.0.1 from 2011-12-02

- Various Access violation fixes

Version 3.2.7.2 from 2011-10-22

- "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

Version 3.2.7.0 from 2011-10-09

+ 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

Version 3.2.6.2 from 2011-09-04

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

Version 3.2.5.10 from 2011-08-06

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

Version 3.2.4.0 from 2011-05-12

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

Version 3.2.3.6 from 2011-03-12

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

Version 3.2.3.3 from 2011-02-25

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

Version 3.2.3.1 from 2011-02-08

New Reader parameter: Source File Creation Date
Various bug fixes

Version 3.2.3.0 from 2011-01-23

Support for Sql Server Compact Edition was introduced
Various bug fixes

Version 3.2.2.3 from 2010-11-14

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

Version 3.2.2.1 from 2010-10-21

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

Version 3.2.1.1 from 2010-09-27

Supports multiple end line delimiters now

Version 3.2.0.8 from 2010-08-22

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

Version 3.2.0.0 from 2010-08-01

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

Version 3.1.0.8 from 2010-07-22

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

Version 3.1.0.7 from 2010-07-17

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

Version 3.1.0.6 from 2010-07-12

Various bugs were fixed

Version 3.1.0.5 from 2010-06-27

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

Version 3.1.0.4 from 2010-05-21

Fixed Loading data into DBF files

Version 2.4.3.3 from 2010-01-16

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

Version 2.4.3.1 from 2010-01-06

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

Version 2.4.3.0 from 2010-01-03

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

Version 2.4.2.8 from 2009-10-25

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

Version 2.4.2.7 from 2009-09-18

Lookup object supports working with oracle now
Documentation Update

Version 2.4.2.4 from 2009-08-16

Minor bug fixes

Version 2.4.2.2 from 2009-08-03

Updated documentation
Minor bug fixes

Version 2.4.2.1 from 2009-07-24

Updated sequence transformation obejct
Running totals
Updated documentation
Minrbug fixes

Version 2.4.2.0 from 2009-07-12

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

Version 2.4.1.0 from 2009-07-05

We are proud to announce that Advanced ETL Processor Standard version 2.4.1.0
In this version we added support for MySql databases.
Rest of the products to follow.

We also working on adding support for PostgreSQL and Interbase/Firebird

Version 2.4.0.2 from 2009-04-13

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

Version 2.3.0.6 from 2009-02-08

Various bug fixies

Version 2.3.0 from 2008-12-07

Updated SQL Query Builder
Support for Oracle 11g

Version 2.2.9 from 2008-07-11

Various bug fixes and performance improvements
 

Download Now
File Size: 8.3 Mb
Buy on ShareIt
Check security certificate

Share |


Text link code :
Hyper link code:
UBB/BLOG code:

Download Now
File Size: 8.3 Mb
Buy on ShareIt
Check security certificate



Search