Advanced ETL Processor Professional is a Code-less Automation Tool.
Design complex data transformations and SQL scripts add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis.
By combining simple Package actions together Advanced ETL Processor Professional helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.
Using native API for Oracle(OCI), MS Sql Server(BCP), ODBC, MySQL, PostgreSQL, Interbase/Firebird gives Advanced ETL Processor great performance - thousands of records per second, and since Advanced ETL Processor Professional is a codeless, most of the tasks performed, without writing a single line of code.
Every package execution is logged, In the event of an error, the Advanced ETL Processor Professional generates a detailed and explanatory report, giving the user ultimate control of accuracy of the data.
Datawarehouse Implementation efficiency
Advanced ETL Processor Pro cuts BI solutions implementations by 10+ times. Our remote consultancy service allows to decrease it even further. Advanced ETL Processor gives our customers data integration capabilities built into a straightforward graphical user interface. At any stage user can press the "Magic Button" and see the result of transformation without actually loading the data.
Data integration in Advanced ETL Processor
Advanced ETL Processor Pro allows you to easily associate target and source data structures using drag and drop functionality. A vast built-in library of advanced data processing filters and functions is available plus you can write your own transformations using powerful data transformation language in more complex data integration scenarios.
Integrating Data from/into Multiple datasources
Advanced ETL Processor Pro lets you easily integrate data from multiple datasources or split data from one datasoure into many. Multiple datasource can be specified through support for wildcard characters (e.g., ? or *) and it can be applied to the files/tables or sheets.
Advanced ETL Processor Pro also allows you to use calculations in file names as parameters in your data integration projects. for example you can use it to load data from today's files only.
Complete Business process automation
Advanced ETL Processor Pro allows you to automate entire business processes such as File operations, Emails, FTP, HTTP, compression/decompression and much more.
Future proof software
We listen to our customers and constantly working on improving our software and adding new features
Recommended product for complex data warehouse development environment
Advanced ETL Processor Professional ScreenshotsClick on thumbnail to see the screenshot
Advanced ETL Processor Professional runs on Microsoft Windows XP/2003/2008/Vista/Win7/Win8