2150 is a Swiss service provider specializing in data warehousing and business intelligence. Having identified the need for a solution that optimizes data warehouse creation and maintenance, development on the Datavault Builder product began back in 2012.
In 2016, a graphical user interface was added and the company started to promote the product in earnest. In all, five dedicated developers look after the development of Datavault Builder with support from its partner Ventum Consulting, which employs 130 people. Additional partners implement the software on the customer side. More than 30 customers are now using Datavault Builder.
Datavault Builder is a data warehouse automation tool focused on implementing the data vault methodology. It aims to simplify, speed up and automate data warehouse building by use of predefined templates. At the same time, the product ensures transparency through auditing and historization including features such as data lineage. In addition, the system creates a documentation of 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. In addition, customers can check the code into a version control system such as SVN or GIT, which can then be compared visually using the tool. Moreover, the software can use external scheduling tools such as UC4 or BMC Control-M. Datavault Builder also relies on market standards for connectivity. It connects to a number of native-supported sources, JDBC-capable databases and different file formats as well as REST APIs. The following databases function as target environments: Postgres, Microsoft SQL Server, Oracle Database and Exasol. Snowflake will also be supported soon.
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 decided to integrate the generated logic directly into the target database. That means that Datavault Builder only acts as a modeling environment – code is executed in the target.
User & Use Cases
Besides data integration (95 percent), customers mainly use Datavault Builder for data warehouse automation (85 percent) and data modelling (79 percent). 61 percent of respondents use it for enterprise data warehousing, 58 percent for data marts and 48 percent for data quality management. The tool is used especially by mid-sized companies and large corporations. 45 percent of our sample come from medium sized companies (101 to 2,5000 employees) and large companies (more than 2,500 employees).
Respondents point out that only around 3 people or 6 percent of the employees in the company use the tool. This is a very low number and shows that it is an expert tool for data warehouse developers used for modelling and developing purpose.
Percentage of employees using Datavault Builder
Number of users using Datavault Builder
Company size (number of employees)