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: 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 22.214.171.124: Added: Change Encoding Package Action Added: Batch email processing option to IMAP4 and POP3 Package Actions
Version 126.96.36.199: 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 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: + Improved: Google Spreadsheet import + Improved: Google Spreadsheet Reader Connection + Improved: Google Spreadsheet Reader works with intenational characters correctly now + Improved: SQL Lookup transformation dialogue - Fixed: Salesforce Bulk API load issues - Fixed: SQL Lookup
Version 18.104.22.168: Major Release: Options Dialog: "Execute only local actions" option was removed "Use agent for execution was" removed Maintenance tab: Complete redesign Schedule tab: Execute on computer check box was removed Schedule Dialog: Execute on computer check box was removed
Version 22.214.171.124: + 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 126.96.36.199: 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 n
Version 188.8.131.52: + Improved: Repository Creation Wizard + Improved: Removed Agent management buttons from log tab and schedule tab + Improved: Removed Number of executions field from log tab + Improved: Removed clutter from maintain tab - Fixed: Addressed issues with scheduler next execution date calculation