Description from the Publisher
Advanced ETL Processor Enterprise 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 Enterprise helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.
Advanced ETL Processor Enterprise supports complex enterprise environments including database , file, smtp, pop3 and ftp servers.
Since Advanced ETL Processor Enterprise is a codeless most of the tasks performed without writing a single line of code
Advanced ETL Processor Enterprise 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 Enterprise writes detailed message into the log and writes a record into rejected records file.
The Enterprise version includes execution agent which can be run as a Windows service.