The government of Saskatchewan, Canada is seeking a data warehousing automation solution (DWAS) that leverages its existing investment in the Microsoft Azure ecosystem. The required solution must feature a comprehensive GUI-based data modeling editor, enabling users to integrate different data sources into a cohesive data vault model through graphical interface tools.

Key functionality includes capabilities for generating and exporting metadata related to data sources, data vaults, and business vaults, supporting data lineage extraction. The solution must be built on a cloud-native architecture with a robust, flexible security framework. Additionally, it should streamline the process of mapping large volumes of source metadata into standardized data vault structures, while empowering data modelers to review, adjust, or enhance the proposed models through an interactive GUI.

Vendors are expected to clearly describe how their solutions fulfill these requirements and address the specific challenges of metadata mapping and model customization. The contract period for the selected vendor will be two years.