Full Data Warehouse Automation
No Data Vault know-how required
Yotilla is a service that automatically provides a Data Warehouse that adapts at the same pace that business changes. Unlike other Data Warehouse Automation solutions on the market, Yotilla does not require any Data Vault know-how or Data Modelling to automate the Data Warehouse.
Discover the unique automation approach
Conceptual Model-driven workflow
The unique automation approach of Yotilla is based on a user-defined Conceptual Model. The Conceptual Model describes business objects, their relationships and how they are mapped to the sources. Users define the Conceptual Model with three simple steps.
Watch a use case demo- Map business objects to their sources
- Define business logic with formulas
- Define facts and dimensions for the Data Marts
Fully automated data modelling.
No Data Vault know-how required!
The user-defined Conceptual Model provides a blueprint from which Yotilla derives all the required logical and physical data models of the Data Warehouse. This means that the Raw Vault and the Business Vault are also fully automated. As a result, Data Vault know-how is not required!
Explore the architecture of a Data Warehouse automated with Yotilla
Measurable benefits for customers
Yotilla customers benefit from 9x faster first results and 14x faster adoption of changes compared to legacy Data Warehousing. The unique automation approach requires no Data Vault know-how and the high level of automation drastically reduces the number of Data Engineers required. Yotilla thus reduces costs by at least 50%.
Explore pricing- 9x faster for the first results
- 14x faster adoption of changes
- >50% cost savings
- No Data Vault know-how required
Supported databases
You own your data! Yotilla follows the ELT approach, your data never flows through Yotilla. Instead, Yotilla generates SQL statements and lets the database do the heavy lifting.
Currently, we support AWS Redshift, Exasol and Snowflake.
Product Features
Consolidate attributes of different sources
Consolidate data from several sources into one business object. Define the leading source per drag&drop.
Separate multiple objects in a source
Map all business objects of a source in the Conceptual Model. Yotilla automatically stores them separately but integrated in the Data Warehouse.
Load and inscription timelines
Yotilla automatically stores the data of the business objects with a load and an inscription timeline. The inscription timeline must be provided by the source.
Business logic with formulas
Define business logic as a scalar formula that uses business objects and attributes directly. As the relationships of the business objects in the Conceptual Model are known, Yotilla fully automates the implementation of your formulas.
Customized business logic
Define the attributes required for customized business logic and implement them with a view. Yotilla automatically provides the necessary data for your business logic without you having to access the Data Vault tables directly.
Early transformations
Use source-specific transformations to homogenize attributes with a simple formula (e.g. to standardize data type formats). These transformations are automatically applied with every load and integrate data from multiple sources.
Integrated Workflow Engine
Yotilla automatically generates all required load and transformation processes. The built-in Workflow Engine orchestrates and executes the loading processes automatically in the correct order.
Full Loads and Delta Loads
Yotilla supports Full Loads with delete detection and Delta Loads. Sources with Delta Loads can provide Soft Deletes.
Scheduler
Yotilla can load your sources based on a defined schedule per source.
The architecture of a modern Data Warehouse with Yotilla
Yotilla integrates your sources into the layers of a modern Data Warehouse:
- Staging
- The Staging Layer decouples the Data Warehouse from your sources by ingesting the data into the Data Platform. The data ingestion can be supported by the Data Ingestion tool of your choice.
- Core
- The Core Layer is the heart of the Data Warehouse. It contains all the history of the data but also integrates and homogenised your source data into the mapped business objects. Modern Data Warehouses leverage the Data Vault modelling approach consisting of a Raw Vaul and Core Vault. With Yotilla, all required data models for both the Raw Vault and the Business Vault are generated fully automatically. Further, all required ELT processes are generated fully automatically.
- Data Mart
- The Data Mart Layer provides a copy of selected business objects of the Core Layer modelled in a way that fast analytical queries can be executed by analytics downstream. The required data models of the Data Mart Layer as well as all loading processes are fully automated by Yotilla.
- Workflow
- The Workflow Engine by Yotilla schedules or starts all loading processes in the right order at the specified time so that data flows consistently from Staging through the Core Layer and finally into the Data Mart Layer.
Use Case Demo
Watch the video showing all the steps involved in automating a data warehouse completely: Starting with the definition of the business objects of the Conceptual Model and their assignment to the sources, through the addition of business logic to the definition of the data marts. The video shows the Conceptual Model of a typical retailer.