|
for users wanting to run load data |
for the development environment |
For companies wanting to automate complex business processes |
Data Sources
|
|
Multiple Delimited Files |
 |
 |
 |
Multiple Fixed Width Files |
 |
 |
 |
Multiple Pivot tables |
 |
 |
 |
Multiple Excel Spreadsheets |
 |
 |
 |
Multiple DBF Files |
 |
 |
 |
Multiple Clarion Files |
 |
 |
 |
Multiple MS Access Databases |
 |
 |
 |
Multiple Source Files |
 |
 |
 |
Multiple Source Tables |
 |
 |
 |
Any ODBC Compliant Database |
 |
 |
 |
Any JDBC Compliant Database |
 |
 |
 |
MS SQL Server |
 |
 |
 |
Oracle Databases |
 |
 |
 |
MySql/MariaDB + SSL |
 |
 |
 |
PostgreSQL + SSL |
 |
 |
 |
Interbase/Firebird |
 |
 |
 |
SQLite |
 |
 |
 |
MongoDB |
 |
 |
 |
OLE DB |
 |
 |
 |
BDE |
 |
 |
 |
XML |
 |
 |
 |
RSS Feed |
 |
 |
 |
Google Spreadsheets |
 |
 |
 |
SalesForce |
 |
 |
 |
BrightPearl |
 |
 |
 |
QlikView QVX Files |
 |
 |
 |
QlikView QVD Files |
 |
 |
 |
Windows Event Log |
 |
 |
 |
Active Directory |
 |
 |
 |
JSON |
 |
 |
 |
Syslog |
 |
 |
 |
File System |
 |
 |
 |
Stored Procedures |
 |
 |
 |
Data Targets
|
|
Oracle |
 |
 |
 |
MS SQL Server |
 |
 |
 |
MySql + SSL |
 |
 |
 |
PostgreSQL+ SSL |
 |
 |
 |
Interbase/Firebird |
 |
 |
 |
SQLite |
 |
 |
 |
SalesForce |
 |
 |
 |
Any ODBC Compliant Database |
 |
 |
 |
OLE DB |
 |
 |
 |
BDE |
 |
 |
 |
Stored Procedure |
 |
 |
 |
Transformations
|
|
Adding Records |
 |
 |
 |
Updating Records |
 |
 |
 |
Deleting Records |
 |
 |
 |
Adding new and Updating old Records |
 |
 |
 |
Add new Records only |
 |
 |
 |
Conditional Loading |
 |
 |
 |
User-definable data formats |
 |
 |
 |
Transformation Functions |
 |
 |
 |
Execution of SQL script Before the loading |
 |
 |
 |
Execution of SQL script After the loading |
 |
 |
 |
The powerful Data transformation language |
 |
 |
 |
Other useful features
|
|
Full support for Unicode |
 |
 |
 |
Rejected Records File |
 |
 |
 |
Transformation Log |
 |
 |
 |
Command Line Interface |
 |
 |
 |
Data Preview |
 |
 |
 |
Library of objects |
|
 |
 |
Repository
|
|
MS Access |
|
 |
 |
MS SQL Server |
|
 |
 |
Oracle |
|
 |
 |
MySql |
|
 |
 |
Interbase |
|
 |
 |
PostgreSQL |
|
 |
 |
Repository Backup |
|
 |
 |
Repository Restore |
|
 |
 |
Repository Creation Wizard |
|
 |
 |
Repository Synchronization |
|
 |
 |
Advanced Objects
|
|
Directories |
|
 |
 |
Connections |
|
 |
 |
Imports |
|
 |
 |
Import script creation wizard |
|
 |
 |
Reports |
|
 |
 |
SQL Scripts |
|
 |
 |
Lookups |
|
 |
 |
Task Scheduler |
|
 |
 |
Execution Logging |
|
 |
 |
Packages |
|
 |
 |
Email Templates |
|
 |
 |
Work Flow
|
|
Imports |
|
 |
 |
Exports |
|
 |
 |
SQL Scripts |
|
 |
 |
Check Files |
|
 |
 |
Compare Files (creation date, file size or MD5) |
|
 |
 |
File Operations (copy,delete,rename,etc) |
|
 |
 |
File Meta Data |
|
 |
 |
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 |
|
 |
 |
Show Message |
|
 |
 |
Ask Question |
|
 |
 |
HTTP Download |
|
 |
 |
Check disk space |
|
 |
 |
Check Date |
|
 |
 |
Reports |
|
 |
 |
Package Variables |
|
 |
 |
Ping Server |
|
 |
 |
Check DB connection |
|
 |
 |
Backup repository |
|
 |
 |
Automation script |
|
 |
 |
SMS Messages |
|
 |
 |
Looping through the list of values |
|
 |
 |
SOAP |
|
 |
 |
XSLT |
|
 |
 |
Twitter |
|
 |
 |
Encryption |
|
 |
 |
Publishing Tableau TDE Files |
|
 |
 |
Support for Python |
|
 |
 |
Cloud Storage |
|
 |
 |
Amazon S3 |
|
 |
 |
Azure Blob |
|
 |
 |
Telegram |
|
 |
 |
RabbitMQ |
|
 |
 |
UnAttended Execution
|
|
Execution Agent |
|
 |
 |
|
Directory Monitor |
|
 |
 |
|
FTP Monitor |
|
 |
 |
|
POP3 Monitor |
|
 |
 |
|
IMAP4 Monitor |
|
 |
 |
|
HTTP Monitor |
|
 |
 |
|
MS MQ Monitor |
|
 |
 |