-
Notifications
You must be signed in to change notification settings - Fork 9
Building a Data Vault with ODE v4
Data Vault is a Data Warehousing methodology. Learn more about it here. ODE is a config-driven engine for building and managing Data Vaults.
At the moment ODE only works with MS SQL Server. Refer here for the latest ODE installation.
Refer our approach for ODE Data Vault structure. This article describes ODE DV objects naming convention you can follow.
Make sure you are running the latest version of ODE. This article helps if you have ODE installed, but you don’t know its version. If your version is ODE v2, some of the following articles are irrelevant to you. Either upgrade to the latest version or use ODE v2 scripts.
Refer a quick start to build your first Data Vault ensemble based on Adventure Works table in a few minutes.
Ready to start with the real data? Use this article to configure a Hub and Satellite. Then use this article to configure a Link.
Once Data Vault is configured, build physical tables.
ODE engine allows scheduling the data loads and releasing configuration to another environment.
Query builder could help with selecting the data from Data Vault.
Use Metrics Vault to audit and capture all the pretty data about your Data Vaults.
Any two Data Vault objects could be reconciled against each other, just let ODE know how to match fields from both sides.
Got stuck? Maybe one of the following articles could help.
ODE Config Entity Relationship Diagram
Should Business Keys be Stored as Concatenated Keys or Separate Fields in the Hub?
How To Implement a Link in ODE?
How To Implement Same-As or Hierarchical Link
Where do you Store Point in Time for Information for a Link
Why do Queries, used to load Links often use DISTINCT?
How To Create Calculated Fields
How Does ODE Deal with Start / End Dating of Satellites
Should the Business Keys be retained on the Satellite?
What are Tombstone Rows and why does ODE have them?
Why do we use specify a Unique Row Key on Satellite Tables?
Why do we Record the Source of each Row in a Satellite?
Why do we Capture all Column Detail in the Configuration Database?