Blog Masonry

Welcome to My Blog

Here is a masonry blog layout with no sidebar

How To Upgrade ODE

There are multiple versions of ODE as we constantly improving it. To make sure you've got all the features available in latest version, you can upgrade your ODE Config to the latest version. ODE is an open source product. That means anybody is allowed to make changes...

What Is My Current ODE Version?

As any other product, ODE has versions. Different ODE versions could be significantly different. We have restructured ODE Config database once and we could do it again as we constantly improving ODE. We have created a number of useful helper scripts. They do all the...

Building a Data Vault with ODE v4

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

Quick Start with ODE v4

Sometimes developers don’t want to read much theory, they just too keen to start doing things and learn from the process. Here is a sample list of queries allowing to build your first ensemble with ODE in a few minutes. In this example we’ll create a Person hub and...

Building a Data Vault with ODE v2

Many concepts described here are only applicable to earlier versions of ODE. Use the latest version for better experience with ODE. Data Vault with ODE Data Vault is a Data Warehousing methodology. Learn more about it here. ODE is a config-driven engine for building...

How To Back Out a Release?

Incremental release system allows small pieces of development to be deployed at once. It also allows removing these pieces easily, for example in case if feature is no longer required. Records could be removed from Config database by using a set of deletion stored...

Big List of Standards

The sections below describe most of standards we have for Data Vault objects in the Optimal Data Engine. Whatever is on this web page is our current version. Databases ODE Data Vault solution will have at least three databases, configuration, stage and vault itself....

Query Builder

The core idea of the Data Vault is Ensemble modelling. Core business concepts are represented by hub tables. Relationships between concepts are represented by link tables. Satellites store attributes and also some metadata. The number of satellites associated with hub...

How To Implement Delta Load

This feature works in earlier versions of ODE. Read this page to find out how it works in latest versions. ODE supports two types of data load, Full and Delta. Full load checks all the data changes for a table, including deletions. Delta load includes inserts and...

How To Do a Full Release

ODE configuration releases are aligned with the Agile process. Developers could deploy small releases for a sprint or user story piece of work. Incremental deployment process is described in another article. This article describes a process of synchronisation of two...

How To Do an Incremental Release

ODE release system supports both small incremental releases and full releases to a next environment. Read more about a release theory here. Developer can choose a size of the release by setting a release number to configuration records. One release could include any...

Quick Start

This article describes the process of configuring new Data Vault objects with earlier versions of ODE. Read this page instead if you use the latest version. Sometimes developers don't want to read much theory, they just too keen to start doing things and learn from...

How To Implement a Link in ODE?

This article describes the basic concept of Link implementation in ODE. For a step-by-step configuration guide please refer to Configure a New Link. Every Link must have a Source for defining the relationship between hubs being linked. The Hub key is generated by ODE...