Compare Advanced ETL Processor Versions

ETL Features
Standard
Professional
Enterprise

 

$340

for users wanting to run ETL processes

$460

for development environment

$690

For companies wanting to automate complex ETL processes

Data Sources

  Multiple Delimited or Fixed width Text files
Multiple Excel files + Multiple Excel Spreadsheets
Multiple MS Access Databases + Multiple Tables
Multiple DBF Files
Any ODBC Compliant Database
Any JDBC Compliant Database
OLE DB
MS SQL Server, MS SQL Server CE, MS SQL Server EXPRESS
Oracle
MySql/MariaDB + SSL
PostgreSQL + SSL
Interbase/FireBird
SQLite
MongoDB
Multiple Source Files
Multiple Source Tables
SQL Select Statement as a Data source
POP3 Email server
IMAP4 Email Server
File System
XML
RSS Feed
HTTP (Web form processing)
HL7 Messages
SalesForce
BrightPearl
Slemma
Google Spreadsheet
QlikView QVX files
QlikView QVD files
BDE
MSMQ
JSON
Clarion
Active Directory

Data Targets

  Oracle database
MS SQL Server, MS SQL Server CE, MS SQL Server Express
MySql+ SSL
PostgreSQL+ SSL
Interbase/Firebird
Any ODBC Compliant Database
SQLite
SalesForce
Slemma
OLE DB
Delimited or Fixed width Text file
MS Access Database
Microsoft Excel File
DBF File
Multiple Data Targets
SQL Insert Script
SMTP Server
File System
XML
HL7
QlikView QVX files
QlikView QVD files
BDE
SMS Messages
MSMQ
Tableau TDE files
Tableau Hyper files
JSON
Stored Procedure

Loading method

  Adding Records
Updating Records
Deleting Records
Adding new and Updating old Records
Adding new Records only
User definable SQL for Adding, Updating and Deleting records
User definable date formats
Transformation Functions
Execution of Sql script Before the loading
Execution of Sql script After the loading

Transformations

  200+ transformation functions
String Transformation
Number Transformation
Date Transformation
Multiple Date Formats
JSON Transformation
Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
Deriving a new calculated value (e.g., sale amount = qty * unit price)
Joining together data from multiple fields
Generating surrogate key values
Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
Customised Transformation
Powerful Data transformation Language

Validation

  190+ Validation Functions
String Validation
Number Validation
Date Validation
Time Validation
Validation Against list of values
Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC

Additional Transformations

  Sorting
Grouping
Deduplication
Fields Selector
Clone record
Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
Data quality log

Other usefull features

  Full Support for Unicode
Rejected Records File
Transformation Log
Command Line interface
Data Preview
Package debugging
Library of Objects  

Repository

  MS Access  
MS Sql Server  
Oracle  
MySql  
Interbase  
PostgreSQL  

Advanced Objects

  Projects  
Directories  
ODBC Connections  
JDBC Connections  
SQL Server Connections  
SQL Server Compact Edition Connections  
Oracle Connections  
MySQL Connenctions  
PostgreSQL Connections  
Interbase/Firebird Connections  
SQLite Connections  
SalesForce Connections  
OLE DB Connenctions  
SMTP Connections  
POP3 Connections  
IMAP4 Connections  
FTP Connections (FTP,FTPS,FTPES,SFTP)  
TCP/IP Connections (Used for HTPP and HL7)  
Data Transformations  
Email Templates  
Sql Scripts  
Reports Designer  
Scheduler  
Execution Log  
Packages  
Backup Repository  
Restore Repository  
Repository Creation Wizard  
Repository Synchronization  

Workflow

  Data Transformations  
Exports  
Sql Scripts  
Check Files  
Compare Files (creation date, file size or MD5)  
File Operations (copy,delete,rename,etc)  
File MetaData  
External applications  
Email Notifications  
Ftp operations Uploads, Downloads, Create Remote directory, Delete File  
Zip (zip and unzip with password)  
POP3 Email receiver  
IMAP4 Email receiver  
SQL Data Check  
FTP Operations with full SSL support  
Backup Repository  
Pause  
Check Date  
Reports  
Check disk space  
Show Message  
Ask Question  
HTTP Download  
Automation Scripts  
Package Variables  
Check DB connection  
Ping Server  
Looping through the list of values  
SMS Messages  
SOAP  
XSLT  
Cloud Storage  

Unattended Execution


  
  Execution Agent
   
Directory Monitor    
FTP Monitor    
HTTP Monitor    
POP3 Monitor    
IMAP4 Monitor     
MS MQ Monitor    

Want to see it yourself?

Download Advanced ETL Processor Enterprise now!
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 790 guests and no members online