BIML, Business Intelligence Markup Language, is a domain-specific, human-readable XML-based language. BIML describes business intelligence entities (database objects, ETL, ELT, Packages, Dimensions, Cubes, etc) and extends aspects of Microsoft's BI platform (SSIS and SSAS), supporting a meta-data-driven, data warehouse development experience.
Biml is an XML based language developed by Varigence for describing business intelligence objects.
Biml has its own dedicated IDE (Mist/BimlStudio) as well as free alternatives (BimlOnline and the BimlExpress Visual Studio plugin) provided by Varigence. There is also the community supported BIDSHelper.
Through the combined use of XML based markup and - for data and/or logic driven XML generation - C# based BimlScript, database objects, SSIS packages and SSAS dimensions and cubes can be generated.
Articles
- Getting started with Biml
- Converting SSIS packages to Biml scripts
- Using Biml scripts to generate SSIS packages
- Extending Biml with C# scripts
- Using external C# script files within Biml
- Biml alternatives: Building SSIS packages programmatically using ManagedDTS
- Biml alternatives: Building SSIS packages programmatically using EzAPI
- Building databases using BIML
- Building SSAS OLAP cubes using Biml
- Building SSAS tabular models using Biml
