Step by Step Configuration of a Data Source and Related Vault Structures - OptimalBI/optimal-data-engine-mssql GitHub Wiki

These concepts work in earlier versions of ODE only. They won’t work if you use the latest version. Refer this page for the latest version concepts.

In ODE terms, a Data Source can be either a Feed from an outside system or the result of a Stored Procedure, which has processed ODE Data into a new form.

In either case, the Configuration Involves 3 distinct Steps:

1. Configure the Vault
   • Configure the Hubs, generally to represent core business concepts;
   • Links are configured to define relationships between the Hubs
   • Satellites define where and how the actual data will be stored, in relation to either owning Hubs and Links.
2. Configure the Data Source
   • Each Source System is configured, mainly for Documentation / Lineage purposes.
   • Each “Source Table” references a Source System and may have logic attached to it in the form of a Stored Procedure.
   • All columns for the Source table need to be defined.
3. Associate the Source Table to its Vault Structure.