General

•  Fully compliant with DataVault model
• Open source, freely available and fully functional
• Thin frontend runs on Windows
• Backend runs on any Java Virtual Machine (JVM)
• Template based load code generation
• Fully documented source code available

Source model

• Reverse engineer source data models from any database platform using generic JDBC connections
• Automatically generate staging model
• Generate extract and load code from source to staging area (only when sources and data warehosue are on the same database instance)
• Add metadata to source models and identify business keys

 Data warehouse generation

• Automatically generate DataVault data warehouse model from staging area
• Generate load code from staging area to datavault
• Optionally use meaningless ID's
• Option to exclude source tables and/ or columns
• Split and merge satellites
• Identify reference tables
• Group relations into one link
• Generate views that reproduce the (point-in-time) source model

Deployment

• Deploy data warehouse and staging models using generated DDL and load code using ANSI-SQL