Biml - Business Intelligence Markup Language

Biml

A programming language for creating and automating data solutions.


Biml Examples

Biml uses XML and small nuggets of C# or VB code to automatically create huge amounts of SQL scripts, SSIS packages, SSAS cubes, tabular models, and more.

The following examples demonstrate a simple staging solution for any source system - in under 50 lines of code.

Getting Started with Biml

1. Install BimlExpress.

Download BimlExpress, our free Visual Studio add-in. When you restart VS, you'll see a new BimlExpress menu.

2. Create your first Biml file.

Right-click on your project in the solution explorer to create a new Biml file in your SSIS project.

3. Paste in some code and build.

Copy/paste one of the code samples above into your Biml file, save, and then right-click on the file in the solution explorer and select "Generate SSIS Packages".

Advanced Features

Staging Environment from Source

Reduce time spent on projects by turning repetitive work into reusable scripts. Maintain control over your framework.

Import and Modify Packages

Leverage Microsoft SQL Server technologies (SSIS and SSAS) with no custom runtimes.

Increased productivity

Eliminate time dealing with corrupted metadata in SSIS. The Biml engine allows you to add a column to a table and it.

Automated Development

Reduce time spent on projects by turning repetitive work into reusable scripts. Maintain control over your framework.

SQL Server Compatibility

Leverage Microsoft SQL Server technologies (SSIS and SSAS) with no custom runtimes. Compiled solutions are immediately.

Increased productivity

Eliminate time dealing with corrupted metadata in SSIS. The Biml engine allows you to add a column to a table and it automatically.


Check out our free Biml resources

We've created amazing tools for developing with Biml

Know how to use Biml already? Take advantage of these products that enhance your Biml experience.

BimlExpress

Write Biml with syntax highlighting and create SSIS packages using our free Visual Studio add-in.

BimlOnline

Create and import packages and auto-generate documentation without installing any software.

BimlStudio

Leverage visual design capabilities and modern programming IDE features while simultaneously editing entire data models.

BimlFlex

Model 90% of your data warehouse using our metadata mapping tool and modify our fully customizable framework for the final 10%.