Description from the Publisher
Advanced ETL Processor Professional is a Codeless Automation Tool.
Users can design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis
By combining simple Package actions together Advanced ETL Processor Professional helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.
Advanced ETL Processor Professional supports complex enterprise environments including database , file, smtp, pop3 and ftp servers.
Since Advanced ETL Processor Professional is a codeless most of the tasks performed without writing a single line of code
Advanced ETL Processor Professional is designed to automate everyday routine tasks. 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 send email to the administrator.
Every package execution is logged,If something went wrong Advanced ETL Processor Pro writes detailed message into the log and writes a record into rejected records file.