ETL Features
Data Sources
Active Directory
BDE
Brightpearl
Clarion DAT
Clarion TPS
DBF Files
Delimited / Fixed Width Text Files
File System
FTP Files List
Google Spreadsheets
HL7 Messages
HTTP Post
IMAP4 Email Server
Interbase / Firebird
JDBC Compliant Database
JSON
MongoDB
MS Access Databases + Tables
MS SQL Server, CE, Express
MSMQ
Excel Files + Spreadsheets
Multiple Source Files
Multiple Source Tables
MySQL / MariaDB + SSL
ODBC Compliant Database
OLE DB
Oracle
Parquet
POP3 Email Server
PostgreSQL + SSL
QlikView QVD Files
QlikView QVX Files
RSS Feed
Salesforce
SQL Select Statement
SQLite
Syslog
XML
MS SQL Server
Multiple Pivot Tables
Stored Procedures
Windows Event Log
Data Targets
HL7
Multiple Data Targets
MySQL + SSL
SMS Messages
SMTP Server
SQL Insert Script
Tableau Hyper Files
Tableau TDE Files
Loading Method
Adding Records
Updating Records
Deleting Records
Adding New and Updating Old
Adding New Records Only
User-Definable SQL
User-Definable Data Formats
SQL Script Before Loading
SQL Script After Loading
Transformations
200+ Transformation Functions
String Transformation
Number Transformation
Date Transformation
Multiple Date Formats
JSON Transformation
Translating Coded Values
Deriving Calculated Values
Joining Multiple Fields
Generating Surrogate Keys
Splitting Column
Customised Transformation
Data Transformation Language
Python Support
Adding new and Updating old Records
Add new Records only
Conditional Loading
Transformation Functions
Execution of SQL script Before loading
Execution of SQL script After loading
Powerful Data transformation language
Validation
190+ Validation Functions
String Validation
Number Validation
Date Validation
Time Validation
Validation Against List
Regular Expressions
Additional Transformations
Sorting
Grouping
Deduplication
Fields Selector
Clone Record
Summarizing Multiple Rows
Transposing / Pivoting
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
Repository Type
MySQL
Interbase
PostgreSQL
Repository Backup
Repository Restore
Repository Creation Wizard
Repository Synchronization
Advanced Objects
Projects
Directories
ODBC Connections
JDBC Connections
SQL Server Connections
Oracle Connections
MySQL Connections
PostgreSQL Connections
Salesforce Connections
SMTP Connections
POP3 Connections
IMAP4 Connections
FTP Connections (FTP, FTPS, FTPES, SFTP)
TCP/IP Connections
Email Templates
SQL Scripts
Reports Designer
Scheduler
Execution Log
Packages
Backup Repository
Restore Repository
Connections
Imports
Import script creation wizard
Reports
Lookups
Task Scheduler
Execution Logging
Workflow
Data Transformations
Exports
File Operations
Folder Operations
External Applications
Email Notifications
FTP Operations
Zip (with password)
POP3 Email Receiver
IMAP4 Email Receiver
SQL Data Check
Clear Log
Pause
Check Date
Check Disk Space
Show Message
Ask Question
User Interaction
HTTP Requests
Automation Scripts
Package Variables
Check DB Connection
Ping Server
Looping (Values, Records, Files, Emails, JSON)
SOAP
XSLT
Cloud Storage
Amazon S3 Storage
Azure Blob Storage
Telegram
RabbitMQ
AI Integration
Check Files
Compare Files (creation date, file size or MD5)
File Operations (copy, delete, rename, etc)
File Meta Data
FTP operations (Uploads, Downloads, Create Remote directory, Delete File)
Zip (zip and unzip) with password
HTTP Download
Automation script
Looping through the list of values
Twitter
Encryption
Publishing Tableau TDE Files
Support for Python
Amazon S3
Azure Blob
Unattended Execution
Execution Agent
Directory Monitor
FTP Monitor
HTTP Monitor
POP3 Monitor
IMAP4 Monitor
MS MQ Monitor