Updated sample and metadata models for Data Vault generation and virtualisation
Note: this page has been updated in March 2019 to update QuickDBD to SQL DBM. I have a license to use SQL DBM to generate code, but for viewers the forward engineering will be limited to 10 objects. However, the full model is visible (and can be saved / copied) and the sample code can be generated from the TEAM application if required. If this doesn’t work feel free to email me as well at firstname.lastname@example.org.
After a bit of a pause in working on the weblog and technology (caused by an extended period of high pressure in the day job) I am once again working on some changes in the various concepts I’m writing about on this site. Recently I was made aware of this great little tool that supports easy creation and sharing of simple data models: SQL Database Modeller ‘SQL DBM’).
The tool is 100% online and can be found at https://www.sqldbm.com/. I have converted the ERwin based sample models on this new platform. It’s really useful – have a look.
One of the reasons for this effort is that ERwin does not provide a Community Edition anymore (boo!). The only option is a trial which lasts one month and requires re-registration every time. But stepping away from ERwin is really a blessing in disguise, as having a web-version of the models available makes updating and sharing a lot easier too. This allows for some closer collaboration as well with whoever is interested. So it’s all for the best.
I’ve moved the following models to the new SQL DBM platform:
- Sample source system model
- Staging Area sample model
- Persistent Staging Area sample model
- Data Vault sample model
These are the sample models you can use for trying out the Virtual Enterprise Data Warehouse application, I use these for regression testing. The example setup page for the Virtual EDW software has been updated as well to reflect this.