Wouldn’t it be nice to have just one tool for you data development? BimlStudio handles the entire end-to-end process of BI, including source database importing, modeling, scripting, ETL, and cube development. With features like advanced code editors, visual designers, project management, live error reporting it’s everything you would expect from a first class development tool and can target any part of your data solution across all versions of Microsoft SQL Server; even multiple targets in the same solution.
All this is made possible because of Business Intelligence Markup Language (Biml). The only language and compiler that translate metadata into data solutions for the Microsoft SQL Server Platform(?). Biml is extended by BimlScript – inline .NET code – that quickly expands basic directives into relational models, Integration Services packages, Analysis Services Cubes, and more. Every line of code you write is leveraged throughout your solution. When adding columns to a table Biml automatically rewrites your MERGE INTO statements. Change data types, and it rewrites your data flows saying goodbye to corrupted SSIS metadata!