Steps described in this article are only applicable to earlier versions of ODE. Use the latest version for better ODE experience.

In ODE, Links represent Relationships between Hubs (Business keys).

To define a Link, you create the Configuration for the Link itself, then you point the link to the Hubs which it relates.

Every Link must have its own Source, which provides the Related Hub Business Keys.

Each Business key in the source needs to be related, by configuration, to the Hub Key which it will populate.

This is described in a separate page, which covers the association of Source Columns to the Vault Model.

ODE Config Logical Model - Link Focus

First Configure the Link:

{Configuration Database}.[dbo].[dv_link_insert]

Parameters:

  • @link_name – Your Chosen Link Name. Normally it will be a Business Name e.g. “Customer_Order”.
  • @link_abbreviation – 4 character artefact of ODE. You can define this manually or use “SELECT [dbo].[fn_get_next_abbreviation] ()” to generate one.
  • @link_schema – Schema where the Link will be placed e.g. “Lnk”.
  • @link_database – Database where the Link will be placed e.g. “ODE_Vault”.
  • @is_retired – Indicates whether the Source System is in use – 0 means in use, 1 means retired. This attribute is documentary only.
  • @release_number – If you want the new Link to be part of a specific release, provide the Release Number. If not, Zero.

The Procedure will return details of the Link, together with it’s Surrogate Key, which will be useful for building further Configurations.

Next, Relate the Link to it’s constituent Hubs (two or more).

Not that at this time, a Link in ODE cannot Relate to a Hub more than once.

{Configuration Database}.[dbo].[dv_hub_link_insert]

Parameters:

  • @link_key – the Key of the Link which you created above.
  • @hub_key – the Key of the Constituent Hub. To find this, Select * from [dbo].[dv_hub] where hub_name = ‘your_hub’.
  • @release_number – If you want the new Link to be part of a specific release, provide the Release Number. If not, Zero.

Example:


EXECUTE [dbo].[dv_link_insert]
 @link_name = 'Customer_Order'
,@link_abbreviation = 'L001'
,@link_schema = 'lnk'
,@link_database = 'ODE_Vault'
,@is_retired = 0
,@release_number = 20150001

Returns a Link Key of 97

Then:


EXECUTE [dbo].[dv_hub_link_insert]
@link_key = 97
,@hub_key = 134 -- where 134 is the Hub Key for Customer.
,@release_number = 2015001


EXECUTE [dbo].[dv_hub_link_insert]
 @link_key = 97
,@hub_key = 101 -- where 101 is the Hub Key for Order.
,@release_number = 2015001

Configure a New Satellite