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.
Visual Defrag
(Popularity: ) : Defragmenting your databases is easy with Visual Defrag. Visual Defrag analyzes all the tables in each of the databases on ... MSSQL-to-MySQL
(Popularity: ) : MSSQL-to-MySQL is a program to move MS SQL databases to MySQL server. All MS SQL data types and attributes are ... Data Browser
(Popularity: ) : This Easy to use tool allows user to connect to any database and browse or modify data ,run sql scripts, ... A Simple Contact Manager
(Popularity: ) : Perhaps the world's most powerful contact management system. With iPod integration, Automatic contact verification, Instant Messenger, Outlook Integration, Mailing Labels, ... Memory Database System Demo
(Popularity: ) : This demo shows you the performance of the memory database system of the database engine developed by MemDB. Info-Pack.com CSV2XML
(Popularity: ) : Info-Pack.com CSV 2 XML is a csv file to XML file converter.
Use it to convert your comma separated files ... DEWizardX
(Popularity: ) : This ActiveX helps you to load and export data from/into various datasources such as delimited and fixed width files or ... Key Control
(Popularity: ) : Keep your assets under control. At a glance you will know which employees have been assigned assets. Generate reports, document ... musiGuide
(Popularity: ) : Get access to the largest database of musical recordings with information about the artist, composer, songwriter, musicians, running time, technology, ... PDF-to-Text
(Popularity: ) : PDF-to-Text is a program to convert Adobe PDF documents into ASCII text format with a minimum loss of formatting information.
User reviews
Screenshot
Rate me
supported os's
Windows XP Windows NT Windows Me Windows 98 Windows 2003 Windows 2000
Software Library
) : Defragmenting your databases is easy with Visual Defrag. Visual Defrag analyzes all the tables in each of the databases on ...
