| |
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 |
|
|
|
