Advanced ETL Processor v.3.4.1.0

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.

Move data between any database automatically. 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.

etl, powerful etl tool, oracle, ms sql server, bcp, sql loader, odbc, data transformation, extract transform load, business automation

 
  • Advanced ETL Processor
  • 3.4.1.0
  • 29 Apr 12
  • DB Software Laboratory
  • WinXP, Windows2000, Windows2003, Windows Vista, Win98, WinME, WinNT 4.x
  •  
  • Shareware
  • 8.32 Mb
  • 126
  • $340.00
Advanced ETL Processor - Move data between any database automatically
View screenshot
 
 
Latest Versions History
Version Date Released Release Notes
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.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.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.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.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.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.4.1 26.05.2011 Transformation editor Fixes 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
 
 

Review Advanced ETL Processor

  • captcha
 

Other software of DB Software Laboratory
  • Active Business Intelligence Portal  v.3.2.0Active BI Portal is business intelligence software that provides an integrated solution for designing and deploying reports and web forms over the internet and intranet. Active BI Portal works with all major commercial and open source databases.
  • Active Table Editor  v.5.0.2.0Design Data Entry Screens and Edit ANY table in ANY Database with ease. Control what users can edit and see. Design menus, Input forms, define security roles. Easy to use and highly customizable
  • Advanced ETL Processor Enterprise  v.5.3.0.3Build 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.

New Database Management software
  • DB2ToAccess  v.1.6DB2ToAccess - Export DB2 data to Access easy and quickly. Main features: 1. Easy visual configuration. 2.Exports from both table and query. 3. Displays progress through time estimation. 4 Wizard, Step by step.
  • Advanced ETL Processor Enterprise  v.5.3.0.3Build 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.