Easy to use, fast and powerful ETL tools, Our prices start from only 100 USD per licence.

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 and QlikView.

Built-in scheduler, business rules designer, package designer, report designer, data browser. Powerful data transformation language, regular expressions and more...

Home

Frontpage

Range Lookup

New release of Advanced ETL Processor adds Range Lookup function our vast library of data transformation functions.

Range Lookup

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

Range Lookup Properties
 

Major ETL Tools update

This release changes the way the Data Validator works

It allows the user to validate and transform the data at the same time.

To update:

Open Data Validator and map validation rules to output fields.
Save Data transformation.
Repeat for all transformations

OLD Version

Advanced ETL Processor - Old Version

NEW Version

Advanced ETL Processor - NEW Version

About Advanced ETL Processor

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.

 

Active Table Editor support for ADO

New version Active Table Editor is available for download. In this version we have introduced support for OLE DB.

Active Table Editor Support for ADO

About Active Table Editor

Active Table Editor is designed to edit data in any database. plus it can create reports and sophisticated data entry screens

 

Incremental Search

New version Advanced ETL Processor is available for download. In this version we have introduced incremental search of transformation and validation functions.

We would like to thank our customers for providing useful feedback

Incremental Search

 

Page 7 of 8

Testimonials

"Using Visual Importer ETL was a lot easier than we expected it to be, and had a lot more functionality than our other software."

Daniel Boel,
Information Technology Manager

Our customers

BP

BBC

HSBC


Databases we work with

Go to top