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 App, 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
| Sample | Description |
|---|---|
| 01 - MSSQL Starting Point | A sample starting point for on-premise Microsoft SQL Server and SSIS. Contains sample Connections, Batches and Projects. Use this starting point to import metadata from AdventureWorksLT and build an initial solution. |
| 02 - MSSQL After Import | A sample starting point for on-premise Microsoft SQL Server and SSIS. Contains sample Connections, Batches, Projects, including imported AdventureWorksLT source metadata objects. |
| 03 - MSSQL DataMart ETL SSIS Solution | On-premise Microsoft SQL Server and SSIS configuration for ETL-style data processing. Contains a two-tiered solution design with a configured Data Mart. |
| 04 - MSSQL DataVault ETL SSIS Solution | On-premise Microsoft SQL Server and SSIS configuration for ETL-style data processing. Contains complete Data Vault and Data Mart sample metadata. |
| 05 - MSSQL DataVault ELT SSIS Solution | Microsoft SQL Server on-premises SSIS configuration for ELT data processing. Contains a complete Data Vault and Data Mart. |
| 06 - MSSQL DataMart SSIS Solution | Microsoft SQL Server on-premises SSIS configuration for ELT data processing. Contains a two-tiered solution design with a configured Data Mart. |
| 07 - MSSQL DataVault ADF Solution | Microsoft SQL Server on-premises ADF configuration, meant to be used with a Self-Hosted Integration Runtime (SHIR). Contains a complete Data Vault and Data Mart. |
| 08 - MSSQL DataMart ADF Solution | Microsoft SQL Server on-premises Target, ADF and Data Mart sample metadata. |
| 15 - Synapse DataVault SSIS Solution | Microsoft Azure Synapse SSIS configuration. Contains a complete Data Vault and Data Mart. |
| 16 - Synapse DataMart SSIS Solution | Microsoft Azure Synapse Target, SSIS and Data Mart sample metadata. |
| 17 - Synapse DataVault ADF Solution | Microsoft Azure Synapse ADF configuration. Contains a complete Data Vault and Data Mart. |
| 18 - Synapse DataMart ADF Solution | Microsoft Azure Synapse Target, ADF Data Mart sample metadata. |
| 19 - Synapse Change Tracking ADF Solution | Microsoft Azure Synapse Target, ADF, Change Tracking source sample metadata. |
| 25 - Snowflake DataVault SSIS Solution | Snowflake Data Vault SSIS configuration. Contains a complete Data Vault and Data Mart. |
| 26 - Snowflake DataMart SSIS Solution | Snowflake Target, SSIS and Data Mart sample metadata. |
| 27 - Snowflake DataVault ADF Solution | Snowflake Data Vault SSIS configuration. Contains a complete Data Vault and Data Mart. |
| 28 - Snowflake DataMart ADF Solution | Snowflake Target, ADF and Data Mart sample metadata. |
| 37 - SQLDB DataVault ADF Solution | Azure SQL Database Data Vault ADF configuration. Contains a complete Data Vault and Data Mart. |
| 38 - SQLDB DataMart ADF Solution | Microsoft Azure SQL Database Target, ADF and Data Mart sample metadata. |
| 41 - Synapse Dynamics ADF Solution | Microsoft Azure Synapse Target, ADF and Dynamics CRM source sample metadata. |
| 42 - Synapse Salesforce ADF Solution | Using a Salesforce Rest API connection to a 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 a Azure Synapse Database Target with ELT stored procedures for transformations and SQL Server Integration Services for orchestration. |
| 51 - File MSSQL DataVault ELT SSIS Solution | Microsoft SQL Server on-premises Target, SSIS and full Data Vault from File source sample metadata. |
| 52 - File Synapse DataVault ELT SSIS Solution | Microsoft Azure Synapse Target, SSIS and full Data Vault from File source sample metadata. |
| 53 - File Snowflake DataVault ELT SSIS Solution | Snowflake Target, SSIS and full Data Vault from File source sample metadata. |
| 54 - File MSSQL DataVault ELT ADF Solution | Microsoft SQL Server on-premises Target, ADF and full Data Vault from File source sample metadata. |
| 55 - File Synapse DataVault ELT ADF Solution | Microsoft Azure Synapse Target, ADF and full Data Vault from File source sample metadata. |
| 56 - File Snowflake DataVault ELT ADF Solution | Snowflake Target, ADF and full Data Vault from File source sample metadata. |
| 57 - File SQLDB DataVault ELT ADF Solution | Microsoft Azure SQL Database Target, ADF and full Data Vault from File source sample metadata. |
| 61 - Delta Lake ADF DataVault DataFlow Solution | |
| 62 - Delta Lake ADF DataMart DataFlow Solution |