Build Complex Data warehouses and Automate Entire Business Processes, Transfer data from ANY Database into ANY Database or file, Use FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, Task scheduler and comprehensive logging.
Version: 18.104.22.168Build Complex Data warehouses and Automate Entire Business Processes
License: Free To Try $690.00
Operating System: Windows
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.
Version 22.214.171.124: + Added: Loading data into Google Spreadsheets + Improved: JSON null values handling + Improved: Directory monitor stability while working with network shares - Fixed: FTP Upload Issues - Fixed: Issues with loading data into Varchar(MAX) fields (SQL Server)
Version 126.96.36.199: + Added: Added Get Excel Cell Value Dynamic transformation function + Improved: Object selection visibility + Improved: Third party components update - Fixed: Addressed issues with loading data into XML,Image and Identity fields (SQL Server)
Version 188.8.131.52: + Improved: Up to two times faster loading data into SQL server - Added: Support for TLS 1.2 SQL Server connections + Improved: Made Calculation dialogue box resizable + Improved: Made Script Package Action dialogue box resizable + Improved: Made Send Email Package Action dialogue box resizable
Version 184.108.40.206: + Added: Data Buffer Transformation Function + Improved: Transformation Error Handling + Improved: Ask question package action always fails now when run from the agent + Improved: Show message package action always fails when run from the agent
Version 220.127.116.11: Major Release 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.
Version 18.104.22.168: + 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
Version 22.214.171.124: Major update: Uses new backup format + Improved: Repository Backup performance + Improved: Repository Backup restore performance + Improved: Repository Synchronization Wizard can use backup as source for Synchronization + Improved: ]Tableau client installation
Version 126.96.36.199: + 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
Version 188.8.131.52: + Added: Support for JSON as data source and target
+ Added: File Metadata Action
+ Added: Added