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, de-duplicate it and load it into the database, run stored procedure or Sql script. Once loading is completed send email to the administrator.

Advanced ETL Processor Sending Price List
 

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 Spread sheets
  • Multiple MS Access Databases + Multiple Tables
  • XML Files
  • Qvx and Qvd QlikView files
  • Multiple DBF Files
  • Multiple Clarion DAT Files
  • Any ODBC compliant database
  • Any JDBC compliant database
  • Full support for OLE DB
  • Direct connection to Oracle, SQL Server, MySql, PostgreSQL, SQLite, SQL Server Compact and Interbase/Firebird
  • Multiple Tables
  • File System
  • POP3 Servers
  • IMAP4 Servers
  • Windows Event Log
  • TCP/IP Socket
  • RSS
  • Google Spread Sheet
  • SalesForce
  • BrightPearl
  • Slemma
  • BDE

And Loading it into:

  • Multiple Data Targets
  • SQL scripts execution before and after loading
  • Delimited or Fixed width Text files
  • MS Access Database
  • Microsoft Excel File
  • DBF File
  • Any ODBC compliant database
  • Any OLE DB compliant database
  • Oracle database
  • Microsoft SQL Server database
  • Microsoft SQL Server CE
  • SQLite
  • MySQL
  • PostgreSQL
  • Interbase/Frebird
  • File System
  • SMTP Servers
  • XML Files
  • QlikView Qvx and Qvd files
  • SalesForce
  • Slemma
  • BDE

Validation:

  • Deal With Dirty Data
  • Validate Post codes, 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 new calculated value

Automation:

  • Load Data into ANY database
  • Export Data from ANY database
  • FTP Downloads and Uploads + SSL
  • Create or Delete directories on FTP server
  • Rename or delete files on FTP server
  • Send Emails with attachments
  • Receive Emails with attachments
  • Save attachments
  • Compress files
  • Decompress files
  • Copy, move, rename, merge, delete files
  • Compare files using MD5, size or creation date
  • Check if file exist
  • Check Disk space
  • Generate Reports
  • Execute Different part of package depending of the day of the week
  • Schedule packages for execution
  • Run bat files or execute any windows application
  • Edit and run SQL Scripts
  • Execute Packages from the command line
  • Add Records
  • Update Records
  • Delete Records
  • Add New and Update existing Records
  • 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
  • Process Unicode Data
  • Generate XML
  • Generate Sql Insert Script Using any Table or File
  • Process EMAILS
  • Send EMAILS
  • Send SMS Messages
  • HTTP Dowloads
  • Post HTTP Forms
  • Post Tweets
  • Ping servers
  • Check database state
  • Load images into database
  • Export blobs into separate files

Every package execution is logged, In the event of an error, the Advanced ETL Processor Enterprise generates a detailed and explanatory report, giving the user ultimate control of accuracy of the data.

Watch online tutorials Data Transformation Data Validation Licence UnInstall
Advanced ETL Processor Standard

Recommended product for desktop users who require advanced data transformation

From only 340$ per license

Read More

Advanced ETL Processor Professional

Recommended product for development environment

From only 480$ per license

Read More

Advanced ETL Processor Enterprise

Recommended product for complex enterprise environment

From only 690$ per license

Read More

We have 898 guests and no members online