Yotilla

83%* of companies are dissatisfied with their data warehouses. To a large part this is due to the data warehouses failing to keep up with the rapid pace of business change. Reorganizations, mergers and acquisitions all cause conventional data warehouses to need changes, as well as breaking the data load routines, transformations, data marts and links to analytic tools. All these structural changes need weeks or months to fix. Frequent changes means that data warehouse is rarely fully up to date, eroding customers trust in it, and reducing its business value.

You cannot stop business changing, but you can speed up the processes that need to be done when a data warehouse has to be amended. Ideally you would operate from a high-level model, making changes to that model to reflect new business hierarchies or data sources. Wouldn’t it be great if a software tool could translate these model changes into new logical and physical database design, as well as regenerating the necessary load routines, transformations etc that flow from these changes? What if these various changes could be automatically generated and applied, with no need for manual code amendments to load routines, transformation scripts or database schemas? In this way even quite significant data warehouse changes could be implemented quickly.

Yotilla is a data warehouse automation product that allows you to design a data warehouse in the form of a high level conceptual visual model that business users can understand. Yotilla generates and manages all layers of the data warehouse, including a data mart that can be directly used by analytic tools. Crucially, it generates the necessary load routines, logical and physical data model, database schema, transformations etc automatically from a conceptual model using business language. It runs on Exasol, Snowflake or on Amazon Redshift as you prefer. It is a modern, serverless, cloud-native product that you can find in the AWS Marketplace. Yotilla greatly speeds up the processes of deploying and changing a data warehouse, significantly reducing operational support costs and risk and the time to respond to business change. You can now have a fast, rapidly changing data warehouse, all based on rock solid German engineering. Yotilla makes your data warehouse flexible and enables it to better provide business value.

Fig 1 – Automated Architecture