SSIS Packages Data Load Type

In ODE version prior to 5 you could only load the data into Data Vault from the source database on the same server where the configuration database is implemented. ODE version 5 could get the data into the Data Vault from another server via SSIS (Microsoft SQL Server...

Building a Data Vault with ODE v5

Data Vault with ODE 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. Modelling 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...