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: 188.8.131.52Build 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 184.108.40.206: + Improved: JSON Data Handling + Added: Support for SQL Server 2017 + Improved: Software registration process - Fixed: Issues with Australian Post Code validation - Fixed: Issues with loading data into varchar(max) field - Improved: SQL Server error handling
Version 220.127.116.11: + Added: Ability to select Amazon connection endpoint
Version 18.104.22.168: + Added: Support for telegram Bot API - Fixed: SplitRegX transformation function bug - Fixed: Lookup transformation function bug
Version 22.214.171.124: + Added: Support for Amazon S3 and Azure Blobs + Added: Amazon S3 operations: Download, upload and delete files, Create and delete baskets, Download basket files List + Added: Azure blob operations: Download, upload and delete files, Create and delete containers, Download container files List
Version 126.96.36.199: + Added: Syslog datasource - Fixed: JSON Data reader AV
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