ETL Features
Visual Importer Enterprise
Advanced ETL Processor
Enterprise
 

$330

$690

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
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
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 Connections
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  
Imports
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
Unattended Execution
  Execution Agent
 
Directory Monitor  
FTP Monitor  
HTTP Monitor  
POP3 Monitor  
IMAP4 Monitor   
MS MQ Monitor  
Visual importer ETL is the first software product we created. 
Since then we have designed Advanced ETL processor which is fully compatible with it and has much more features.

Want to see it yourself?

Download Advanced ETL Processor Enterprise now!