Building a Better
BI Community

The Complete History of Biml

The Business Intelligence Markup Language (Biml) is an XML dialect that specifies many aspects of a business intelligence solution. Since basic Biml is just XML, you can easily use the broad ecosystem of tools for XML-based languages. Unlike DTSX and other SQL Server files, Biml is human readable and writable which makes it makes it easy to edit Biml files by hand, compare and merge changes across Biml files, automatically template code, and leverage team development tools.

BimlScript is an extension to the Biml language where C# or VB.NET code nuggets are embedded directly within Biml. By incorporating BimlScript, it’s possible to turn tedious, repetitive work into reusable scripts and BimlScript’s power extends to automating package generation and building reusable patterns for common BI tasks. BimlScript is particularly powerful when metadata from various sources is used to automatically generate Biml code for your solution. Using BimlScript has no impact on a Biml file’s ability to target different SQL Server versions. Biml and BimlScript can be used to generate BI assets for your target platform.

The Complete History of Biml

We made an awesome page about the history of Biml. Check it out!

The Complete History of Biml