Advanced ETL Processor Pro extracts data from any database, transforms, validates it and loads into another database completely automatically. At any time, you can press the Preview' button and see what the results of an ETL flow would look like.
Version: 220.127.116.11Advanced ETL Processor Professional is a Codeless Automation Tool. It transfers from ANY Database into ANY Database or file.
License: Free To Try $460.00
Operating System: Windows
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 files.
Since Advanced ETL Processor Pro is a codeless most of the tasks performed without writing a single line of code
Advanced ETL Processor Pro is designed to automate complex business processes.
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 transformation is completed send email to the administrator.
Every package execution is logged, If something went wrong Advanced ETL Processor Pro writes detailed message into the log and adds a line into rejected records file.
Version 18.104.22.168: + 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 22.214.171.124: + Added: Ability to select Amazon connection endpoint
Version 126.96.36.199: + Added: Support for telegram Bot API - Fixed: SplitRegX transformation function bug - Fixed: Lookup transformation function bug
Version 188.8.131.52: + Added: Added ability to pull license from the license server - Fixed: Package copy/paste issues - Fixed: Bat files execution problems - Fixed: Last record flag issue for files with two lines
Version 184.108.40.206: + 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 220.127.116.11: + Added: Syslog datasource - Fixed: JSON Data reader AV
Version 18.104.22.168: Improved: Extracts data from OLE Db up to 4 times faster Improved: Extracts data from SQLite up to 2 times faster Improved: The application starts much faster Improved: It is now possible to add files to the existing archive Fixed: Issues with reading google spreadsheet data
Version 22.214.171.124: 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 126.96.36.199: Added: Change Encoding Package Action Added: Batch email processing option to IMAP4 and POP3 Package Actions
Version 188.8.131.52: 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