Data Vault Automation

Data Vault 2.0

Data Vault 2.0 includes an agile methodology and offers best practices and high-quality standards that are perfect for automation. While completed Data Vaults deliver many benefits, designing and developing them by hand requires significant time, effort and money. Data Vault Automation helps data warehousing teams deliver Data Vaults into production faster and with less risk.

Data Vault Automation leverages metadata and templates designed for the best practice use of the Data Vault 2.0 methodology in order to automate a data warehousing team’s work within the Data Vault lifecycle. From design and development to deployment, documentation and operation, data vault automation takes advantage of the patterns within the data vault lifecycle to automatically generate code, tables, objects, documentation and more.

Data Vault 2.0 Architecture

Data Vault Automation additionally serves as a set of guardrails for teams new to Data Vault and data vault modeling ensuring they adopt the Data Vault 2.0 principles appropriately. Data Vault 2.0 automation can greatly accelerate an organization’s ability to implement a data vault architecture and incorporate flexibility, scalability and change within its data infrastructure.

Request a Demo

Data Vault 2.0 Modeling

Data Vault 2.0 is a system of business that extends beyond the enterprise data warehouse to offer a data model capable of dealing with cross-platform data persistence, multi-latency and multi-structured data, and massively parallel platforms. The Data Vault 2.0 model, invented by Dan Linstedt, simplifies data integration from multiple sources, makes it easy to evolve or add new data sources without disruption, and increases scalability and consistency in enterprise data infrastructure.

A Data Vault 2.0 model consists of Hubs, Links and Satellites. A Hub is a unique business key, a Link is a relationship or association, and a Satellite is descriptive data. The combination of these categories come together to comprise a Data Vault network or data vault model – connecting an organization’s data and data streams in a flexible, repeatable way. A more in-depth description of Data Vault 2.0 can be found in this WhereScape blog or on

Data Vault Modeling.jpg

Dan Linstedt on WhereScape Data Vault Automation

Deliver Data Vaults faster with Data Vault Automation

WhereScape Data Vault Express™ automates the entire Data Vault lifecycle, helping you to deliver analytics solutions to the business far more quickly, at a much lower cost, and with better success than do-it-yourself approaches.

Learn more

WhereScape plays an integral part in our Data Vault development and is enabling us to substantially improve our delivery speed.

– Steve Taylor, Director of Enterprise Architecture, Micron Technology