Advanced ETL Processor 3.4.0.3

Free Advanced ETL Processor screenshot fileWorks with Windows Vista
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 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.
Type : Shareware ($340.00) » EULA
OS Support : Windows All + Vista
Date stamp / Size : Dec, 23. 2008 / 8517 kBytes
Asked : Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003
Users' value : - Write a Review
Download Advanced ETL Processor fileOrder Advanced ETL ProcessorImage of Advanced ETL Processor
Update history of Advanced ETL Processor
v3.4.0.3 (April, 13. 2012)
+ New arithmetical functions were added Add,Subtract,Divide,Multiply,Max and Min
+ Documentation update
v3.4.0.0 (March, 28. 2012)
+ Union ALL transformation object was created
+ Documentation update
+ Support for Dynamic SQL for ETL transformations was introduced
- Various bug fixes
v3.3.1.0 (February, 22. 2012)
+ 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 (January, 29. 2012)
+ Documentation update
+ First Record flag, Last Record flag, First Record flag for file/table/sheet, Last Record for file/table/sheet were added to Reader parameter data trasformation function
+ Sequence and Running total transformation function improvements
- Various bug fixes
v3.3.0.1 (December, 24. 2011)
- Various Access violation fixes
v3.3.0.0 (November, 29. 2011)
+ 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 (November, 7. 2011)
- "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.6.2 (September, 6. 2011)
Added Support for XSLT transformations
Added Get Variable, XML XSLT transformation, Validate XML function
Interface Update
Various bug fixes
v3.2.5.6 (August, 2. 2011)
Improved support for spaces in table names and SQL reserved words
Added clear log check box to transformation progress dialog
Added open open execution log button
Added Clone Row, Base64 Encode, Base64 Decode, GUID, Random transformation functions
Various bug fixes
v3.2.5.0 (June, 30. 2011)
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
Distribution permissions for Advanced ETL Processor
This product can be freely distributed. For futher information contact info@dbsoftlab.com
Featured Advanced ETL Processor 3.2.3.11 Vista Files

...Advanced ETL Processor Professional is a...Codeless Automation Tool. It transfers...or file. Complete automation of business processes...SMTP, File operations, SQL scripts, Zip and...Unzip, ETL Task scheduler and...files, Oracle, MS SQL Server, Interbase/Firebird, MySQL,...PostgreSQL, SQLite, MS SQL Server Compact or...

...Build Complex Data warehouses and Automate...Entire Business Processes Transfer Data...or file. Complete automation of business processes...SMTP, File operations, SQL scripts, Zip and...Unzip, ETL Task scheduler and...files, Oracle, MS SQL Server, Interbase/Firebird, MySQL,...SQLite or any ODBC compliant database. Since...

...Now You Can Load 14,347 Records A...Easy-To-Use Visual Importer ETL If you regularly...export, transform or load database data, Visual...Importer ETL is designed to...Using Visual Importer ETL Standard version 4.9.1.4,...you can load a delimited text...file into MS SQL Sever via BCP...around with your data to get it...

...Visual Importer ETL Enterprise is a...building high performance data integration solutions, Including...extraction, transformation, and load (ETL) packages for...data warehousing and business automation. Visual Importer...ETL Enterprise includes graphical...building and debugging automation packages; Plus automation...

...Data Exchange Wizard Loads...or export data from/into ANY database....files,XML, Oracle, MS SQL Server, Interbase/Firebird, MySQL,...OleDB, SQLite, MS SQL Server Compact or...ANY ODBC compliant database. Great...use and learn Data Exchange Wizard may...may also execute SQL statements before and...primary key distinguishes Data Exchange Wizard from...