Data Warehouse Automation

About data warehouse automation

This website will soon be providing reviews and insights to various Data Warehouse Automation solutions. If you are looking for a Data Warehouse Automation tool to buy, or have some questions, contact us here.

If you are a Data Warehouse Automation solution provider, send us some information and we'll add your product to our pages.

What is Data Warehouse Automation?

Data Warehouse Automation promises what Big Data cannot. Information now.
Getting your data ready for Business Intelligence is the toughest part of the job, consuming 70-80% of your project’s time and budget.
Data Warehousing is hard, and traditional development approaches using ETL tools simply take too long and cost too much.

1
PURPOSE BUILT

DOES ONE THING - AND DOES IT VERY WELL

Data Warehouse Automation tools are purpose built for the job. Just like you wouldn't use Excel to build an accounting system, using ETL tools to build data warehouses is a slow, manual, error-prone and expensive process. ETL tools are just bad news for building data warehouses - ETL stands for Extract, Transform and Load. It should stand for Expensive, Tardy and Laborious.

Data Warehouse Automation tools come with all the smarts built-in to create consistent, accurate results very quickly.

2
No CODING

FOCUS ON THE OUTCOME - NOT THE CODE

By automating the coding, Data Warehouse Automation tools allow you to focus on the model and the business outcome, and not the code. At last, you are free from the time-consuming drudgery of coding!

You only need to manage the transformation code (usually, less than 5% of your data needs transformation). Data Warehouse Automation tools manage everything else.

3
SUPER-FAST DELIVERY

FASTER THAN A SPEEDING BULLET

Data Warehouse Automation tools are proven to deliver fully-working data warehouses in a fraction of the time. A project ordinarily taking 2-3 months can be delivered in a day or two.

We can cite many examples where a project that took 2-3 months using ETL tools were built in a day or two using Data Warehouse Automation.

4
SELF-DOCUMENTING

ELIMINATES THE BANE OF EVERY DEVELOPER

Since the code is generated automatically, so is the documentation. Taking much of the information from your metadata, you can enrich the documentation and release it to your business users. Fast. Most Data Warehouse Automation tool will give you the means to add lots of descriptive information about the data in your data warehouses.

Straight away, this makes it easier for your users to navigate their data in their BI tool, and the ongoing maintenance of your data warehouse a cinch.

5
CAVEAT EMPTOR

CHOOSE WISELY (WHERE WE COME IN!)

Not all Data Warehouse Automation tools are created equal! Some may deal with only one kind of target database. Others are not really Data Warehouse Automation tools per se. They may help with some aspects of the design or coding, or speed up the mappings of source to target, but still require a lot of manual coding to finish the job.

A good Data Warehouse Automation tool will give you target database choices, automate the entire process, provide full documentation, and may support more than one design philosophy e,.g. Third Normal Form (Inmon), Star Schema (Kimball) or Data Vault (Linstedt).

Data warehouse automation choices

Are you a data warehouse automation software vendor? Feature your product here!

CONTACT US