AutomateDV is an open source tool for generating Data Vault 2.0™ data platforms using the dbt™ (a great tool for building ETL data pipelines).

Getting Started

AutomateDV uses metadata to generate and execute the ETL code needed to build a Data Vault warehouse, removing the need to write SQL. This leads to better quality code, fewer mistakes and improved productivity resulting in increased agility.

SET-UP

 

Configure dbt™ and your choice of database

EXPLORE

 

Learn with our worked example

BUILD YOUR OWN

 

Provide metadata and generate Data Vault tables

Data Sources

 

Load data from a variety of source systems

Metadata

 

Only provide metadata to AutomateDV

AutomateDV

 

Use AutomateDV to generate your Data Vault structures (hubs, links, satellites and more)

dbt™

 

Built on dbt™ for rapid and trusted development workflows

Data Platforms

 

Executes on your data platform

AI

MACHINE LEARNING

ANALYTICS

Create insights

Use your data to deliver business value

GET STARTED QUICKLY

Free download, extensive documentation, and examples available

MEET YOUR BUSINESS NEEDS

Highly configurable and open source that adapts to your business case.

SUPPORT DATA PRODUCTS

Building the foundation for effective data science and analytics using Data Vault and dbt.

ROBUST AUDIT TRAILS & DATA INTEGRITY

Data Vault inherent audit capabilities enhanced by the metadata provided by dbt.

BUILT-IN GOVERNANCE

Data Vault governance features supported by dbt.

SPEED UP TIME-TO-VALUE

Focus on delivering business value by automating the SQL operation.