Advanced ETL Processor

Advanced ETL Processor

Advanced ETL Processor 3.2.0.8 is a utility that extracts data from any database, then transforms, validates and loads it into another database automatically. The unique technology called 'What you can see is what you can load' saves you a lot of time during the test and the transformation process and the valid design. It provides you with how the data will be transformed and loaded into a database or database that doesn't actually load it. At any time, you can press the 'Preview' button and see the result.

Advanced ETL Processor can help you extract data from Excel files, validate date formats, categorize data, destroy duplicates and load it into a database, run stored procedures or scripts. SQL version, when the loading process is complete. Unlike the Oracle SQL loader, BCP, DTS or SSIS, Advanced ETL Processor can add new update records and update old records based on user-defined keys. The program can extract data from multiple text files, multiple Excel files, multiple Excel spreadsheets, MS Access databases and multiple tables. It can load data into multiple targets such as text files, or MS Access databases, Microsoft Excel, DBF, and Oracle databases. If the data format is incorrect, the Advanced ETL Processor will write a detailed message to the error log and write a record to the discarded log file.

New points in this version:

Version 3.2.0.8 can pass variables between conversion processes.