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 togetherAdvanced ETL Processor Professional helps businesses 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 Download a Free Trial or ReadProduct Documentation (PDF) today.
Works out of the box, Backed up by Free, Fast, Unparalleled Support What can Advanced ETL Processor Professional Do? Advanced ETL Processor 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. Some examples of what our customers use thisETL tool for include: Extracting 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 Loading it into:Multiple Data TargetsSql scripts execution before and after loadingDelimited or Fixed width Text fileMS Access DatabaseMicrosoft Excel FileDBF FileOracle 7-11g database SQL server 7- 2005 Any ODBC compliant database Validation: Deal With Dirty Data Validate Post codes, Phone numbers,TAX Codes using regular expressions.