About me: Aashish Patel.
I am an enthusiastic BI Developer who is always eager to learn new technology. My skill set is within Data Warehousing using Microsoft BI Stack. I have worked in various industries (Airline , Marketing Database, Document Management and Healthcare).In this series of post I will be writing my own experience about various technologies, I have used in my day to day work as a developer and how I have learned to use this technology in my work.
BEGINNING WITH BIML
I read a lot about BIML on various sites and always wondered how can it be of any benefit to BI developers. Until I started writing BIML scripts myself. It has been months now I am writing BIML scripts and now I understand the real sense of development and the speed at which SSIS Packages can be developed at the same time maintain a design pattern which suits you and your company needs.
SSIS is a powerful tool for extracting,transforming and loading data into various different format and environments, but creating repetitive SSIS packages with minor changes can be tedious and time consuming task. Even if you use templates and changing minor things you often are going to repeat the same task over and over again. Now this where BIML can be a life saver for developer and the data architect.
WHAT IS BIML
The Business Intelligence Markup Language (BIML) is an XML dialect that specifies many aspects of a business intelligence solution, including relational models, data transformation packages, multi-dimensional models (OLAP), and permissions. It is human readable and writable which makes it easy to edit BIML files by hand, compare and merge changes between BIML files and helps ensure consistent design patterns are followed.
WHY USE BIML
The first thing whilst reading about BIML strikes you is why use BIML. I can do everything which BIML does in SSIS using SSDT/Visual Studio. The advantage which BIML has over SSIS (creating SSIS Packages manually) is you do not need to repeat yourself again and again if you want to do the same task in multiple different packages with BIML it is so much easier to make changes and ease of use.
In these series of post I will use BIDS Helper add-in to show you the basics of BIML and BIMLSciprt and how it can help you to generate SSIS Packages and how easy it to change things in these packages. I will show how you can create repetitive task as a block and just refer it to when you want to use it rather than writing it from scratch. I will also be showing different scenarios where it makes a huge difference as a developer to use BIML than SSIS (Creating Packages using SSDT). Show how BIML can speed up development when the same SSIS Package would take more time to develop if done in SSDT or SQL Server Business Intelligence Development Studio.