SSIS Packages Data Load Type

In ODE version prior to 5 you could only load the data into Data Vault from the source database on the same server where the configuration database is implemented. ODE version 5 could get the data into the Data Vault from another server via SSIS. ODE version 5...

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

Metrics Vault

Metrics Vault is a Data Vault for the data about the data. Metrics Vault is managed by ODE configuration database. It could be added to the Configuration at any time, and it will start collecting record stats, Vault data load time and record counts....

Task Scheduling

ODE provides a mechanism for ordering and executing groups of tasks in parallel. Without the Scheduler, all tasks are either run in series or they need to be scheduled by a 3rd Party application, which caters for parallel processing of tasks. In most cases,...

Configuration Release Management

ODE has a set of processes for Packaging Configuration Data and migrating it to other environments. This is a “Tight” release system – it uses the internal ODE Object Identifiers (Object keys) in order to apply Configuration to the next environment....

Raw Vault Layer – Create Satellite Table

Create or Recreate a Satellite Table. Process: {Configuration Database}.[dbo].[dv_create_satellite_table] Features: Using information from the Configuration Database, instantiates a Satellite Table. The Technical Columns and Naming Standards are derived from...