Release Config with SSIS package

ODE configuration release mechanism includes a step of writing into the file. We found that some organisations limit developer security permissions, making this function unavailable for them. We have implemented this SSIS package to be used in this case. Configuration...

How To Monitor and Troubleshoot Data Loads?

How to Monitor? You can set up a scheduled email to be sent to an administrator or to a group of administrators responsible for monitoring the Data Vault loads. ODE sends an email on procedure [dv_scheduler].[dv_report_email_manifest_progress] execution. SQL...

How To Reconcile Tables Using ODE v4

One of the new features of ODE version 4 is built-in reconciliation. This feature can be used to compare any two objects in the Data Vault including staging tables. So you can compare two satellites, or stage table and satellite, or two links, or any other combination...

How To Version Business Rules in ODE v4

ODE attaches all Processing Rules to “Source Tables”. Each Source Table can have a number of Source Table Versions, only one of which may be “Current”. The rest are retained for history and tracking purposes. As data is loaded into the Vault,...

How To Create a Calculated Field in ODE v4

In ODE v4 we have introduced a new feature, we call it functions. Functions could be used in satellites to calculate attributes on the fly (during the load actually) from other satellite’s columns, i.e. calculated columns. At the moment most of the load logic is...