Advanced ETL Processor is aCodeless ETL tool It canload ,validate ,transform , group,sort and deduplicate data without writing a single line of code.
It works withANY database or file formatReadAdvanced ETL Processor FAQ ,Watch Online Flash Demo , ReadProduct Documentation (PDF). Backed up by Free, Fast, Unparalleled SupportWhat can Advanced ETL Processor Do?
Advanced ETL Processor is designed to automateextracting data from ANY database ,transform ,validate it and load into ANY database. Typical usage of it would be extract data from 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 primary key. Some examples of what our customers use thisETL tool for include: Extract data from: Multiple Delimited or Fixed width Text filesMultiple Excel files + Multiple Excel SpreadsheetsMultiple MS Access DatabasesMultiple DBF FilesAny ODBC compliant databaseMS Sql ServerMultiple Tables And Load it into:Multiple Data TargetsSql scripts execution before and after loadingDelimited or Fixed width Text fileMS Access DatabaseMicrosoft Excel FileDBF File.