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!