Skip to content
/ vau Public

Data Vault data model and ETL generator for Oracle Databases

License

Notifications You must be signed in to change notification settings

karsany/vau

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

80 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

VAU

Data Vault data modeling tool and ETL generator for Oracle Databases

Introduction

Model your datawarehouse DW layer, write your ETL/ELT logic with simple SQL SELECT commands, generate table scripts, stored procedures and documentation.

VAU is a datawarehouse source code generator supporting Oracle Databases. It helps generating the DW layer in a datawarehouse, based on Data Vault methodology.

VAU is licenced under the BSD licence, and is 100% free.

Features

A few things you can do with VAU:

  • model DW layer: entities/hubs, sattelites, links and reference tables
  • map the Stage layer to DW layer with SQL SELECT or with VAU's simplemap
  • generate table scripts and sequences for DW layer
  • generate loader procedures for populating the DW tables
  • generate example mapping
  • generate data model diagram and CSV
  • generate table and column lineage CSVs
  • you can version your DW model and logic with GIT, SVN, etc.

Feedback

If you notice any bugs in the app, see some code that can be improved, or have features you would like to be added, please create an issue!

If you want to open a PR that fixes a bug or adds a feature, then we can't thank you enough! It is definitely appreciated if an issue has been created before-hand so it can be discussed first.

Build Process

Currently -- due to heavy development -- there is no released versions yet. If you want to build VAU, you can do it by running nightly_snapshot.bat from tools directory. It compiles the binary version: vau-bin-yyyymmdd-hhmmss.zip

Prerequisites for build are: jdk8 or above, maven, git, cat, grep, sed.

If you unzip the build somewhere, there will be a vau.cmd in it.

Compile the example from directory examples/oracle-hr with:

vau.cmd clean compile doc

About

Data Vault data model and ETL generator for Oracle Databases

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published