Products

Forget about your routine messy data conversions!

“For Database Users”

- Extract data directly from SQL Server, Oracle, DB2, Access, etc. databases.

- No SQL skills necessary.

- Includes all functionality of CSV version as well.

“For CSV (Excel) Users”

- Works with standard text data exchange formats such as CSV (Comma or tab separated values) or fixed text column length data files.

- Many databases export to CSV files which may be used, although direct database access is not available in this version.

Waha! Transformer is the standard ETL tool in Japan.

- Server Edition has been installed at over 400 companies.

- Through our OEM partners, more than 8,000 licenses of Personal Edition have been sold.

The main functions of ETL tools include the following:

Extract

Extract data from various databases or files that administer those data to be integrated.

Transform

Integrate data from multiple data sources, convert codes, transform and process it as however defined. It also cleans data by correcting reference and consistency errors.

Load

Load the processed data into a data warehouse or datamart.

Waha! Transformer is capable of all of the above, with an intuitive interface to define the flow of information from extraction, through transformation, to loading at a target.

It's so easy. Learn through a quick tutorial, and you will be ready to enjoy this great tool.

Standard Filter

Sort, change column order, and apply predefined functions on data.

Join Filter

Join two or more related data sources into a single view.

Merge Filter

Merge similar data sources into a single view.

Split Filter

Split a single data source into any number of target views based on any number of conditions.

Group Filter

Report the number of records, minimum, maximum, average, and sum of groups of data.

Lookup Filter

Reference data from one data source to another, with output based on if the reference condition exists or not.

Layout Filter

Rearrange a table to convert columns to rows.