Data Warehouse Automation

Data Warehouse Automation

Report Author(s): Philip Howard,Daniel Howard

There are two common approaches to this issue: one of which is model-driven and the other is driven by metadata. We have no opinion about which is the better approach, primarily because it all comes down to implementation: how easy is it to use the tool in question and how automated does it make the processes involved in creating and managing your warehouse or lake? We should add that ongoing maintenance of the environment is as important, if not more so, than the original creation of the warehouse/lake. These are continuously updated and may require schema changes from time to time: the ability to support change in the ongoing environment is as critical as the savings, in time and money, that derive from automating the initial creation.


Bloor Research

Bloor is an independent research and analyst house focused on the idea that Evolution is Essential to business success and ultimately survival. For nearly 30 years we have enabled businesses to understand the potential offered by technology and choose the optimal solutions for their needs.