In new release of Advanced ETL Processor data sorting functionality is improoved by allowing the user to define directory to store temorary files and specify memory buffer dedicated to sorting
Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively. For example, you might want to order sales data by calendar month so that you can produce shop performance report.
New version Database Browser is available for download. In this version we have introduced data import wizard.
This easy to use tool allows user to connect to any database and browse or modify data,run sql scripts, export and print data. And the most important thing it is Free-ware.
New release of Advanced ETL Processor adds Range Lookup function our vast library of data transformation functions.
Performing range lookups (or to finding a key for a given range) is a common ETL operation in data warehousing scenarios. It's especially for historical loads and late arriving fact situations, where you're using type 2 dimensions and you need to locate the key which represents the dimension value for a given point in time.
Data for lookup can be entered manually or loaded from the database or a file
This release changes the way the Data Validator works
It allows the user to validate and transform the data at the same time.
Open Data Validator and map validation rules to output fields.
Save Data transformation.
Repeat for all transformations
Advanced ETL Processor is a powerful data integration application with support for integrating data with virtually any formats including Flat files, Excel, MS Access, DBF, FoxPro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, POP3 + SSL, SMTP + SSL, File System, XML. Advanced ETL Processor is an ideal product for transforming data in any enterprise. All this can be achieved without writing a single line of code.