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.

mt_ignore:Exporting All Act Tables Into csv files

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.