Databases and Schemas

ODE can be configured with a number of databases and schemas. Our standard approaches are as follows: MS SQL Server Our existing ODE deployments on SQL Server use several databases and schemas. ODE_Config ODE_Stage or ODE_Raw_Stage, with schema “stage”....

Reconciliation Testing ODE

When doing a data conversion between applications reconciliation testing is simple. Everything that was in the source application should be in the destination, and everything that is in the destination should be in the source. A data warehouse is a more complicated to...

Date Dimension overview

Almost everything a data warehouse is asked to do involves dates: days, weeks, months, years, periods of interest, special days. These date details “are attached to virtually every fact table to allow [easy] navigation…” (Source: Kimball Group) A...

Understanding Git Architecture

Git has a distributed architecture, illustrated by the following diagram. Every git user has git installed locally on their computer. For each product they have a workspace, which is a set of folders, and git maintains an index and a local repository. In addition to...

Data Layers

One line overiewBusiness viewTechnical viewPrincipals view   Staging The data extracted from source systems Time Variant A record of all changes in data over all time.  May also contain an operational data store. Raw Vault Business context is applied to the...

3CpO

3CpO is the name we give to the ODE framework.  Its an acronym for three C’s plus an O.  These are: Configuration Code Generation Code Execution Orchestration Config Config is the relational data model we have built that holds all the configuration...