Advanced ETL Processor Professional is designed to automate everyday routine tasks.
Typical usage of it would be to extract data from Excel File, Validate Date Formats, Sort data, de-duplicate it and load it into the database and run stored procedures or SQL script. Once loading is completed send an email to the administrator.

Some examples of what our customers use this ETL tool for include:
Extracting data from:
- Multiple Delimited or Fixed Width Text files
- Multiple Excel files + Multiple Excel Spreadsheets
- Multiple MS Access Databases
- Multiple DBF Files
- Multiple Tables
- OLE DB Datasource
- Any ODBC/JDBC compliant database
- MS SQL Server
- MS SQL Server CE
- Oracle
- MySQL
- PostgreSQL
- Interbase/Firebird
- SQLite
- POP3 + SSL (Receives Emails)
- IMAP4 + SSL (Receives Emails)
- File System
- XML
- QVX/QVD Files
- SalesForce
- Brightpearl
- Windows Event Log
And Loading it into:
- Multiple Data Targets
- Delimited or Fixed width Text files
- MS Access Databases
- Microsoft Excel Files
- DBF Files
- Oracle
- MS SQL Server
- MySQL
- PostgreSQL
- Interbase/Firebird
- Any ODBC compliant database
- Email Server (Sends Emails)
- OLE DB
- File System
- XML
- QVX/QVD Files
Validation:
- Deal With Dirty Data
- Validate Postcodes, Phone numbers, TAX Codes using regular expressions
- Validate Date Formats
- Validate Date and Time
- Validate Numbers
- Validate Strings
Transformation:
- Split, merge Fields
- Split data and load it into different tables
- Add, replace, delete strings
- Run custom transformations
- Translate coded values
- Derive a newly calculated value
Automation:
- Load Data into ANY database
- Add Records
- Update Records
- Delete Records
- Add New and Update existing Records
- Export ALL Data from ANY database
- FTP Downloads and Uploads
- Create or Delete directories on the FTP server
- Rename or delete files on the FTP server
- Send Emails with attachments
- Receive Emails with attachments
- Save attachments
- Compress files
- Decompress zip files
- Copy, move, rename, merge, delete files
- Compare files using MD5, size or creation date
- Check if the file exists
- Generate Reports
- Execute Different parts of the package depending on the day of the week
- Check disk space
- Debug packages
- Schedule packages for execution
- Run bat files or execute any Windows application
- Edit and run SQL Scripts
- Execute Packages from the command line
- De-duplicate Data
- Sort Data
- Group Data
- Summarize Data
- Pivot and UnPivot Data
- Create surrogate keys
- Run SQL script before and after loading data
- Filter Source Data
- Use Select Statement as a Data Source
- Generate XML
- Transform Unicode Data
- Generate SQL Insert Script Using any Table or File
- Load files into the database
- Export blob data into separate files
- Extract Emails
- Adress and Report Data Quality Issues
- Encrypt data
- Decrypt Data
Every package execution is logged, In the event of an error, the Advanced ETL Processor Professional generates a detailed and explanatory report, giving the user ultimate control of the accuracy of the data.