• PRODUCTS
  • SUPPORT
  • DOCS
  • PARTNERS
  • COMPANY
  • QUOTE
  • ACCOUNT
  • STORE
QUOTE

Documentation

Support Forums
What can we help you with?
Topics

Designing and delivering a Data Vault with BimlFlex

Data Vault provides an easy-to-explain and flexible way to tackle complex issues for bringing data together, and BimlFlex is optimized to deliver data solutions that have adopted this approach.

The Data Vault design and development can be done quickly and efficiently, using the BimlFlex Data Vault Accelerator.

This guide assumes the BimlFlex product has been installed, configured and that the sample source metadata is ready to be modeled.

Note

More information on getting started with BimlFlex:

  • BimlFlex Getting Started Intro Videos
  • BimlFlex Setup Overview

Data Vault Essentials

  • A brief introduction of Data Vault
  • Data Vault Hubs - the Core Business Concept
  • Data Vault Links - the Natural Business Relationship
  • Data Vault Satellites - the Context entity containing descriptive information
  • Data Vault and Business Data Vault
  • Point-in-Time tables
  • Bridge tables
  • Reference Data

BimlFlex Concepts for Data Vault

BimlFlex provides various ways to implement data solutions that utilize concepts from Data Vault methodology:

  • BimlFlex best practices for Data Vault
  • Integration Key Concept
  • Using hashing for Data Vault
  • Driving Keys in BimlFlex
  • BimlFlex solution templates for Data Vault
  • Zero records

Delivering Data

BimlFlex allows the creation of a Dimensional Model (Data Mart) from metadata. This can be based on existing objects, such as Satellites, Point-In-Time or Bridge objects, or views added as a separation-of-concern layer on top of the 'Raw' and 'Business' Data Vault constructs.

  • Business Data Vault
  • Facts and Dimensions on Data vault

Recommendations for implementing Data Vault on Microsoft Azure Synapse Analytics

  • Implementing Data Vault on Synapse

© Varigence