Business Intelligence Markup Language
- Compile Metadata into BI Solutions
- .NET-Based Scripting Language
- Powerful code generation
- Reuse BI patterns and components
- 100% SSIS / SSAS Compatible
A Microsoft BI Developer’s Best Friend
SQL Server, meet Biml, the markup language and compiler that translate metadata into business intelligence solutions for the Microsoft SQL Server Platform. BIML can be extended by BimlScript – inline .NET code in your files – to quickly expand basic directives into relational models, Integration Services packages, Analysis Services Cubes, and more.
Slash Development Time with Code Generation
The advanced BimlScript extensions to Biml allow you to turn tedious, repetitive work into reusable scripts that expand at compile time. Automate package generation for processing flat files and build reusable components for common BI tasks. Call or include other BimlScript to turn complex ETL patterns into simple, layered steps.
Embrace, Extend, Enhance
Powerful Transformer BimlScript allows you to extend the compiler, adding your own best practices and frameworks, or even changing the way we generate code. With Biml you can embed a little piece of your team architect into each and every BI developer. Design patterns done right.
Work with the Whole Solution, Not Just Pieces
Make changes in one place and recompile. Don’t waste time dealing with corrupted metadata in SSIS because you added a column or changed a data type – the Biml compiler analyzes your entire solution, applying changes and side effects. Add a column to a table and we automatically rewrite the MERGE INTO statement for you. How easy is that?
Open for Business
The Varigence BI platform leverages Microsoft SQL Server technologies including Integration Services (SSIS) and Analysis Services (SSAS). No closed source embedded code or custom runtimes – your compiled solution is instantly readable and usable with standard Microsoft tools. Solutions generated from Mist integrate seamlessly your existing environment.
Hides complexity, not power
If you can do it in BIDS, you can do it in BIML. Biml simplifies BI tasks into reusable, componentized blocks without locking you out of the bare metal. Directly manipulate SSIS Tasks, Transformations, and expressions. Create full fidelity OLAP cubes. Use our higher-level abstractions where they make sense, and skip them where they don't. You have control over your framework.
