---
title: Oracle - DataVault
description: Oracle - DataVault generates a Stage, Raw Vault and Business Vault for an Oracle database as SQL*Plus scripts with PL/SQL loader packages.
---

[Skip to content](https://knowledge.bigenius-x.com/oracle-datavault#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. [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle)

# Oracle - DataVault

**Applies to**  
Platform: Oracle  
Architecture: Data Vault

Oracle - DataVault generates a Stage, Raw Vault and Business Vault for an Oracle database as SQL\*Plus scripts with PL/SQL loader packages. Select it in Project Settings, where Generator Configuration shows `Oracle DataVault`, when your Data Vault runs on Oracle. This article lists what the configuration supports and where it differs from [Microsoft SQL Server - DataVault](https://knowledge.bigenius-x.com/microsoft-sql-server-datavault-2.0?hsLang=en).

[Business Driving Key Link](https://knowledge.bigenius-x.com/business-driving-key-link?hsLang=en) offers no Foreign Key Mode, Partition Clause or Table Compression on Oracle.

### Scope and output

- Platform: Oracle. The configuration is available since Generator 2.0.
- Layers: Source, Stage, Raw Vault and Business Vault. Dataflow Modeling shows Stage in the Bronze column and both vault layers in the Silver column. See [Understand the Layering concept](https://knowledge.bigenius-x.com/understand-the-layering-concept?hsLang=en).
- Output: one SQL\*Plus script per layer, PL/SQL loader packages, the load control scripts and the PowerShell 7 scripts that deploy and load, described in [Oracle - Artifacts](https://knowledge.bigenius-x.com/oracle-artifacts?hsLang=en).

### Prerequisites

- One Oracle user for each layer, here Stage, Raw Vault and Business Vault, and one for load control (with Native Load Control). Each user name is also the schema name of its layer.
- PowerShell 7 and SQL\*Plus on the machine that deploys.
- The privileges listed in [Oracle - Target environment](https://knowledge.bigenius-x.com/oracle-target-environment?hsLang=en), for example `CREATE DATABASE LINK` for the Stage user.
- For model objects imported from a linked project, with [Create GRANTs for Imported Objects](https://knowledge.bigenius-x.com/create-grants-for-imported-objects-project?hsLang=en) on: the user name and password of each linked layer's user. The deployment connects as that user to grant the objects.

The placeholders for the users, schemas and connections are listed in [Oracle - Placeholder values](https://knowledge.bigenius-x.com/oracle-placeholder-values?hsLang=en).

### Sources and linked projects

The source system has the type `Oracle`. Stage views read its tables through a database link or directly, as set in [Database Links for Source Systems](https://knowledge.bigenius-x.com/database-links-for-source-systems-project?hsLang=en). To create source model objects from an Oracle schema, see [Discover an Oracle database](https://knowledge.bigenius-x.com/discover-an-oracle-database?hsLang=en).

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). [Create GRANTs for Imported Objects](https://knowledge.bigenius-x.com/create-grants-for-imported-objects-project?hsLang=en) decides whether the deployment grants the imported objects to the layer users.

### Supported model objects

#### Source and Stage

- [Source](https://knowledge.bigenius-x.com/create-a-source?hsLang=en)
- [Stage](https://knowledge.bigenius-x.com/create-a-stage?hsLang=en)

#### Raw Vault

- [Hub](https://knowledge.bigenius-x.com/create-a-hub?hsLang=en)
- [Link](https://knowledge.bigenius-x.com/create-a-link?hsLang=en)
- [Satellite](https://knowledge.bigenius-x.com/create-a-satellite?hsLang=en)
- [Link Satellite](https://knowledge.bigenius-x.com/create-a-link-satellite?hsLang=en)
- [Multi-Active Satellite](https://knowledge.bigenius-x.com/create-a-multi-active-satellite?hsLang=en)
- [Same As Link](https://knowledge.bigenius-x.com/create-a-same-as-link?hsLang=en)
- [Hierarchical Link](https://knowledge.bigenius-x.com/create-a-hierachical-link?hsLang=en)
- [Driving Key Link](https://knowledge.bigenius-x.com/create-a-driving-key-link?hsLang=en)
- [Record Tracking Satellite](https://knowledge.bigenius-x.com/create-a-record-tracking-satellite?hsLang=en)
- [Effectivity Satellite](https://knowledge.bigenius-x.com/create-an-effectivity-satellite?hsLang=en)
- [Record Tracking Link Satellite](https://knowledge.bigenius-x.com/create-a-record-tracking-link-satellite?hsLang=en)
- [Effectivity Link Satellite](https://knowledge.bigenius-x.com/create-an-effectivity-link-satellite?hsLang=en)
- [Non-Historized Link Satellite](https://knowledge.bigenius-x.com/create-a-non-historized-link-satellite?hsLang=en)
- Non-Historized Satellite (no article yet), since Generator 2.4
- [PIT](https://knowledge.bigenius-x.com/create-a-pit?hsLang=en)
- [Reference Table](https://knowledge.bigenius-x.com/create-a-reference-table?hsLang=en)
- [RawVault Composite](https://knowledge.bigenius-x.com/create-a-raw-vault-composite?hsLang=en)
- [Current View](https://knowledge.bigenius-x.com/create-a-current-view?hsLang=en)
- [History View](https://knowledge.bigenius-x.com/create-a-history-view?hsLang=en)

#### Business Vault

- [Business Hub](https://knowledge.bigenius-x.com/create-a-business-hub?hsLang=en)
- [Business Link](https://knowledge.bigenius-x.com/create-a-business-link?hsLang=en)
- [Business Satellite](https://knowledge.bigenius-x.com/create-a-business-satellite?hsLang=en)
- [Business Link Satellite](https://knowledge.bigenius-x.com/create-a-business-link-satellite?hsLang=en)
- [Same As Business Link](https://knowledge.bigenius-x.com/create-a-same-as-business-link?hsLang=en)
- [Hierarchical Business Link](https://knowledge.bigenius-x.com/create-a-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/create-an-effectivity-business-satellite?hsLang=en)
- [Record Tracking Business Link Satellite](https://knowledge.bigenius-x.com/create-a-record-tracking-business-link-satellite?hsLang=en)
- [Effectivity Business Link Satellite](https://knowledge.bigenius-x.com/create-an-effectivity-business-link-satellite?hsLang=en)
- [Non-Historized Business Link Satellite](https://knowledge.bigenius-x.com/create-a-non-historized-business-link-satellite?hsLang=en)
- Non-Historized Business Satellite (no article yet), since Generator 2.4
- [Business PIT](https://knowledge.bigenius-x.com/create-a-business-pit?hsLang=en)
- [BusinessVault Composite](https://knowledge.bigenius-x.com/create-a-business-vault-composite?hsLang=en)
- [Business Current View](https://knowledge.bigenius-x.com/create-a-business-current-view?hsLang=en)
- [Business History View](https://knowledge.bigenius-x.com/create-a-business-history-view?hsLang=en)
- [Hierarchy Flatten](https://knowledge.bigenius-x.com/create-a-hierachy-flatten?hsLang=en)
- [Vault Out](https://knowledge.bigenius-x.com/create-a-vault-out?hsLang=en), since Generator 2.2

### Capabilities and limitations

- Names: generated names are unquoted and in capitals. Characters other than letters, digits, `_`, `$` and `#` become `_`, and names are cut to 128 characters.
- Keys: primary keys are created with `RELY` and a unique index, and business keys get a unique constraint. [Foreign Key Mode](https://knowledge.bigenius-x.com/foreign-key-mode-model-object?hsLang=en) offers `None`, `Create Disabled` (default) and `Create Enforced`.
- Indexes: the deployment creates a B-tree index on the referencing columns of each relationship, unless the primary key or a unique key has the same columns. [Index management](https://knowledge.bigenius-x.com/add-an-index?hsLang=en) offers `B-Tree Index` and `Bitmap Index` and the option Create as local Index.
- Table storage: the partition, compression, tablespace and statistics properties of a model object are described in [Partition Clause and table storage (Model Object)](https://knowledge.bigenius-x.com/partition-clause-and-table-storage-model-object?hsLang=en).
- Wide objects: [Hash Group Size](https://knowledge.bigenius-x.com/hash-group-size-model-object?hsLang=en) splits the row hash of Satellites, Link Satellites, Multi-Active Satellites, Business Satellites, Business Link Satellites and Reference Tables into groups.
- Identity values: identity columns such as `BG_ID` are `NUMBER GENERATED BY DEFAULT AS IDENTITY`.
- Grants: each layer grants `ALL` with `GRANT OPTION` on its tables and views to the users of the following layers. It grants `EXECUTE` on its loader packages to the load-control user.
- Loading: [LoadControl Options](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en) offers `Native Load Control` and `Airflow`.
- Data types: the platform data types `CHAR(CHAR)`, `CHAR(BYTE)`, `VARCHAR2(CHAR)` and `VARCHAR2(BYTE)` write the length semantics, for example `VARCHAR2(100 CHAR)`. `CHAR` and `VARCHAR2` write none, so the database setting `NLS_LENGTH_SEMANTICS` applies. `TIMESTAMP WITH TIME ZONE` with precision 3 becomes `TIMESTAMP(3) WITH TIME ZONE`.
- Data type validation: a length, precision or scale that does not fit the Oracle data type gets a warning, see [Invalid data type configuration (Business Rule)](https://knowledge.bigenius-x.com/invalid-data-type-configuration-business-rule?hsLang=en). The generator writes the configured value: `VARCHAR2(5000)` fails with `ORA-00910` at deployment on a database with `MAX_STRING_SIZE = STANDARD`.

### Project properties

Project Settings shows these properties of the configuration, with their defaults:

- [Hash Algorithm](https://knowledge.bigenius-x.com/hash-algorithm-project?hsLang=en): `SHA1`; also `MD5`, `SHA256`, `SHA384` and `SHA512`

With `SHA256`, `SHA384` or `SHA512`, the hash Default Terms stay `RAW(20)`. Set their data type to the result length of the algorithm, see [Hash Algorithm](https://knowledge.bigenius-x.com/hash-algorithm-project?hsLang=en).

- [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
- [Behaviour for Nulled Business Keys in Links](https://knowledge.bigenius-x.com/behaviour-for-nulled-business-keys-in-links?hsLang=en): `Nulled Business Keys Point to Non-Existing Hub Key`
- [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`
- [Artifact Output Mode](https://knowledge.bigenius-x.com/artifact-output-mode-project?hsLang=en): `Layer Composites`
- [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`
- [Database Links for Source Systems](https://knowledge.bigenius-x.com/database-links-for-source-systems-project?hsLang=en): `Create Database Links`
- [Create GRANTs for Imported Objects](https://knowledge.bigenius-x.com/create-grants-for-imported-objects-project?hsLang=en): on

### Platform differences

The table compares the configuration with Microsoft SQL Server - DataVault of the same release:

| Item | Oracle | Microsoft SQL Server |
| --- | --- | --- |
| Timestamp Default Terms | `TIMESTAMP` | `datetimeoffset` |
| Effectivity Default Terms | `TIMESTAMP` | `datetime2` |
| Hash Default Terms | `RAW(20)` | `binary(20)` |
| Text Default Terms | `VARCHAR2` | `nvarchar` |
| Number Default Terms | `NUMBER` | `int` or `bigint` |
| Flag Default Terms | `NUMBER(1, 0)` | `bit` |
| Hash Algorithm values besides `SHA1` and `MD5` | `SHA256`, `SHA384`, `SHA512` | `SHA2_256` |
| Index types | B-tree, bitmap | rowstore, columnstore |
| Foreign Key Mode on Business Driving Key Link | not available | available |

Database Links for Source Systems, Create GRANTs for Imported Objects, Hash Group Size, Create as local Index and the table storage properties exist only on Oracle. Included Columns of an index exists only on Microsoft SQL Server.

These Default Terms belong to each group; text Default Terms have the same lengths on both platforms:

- Timestamps: `BG_LoadTimestamp`, `BG_ValidFromTimestamp`, `BG_ValidToTimestamp`, `BG_UpdateTimestamp`, `BG_EffectiveTimestamp`, `DVPIT_ForeignKey_LoadDate`
- Effectivity: `BG_Effectivity_Begin`, `BG_Effectivity_End`
- Hash keys and row hashes: `Hub_HK`, `Link_HK`, `DrivingKeyLink_HK`, `PIT_HK`, `DVLINK_ForeignKey_Identity`, `DVPIT_ForeignKey_Identity`, `BG_RowHash`, `BG_RowHashScd1`, `BG_RowHashScd2`
- Text: `BG_SourceSystem`, `BG_DataflowName`, `BG_DataflowSetName`, `BG_ErrorDescription`, `BG_IncrementLoadStatus`
- Numbers: `BG_ID`, `BG_Sequence`, `BG_ErrorCount`, `BG_DataQuality_ID`
- Flags: `BG_IsDeleted`, `BG_Appearance`, `BG_MAS_HubDifferenceFound`

### Example

A Hub `common_customer` with the business key term `CUSTOMER_ID` generates this table. In the excerpt, `<raw vault schema>` and `<business vault user>` stand for the placeholders of the Raw Vault schema and the Business Vault user, and short lines are joined:

```
CREATE TABLE <raw vault schema>.RDV_HUB_COMMON_CUSTOMER (
     BG_LOADTIMESTAMP TIMESTAMP NOT NULL
    ,HUB_HK RAW(20) NOT NULL
    ,BG_SOURCESYSTEM VARCHAR2(255)
    ,CUSTOMER_ID NUMBER NOT NULL
)
;
ALTER TABLE <raw vault schema>.RDV_HUB_COMMON_CUSTOMER
ADD CONSTRAINT RDV_HUB_COMMON_CUSTOMER_PK PRIMARY KEY (HUB_HK)
RELY
USING INDEX (
    CREATE UNIQUE INDEX <raw vault schema>.RDV_HUB_COMMON_CUSTOMER_PK
    ON <raw vault schema>.RDV_HUB_COMMON_CUSTOMER (HUB_HK)
);
ALTER TABLE <raw vault schema>.RDV_HUB_COMMON_CUSTOMER
ADD CONSTRAINT RDV_HUB_COMMON_CUSTOMER_UK UNIQUE (CUSTOMER_ID)
USING INDEX (
    CREATE UNIQUE INDEX <raw vault schema>.RDV_HUB_COMMON_CUSTOMER_UK
    ON <raw vault schema>.RDV_HUB_COMMON_CUSTOMER (CUSTOMER_ID)
);
GRANT ALL ON <raw vault schema>.RDV_HUB_COMMON_CUSTOMER
    TO <business vault user> WITH GRANT OPTION;
```

With Microsoft SQL Server - DataVault, the three Default Terms of this Hub get the types `datetimeoffset`, `binary(20)` and `nvarchar(255)`.

### Release differences

Project Settings shows the Generator Version of your project.

- Generator 2.0: first release of the configuration.
- Generator 2.2: Vault Out; the project properties Persist Validity, Create Result Views, Hash Casing, Hash Concatenation Separator, Hash Null Placeholder and Hash Trim; the model object properties Increment Management Type and Use Embryo Loader, see [Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader?hsLang=en); the platform data types with length semantics and the data type validation; the replacement of characters in generated names. Up to Generator 2.0.1, precision 3 was written as `TIMESTAMP(3 WITH TIME ZONE)`.
- Generator 2.3: the model object properties Hash Group Size and [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).
- Fixes for Oracle are listed in [Generators Release - 2.3.0](https://knowledge.bigenius-x.com/generators-release-2.3.0?hsLang=en), [Generators Release - 2.4.0](https://knowledge.bigenius-x.com/generators-release-2.4.0?hsLang=en) and [Generators Release - 2.4.1](https://knowledge.bigenius-x.com/generators-release-2.4.1?hsLang=en).

### Related articles

- Previous: 
    - Oracle: [Target environment](https://knowledge.bigenius-x.com/oracle-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) 
    - Oracle: [Artifacts](https://knowledge.bigenius-x.com/oracle-artifacts?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/oracle-deployment?hsLang=en), [Load data - Native Load Control](https://knowledge.bigenius-x.com/oracle-load-data-native-load-control?hsLang=en), [Load data - Apache Airflow Load Control](https://knowledge.bigenius-x.com/oracle-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), [Partition Clause and table storage (Model Object)](https://knowledge.bigenius-x.com/partition-clause-and-table-storage-model-object?hsLang=en), [Hash Group Size (Model Object)](https://knowledge.bigenius-x.com/hash-group-size-model-object?hsLang=en), [Database Links for Source Systems (Project)](https://knowledge.bigenius-x.com/database-links-for-source-systems-project?hsLang=en), [Create GRANTs for Imported Objects (Project)](https://knowledge.bigenius-x.com/create-grants-for-imported-objects-project?hsLang=en), [LoadControl Options (Project)](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en) 
    - Oracle: [Placeholder values](https://knowledge.bigenius-x.com/oracle-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 Configurations](https://knowledge.bigenius-x.com/source-systems-per-generator-configurations?hsLang=en), [Microsoft SQL Server - DataVault](https://knowledge.bigenius-x.com/microsoft-sql-server-datavault-2.0?hsLang=en) 
    - Oracle: [Stage](https://knowledge.bigenius-x.com/oracle-stage?hsLang=en), [Data Store](https://knowledge.bigenius-x.com/oracle-data-store?hsLang=en), [Datamart](https://knowledge.bigenius-x.com/oracle-datamart?hsLang=en), [DataVault and Mart](https://knowledge.bigenius-x.com/oracle-datavault-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)

    - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse)
    - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse)
    - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks)
    - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake)
    - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server)
    - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle)
    - [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 Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-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)

<https://www.linkedin.com/company/bigenius> <https://www.youtube.com/@biGENIUS_DWA>

All rights reserved © 2025, biGENIUS AG