Sample Metadata
BimlFlex provides several sets of sample metadata and configurations.
These samples support various common use-cases and scenarios and are intended to assist adopting specific features for certain architectures and technical environments. The full list of available samples is available in the samples documentation.
For example, samples cover how to load files using SQL Server Integration Services (SSIS), how to implement delete detection to load data into Azure, or how to deliver a Data Vault model on Snowflake.
In the BimlFlex Application, use the Load Sample Metadata button in the Getting Started pane on the Dashboard to load sample metadata to the current active Customer.
tip
The Varigence YouTube channel contains various introduction videos about using BimlFlex and BimlStudio. This video provides an overview of how to load sample metadata into BimlFlex.
Available Metadata Samples
Starting Point Samples
| Sample | Description |
|---|---|
| 00.01 - MSSQL SSIS Starting Point | Sample connections, batches and projects for an SSIS Microsoft SQL Server Data Warehouse. Use this starting point to import metadata from AdventureWorksLT to build the Data Warehouse |
| 00.02 - MSSQL ADF Starting Point | Sample connections, batches and projects for an ADF Microsoft SQL Server Data Warehouse. Use this starting point to import metadata from AdventureWorksLT to build the Data Warehouse |
| 00.03 - Synapse SSIS Starting Point | Sample connections, batches and projects for an SSIS Azure Synapse Data Warehouse. Use this starting point to import metadata from AdventureWorksLT to build the Data Warehouse |
| 00.04 - Synapse ADF Starting Point | Sample connections, batches and projects for an ADF Azure Synapse Data Warehouse. Use this starting point to import metadata from AdventureWorksLT to build the Data Warehouse |
| 00.05 - Azure SQLDB ADF Starting Point | Sample connections, batches and projects for an ADF Azure SQL Database Data Warehouse. Use this starting point to import metadata from AdventureWorksLT to build the Data Warehouse |
| 00.10 - Snowflake SSIS Starting Point | Sample connections, batches and projects for an SSIS Snowflake Data Warehouse. Use this starting point to import metadata from AdventureWorksLT to build the Data Warehouse |
| 00.11 - Snowflake ADF Starting Point | Sample connections, batches and projects for an ADF Snowflake Data Warehouse. Use this starting point to import metadata from AdventureWorksLT to build the Data Warehouse |
| 00.15 - Databricks DeltaVault ADF Starting Point | Sample connections, batches and projects for an ADF Databricks Data Warehouse built as a DeltaVault, a Data Vault stored as Delta tables on Azure Databricks with Unity Catalog tables. Use this starting point to import metadata from AdventureWorksLT to build the Data Warehouse |
Microsoft SQL Server Samples
| Sample | Description |
|---|---|
| 01 - MSSQL Starting Point | Sample connections, batches and projects for a Microsoft SQL Server-based Data Warehouse. Use this starting point to import metadata from AdventureWorksLT to build the Data Warehouse |
| 02 - MSSQL After Import | After Import before Data Vault Modeling for MSSQL. Includes imported metadata from the AdventureWorksLT source |
| 03 - MSSQL DataMart ETL SSIS Solution | Using a SQL Server Database (On-Prem), the final metadata for a complete Data Mart Project (STG, PSA, DM) using SQL Server Integration Services for transformations and SQL Server Integration Services for orchestration. |
| 04 - MSSQL DataVault ETL SSIS Solution | Using a SQL Server Database (On-Prem), the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using SQL Server Integration Services for transformations and SQL Server Integration Services for orchestration. |
| 05 - MSSQL DataVault ELT SSIS Solution | Using a SQL Server Database (On-Prem), the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 06 - MSSQL DataMart SSIS Solution | Using a SQL Server Database (On-Prem), the final metadata for a complete Data Mart Project (STG, PSA, DM) using ELT stored procedures for transformations and SQL Server Integration Services for orchestration. |
| 07 - MSSQL DataVault ADF Solution | Using a SQL Server Database (On-Prem), the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 08 - MSSQL DataMart ADF Solution | Using a SQL Server Database (On-Prem), the final metadata for a complete Data Mart Project (STG, PSA, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 09 - MSSQL Business Central ADF Solution | Using a SQL Server Database (On-Prem), the final metadata for a complete Persistent Staging Project (STG, PSA) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 10 - MSSQL Change Tracking ELT SSIS Temporal | Using a SQL Server Database (On-Prem), the final metadata for Change Tracking using ELT stored procedures for transformations and SQL Server Integration Services for orchestration with Temporal PSA Tables. |
| 11 - MSSQL Change Tracking ADF Temporal | Using a SQL Server Database (On-Prem), the final metadata for Change Tracking using ELT stored procedures for transformations and Azure Data Factory for orchestration with Temporal PSA Tables. |
| 12 - MSSQL Change Data Capture SSIS Solution | Using a SQL Server Database (On-Prem), the final metadata for Change Data Capture using ELT stored procedures for transformations and SQL Server Integration Services for orchestration with Temporal PSA Tables. |
Azure Synapse Samples
| Sample | Description |
|---|---|
| 15 - Synapse DataVault SSIS Solution | Using an Azure Synapse Database, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and SQL Server Integration Services for orchestration. |
| 16 - Synapse DataMart SSIS Solution | Using an Azure Synapse Database, the final metadata for a complete Data Mart Project (STG, PSA, DM) using ELT stored procedures for transformations and SQL Server Integration Services for orchestration. |
| 17 - Synapse DataVault ADF Solution | Using an Azure Synapse Database, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 18 - Synapse DataMart ADF Solution | Using an Azure Synapse Database, the final metadata for a complete Data Mart Project (STG, PSA, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 19 - Synapse Change Tracking ADF Solution | Using an Azure Synapse Database, the final metadata for Change Tracking using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
Microsoft Fabric Samples
| Sample | Description |
|---|---|
| 20 - Fabric DataVault Solution | Using a Microsoft Fabric Lakehouse and Warehouse, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and Microsoft Fabric Data Factory for orchestration. |
| 21 - Fabric DataMart Solution | Using a Microsoft Fabric Lakehouse and Warehouse, the final metadata for a complete Data Mart Project (STG, PSA, DM) using ELT stored procedures for transformations and Microsoft Fabric Data Factory for orchestration. |
Snowflake Samples
| Sample | Description |
|---|---|
| 25 - Snowflake DataVault SSIS Solution | Using a Snowflake Database, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and SQL Server Integration Services for orchestration. |
| 26 - Snowflake DataMart SSIS Solution | Using a Snowflake Database, the final metadata for a complete Data Mart Project (STG, PSA, DM) using ELT stored procedures for transformations and SQL Server Integration Services for orchestration. |
| 27 - Snowflake DataVault ADF Solution | Using a Snowflake Database, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 28 - Snowflake DataMart ADF Solution | Using a Snowflake Database, the final metadata for a complete Data Mart Project (STG, PSA, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
Azure SQL Managed Instance Samples
| Sample | Description |
|---|---|
| 35 - SQLMI DataVault ADF Solution | Using an Azure SQL Managed Instance Database, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 36 - SQLMI DataMart ADF Solution | Using an Azure SQL Managed Instance Database, the final metadata for a complete Data Mart Project (STG, PSA, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
Azure SQL Database Samples
| Sample | Description |
|---|---|
| 37 - SQLDB DataVault ADF Solution | Using an Azure SQL Database, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 38 - SQLDB DataMart ADF Solution | Using an Azure SQL Database, the final metadata for a complete Data Mart Project (STG, PSA, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 39 - SQLDB Change Data Capture ADF Solution | Using an Azure SQL Database, the final metadata for Change Data Capture using ELT stored procedures for transformations and Azure Data Factory for orchestration with Temporal PSA Tables. |
Third-Party Source Samples
| Sample | Description |
|---|---|
| 41 - Synapse Dynamics ADF Solution | Using a Dynamics CRM 365 Rest API connection to an Azure Synapse Database Target with ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 42 - Synapse Salesforce ADF Solution | Using a Salesforce Rest API connection to an Azure Synapse Database Target with ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 43 - Synapse Salesforce SSIS Solution | Using a Salesforce Rest API connection to an Azure Synapse Database Target with ELT stored procedures for transformations and SQL Server Integration Services for orchestration. |
File Source Samples
| Sample | Description |
|---|---|
| 51 - File MSSQL DataVault ELT SSIS Solution | Using Flat Files to a SQL Server Database (On-Prem) connection, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using SQL Server Integration Services for transformations and SQL Server Integration Services for orchestration. |
| 52 - File Synapse DataVault ELT SSIS Solution | Using Flat Files to a Synapse Database connection, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using SQL Server Integration Services for transformations and SQL Server Integration Services for orchestration. |
| 53 - File Snowflake DataVault ELT SSIS Solution | Using Flat Files to a Snowflake Database connection, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using SQL Server Integration Services for transformations and SQL Server Integration Services for orchestration. |
| 54 - File MSSQL DataVault ELT ADF Solution | Using Flat Files to a SQL Server Database (On-Prem) connection, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 55 - File Synapse DataVault ELT ADF Solution | Using Flat Files to a Synapse Database connection, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 56 - File Snowflake DataVault ELT ADF Solution | Using Flat Files to a Snowflake Database connection, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
| 57 - File SQLDB DataVault ELT ADF Solution | Using Flat Files to an Azure SQL Database connection, the final metadata for a complete Data Vault Project (STG, PSA, DV, DM) using ELT stored procedures for transformations and Azure Data Factory for orchestration. |
Databricks Samples
| Sample | Description |
|---|---|
| 65 - Databricks Persistent Staging Solution | Using Flat Files and an Azure SQL Database connection, the final metadata for a complete Data Lake Landing Project (STG, PSA) using Azure Databricks for transformations and Azure Data Factory for orchestration. |
| 66 - Databricks DeltaVault Pushdown Solution | A DeltaVault project, a Data Vault built as Delta tables on Azure Databricks with Unity Catalog tables. Using Flat Files and an Azure SQL Database connection, the final metadata for a complete Hash Key Data Vault Project (STG, PSA, DV, DM) using Azure Databricks with Unity Catalog Tables for transformations and Databricks Pushdown Processing for orchestration. |
| 67 - Databricks DeltaVault Solution | A DeltaVault project, a Data Vault built as Delta tables on Azure Databricks with Unity Catalog tables. Using Flat Files and an Azure SQL Database connection, the final metadata for a complete Hash Key Data Vault Project (STG, PSA, DV, DM) using Azure Databricks with Unity Catalog Tables for transformations and Azure Data Factory for orchestration. |
| 68 - Databricks DeltaVault SQL Solution | A DeltaVault project, a Data Vault built as Delta tables on Azure Databricks with Unity Catalog tables. Using Flat Files and an Azure SQL Database connection, the final metadata for a complete Hash Key Data Vault Project (STG, PSA, DV, DM) using Azure Databricks with Unity Catalog Tables for transformations and Databricks SQL Scripting Pushdown Processing for orchestration. |
Business Model Samples
| Sample | Description |
|---|---|
| 90 - Business Model Starting Point | This sample provides the starting point involved in creating a comprehensive business model. It is tailored for those looking to understand the foundational elements of a successful business modelling strategy. |
| 91 - Business Model Concepts Added | This sample provides the starting point with the Business Concepts added for creating a comprehensive business model. It is tailored for those looking to understand the foundational elements of a successful business modelling strategy. |
| 92 - Business Model Accelerator | This sample provides the starting point for Data Vault Acceleration with the Business Concepts added for creating a comprehensive business model. It is tailored for those looking to understand the foundational elements of a successful business modelling strategy. |
| 93 - Business Model Accelerated | This sample provides the Accelerated for Data Vault with the Business Concepts added for creating a comprehensive business model. It is tailored for those looking to understand the foundational elements of a successful business modelling strategy. |
| D01 - Willibald Starting Point | VARIGENCE: Metadata Starting Point for the Data Vault User Group (DDVUG) Willibald case study. The Willibald data model is a Data Vault-ready blueprint that unifies webshop orders and point-of-sale "roadshow" transactions for the fictitious seed-and-plant retailer "Willibald." |
| D02 - Willibald Imported Source | VARIGENCE: Metadata with Imported Source Schema for the Data Vault User Group (DDVUG) Willibald case study. |
| D03 - Willibald Source Modeled | VARIGENCE: Metadata with Imported and Modeled Source Schema for the Data Vault User Group (DDVUG) Willibald case study. |
| D04 - Willibald Business Modeled | VARIGENCE: Metadata with Imported Source Schema and Business Model for the Data Vault User Group (DDVUG) Willibald case study. |
| D05 - Willibald DataVault Accelerated | VARIGENCE: Metadata with Imported Source and Modeled Schema, Business Model and Data Vault Accelerated for the Data Vault User Group (DDVUG) Willibald case study. |
| D06 - Willibald DataMart Derived | VARIGENCE: Metadata with Imported Source and Modeled Schema, Business Model, Data Vault Accelerated and Data Mart Derived for the Data Vault User Group (DDVUG) Willibald case study. |