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,

Download (8517 KB) Website Link to this page