Advanced ETL Processor 2.2.4

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.The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database.If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Latest release downloads Databases&Tools

This trends management program handles field data from one or more acquisition systems, or internal performance data from servers. It manages any kind of periodically updated value in a database, which can be reached by SQL query. ...

Version: 4.20 | Release date: Nov 09, 2002 | USD$259 | Licence: Shareware

icon

Downloads: 30
Date added: Jan 25, 2008
Date updated: May 20, 2008
Details

Show Classic Menus and Toolbars on the Ribbon of Microsoft Access 2007. Supports all languages that are supported by Microsoft Access 2007. ...

Version: 3.00 | Release date: Jun 07, 2007 | USD$15.99 | Licence: Shareware

icon

Downloads: 36
Date added: Apr 10, 2008
Date updated: May 23, 2008
Details

Database Workshop is a professional multifunctional tool for working with databases and database objects. It uses the modern plug-in module technology that combines flexibility and versatility for working with various databases. ...

Version: 5.56 | Release date: Jul 12, 2004 | USD$69 | Licence: Shareware

icon

Downloads: 22
Date added: Jan 16, 2008
Date updated: May 20, 2008
Details

FMP makes it easy to manage preventive and repair maintenance on your fleet. FMP alerts you when PM is due, provides user-definable PM schedules, generates a fleet history, monitors operating costs, and tracks repairs, fuel, vendors, and drivers. ...

Version: 11.0.0.2 | Release date: May 16, 2008 | USD$399.00 | Licence: Shareware

icon

Downloads: 30
Date added: Jan 14, 2008
Date updated: May 20, 2008
Details

Find content differences between two tables in a MS Access database. In addition to this comparison, selectively create a new table based on the differences. Access 2000 or higher required. ...

Version: 7.0 | Release date: Dec 05, 2006 | USD$19.99 | Licence: Shareware

icon

Downloads: 16
Date added: Jan 16, 2008
Date updated: May 20, 2008
Details

Horizontally merge two MS Access tables into one by a common column (field) of data. The two tables can be located in the same Access file or two different Access files. Access 2000 or higher required. ...

Version: 7.0 | Release date: Sep 03, 2006 | USD$19.99 | Licence: Shareware

icon

Downloads: 20
Date added: Jan 16, 2008
Date updated: May 20, 2008
Details

A powerful MySQL development add-in for Visual Studio .NET. It integrates into Visual Studio, making all database development and administration tasks available from your favorite IDE. ...

Version: 2.10 | Release date: Oct 04, 2007 | USD$69.95 | Licence: Shareware

icon

Downloads: 26
Date added: Jan 16, 2008
Date updated: May 20, 2008
Details

Export Query for Microsoft SQL Server helps to save query results to Excel spreadsheet. The program has easy to use and to learn wizard interface. All modersn versions of Microsoft SQL Server and all versions of Microsoft Excel are supported. ...

Version: 1.04.20 | Release date: Jan 05, 2008 | USD$45 | Licence: Demo

icon

Downloads: 14
Date added: Jan 16, 2008
Date updated: May 20, 2008
Details

Export Query for Oracle Server helps to save a query results to text file. The program supports delimited or fixed length formats. Export utility has easy to learn and to use wizard interface. All modern versions of Oracle Server are supported. ...

Version: 1.04.20 | Release date: Jan 05, 2008 | USD$49 | Licence: Demo

icon

Downloads: 18
Date added: Jan 16, 2008
Date updated: May 20, 2008
Details

Visual development system intended for database design, modeling, creation, modification and reverse engineering in an easy and powerful way. Accelerates the process of database creation and makes it clear, simplifies MySQL database maintenance. ...

Version: 1.9.6 | Release date: Jan 23, 2008 | USD$124.95 | Licence: Shareware

icon

Downloads: 22
Date added: Jan 15, 2008
Date updated: May 20, 2008
Details

NEVER AGAIN RE-KEY LEGACY DATA: Reads most files including XML, page image print files from other processes, fixed format, delimited, dBase, structured binary etc. ASCII or EBCDIC. Exports as various formats. Parse from/to clipboard. ...

Version: 2.0f | Release date: Jul 22, 2004 | USD$49.95 | Licence: Shareware

icon

Downloads: 19
Date added: Jan 16, 2008
Date updated: May 20, 2008
Details

Advanced interactive search replace directly in database tables with patterns, fuzzy and sounds-like matching,trim leading and trailing blanks and binary characters,correct capitalization,code your own transform in VBScript or JScript and heaps more ...

Version: 3.7 | Release date: Aug 07, 2007 | USD$495 | Licence: Shareware

icon

Downloads: 21
Date added: Jan 16, 2008
Date updated: May 20, 2008
Details

German English French Italian Dutch Spanish Romanian