Overview
The Virtual Data Warehouse (VDW) and the associated metadata management software TEAM are free tools to quickly prototype your Data Warehouse model (output), validate your metadata and generally get insight in the effect your patterns have on your data (interpretation).
I use VDW to test out various new patterns and ideas, as well as regression testing for pattern changes in various technologies and platforms.
The key concepts are related to the idea that, if you can generate all your ETL and you can ‘replay’ your entire Data Warehouse (when you refactor for instance – using Persistent Staging Areas), you can basically virtualise your entire Data Warehouse (I coined the term ‘NoETL’ for this :-)).
Your Data Warehouse model essentially becomes a ‘schema-on-read’ on your raw data. This is further detailed in various papers, most importantly here and here.
This page contains updates and general version information. To make life easier I have added the following pages to this site:
- Installation guide and instructions
- Examples to get started
- Frequently Asked Questions (FAQ)
In general, all files (installation and support files) can be downloaded from the Github releases section. Hope everything works and is of some use. At this time the most recent working version is v1.6.9.
Also have a look at the TEAM software to create some of the input Json files in an easy way.