Description: Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. It can help you extract data from an Excel file, validate date formats, sort data, deduplicate it and load it into any database, run stored procedure or SQL script, once loading is completed. Unlike Oracle SQL loader, DTS or SSIS, Advanced ETL Processor can add new and update old records based on key defined by the user
Click here for more information
- Click here for a screenshot.