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...

Satellite Change Data Capture Functions

In the Data Vault satellite is a container for business concept’s attributes and it has a SCD type 2 structure for storing the data. This means that history of record changes is stored in the satellite alongside with its current state. One have to use a set of...

How To Monitor and Troubleshoot Data Loads?

How to Monitor? You can set up a scheduled email to be sent to an administrator or to a group of administrators responsible for monitoring the Data Vault loads. ODE sends an email on procedure [dv_scheduler].[dv_report_email_manifest_progress] execution. SQL...