Metadata Types
BimlFlex has a number of internal static types that are used to classify metadata. They can also be referred to as an enumeration type (or 'enum'), and represent the constant values that can be used in the App.
Attribute Types
Attribute Types are applied using the Attribute Editor and govern the scope for which the Attribute is applied. Selecting the attribute type will then show available options for the selected type.
The following options are available:
| Attribute Type | Code | Description |
|---|---|---|
| Batch | BAT | A Batch in the BimlFlex App. |
| Column | COL | A Column in the BimlFlex App. |
| Connection | CON | A Connection in the BimlFlex App. |
| Customer | CUS | A Customer in the BimlFlex App. |
| Object | OBJ | An Object in the BimlFlex App. |
| Project | PRJ | A Project in the BimlFlex App. |
Change Types
Change Types are applied using the Column Editor and drive the behavior and purpose of the Column for the design and code generation process. The available change types are dependent on the way the Connection is used in a BimlFlex Project. Depending on the connection's Integration Stage some options may, or may not be, available.
The following options are available:
| Change Type | Code | Description | Applies To |
|---|---|---|---|
| Update | CHG | Assigns the column to track the latest value assigned to the column. Also used as default for attribute columns. In Dimensional Modeling, this corresponds to a 'Type 1' column. | All integration stages, any column. |
| Key | KEY | Indicates that the column is treated as a key value in downstream processing. It is part of the object's Primary Key definition for all intents and purposes. | All integration stages, any column. |
| Ignore | IGN | Assigns the column to be ignored from all processing. This means that the column will not appear in the object and any data pipelines associated with it. | All integration stages, any column. |
| Track History | HST | Assigns the column to track historical changes for the column. In Dimensional Modeling, this corresponds to a 'Type 2' column. | Columns for an objects belonging to a connection with a Data Mart integration stage. |
| Change Data Capture | CDC | Indicates this column is used for historization in Data Marts. | Columns for an objects belonging to a connection with a Data Mart integration stage. |
| Hash Distribution | HDK | Assigns the column to be used for hash distribution when using Synapse objects. | All integration stages, any column, but only when used for Synapse connections. |
| Transient | TRS | Assigns the column to be used in relevant data flow tasks, but not to persist the information. Used when a column value is needed for an expression but the value of the column itself is not needed to be persisted. | Any object used in a project with the SQL Server Integration Services (SSIS) integration template without pushdown processing enabled. |
| Exclude DV | EXC | Processes the column into the Staging Area and Persistent Staging Area (if configured), but does not process/accelerate the column into the Data Vault. | Columns for an objects belonging to a connection with a Source System integration stage, any object. |
| Link Reference | REF | Defines what columns will be used to define Surrogate Keys for the associated Link. These values will be pre-calculated (pre-hashed, if hashing is used) and saved in the Staging Area, but not in the Persistent Staging Area (if configured). Generated by BimlFlex during acceleration to map source columns to individual Link Surrogate Keys. | Columns for an objects belonging to a connection with a Source System integration stage, any object. |
| Link Degenerate | DGA | Assigns the column as part of the Unit of Work for a Link. The column will be included in the hashing of the Link's Surrogate Key, and will be added to the Data Vault Link object. This is also known as a dependent child key. | Columns for an objects belonging to a connection with a Source System integration stage, any object. |
| Link-Satellite Reference | LSR | Defines what columns will be used to define the Surrogate Keys for the target Link Satellite. These values will be pre-calculated (pre-hashed, if hashing is used) and saved in the Staging Area, but not in the Persistent Staging Area (if configured). Generated by BimlFlex during acceleration to map source columns to individual Link Surrogate Keys. | Columns for an objects belonging to a connection with a Source System integration stage, any object. |
| Stub Hub | STH | Designates an object to be created as its own Hub using the Data Vault Accelerator, with a Link to the main Hub that will be created from the source object. The column on which Stub Hub is applied will be used as Business Key / Surrogate Key definition. | Columns for an objects belonging to a connection with Source System integration stage, any object. |
| Driving Key | LDK | A Driving Key is a special column that is used in Data Vault to drive custom historization in Link Satellites. This occurs when changes in Link key values must trigger a change record in the Link Satellite. | Columns for an objects belonging to a connection with a Data Vault integration stage. |
| Effective Date | EFD | Assigns the column as an effective date marker for controlling when records become active in historical tracking scenarios. Used in Data Vault and Dimensional modeling for point-in-time queries. | Columns for objects belonging to a connection with a Data Vault or Data Mart integration stage. |
| Effective Date Low Marker | EFDL | Assigns the column as the start/from date in a date range for bi-temporal or effective-dated records. Represents when a record version becomes valid. | Columns for objects belonging to a connection with a Data Vault or Data Mart integration stage. |
| Effective Date High Marker | EFDH | Assigns the column as the end/to date in a date range for bi-temporal or effective-dated records. Represents when a record version expires or is superseded. | Columns for objects belonging to a connection with a Data Vault or Data Mart integration stage. |
| Hub Natural Key | HNK | Indicates that the column contains a natural key value used to identify a Hub entity in Data Vault. Used when referencing Hub records by their business key rather than surrogate key. | Columns for objects belonging to a connection with a Source System or Data Vault integration stage. |
| Hub Reference | HRF | Defines what columns will be used to reference a Hub's Surrogate Key. These values are pre-calculated during staging and used to establish relationships to Hub entities in Data Vault. | Columns for objects belonging to a connection with a Source System integration stage. |
| Link Natural Key | LNK | Indicates that the column contains a natural key value used to identify a Link relationship in Data Vault. Used when the source provides natural key references rather than surrogate keys. | Columns for objects belonging to a connection with a Source System or Data Vault integration stage. |
| Multi Active Row | MAK | Assigns the column to be a multi-active value for the associated object. Used to determine the grain of a Multi-Active Satellite. This column must also be part of the Primary Key, together with the Integration Key. | Columns for an objects belonging to a connection with Source System integration stage, any object. |
| Multi Active Set | MAS | Assigns the column to define a set for multi-activeness. Used when a group of rows are active and maintained as a unit for the Satellite. All rows in the set share the same Multi Active Set value and are versioned together. | Columns for objects belonging to a connection with Source System integration stage, any object. |
| Replicate | RPL | Assigns the column to be replicated across all distributions in Azure Synapse Analytics. Used for smaller lookup/dimension tables to improve join performance by avoiding data movement. | Columns for objects belonging to a connection configured for Azure Synapse. |
Configuration Attribute Types
Configuration Attribute Types are the allowed values to configure the attribution of a Configuration to a specific area of the data solution architecture. This is defined using the Configuration Editor and governs the location in the data pipeline for which the Configuration is applied.
Each configuration property will allow a list of values to be selected, which impacts how the configuration is applied to the in-scope objects.
| Attribute Type | Code | Description |
|---|---|---|
| Ignore | IGN | Set the Configuration Attribute to Ignore to make sure the configuration does not apply to the assigned area. |
| Derived | DER | Derive the configuration using the value specified in the appropriate Expression column. Which expression column will be used depends on the Integration Template used. |
| Source | SRC | Use the value as is available from the source object. This column needs to exist in the source and have the same name as specified by the Configuration Value column for the configuration in the source object. |
| Default | DEF | Apply the value specified in the Configuration Default field of the Configuration as a default value / constraint for the Objects the configuration has been defined for. Note that this only applies to SQL Server, Managed Instances and Azure SQL because these database technologies support having default constraints with expression (example: GETDATE()). |
| Target | TGT | Defined by the Target. |
| Hash | HSH | Apply hashing logic when loading the value. |
Connection Types
Connection Types are configured using the Connection Editor to define what kind of data source or target is connected to.
| Connection Type | Code | Description | Applies To |
|---|---|---|---|
| ADONET | ADONET | An ADO.NET connection is used to connect to the data. | Any Connection. |
| Azure Blob Storage | AZB | A connection to an Azure Blob Storage Account. | Connections with a Source System, Landing Area, or Staging Area integration stage. |
| Azure Data Lake Store | AZDLS | A connection to Azure Data Lake Storage Account. | Any Connection except if defined with integration stage Data Warehouse. |
| Custom Component | CUSTOM | A connection to a custom component data source (COZYROC). This is limited to connections that are used in Projects that have a SQL Server Integration Services (SSIS) integration template. | Connections with a Source System integration stage. |
| FILE | FILE | A connection to a file. | Connections with a Source System integration stage. |
| FTP | FTP | An FTP connection is used to connect to the data source. | Connections with a Source System integration stage. |
| Microsoft MDS | MDS | A connection to Microsoft's Master Data Services (MDS). | Connections with a Master Data Services integration stage. |
| ODBC | ODBC | An ODBC connection is used to connect to the data. | Any Connections except ones with a Landing Area integration stage. Allowable System Types will be limited depending on the integration stage applied. |
| OLEDB | OLEDB | An Object Linking and Embedding (OLE DB) connection is used to connect to the data. | Any Connection. For connections with a Source System there will be additional System Types available. |
| ORACLE | ORA | A connection to a Teradata data source. | Connections with a Source System integration stage. |
| REST | REST | A connection to a Rest API endpoint. | Connections with a Source System integration stage. |
| Script Source | SCSRC | A connection to a script task data source. This is limited to connections that are used in Projects that have a SQL Server Integration Services (SSIS) integration template. | Connections with a Source System integration stage. |
| SFTP | SFTP | An secure FTP (SFTP) connection is used to connect to the data. | Connections with a Source System integration stage. |
| TERADATA | TD | A connection to a Teradata data source. | Connections with a Source System integration stage. |
| Azure File Server | AZFS | A connection to Azure File Storage for SMB-based file access in the cloud. Supports file shares that can be mounted as network drives. | Connections with a Source System or Landing Area integration stage. |
| Azure Key Vault | AZKV | A connection to Azure Key Vault for centralized secrets management. Used to securely store and retrieve connection strings, passwords, and API keys. | Connections with an Azure Key Vault integration stage. |
| Databricks | DBR | A connection to a Databricks workspace for unified analytics and data engineering. Supports notebooks, SQL warehouses, and Unity Catalog. | Connections with any integration stage when using Databricks as a compute or storage platform. |
| Microsoft Fabric | FBR | A connection to a Microsoft Fabric workspace. Supports Fabric Warehouses, Lakehouses, and SQL Databases within the Fabric ecosystem. | Connections with any integration stage when using Microsoft Fabric as the data platform. |
Data Types
Data Types are the allowed values that can be used to specify Columns in BimlFlex.
| Data Type | Description |
|---|---|
| AnsiString | ANSI string. |
| AnsiStringFixedLength | Fixed length ANSI string. |
| Binary | Binary data column. |
| Boolean | Boolean, Bit or True/False. |
| Byte | Unsigned tiny integer. |
| Currency | Money or currency. |
| Date | Date only. |
| DateTime | Date and time. |
| DateTime2 | Variable precision date and time. Increased precision over DateTime. |
| DateTimeOffset | Data and time with time zone offset. |
| Decimal | Fixed precision and scale numbers. |
| Double | Float or Double. |
| Guid | Unique identifier or GUID. |
| Int16 | Small integer. |
| Int32 | Integer. |
| Int64 | Big integer. |
| Object | Object. Used for complex data types. |
| SByte | Tiny integer. |
| Single | Real or Single. |
| String | Unicode String. |
| StringFixedLength | Fixed Length Unicode String. |
| Time | Time only. |
| UInt16 | Unsigned small integer. |
| UInt32 | Unsigned integer. |
| UInt64 | Unsigned big integer. |
| VarNumeric | Variable numeric |
| Xml | XML formatted data. |
| HierarchyId | SQL Server HierarchyId data type. |
| Geometry | SQL Server geometry data type. |
| Geography | SQL Server geography data type. |
| SmallMoney | Small money. |
| Variant | Variant. Non explicit data type. |
note
For information on how these map to SQL Server, Synapse and Snowflake data types see associated link below.
BimlFlex Documentation: BimlFlex Data Type Conversions.
Integration Stages
The Integration Stage is a Connection property that defines and drives how a connection is used in the architecture. The integration stage is an important classification for a connection, because it is used by BimlFlex to direct what code is generated, and what further options are available - including Connection Types and corresponding System Types and even down to the Change Types at Column level.
The following integration stages are available:
| Integration Stage | Code | Description | Applies To |
|---|---|---|---|
| Business Data Vault | BDV | This layer represents the data following the application of the soft business rules that may be required. | Any connection. Selecting this integration stage will limit the available connection types and system types to BimlFlex supported target platforms. |
| Data Mart | DM | A subset of data stored within the data warehouse, for the needs of a specific team, section or department within the enterprise. | Any connection. Selecting this integration stage will limit the available connection types and system types to BimlFlex supported target platforms. The allowed change types at column level will also be scope to support Dimensional Modeling. |
| Data Warehouse | DWH | The connection type dedicated for the BimlCatalog. A connection with the Data Warehouse integration stage can not be used in project definitions. | BimlCatalog connections only. |
| File Export | EXP | A file or series of files that contain a subset of the data in a Data Warehouse. | Connections used in projects that have been configured with an Integration Template of SQL Server Integration Services (SSIS) only. |
| Landing Area | LND | A Landing Area connection is only applicable to Cloud Enabled Connections, to identify the location where data needs to be 'landed' before being loaded into the cloud database. | Any connection. Selecting this integration stage will limit the available connection types and system types to BimlFlex supported target platforms. |
| Master Data Services | MDS | Microsoft's solution for handling "master" data within an enterprise using SQL Server. | Connections used in projects that have been configured with an Integration Template of SQL Server Integration Services (SSIS) only. |
| Persistent Staging Area | PSA | A staging area where history is kept and changed data capture (CDC) is managed for all source attributes. | Any connection. Selecting this integration stage will limit the available connection types and system types to BimlFlex supported target platforms. |
| Data Vault | DV | A uniquely linked set of normalized tables that support one or more functional areas of business and provides historical tracking. | Any connection. Selecting this integration stage will limit the available connection types and system types to BimlFlex supported target platforms. |
| Source System | SRC | A data source that is being extracted, with the intent to be processed into the BimlFlex data integration environment. | Any connection. |
| Staging Area | STG | A temporary storage area between the source systems and a data warehouse. | Any connection. Selecting this integration stage will limit the available connection types and system types to BimlFlex supported target platforms. |
| Target Staging Area | TSA | Only used in SSIS DataWarehouse and Data Mart templates. | Connections used in projects that have been configured with an Integration Template of SQL Server Integration Services (SSIS) only. |
| Persistent Landing Area | PLND | A Landing Area connection where data is persisted and retained for historical tracking. Unlike standard Landing Areas which are transient, Persistent Landing Areas maintain a full history of landed files before processing into the staging layer. | Any connection. Selecting this integration stage will limit the available connection types and system types to BimlFlex supported landing platforms. |
| Compute | CMP | A connection type designated for compute resources such as Databricks clusters. Used to define processing engines that execute data transformations rather than storing data. | Connections configured for Databricks compute. |
| Azure Key Vault | AKV | A connection to Azure Key Vault for managing secrets, connection strings, and sensitive configuration values. Provides centralized and secure credential storage for the data solution. | Azure Key Vault connections only. |
Integration Templates
An Integration Template in BimlFlex drives which code generation patterns are applied to the design metadata. In other words, the Integration Template defines how the output will be generated. An integration template is set for a Project, and all data pipelines defined in this project will be generated for the selected template.
BimlFlex supports SQL Server Integration Services (SSIS) and Azure Data Factory (ADF) Execute Pipelines as runtime integration engines, and depending on specific Connection properties also generates SQL-based Stored Procedures.
The following integration templates are supported in BimlFlex:
| Integration Template | Code | Description |
|---|---|---|
| SQL Server Integration Services (SSIS) | SSIS | Deliver the data pipelines for the project in SQL Server Integration Services (SSIS). If Pushdown Processing is enabled, SSIS will orchestrate the data pipelines, but the processing will mostly occur on the data platform using Stored Procedures. If pushdown processing is disabled, most the processing will be done in SSIS Data Flows. |
| Azure Data Factory (ADF) | ADF | Deliver the data pipelines for the project using Execute Pipelines. This will generate Execute Pipelines that use a Copy Activity to ingest the data from the source, and Stored Procedures to process the data further. |
| SSIS: File Extract | S2FIL | Use SSIS to extract data to file. |
| SSIS: Zip File Extract | S2ZIP | Use SSIS to extract data to a zip file. |
| Databricks (ADF) | DBR | Deliver the data pipelines for the project using Azure Data Factory for orchestration with Databricks notebooks for data processing. ADF pipelines trigger Databricks jobs that execute the transformation logic using Spark. |
| Data Factory (Fabric) | FDF | Deliver the data pipelines for the project using Microsoft Fabric Data Factory pipelines. This generates Fabric Data Pipelines that orchestrate data movement and processing within the Fabric ecosystem, leveraging Fabric compute and storage. |
Object Types
Object Types are configured using the Object Editor and drive the behavior and purpose of the Object for the design and code generation process. The available object types are dependent on the way the Connection is used in a BimlFlex Project. Depending on the connection's Integration Stage and System Type some options may, or may not be, available.
| Change Type | Code | Description | Allowed for Integration Stage | Allowed for System Type |
|---|---|---|---|---|
| Bridge | BRG | Defines the object as a Data Vault Bridge entity. | Business Data Vault, Data Vault | All |
| Dimension | DIM | Defines the object as a Dimension Table in a Dimensional Model / Data Mart. | Data Mart | All |
| Exclude in Accelerator | EXC | Flags an object to not be included in the Data Vault Accelerator. | Source System | All |
| Fact | FCT | Defines the object as a Fact Table in a Dimensional Model / Data Mart. | Data Mart | All |
| Flat File | FIL | Determines that the object is a flat file. | File Export, Source System | Avro Format, Binary Format, Delimited Format, JSON Format, ORC Format, Parquet Format, Ragged Right Format , XML Format |
| Hierarchy Link | HAL | Defines the object as a Data Vault Hierarchy Link entity. Hierarchy Links model recursive or parent-child relationships within a single Hub, such as organizational structures, bill-of-materials, or reporting hierarchies. | Business Data Vault, Data Vault | All |
| Hub | HUB | Defines the object as a Data Vault Hub entity. | Business Data Vault, Data Vault | All |
| Ignore | IGN | Setting an object to Ignore will remove it from any processing and/or visualisation in BimlFlex. No Staging Area or Persistent Staging Area objects will be derived. | All | All |
| Json | JSON | Determines that the object is a flat file in JSON format. Only applies when used for a REST API connection. | Source System | Rest Service |
| Link | LNK | Defines the object as a Data Vault Link entity. | Business Data Vault, Data Vault | All |
| Link Satellite | LSAT | Defines the object as a Data Vault Link-Satellite entity. | Business Data Vault, Data Vault | All |
| Point In Time | PIT | Defines the object as a Data Vault Point-In-Time (PIT) entity. | Business Data Vault, Data Vault | All |
| Reference | REF | Determines that this object will be generated as a stand-alone historized table in a Data Vault context. | Business Data Vault, Data Vault | All |
| Reference Satellite | RSAT | Determines that this object will be generated as a stand-alone (unconnected) Satellite in a Data Vault context. | Business Data Vault, aw Data Vault | All |
| Satellite | SAT | Defines the object as a Data Vault Satellite entity. | Business Data Vault, Data Vault | All |
| Stored Procedure | SP | For source objects only, determines the the object is a stored procedure whose output must be ingested into the data solution by BimlFlex. | Source System | Azure SQL Database, Azure Synapse, Microsoft SQL Server |
| Staged Object | STQ | Defines the object as an object that is derived from other existing objects. This will be treated as a data source, but no Staging Area and/or Persistent Staging Area components will be generated. For more details, please refer to the Staged Object Concept. | Source System | Azure SQL Database, Azure Synapse, Microsoft SQL Server, Snowflake Data Warehouse |
| Table | TBL | This is the default object type in BimlFlex. A Table property for the object means that no specific behaviour is applied by the BimlFlex code generation processes. | Business Data Vault, Landing Area, Master Data Services, Persistent Staging Area, Data Vault, Source System, Staging Area | Azure Synapse, COZYROC Excel File, COZYROC Salesforce, DB2, Dynamics CRM, Microsoft SQL Server, MySql, Oracle, Oracle RDB, PostgreSQL, Salesforce, Salesforce Marketing Cloud, Salesforce Service Cloud, Snowflake Data Warehouse, Sybase, Teradata |
| CDC All | TCA | Determines that the object is configured for Change Data Capture, querying the full history of available changes. BimlFlex will generate specific code to query the object. | Source System | Microsoft SQL Server |
| CDC Last | TCL | Determines that the object is configured for Change Data Capture, but only retrieves the last value every time data is loaded. BimlFlex will generate specific code to query the object. | Source System | Microsoft SQL Server |
| Change Tracking | TCT | Determines that the object is configured for Change Tracking. BimlFlex will generate specific code to query the object. | Source System | Microsoft SQL Server |
| Same As Link | SAL | Defines the object as a Data Vault Same-As Link entity. Same-As Links relate equivalent business keys from different sources, establishing that records from multiple systems represent the same real-world entity. | Business Data Vault, Data Vault | All |
| View | TBV | Defines the object as a database view. Used when the source object is a view rather than a physical table. BimlFlex will query the view during extraction but not generate DDL for the source. | Source System, Data Vault, Business Data Vault | Azure SQL Database, Azure Synapse, Microsoft SQL Server, Snowflake Data Warehouse |
System Types
System Types are configured using the Connection Editor to define what kind of data source or target is connected to as part of the Connection Type configuration.
| System Type | Code | Description | Supported by Connection Type |
|---|---|---|---|
| Avro Format | AVRO | Avro is a binary, compressed, file format. Only supported for Azure Data Factory. | Azure Blob Storage, Azure Data Lake Store, FILE, FTP, SFTP |
| Azure Synapse | SQLDW | Azure Synapse Analytics database (Formerly Azure SQL Data Warehouse). | ADONET, OLEDB |
| Binary Format | BIN | Binary storage file. Only supported for Azure Data Factory. | Azure Blob Storage, Azure Data Lake Store, FILE, FTP, SFTP |
| COZYROC Excel File | CREXCEL | Excel File using COZYROC SSIS Components. | Custom Component |
| COZYROC Salesforce | CRSFDC | Salesforce API using COZYROC SSIS Components. | Custom Component |
| DB2 | DB2 | IBM DB2 database. | ADONET, ODBC, OLEDB |
| Delta Lake | DELTA | Delta Lake Storage Layer. | Azure Data Lake Store |
| Dynamics CRM | DYNCRM | API that can connect to Microsoft Dynamics data sources. | Rest API |
| Delimited Format | FF_DEL | Flat File with Delimiters. | Azure Blob Storage, Azure Data Lake Store, FILE, FTP, SFTP |
| Ragged Right Format | FF_RAG | Flat File with Ragged Right formatting. | FILE |
| JSON Format | JSON | JSON file format. Only supported for Azure Data Factory. | Azure Blob Storage, Azure Data Lake Store, FILE, FTP, SFTP |
| Microsoft SQL Server | MSSQL | Microsoft SQL Server database. Can be configured for on-premise, also accessible via a Self-Hosted Integration Runtime. Also can be configured for cloud computing as a Managed Instance or Azure SQL database. This is done in the Linked Service configuration for the connection. | ADONET, Microsoft MDS, OLEDB |
| MySql | MYSQL | MySQL database. | ADONET, ODBC, OLEDB |
| Oracle | ORA | Oracle database. | ADONET, ODBC, OLEDB, ORACLE |
| Oracle RDB | ORARDB | Oracle RDB Database. Discontinued product line from Oracle. Separate from there current database product. | ADONET, ODBC, OLEDB, ORACLE |
| ORC Format | ORC | ORC file format. Only supported for Azure Data Factory. | Azure Blob Storage, Azure Data Lake Store, FILE, FTP, SFTP |
| Parquet Format | PARQ | Parquet file format. Only supported for Azure Data Factory. | Azure Blob Storage, Azure Data Lake Store, FILE, FTP, SFTP |
| PostgreSQL | PGR | PostgreSQL database. | OLEDB |
| Rest Service | REST | Configurable REST API connector. | Rest API |
| Salesforce | SFDC | API to connect to the generic Salesforce tenant. | Rest API |
| Salesforce Marketing Cloud | SFDCMC | API to connect to the Salesforce Marketing Cloud. | Rest AP |
| Salesforce Service Cloud | SFDCSC | API to connect to the Salesforce Service Cloud. | Rest API |
| Snowflake Data Warehouse | SFLDW | Snowflake database. | ODBC |
| Sybase | SYBASE | Sybase database. | ADONET, ODBC, OLEDB |
| Teradata | TD | Teradata database. | ADONET, ODBC, OLEDB, TERADATA |
| XML Format | XML | XML file format. | Azure Blob Storage, Azure Data Lake Store, FILE, FTP, SFTP |
| Azure SQL Database | SQLDB | Azure SQL Database - a fully managed PaaS database service in Azure. Supports both serverless and provisioned compute tiers. Configured for cloud connectivity via Azure-hosted resources. | ADONET, OLEDB |
| Azure Key Vault | AZKV | Azure Key Vault for secrets and connection string management. Provides secure, centralized storage for credentials used by BimlFlex connections and integrations. | Azure Key Vault |
| Custom Type | CUSTOM | A custom system type for specialized integrations not covered by standard system types. Used with Custom Component connections for third-party or proprietary data sources. | Custom Component |
| Databricks | DBR | Databricks unified analytics platform for data engineering and data science. Supports Delta Lake storage, SQL warehouses, and notebook-based transformations. | Databricks |
| Dynamics Business Central | DYNBC | Microsoft Dynamics 365 Business Central ERP system. Connects via REST API for financial, sales, and operational data extraction. | Rest API |
| Fabric Warehouse | FBRDW | Microsoft Fabric Synapse Data Warehouse. A fully managed, cloud-scale SQL analytics warehouse within the Fabric ecosystem. Supports T-SQL and integrates with Fabric's unified data platform. | Microsoft Fabric |
| Fabric Lakehouse | FBRLH | Microsoft Fabric Lakehouse combining data lake storage with warehouse capabilities. Uses Delta Lake format and supports both SQL and Spark-based analytics. | Microsoft Fabric |
| Fabric SQL Database | FBRSQL | Microsoft Fabric SQL Database - a transactional SQL database within Fabric. Suitable for operational workloads that integrate with the broader Fabric ecosystem. | Microsoft Fabric |