Advanced ETL Processor Pro is an automated data extraction software that extracts data from databases, validates, and loads it into other databases. With a preview feature, users can view the expected results of the ETL flow.
Advanced ETL Processor Professional is a comprehensive codeless automation tool that allows you to seamlessly transfer data from any database into any database or file. It is designed to automate complex business processes to enable complete automation and save time.
It is equipped with a variety of features that include FTP, Email: POP3 and SMTP, file operations, SQL scripts, Zip and Unzip, ETL task scheduler, and comprehensive logging. These features enable you to work with various file types such as 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.
Advanced ETL Processor Pro doesn't require you to write a single line of code in most of the tasks performed; hence, it simplifies your data transfer processes significantly. The software is also designed to allow you to automate complex business processes with ease.
Typical usage of Advanced ETL Processor Pro involves extracting data from an Excel file, validating date formats, sorting data, deduplicating it, loading it into the database, and running stored procedures or SQL scripts. You can also set up the software to send an email to the administrator once the transformation process is complete.
Advanced ETL Processor Pro provides detailed logs of every package execution. In case something goes wrong during the process, the software writes a detailed message in the log and adds a line into the rejected records file. Overall, Advanced ETL Processor Pro is an efficient and reliable tool that simplifies complex business processes and helps you save time.
It is equipped with a variety of features that include FTP, Email: POP3 and SMTP, file operations, SQL scripts, Zip and Unzip, ETL task scheduler, and comprehensive logging. These features enable you to work with various file types such as 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.
Advanced ETL Processor Pro doesn't require you to write a single line of code in most of the tasks performed; hence, it simplifies your data transfer processes significantly. The software is also designed to allow you to automate complex business processes with ease.
Typical usage of Advanced ETL Processor Pro involves extracting data from an Excel file, validating date formats, sorting data, deduplicating it, loading it into the database, and running stored procedures or SQL scripts. You can also set up the software to send an email to the administrator once the transformation process is complete.
Advanced ETL Processor Pro provides detailed logs of every package execution. In case something goes wrong during the process, the software writes a detailed message in the log and adds a line into the rejected records file. Overall, Advanced ETL Processor Pro is an efficient and reliable tool that simplifies complex business processes and helps you save time.
What's New
Version 6.3.6.10:
+ 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