ETL Features
Standard
Professional
Enterprise
 

$340

for users wanting to run ETL processes

$460

for the 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 (Webform processing)
HL7 Messages
SalesForce
Brightpearl
Slemma
Google Spreadsheet
QlikView QVX files
QlikView QVD files
BDE
MSMQ
JSON
Clarion
Active Directory
Syslog
FTP Files List
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 data 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 newly 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
Python
Validation
  190+ Validation Functions
String Validation
Number Validation
Date Validation
Time Validation
Validation Against a list of values
Regular Expressions: Postcodes, 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 useful features
  Full Support for Unicode
Rejected Records File
Transformation Log
Command Line Interface
Data Preview
Package debugging  
Library of Objects  
Support for python
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 Connections  
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  
Clear Log  
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  
Amazon S3  
Azure Blob  
Telegram  
RabbitMQ  
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 now
Direct link, no registration required.