The 5 top most searched Data Warehouse Automation tools on the market compared with GoogleTrends is telling you that WhereScape is first before TimeXtender and BiReady (new Attunity Compose) over the last year. See the picture in full size or go directly to GoogleTrend comparison and change to your own needs.

Although the analysis is not representative, it still gives some insights and a good overview to size and presumably usage compared to each other, worldwide. Please consider that WhereScape and TimeXtender have more search results as the company name is the same as their product, meaning some of them are dedicated to the company name rather the Data Warehouse Automation (DWA) tool itself. And BimlFlex just published their first release and biGENiUS is rather new to market their product actively, they will probably increase slightly in the soon future.

Data Warehouse Automation Tools on the market

As you can imagine, there are plenty of tools on the market. From open-source, to very expensive once, and all with different features. To narrow down the scope you need to distinguish between these two approaches model-driven and data-driven.

Model-driven approach

You design your models with the business and when approved you search for the source data and import them to the representative model

More likely to use only the data you need instead the data you might need

Benefits of that is that business requirements are clearly documented up front

Contra

Slow as you need to have many inputs from the business which can be challenging and slow in bigger companies for example

Can be difficult to synchronise the model with the physical model

Can have wrong expectations as you can model a dimension conceptual but at the end, you don’t have the data available

Data-driven approach

You quickly generate a model with the data which is available

Developer approach as the way to communicate to the business by showing already the end results with a BI tool or MS Excel

The benefit is you only work with data that is actually there and the business has already a real-life model that represents the data and can be developed. This suits very well with the agile methodology of Data Warehouse Automation tools

Contra

It doesn’t easily show rules or data relationship between the model and real source data to the business

An overview some years back (Nov 2015) from the white paper by Eckerson:

The Data Warehouse Automation tools

For the complete overview, Hans Michiels created a very comprehensive guide for that manner where you can filter by any criteria and compare up to 3 different tools at the same time. Because I couldn’t do it better 🙂 , here the link: