Build Complex Data warehouses and Automate Entire Business Processes
Transfer Data from ANY Database into ANY Database or file. Complete automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive logging. Work with: Text, XML, Excel, Access, DBF, Foxpro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, SMTP, File System, FTP, SSL, Unicode, RSS, Windows Event Log, Google Spreadsheets, SalesForce, BrightPearl and QlikView.
Since Advanced ETL Processor Enterprise is a codeless most of the tasks performed without writing a single line of code
Advanced ETL Processor Enterprise is designed to automate everyday routine tasks. Typical usage of it would be extract data from Excel File, Validate Date Formats, Sort data, deduplicate it and load it into the database, run stored procedure or Sql script. Once loading is completed send email to the administrator.
Every package execution is logged, If something went wrong Advanced ETL Processor Enterprise writes detailed message into the log and writes a record into rejected records file.
The Enterprise version includes execution agent, which can be run as a Windows service.
Introduction of monitors. Monitor is a windows service which waits for certain event to happen.
It automatically responds to events by performing user-defined tasks and actions.
Supported Monitors: Directory, FTP, POP3, IMAP4, MSMQ and HTTP Monitor.
+ Added : Tableau Server Connection
+ Added : Publishing Tableau TDE Files
+ Improved: Updated Tableau Client
- Fixed : Issues with loading version info
- Fixed : Tableau Datetime fields processing issues
- Fixed : MySql Server Repository Creation Scripts issues
+ Added: Number Of Files Found variable to File Operation, Check File, Zip and FTP Package actions
+ Improved: Report generator components update
+ Improved: Query Builder components update
+ Improved: SSL components update
+ Improved: Improved file delete messages
+ Added: Support for JSON as data source and target
+ Added: File Metadata Action
+ Added: Added <Package ID> variable
+ Added : Do not show notifications option
+ Improved : Object tree search functionality
+ Improved : Lookup transformation supports JSON as datas source now
+ Improved : MySQL Error handling
+ Improved : Global variables handling
+ Improved: Services registration during installation
+ Improved: Management console can start and stop agent now
+ Improved: Management console can amend agent service properties now
- Fixed : BDE Datasource issues
+ Support for latest tableau api was introduced
+ Calculation transformation function support Python now
+ Improved support for RSS feeds
- Addressed issues with Running Total transformation
- Addressed Salesforce data update issues
- Log Object bugs fixes
+ SSL Libraries update
+ Third party components update
+ SalesForce connection uses TLS 1.1 now