75 docs tagged with "Conceptual"

Documentation of how to add and edit files in BimlExpress

Guide to assist with Azure Data Factory project creation, deployment, and standard configurations

Documentation regarding the BimlFlex Attribute editor, including editor fields, field descriptions, and data types.

Guide to deploy artifacts generated in Azure Data Factory through the Azure portal

Documentation on Microsoft Azure Best Practices for Azure Synapse, with attention on interface contracts, forward only migration, version control, and distribution

Various bimlc compiler options

Documentation of BimlExpress accounts

Comparing BimlExpress and BimlStudio.

Using BimlFlex batch orchestration to control failure scenario management, auditing, and logging of runs, with the BimlCatalog database

Guide for CI/CD for Azure Data Factory using command line scripts and changes through a build server pipeline

Explanation of Model Override concept in BimlFlex

New Features relating to Azure Data Factory integrations in BimlStudio 2020.2 update

Overview of Data Vault Bridge tables

Overview of implementing a Business Data Vault based on a Data Vault

Discusses the three types of BimlScripts and which is right for the user's needs.

Details regarding concurrent development between teams, customers, and shared metadata

Documentation of the process to implement a Data Mart layer in BimlFlex

Changing the bitness of BimlFlex Excel through installation or project folder

Discussion of the various project settings in BimlStudio.

BimlFlex can access data from Salesforce into the data warehouse using the REST API Connection Type.

Documentation providing considerations and approaches for CI/CD using BimlFlex

Overview of the customer concept in BimlFlex

Documentation on BimlFlex Configurations used to drive default behavior across multiple data architecture concepts within a Data Mart

Overview of implementing a Data Vault

Documentation for Data Vault best practices within BimlFlex, including settings for hash key and algorithms, integration keys, and data vault entity management

Overview of Data Vault Zero Records

Overview of implementing Databricks using Azure Data Factory within BimlFlex, with installation guide, templates, and examples

Documentation on BimlFlex delete detection mechanism for detection of hard deleted keys from a source system

Documentation of the way BimlFlex deploys Dimension Table structures and data logistics

Overview of implementing a Dimensional Model based on a Data Vault

Documentation on assignment, importance of, and tracking Driving Keys in a Linked Satellite in Data Vault with examples

Reference documentation on BimlFlex extension points to control directives, inheritance, custom code, and path variables in SSIS packages

Documentation of the way BimlFlex deploys Fact Table structures and data logistics

Documentation on exporting data out of a database into files within BimlFlex, including flat file types, data rows, and delimiters

Documentation on loading a flat file source to staging from within BimlFlex

Generate DDL based on BimlFlex metadata using BimlStudio and DDL scripts

Overview of hashing concepts as available in BimlFlex

Documentation regarding hashing in Data Vault for hash-based keys and row checksums for changes to attributes

Overview of Data Vault Hubs

Guidance on how to implement Databricks using Azure Data Factory for cloud based data warehouse solutions within BimlFlex

Guidance on how to implement Snowflake using Azure Data Factory for cloud based data warehouse solutions within BimlFlex

Documentation on how to configure Azure Synapse as Source and a target data warehouse for both SSIS and ADF implementation within BimlFlex

Documentation on importing metadata into BimlFlex with import options and default properties

How to install BimlExpress

Explanation of the Integration Keys concept, what it is and why it matters

Data Vault management of integration keys, relationships, business keys, examples, and how to accelerate in the Data Vault Accelerator

Positioning of Data Vault methodology in the data world

Instructions on how to configure Azure Data Factory Landing Area accessible by SQL Based ELT stored procedures

Overview of Data Vault Links

Documentation for parameters for load queries added in Parameters section or as Extension Points in BimlFlex

Explore menus and options

Using BimlFlex batch orchestration to control failure scenario management, auditing, and logging of runs, with the BimlCatalog database

Overview of Data Vault concepts as implemented in BimlFlex

Overview of supporting techniques that BimlFlex provides

Overview of the version concept in BimlFlex

Overview of the persistent staging area concept in BimlFlex

Overview of Data Vault Point-In-Time tables

Guide to deploy artifacts generated in Azure Data Factory through PowerShell

Explore how to preview the expanded BimlScript

Explanation of how Projects and Batches are translated into ADF folder structures and containers

Overview of Data Vault handling of reference data

Documentation regarding the BimlFlex Operational Reports screen, including configuring operational reports, report screens, and execution details for batches

Overview of Data Vault Satellites

Overview of implementing Snowflake using Azure Data Factory within BimlFlex, with installation guide, templates, and examples

Documentation on steps and considerations for extracting data from a Source database through staging, persisted stage, raw data vault, and business data vault for an on-premise SQL Server

Overview of the Staged Object concept in BimlFlex

BimlFlex tips and tricks including custom SSIS components, Extension Point abilities, importing metadata, custom scripts and setting options

Documentation on connecting to Postgres metadata in BimlFlex

Documentation on loading Excel source files using COZYROC Excel Plus SSIS Component within BimlFlex

Documentation on integrating Microsoft SQL Server Master Data Services within BimlFlex with sample models, sample metadata, and schema types

Documentation on loading an Odata source from bespoke sources within BimlFlex

Documentation regarding Microsoft SQL Server change data capture in source to staging with setting descriptions and additional considerations

Documentation on how to use BimlFlex stored procedure source to load data

Overview of the version concept in BimlFlex

Documentation regarding the BimlFlex Versions editor, including editor fields, action buttons, field descriptions, setting options, and overrides.