Persistent Staging Area with ODE

In ODE version 5 we have added SSIS (MS SQL Server Integration Services) data loads and CDC (Change Data Capture) loads.This functionality is enough to build Persistent Staging Area with ODE. PSA is a copy of the source database, but all the changes to all the records...

Create a Data Vault with ODE v5

ODE is available as a download from GitHub, which has the instructions for implementing the Configuration Database. Configuration is a heart and brain of ODE Data Vault. Other organs include stage and vault databases. From ODE version 5 these databases should have a...

Preparation for Data Vault Modeling

Pre-requisite for creating Data Vault ensembles and links is an ODE Config database installed (refer here for ODE installation instructions), stage and vault databases created and have an audit table in there (refer here for the Data Vault database installation...