Skip to main content

537 docs tagged with "BimlFlex"

View all tags

Accelerator

Documentation regarding the BimlFlex Data Vault Accelerator, including videos, starting point, user interface, metadata requirements, and entity options

ADF Deployment Overview

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

Attributes

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

Batches

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

BimlFlex Batch Orchestration

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

Bridge

Overview of Data Vault Bridge tables

Business Modeling

Overview of the Business Modeling process within BimlFlex App, including conceptual origin, creating a model, action bar, settings, and relationship models

Columns

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

Command Line Build

Guide to building solutions involving CI/CD for automated processes, using response files, Biml Compiler, and MsBuild

Concurrent Development

Documentation on metadata setup, customers, and versions needed for concurrent development between users in BimlFlex

Configuration

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

Configurations

Documentation on the metadata and framework configurations available in BimlFlex with standard configurations and examples

Configurations

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

Configuring a Linked Service

Documentation on enabling linked service connections, connections for cloud services, and supported linked services for BimlFlex

Connecting to Salesforce

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

Connections

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

Continuous Delivery (CI/CD)

Documentation providing consideration and approaches to continue integration and continuous delivery within BimlFlex

Customers

Overview of the customer concept in BimlFlex

Dashboard

Overview of the BimlFlex dashboard with sunburst graph, navigation, menus, and loading data

Data Lineage

Documentation on Data Lineage within BimlFlex to review and update graphical interface, with starting point, context aware actions, action buttons, and settings

Data Mart Template Overrides

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

Data Type Conversions

Documentation providing data type conversations between BimlFlex data types and SQL Server data types

Data Type Mappings

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

Data Vault Best Practices

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

Delete Detection

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

Dimension Pattern

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

Documentation

Documentation for generating, deploying, and customizing BimlFlex Documentation

Driving Keys in Data Vault

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

Excel Add-In

Guide on how to update the BimlFlex Excel add-in

Extension Points

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

Extension Points

Documentation of components and properties for all Extension Points within BimlFlex

Fact Pattern

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

First Project

Guidance on creating a BimlFlex project end to end, including setting up source data, accelerating a data vault, and applying load parameters

Flat File Export

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

Flat File Import

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

Hashing

Overview of hashing concepts as available in BimlFlex

Hashing

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

Hubs

Overview of Data Vault Hubs

Implementing BimlFlex for Synapse

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

Importing Metadata

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

Initial Configuration

Initial walkthrough of setting up BimlFlex to create project, connect database, and load sample metadata

Integration Keys

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

Integration Keys

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

Introductory Videos

Collection of BimlFlex introductory videos, including end to end walkthrough, loading sample metadata, data vault acceleration, and building a data vault project and dimensional models

Landing Area

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

Links

Overview of Data Vault Links

Load Parameters

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

Managing Sensitive Data

Management of sensitive information within Azure Data Factory Key Vaults and Extension Points

Managing Sensitive Data

Documentation regarding sensitive information management in SSIS, Visual Studio, and extension points

Metadata Editors

Documentation of components and properties for all editors within BimlFlex

Objects

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

Orchestration using SSIS

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

Overview

Overview of Data Vault concepts as implemented in BimlFlex

Overview

Overview of supporting techniques that BimlFlex provides

Overview

Delivering a Staging Layer using BimlFlex

Overview

Organizing data logistics orchestration using BimlFlex

Overview

The BimlFlex Reference Documentation contains detailed information about the many ways BimlFlex can be configured

Overview

Overview of the version concept in BimlFlex

Parameters

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

Projects

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

Reports

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

Schema Diagram

Documentation providing Schema Diagram overview, including starting points, context aware actions, action buttons, and user interface

Settings

Documentation on metadata and framework settings within BimlFlex

Settings

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

SSIS Custom Components

Documentation regarding custom SSIS components used for ETL load processes in SSIS packages in BimlFlex

SSIS Deployment Guide

Documentation on project configurations and deployments to SSIS Catalog within BimlFlex

SSIS with On-Premise Sql Server

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

System Requirements

Documentation on software and hardware requirements for installing BimlStudio, BimlFlex, BimlFlex Excel Add-In, and related databases

Tips and Tricks

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

Upgrade Process

BimlFlex comes in a consolidated installer that contains the following components that are upgraded when a later version is installed:

Using Powershell

Documentation regarding SSIS asset deployment using PowerShell scripts generated by BimlFlex

Using SQL Server CDC as a source

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

Using SQL Server Data Tools (SSDT)

BimlFlex and SQL Server Data Tools documentation for guidance on database management and automation of deployment processes and source control mechanisms

Versions

Overview of the version concept in BimlFlex

Versions

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