Data Vault is a modeling methology developed by Dan Linstedts.

 

Due to is characteristics, this approach is a really candidate for automated processing.  Using this characteristics we created automated processing permitting, from a source data model:

 

• Physical data models:

  • Creation of data vault model

  • Creation of data models for intermediate steps

  • Complete linage between all models

  • All SQL to load all tables in all models

  • Optionnaly usage of customizable "optimization" extended model for each database technology to produce 

 

• Data movement models:

  • Creation of all data flows with all components to be used to produce the solution

  • Creation of orchestration: considering all depedencies, orchestration is the flow organisation to produce the final solution

 

• ETL (new since SAP PowerDesigner 16.5 SP05)

  • Data movement models can now be used to generate Data Services 4.2 XML file (with existing limitations as documented)

 

The process is complex but very fast and permit to gain weeks or months of work with a high level quality, reproductible results, a complete linage with complete data models for all stages (which is often missed in projects).

 

 

Data vault service is declined in two ways:

• Off site service or "Datawarehouse in Half week": you provide data model in the form of DDL for a supported database with information about Business Keys.  After control of the generation made, We produce DDL of all layers and SQL to load data.

• On site service: we come in your site wand we make the work with you.