BimlScript Documentation
Automate data warehouse development with BimlScript - embed C# or VB logic in Biml to generate ETL pipelines from metadata.
Getting Started
- What is Biml? - Overview, key concepts, and your first code example
- Quick Start Guide - Build your first Biml solution in 5 minutes
- Biml Tools - Choose the right tool for your needs
Prerequisites
- C# Primer - Variables, LINQ, lambdas, and error handling for BimlScript automation
- LINQ for BimlScript - Complete LINQ reference for metadata queries
- Intro to XML - XML fundamentals for Biml
Core Concepts
- Biml Basics - Syntax, naming conventions, and object references
- Biml for Relational DBs - Connections, databases, tables, columns
- Biml for SSIS - Control flows, data flows, and transformations
- Biml for SSAS - Cubes, dimensions, tabular models, and processing automation
Automation Techniques
- Introduction to BimlScript - Code nuggets, directives, and tiers
- Biml Utility Methods - Include files, CallBimlScript, helper classes, extension methods
- Using .NET Variables - Partial automation with variables
- Using .NET Control Structures - Full automation with loops and conditions
- Techniques for Automation - Alternative approaches (Excel, SQL, PowerShell)
Practical Guides
- Common Patterns - Reusable solutions for staging, loading, and error handling
- Build Staging Layer - End-to-end example with metadata-driven generation
- Automation Philosophy - Design principles for maintainable solutions
Troubleshooting
- Troubleshooting Guide - Debug compilation errors and fix common issues