--- title: Microsoft SQL Server Data Vault and Mart description: Microsoft SQL Server Data Vault and Mart generates a Stage, Raw Vault, Business Vault and Mart for SQL Server as T-SQL scripts with stored procedures. --- [Skip to content](https://knowledge.bigenius-x.com/microsoft-sql-server-data-vault-and-mart#main-content) [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en) [![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/) Open main navigation Close main navigation - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new) - [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal) How can we help you? - There are no suggestions because the search field is empty. 1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en) 2. [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en) 3. [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server) # Microsoft SQL Server Data Vault and Mart **Applies to** Platform: Microsoft SQL Server Architecture: Data Vault · Data Mart Microsoft SQL Server Data Vault and Mart generates a Stage, Raw Vault, Business Vault and Mart for SQL Server as T-SQL scripts with stored procedure loaders. Select the Generator Configuration `Microsoft SQL Server DataVault & Mart` when you add a project whose Data Vault and data marts run on SQL Server. ### Scope and output - Platform: Microsoft SQL Server. - Layers: Source, Stage, Raw Vault, Business Vault and Mart. Dataflow Modeling shows Stage in the Bronze column, both vault layers in the Silver column and the Mart model objects in the Datamart column, which is Gold. See [Understand the Layering concept](https://knowledge.bigenius-x.com/understand-the-layering-concept?hsLang=en). - Output: the layer scripts `SQL\L010_Stage.sql` to `SQL\L040_Mart.sql`, the load control scripts or an Airflow DAG, and the PowerShell 7 scripts that deploy and load, described in [Microsoft SQL Server - Artifacts](https://knowledge.bigenius-x.com/microsoft-sql-server-artifacts?hsLang=en). ### Prerequisites - A SQL Server instance and a login that can create the databases, schemas and objects of the layers and the load control. Each layer script creates its database with the recovery model `SIMPLE` and its schema when they are missing. - PowerShell 7 and sqlcmd on the machine that deploys. The setup is described in [Microsoft SQL Server - Target environment](https://knowledge.bigenius-x.com/microsoft-sql-server-target-environment?hsLang=en). The placeholders for the server, database and schema names are listed in [Microsoft SQL Server - Placeholder values](https://knowledge.bigenius-x.com/microsoft-sql-server-placeholder-values?hsLang=en). ### Sources and linked projects Stage source views read each source table by its four-part name `[].[].[].[]`. The server name stays empty for a source database on the same instance; otherwise it is the name of a linked server. The discovery types are listed in [Source systems per generator configuration](https://knowledge.bigenius-x.com/source-systems-per-generator-configuration?hsLang=en), and [Discover a Microsoft SQL Server database](https://knowledge.bigenius-x.com/discover-a-microsoft-sql-server-database?hsLang=en) creates the source model objects. You can [import a linked project](https://knowledge.bigenius-x.com/import-a-project-to-be-used-as-a-linked-project?hsLang=en) as a source and [export this project as a linked project](https://knowledge.bigenius-x.com/export-a-project-to-be-used-as-linked-project?hsLang=en). ### Supported model objects #### Source and Stage - [Source](https://knowledge.bigenius-x.com/source?hsLang=en) - [Stage](https://knowledge.bigenius-x.com/stage?hsLang=en) #### Raw Vault - [Hub](https://knowledge.bigenius-x.com/hub?hsLang=en) - [Link](https://knowledge.bigenius-x.com/link?hsLang=en) - [Satellite](https://knowledge.bigenius-x.com/satellite?hsLang=en) - [Link Satellite](https://knowledge.bigenius-x.com/link-satellite?hsLang=en) - [Multi-Active Satellite](https://knowledge.bigenius-x.com/multi-active-satellite?hsLang=en) - [Same As Link](https://knowledge.bigenius-x.com/same-as-link?hsLang=en) - [Hierarchical Link](https://knowledge.bigenius-x.com/hierarchical-link?hsLang=en) - [Driving Key Link](https://knowledge.bigenius-x.com/driving-key-link?hsLang=en) - [Record Tracking Satellite](https://knowledge.bigenius-x.com/record-tracking-satellite?hsLang=en) - [Effectivity Satellite](https://knowledge.bigenius-x.com/effectivity-satellite?hsLang=en) - [Record Tracking Link Satellite](https://knowledge.bigenius-x.com/record-tracking-link-satellite?hsLang=en) - [Effectivity Link Satellite](https://knowledge.bigenius-x.com/effectivity-link-satellite?hsLang=en) - [Non-Historized Link Satellite](https://knowledge.bigenius-x.com/non-historized-link-satellite?hsLang=en) - [Non-Historized Satellite](https://knowledge.bigenius-x.com/non-historized-satellite?hsLang=en), since Generator 2.4 - [PIT](https://knowledge.bigenius-x.com/pit?hsLang=en) - [Reference Table](https://knowledge.bigenius-x.com/reference-table?hsLang=en) - [RawVault Composite](https://knowledge.bigenius-x.com/rawvault-composite?hsLang=en) - [Current View](https://knowledge.bigenius-x.com/current-view?hsLang=en) - [History View](https://knowledge.bigenius-x.com/history-view?hsLang=en) #### Business Vault - [Business Hub](https://knowledge.bigenius-x.com/business-hub?hsLang=en) - [Business Link](https://knowledge.bigenius-x.com/business-link?hsLang=en) - [Business Satellite](https://knowledge.bigenius-x.com/business-satellite?hsLang=en) - [Business Link Satellite](https://knowledge.bigenius-x.com/business-link-satellite?hsLang=en) - [Same As Business Link](https://knowledge.bigenius-x.com/same-as-business-link?hsLang=en) - [Hierarchical Business Link](https://knowledge.bigenius-x.com/hierarchical-business-link?hsLang=en) - [Business Driving Key Link](https://knowledge.bigenius-x.com/business-driving-key-link?hsLang=en) - [Effectivity Business Satellite](https://knowledge.bigenius-x.com/effectivity-business-satellite?hsLang=en) - [Record Tracking Business Link Satellite](https://knowledge.bigenius-x.com/record-tracking-business-link-satellite?hsLang=en) - [Effectivity Business Link Satellite](https://knowledge.bigenius-x.com/effectivity-business-link-satellite?hsLang=en) - [Non-Historized Business Link Satellite](https://knowledge.bigenius-x.com/non-historized-business-link-satellite?hsLang=en) - [Non-Historized Business Satellite](https://knowledge.bigenius-x.com/non-historized-business-satellite?hsLang=en), since Generator 2.4 - [Business PIT](https://knowledge.bigenius-x.com/business-pit?hsLang=en) - [BusinessVault Composite](https://knowledge.bigenius-x.com/businessvault-composite?hsLang=en) - [Business Current View](https://knowledge.bigenius-x.com/business-current-view?hsLang=en) - [Business History View](https://knowledge.bigenius-x.com/business-history-view?hsLang=en) - [Hierarchy Flatten](https://knowledge.bigenius-x.com/hierarchy-flatten?hsLang=en) - [Vault Out](https://knowledge.bigenius-x.com/vault-out?hsLang=en), since Generator 2.2 #### Mart - [Mart Dimension](https://knowledge.bigenius-x.com/mart-dimension?hsLang=en) - [Mart Fact](https://knowledge.bigenius-x.com/mart-fact?hsLang=en) - [Mart Composite](https://knowledge.bigenius-x.com/mart-composite?hsLang=en) - [Mart Hierarchy Flatten](https://knowledge.bigenius-x.com/mart-hierarchy-flatten?hsLang=en) - [Mart Out](https://knowledge.bigenius-x.com/mart-out?hsLang=en), since Generator 2.2 ### Capabilities and limitations - Keys: the primary key of a Hub or Link is its hash key, and of a Mart Dimension its surrogate key `_SK INT IDENTITY`. Both get a unique constraint on the business key terms; a Mart Fact has no primary key. Primary keys are clustered. When a model object has a user-defined clustered index, its primary key is nonclustered and validation reports a warning. - Foreign keys: [Foreign Key Mode](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en) offers `None`, `Create Disabled` (default) and `Create Enforced`. `Create Disabled` adds the constraint and disables it with `NOCHECK CONSTRAINT`. With `Create Enforced` on a Mart Fact, the procedure `DM_HeaderAction` disables the constraints before the loaders of the layer run, and `DM_FooterAction` checks them again afterwards. - Indexes: the deployment creates a nonclustered index `IX_
_` on the referencing column of each relationship. [Index management](https://knowledge.bigenius-x.com/add-an-index?hsLang=en) offers clustered and nonclustered rowstore and columnstore indexes, unique indexes and Included Columns. - Unknown member: Hubs, Links, Satellites, Link Satellites and Multi-Active Satellites get a row with the hash key `0x00`, and each Mart Dimension gets a row with the surrogate key `-1`. [Custom Singleton Values](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en) sets their values. - Hashing: hash keys and row hashes are `HASHBYTES('SHA1', ...)` with the default Hash Algorithm, cast to `VARBINARY(20)` and stored in `BINARY(20)` columns. See [How biGENIUS-X builds hash values](https://knowledge.bigenius-x.com/how-bigenius-x-builds-hash-values?hsLang=en). - Validity: with Persist Validity off, historized tables have no `BG_ValidToTimestamp` column. The result view computes it from the `BG_ValidFromTimestamp` of the next version. - Change detection: with [Excluded from Delta Detection](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object?hsLang=en), changes to the selected terms of a Satellite alone create no new version. - Loading order: [Use Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader?hsLang=en) on a relationship adds a loader that inserts missing keys into the related Hub or Link before the Satellite loader runs. - Data quality: [data quality rules](https://knowledge.bigenius-x.com/understand-data-quality-rules-overview?hsLang=en) are available, except on Mart model objects. - Deployment: with the default [Deployment Options](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en), each deployment drops and recreates the tables. See [Microsoft SQL Server - Deployment](https://knowledge.bigenius-x.com/microsoft-sql-server-deployment?hsLang=en). - Loading: [LoadControl Options](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en) offers `Native Load Control` and `Airflow`. ### Project properties The configuration offers these project properties, with their defaults: - [Hash Algorithm](https://knowledge.bigenius-x.com/hash-algorithm-project?hsLang=en): `SHA1`; also `SHA2_256` and `MD5` - [Hash Casing](https://knowledge.bigenius-x.com/hash-casing-project?hsLang=en): `None`; also `Upper` and `Lower` - [Hash Concatenation Separator](https://knowledge.bigenius-x.com/hash-concatenation-separator-project?hsLang=en): `_` - [Hash Null Placeholder](https://knowledge.bigenius-x.com/hash-null-placeholder-project?hsLang=en): `_NULL_` - [Hash Trim](https://knowledge.bigenius-x.com/hash-trim-project?hsLang=en): off - [Begin of Universe](https://knowledge.bigenius-x.com/begin-of-universe-project?hsLang=en): `19000101` - [End of Universe](https://knowledge.bigenius-x.com/end-of-universe-project?hsLang=en): `99991231` - [Persist Validity](https://knowledge.bigenius-x.com/persist-validity-project?hsLang=en): off - [Create Result Views](https://knowledge.bigenius-x.com/create-result-views-project?hsLang=en): on - [Target Object Comment Type](https://knowledge.bigenius-x.com/target-object-comment-type-project?hsLang=en): `None`; also `Tables` and `Tables and Views` - [Artifact Output Mode](https://knowledge.bigenius-x.com/artifact-output-mode-project?hsLang=en): `Layer Composites`; also `Deployment Objects` - [Deployment Options](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en): `Generate Drop Table Statements` - [Configure LoadControl](https://knowledge.bigenius-x.com/configure-loadcontrol-project?hsLang=en): on - [Deploy LoadControl](https://knowledge.bigenius-x.com/deploy-loadcontrol-project?hsLang=en): on - [LoadControl Options](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en): `Native Load Control`; also `Airflow` Older projects can still show the legacy property [Behaviour for Nulled Business Keys in Links](https://knowledge.bigenius-x.com/behaviour-for-nulled-business-keys-in-links-project?hsLang=en); the data quality rules replace it, see [Understand Data Quality rules overview](https://knowledge.bigenius-x.com/understand-data-quality-rules-overview?hsLang=en). ### Data types The Default Terms get these SQL Server data types. `DATETIMEOFFSET` and `DATETIME2` are written without precision, so SQL Server uses precision 7: - Timestamps, `datetimeoffset`: `BG_LoadTimestamp`, `BG_UpdateTimestamp`, `BG_ValidFromTimestamp`, `BG_ValidToTimestamp`, `BG_EffectiveTimestamp`, `DVPIT_ForeignKey_LoadDate` - Effectivity, `datetime2`: `BG_Effectivity_Begin`, `BG_Effectivity_End` - Hash keys and row hashes, `binary(20)`: `Hub_HK`, `Link_HK`, `DrivingKeyLink_HK`, `PIT_HK`, `DVLINK_ForeignKey_Identity`, `DVPIT_ForeignKey_Identity`, `BG_RowHash`, `BG_RowHashScd1`, `BG_RowHashScd2` - Text, `nvarchar`: `BG_SourceSystem`, `BG_DataflowName` and `BG_DataflowSetName` with length 255, `BG_ErrorDescription` with 4000, `BG_IncrementLoadStatus` with 20 - Numbers: `BG_ID`, `BG_ErrorCount`, `BG_Sequence`, `BG_MartDimension_Identity`, `BG_MartFact_ForeignKey_Identity` `int`; `BG_DataQuality_ID` `bigint` - Flags, `bit`: `BG_IsDeleted`, `BG_Appearance`, `BG_MAS_HubDifferenceFound` - `BG_IncrementalFilter`, `BG_LowerThreshold` and `BG_UpperThreshold`: the data type of the term that you map to `BG_IncrementalFilter` ### Platform differences These profiles compare their configuration with this one, including data types and properties: - [Oracle Data Vault and Mart](https://knowledge.bigenius-x.com/oracle-data-vault-and-mart?hsLang=en) ### Example A Mart Dimension `bk_multipart_not_nullable` reads the Business Current View `BDV_Current_BDC_CUSTOMER` of the same project. The excerpt uses the example database `DWH` and the schemas `bv` and `mart` for the placeholders and leaves out two name columns: ``` CREATE VIEW [mart].[DM_MD_bk_multipart_not_nullable_Source] AS SELECT CAST(NULL AS NVARCHAR(255)) AS [BG_SourceSystem] ,[s1].[BDC_SHOP_ID] AS [BDC_SHOP_ID] ,[s1].[BDC_CUSTOMER_ID] AS [BDC_CUSTOMER_ID] ,[s1].[DATE_OF_BIRTH] AS [DATE_OF_BIRTH] ,[s1].[LOCATION] AS [LOCATION] FROM [DWH].[bv].[BDV_Current_BDC_CUSTOMER] AS [s1] ; ``` The view `DM_MD_bk_multipart_not_nullable_Hashing` builds the row hash of the SCD1 terms `FIRST_NAME`, `LAST_NAME`, `DATE_OF_BIRTH` and `LOCATION`. It joins them with the separator `_` and replaces NULL with `_NULL_`: ``` CAST(HASHBYTES('SHA1', CAST('' AS VARCHAR(MAX)) + ISNULL([FIRST_NAME], N'_NULL_') + N'_' + ISNULL([LAST_NAME], N'_NULL_') + N'_' + ISNULL(CAST([DATE_OF_BIRTH] AS NVARCHAR(4000)), N'_NULL_') + N'_' + ISNULL([LOCATION], N'_NULL_')) AS VARBINARY(20)) AS [BG_RowHashScd1] ``` ### Release differences Project Settings shows the Generator Version of your project. - Generator 2.2: Vault Out and Mart Out; the project properties Persist Validity, Create Result Views, Hash Casing, Hash Concatenation Separator, Hash Null Placeholder and Hash Trim; the model object property Increment Management Type; the relationship property Use Embryo Loader. - Generator 2.3: the model object property [Custom Singleton Values](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en). - Generator 2.4: Non-Historized Satellite and Non-Historized Business Satellite; the model object property [Excluded from Delta Detection](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object?hsLang=en). - Generator 1.10: the project property [Delta Detection](https://knowledge.bigenius-x.com/delta-detection-model-object?hsLang=en). Since Generator 2.0, Delta Detection is a property of the Mart Dimension. ### Related articles - Previous: - Microsoft SQL Server: [Target environment](https://knowledge.bigenius-x.com/microsoft-sql-server-target-environment?hsLang=en) - Next: [Generate artifacts](https://knowledge.bigenius-x.com/generate-artifacts?hsLang=en), [Replace the placeholders in the artifacts](https://knowledge.bigenius-x.com/replace-the-placeholders-in-the-artifacts?hsLang=en) - Microsoft SQL Server: [Artifacts](https://knowledge.bigenius-x.com/microsoft-sql-server-artifacts?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/microsoft-sql-server-deployment?hsLang=en), [Load data - Native Load Control](https://knowledge.bigenius-x.com/microsoft-sql-server-load-data-native-load-control?hsLang=en), [Load data - Apache Airflow Load Control](https://knowledge.bigenius-x.com/microsoft-sql-server-load-data-apache-airflow-load-control?hsLang=en) - Reference: [Foreign Key Mode (Model Object)](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en), [Custom Singleton Values (Model Object)](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en), [Excluded from Delta Detection (Model Object)](https://knowledge.bigenius-x.com/excluded-from-delta-detection-model-object?hsLang=en), [Delta Detection (Model Object)](https://knowledge.bigenius-x.com/delta-detection-model-object?hsLang=en), [Behaviour for Nulled Business Keys in Links (Project)](https://knowledge.bigenius-x.com/behaviour-for-nulled-business-keys-in-links-project?hsLang=en), [Hash Algorithm (Project)](https://knowledge.bigenius-x.com/hash-algorithm-project?hsLang=en), [Artifact Output Mode (Project)](https://knowledge.bigenius-x.com/artifact-output-mode-project?hsLang=en), [Deployment Options (Project)](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en), [LoadControl Options (Project)](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en), [BG\_MartDimension\_Identity](https://knowledge.bigenius-x.com/bg_martdimension_identity?hsLang=en), [BG\_MartFact\_ForeignKey\_Identity](https://knowledge.bigenius-x.com/bg_martfact_foreignkey_identity?hsLang=en) - Microsoft SQL Server: [Placeholder values](https://knowledge.bigenius-x.com/microsoft-sql-server-placeholder-values?hsLang=en) - See also: [Available Generator Configurations](https://knowledge.bigenius-x.com/available-generator-configurations?hsLang=en), [Understand the Generator Configuration](https://knowledge.bigenius-x.com/understand-the-generator-configuration?hsLang=en), [Source systems per generator configuration](https://knowledge.bigenius-x.com/source-systems-per-generator-configuration?hsLang=en), [Use Linked Projects](https://knowledge.bigenius-x.com/use-linked-projects?hsLang=en), [Oracle Data Vault and Mart](https://knowledge.bigenius-x.com/oracle-data-vault-and-mart?hsLang=en) - Microsoft SQL Server: [Data Vault](https://knowledge.bigenius-x.com/microsoft-sql-server-data-vault?hsLang=en), [Data Mart](https://knowledge.bigenius-x.com/microsoft-sql-server-data-mart?hsLang=en), [Dimensional and Mart](https://knowledge.bigenius-x.com/microsoft-sql-server-dimensional-and-mart?hsLang=en) - [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content) - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines) - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working) - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account) - [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en) - [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en) - [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content) - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration) - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions) - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features) - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects) - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches) - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections) - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview) - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps) - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms) - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping) - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships) - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality) - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes) - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling) - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts) - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings) - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace) - [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content) - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks) - [Databricks dbt](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks-dbt) - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse) - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse) - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server) - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle) - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake) - [Snowflake dbt](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake-dbt) - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts) - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders) - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment) - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment) - [Deployment with an Azure DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azure-devops-pipeline) - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment) - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment) - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control) - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow) - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type) - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties) - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms) - [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content) - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations) - [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content) - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches) - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases) - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules) - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules) - [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en) - [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content) - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application) - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application) - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators) - [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content) - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs) - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits) - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) - [Customer Portal](https://knowledge.bigenius-x.com/customer-portal) - [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login) [![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com) All rights reserved © 2025, biGENIUS AG