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: 22.214.171.124Advanced 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 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: + 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 220.127.116.11: 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 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 n
Version 126.96.36.199: + 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
Version 188.8.131.52: + Improved: Up to 10 percent performance increase while loading data into date/time fields + Improved: Support for JSON as data source
Version 184.108.40.206: + Added: Support for JSON as data source and target
+ Added: File Metadata Action
+ Added: Added
Version 220.127.116.11: + Improved : MySQL Error handling + Improved : Global variables handling + Improved: Services registration during installation + Improved: Management console can start and stop agent now + Improved: Management console can amend agent service properties now - Fixed : BDE Datasource issues