Advanced ETL Processor v.3.4.2.1

On this page

Description

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.

To free download a trial version of Advanced ETL Processor, click here
To buy software Advanced ETL Processor, click here
To visit developer homepage of Advanced ETL Processor, click here

Download Now Buy Now
Versions History
Version Date Released Release Notes
3.4.2.1 14.05.2012 + Uses 10 times less memory for large excel files + Documentation update
3.4.1.0 29.04.2012 + 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
3.4.0.3 06.04.2012 + New arithmetical functions were added Add,Subtract,Divide,Multiply,Max and Min + Documentation update
3.4.0.0 17.03.2012 + Union ALL transformation object was created + Documentation update + Support for Dynamic SQL for ETL transformations was introduced - Various bug fixes
3.3.1.0 20.02.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
3.3.0.11 25.01.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
3.3.0.9 09.01.2012 + 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
3.3.0.1 02.12.2011 - Various Access violation fixes
3.3.0.0 22.10.2011 + On win64 can now access 3 gb of memory + Support for themes + Documentation update - Text writer unicode fixes - Various bug fixes
3.2.7.0 09.10.2011 + 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
3.2.6.7 04.09.2011 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
3.2.6.2 04.09.2011 Added Support for XSLT transformations Added Get Variable, XML XSLT transformation, Validate XML function Interface Update Various bug fixes
3.2.5.10 06.08.2011 Added File name and Directory name extraction transformation functions Data splitter modifications Documentation Update Various bug fixes
3.2.5.6 26.07.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
3.2.5.0 27.06.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
3.2.4.1 26.05.2011 Transformation editor Fixes Various Bug Fixes
3.2.4.0 12.05.2011 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
3.2.3.6 12.03.2011 Fixed number of problems related to working with InList and Lookup functions Fixed number of problems related to working with uniqueidentifierfileds in sql server
3.2.3.1 08.02.2011 New Reader parameter: Source File Creation Date Various bug fixes
3.2.3.0 23.01.2011 Support for Sql Server Compact Edition was introduced Various bug fixes
Screen Shot

Click on a thumbnail for the larger image.

Advanced ETL Processor
System Requirements

Advanced ETL Processor requires WinXP, Windows2000, Windows2003, Windows Vista Ultimate, Windows Vista Ultimate x64, Win98, WinME, WinNT 4.x, Windows Vista Starter, Windows Vista Home Basic, Windows Vista Home Premium, Windows Vista Business, Windows Vista Enterprise, Windows Vista Home Basic x64, Windows Vista Home Premium x64, Windows Vista Business x64, Windows Vista Enterprise x64.

Advanced ETL Processor v.3.4.2.1 Copyright

Shareware Junction periodically updates pricing and software information of Advanced ETL Processor v.3.4.2.1 full version from the publisher using pad file and submit from users, so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft, Using crack, password, serial numbers, registration codes, key generators, cd key, hacks is illegal and prevent future development of Advanced ETL Processor v.3.4.2.1 Edition. Download links are directly from our publisher sites. Links Advanced ETL Processor v.3.4.2.1 from Bittorrent, mediafire.com, uploadfiles.com, hotfiles.com rapidshare.com, megaupload.com, netload.in, storage.to, depositfiles.com and other files hosting are not allowed. The download file is obtained directly from the publisher, not from any Peer to Peer file sharing applications such as Shareaza, Limewire, Kazaa, Imesh, eDonkey, eMule, Ares, BearShare, Overnet, Morpheus, BitTorrent Azureus and WinMX.

Review This Software
Your Name:
Rating:
Comment:
Security Code:

More Advanced ETL Processor Software

Advanced ETL Processor  v.3.4.2.1

Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database completely automatically. At any time, you can press the "Preview" button and see what the results of an ETL flow would look like.

Advanced ETL Processor Professional  v.5.3.0.2

Advanced ETL Processor Pro extracts data from any database, transforms, validates it and loads into another database completely automatically. At any time, you can press the ‘Preview' button and see what the results of an ETL flow would look like.

Advanced ETL Processor Enterprise  v.5.3.0.3

Build Complex Data warehouses and Automate Entire Business Processes, Transfer data from ANY Database into ANY Database or file,Use FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, Task scheduler and comprehensive logging.

Advanced Attachments Processor  v.1.40.81

Advanced Attachments Processor (AAP) is a software product designed to extract attachments from mail client message databases and to make an archive of the files extracted.

Advanced Mailbox Processor  v.3.0.118

Advanced Mailbox Processor (AMP) - is the program intended for extracting owners names and e-mail addresses from the local files, and making e-mails list. AMP is very effective and convenient decision for e-commerce companies.

Virdi Advanced Mail Processor  v.1.8.4.148

Virdi Advanced Mail Processor (VAMP) is an advanced and very versatile mail processor. Its main purpose is to pre-process that mail which requires standard responses.

Quicknote  v.5.5.0.55

Often you do not need an advanced text processor but a virtual scrapbook to quickly write down an occasional thought, a plan for the day or an Internet URL.

Vamp  v.4.0

Vamp is an advanced and very versatile mail processor. Its main purpose is to pre-process that mail which requires standard responses.

Coustyx  v.1 9

Coustyx integrates the Fast Multipole Method (FMM) with advanced Boundary Element Methods (BEM) for rapid solutions to Acoustic Field problems.

V-CamShow

V-CamShow is a free webcam slide show and screen saver. It enables you to watch your favourite webcams as a slide show or a screen saver. There is no limit to the number of webcams you can view. It employs an intelligent algorithm to auto-detect and

V-Mailer

V-Mailer is 32-bit command-line and batch mailer and supports SMTP authentication. It is a console application, which means that it can only be run from the DOS prompt or from inside a batch file. It willsend a message to any single email address.

Text2Web Pro

Text2Web Pro is a tool to convert text documents to html format. It incorporates integrated clipboard support which provides a seamless operation for web authors who want to include snippets of text (formatted or unformatted) into their web pages. Operate

Other products of this developer DB Software Laboratory

Active Business Intelligence Portal

Active BI Portal is business intelligence softwa...wo parts Active BI Portal Manager which works on

Active Table Editor  v.5.0.1.1

Design Data Entry Screens and Edit ANY table in ...urity roles. Easy to use and highly customizable

Active Table Editor  v.5.0.2.0

Design Data Entry Screens and Edit ANY table in ...urity roles. Easy to use and highly customizable

Advanced ETL Processor Enterprise  v.5.3.0.3

Build Complex Data warehouses and Automate Entir...Unzip, Task scheduler and comprehensive logging.

Advanced ETL Processor Professional  v.5.3.0.2

Advanced ETL Processor Pro extracts data from an...what the results of an ETL flow would look like.