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: 126.96.36.199Build 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 188.8.131.52: Improved: Excel action can change file extension now Improved: Management Console look and feel Improved: Software Installation Process Improved: Thrird Party Components Update Fixed: Minor Python Integration Issues Improved: if an object is read only, it's shown in grey color
Version 184.108.40.206: Improved: Extracts data from OLE Db up to 4 times faster Improved: Extracts data from SQLite up to 2 times faster Improved: It is now possible to use agent during the trial period Improved: The application starts much faster Improved: It is now possible to add files to the existing archive
Version 220.127.116.11: Added: New datasource - Twitter Improved: Loads data into SQL server up to 25 percent faster Improved: Generating Tableau hyper files up to 25 percent faster Improved: Generating Tableau tde files up to 30 percent faster Improved: Twitter message can include pictures
Version 18.104.22.168: Added: Change Encoding Package Action Added: Batch email processing option to IMAP4 and POP3 Package Actions
Version 22.214.171.124: Added: Support for DropBox, Google Drive, Microsoft OneDrive, Box, Amazon Cloud Drive, Hubic, HiDrive and Yandex Disk cloud storage Added: Cloud storage operations: Download, Upload, Create Remote Directory, Delete Remote Directory, Delete Files and Directory List Added: Enable logging option
Version 126.96.36.199: + 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 188.8.131.52: + 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 184.108.40.206: + 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 220.127.116.11: + 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 18.104.22.168: 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.