The software vendor 2150 Datavault Builder employs 15 data warehouse experts to drive the development of its Datavault Builder product with support from its partner Ventum Consulting, which employs 180 people. The tool is used in 240 installations on three continents. Implementation is also supported by 50 implementation partners.
The solution focuses on automating the full development, deployment and operations cycle of a data warehouse. It aims to reduce development time, project risk and maintenance costs in order to increase customer efficiency. Predefined templates support not only building data vault models but also relational or multidimensional models, flat tables and even providing data products based on data consumers’ needs. At the same time, the product ensures transparency through auditing and historization, including features such as data lineage. In addition, the system documents the resulting data warehouse.
The vendor has worked extensively on systems adaptability in the customer infrastructure. Datavault Builder is based on Docker containers and can be deployed on platforms of the customer’s choosing. Recently, the vendor announced the option to use Datavault Builder on Snowflake Snowpark Container Services, empowering data teams to easily set up their own data solutions. The tool itself consists of a server and a web-based interface for the creation of data models. Instead of using its own metadata repository, 2150 Datavault Builder decided to integrate the generated logic directly into the target database. Supported databases include Postgres, Microsoft SQL Server, Microsoft Azure Synapse, Oracle Database, Exasol and Snowflake. That means that Datavault Builder only acts as a modeling environment – code is executed in the target.
The tool provides a user-friendly interface with guided processes. For development support, it also integrates well with customers’ development processes and tools. For example, it integrates with versioning tools such as SVN and GIT as well as scheduling and monitoring tools including UC4 and BMC Control-M.
In terms of connectivity, Datavault Builder relies on market standards. It connects to several native-supported sources, JDBC-capable databases, some NoSQL databases, Python classes and different file formats as well as REST APIs.
The latest updates of the tool include Azure Synapse support, refactoring of the deployment module allowing deployments with 10,000 and more model elements, GIT integration and bi-temporal data processing for the finance industry.
