Building tomorrows ETL architecture with BIML and MDS today

A session at SQLSaturday Cambridge 2015

  • Rasmus Reinholdt Nielsen

Friday 11th September, 2015

8:30am to 5:30pm (GMT)

For more detail please visit the event page http://sqlcambs.org.uk/precon4/

In this hands-on / bring your own laptop pre-con, Rasmus will show how you can take your ETL to the next level. You will go from “Zero to BIML to BIMLScript” in the duration of the day. That means, that leaving the pre-con, you will never ever again have to go over hundreds of packages to change a datatype or add a column, all you’ll need to do, is to change your meta-data and you are home free.

As our meta-data repository, we will use SQL Servers built-in Master Data Services. You will be given a thorough introduction to this component and learn how to use and administer it.
Besides getting a working knowledge of BIML AND MDS, and become able to use that in your ETL development, you will also get an overview of, and get to work with, the following advanced ETL concepts:

  • Early arriving facts
  • Slowly Changing Dimensions (SCD) with script task
  • Least interdependent structure
  • Change Data Capture (CDC)

At the end of the day, this combination will not only make you able to build the best ETL structure possible, but do so meta-driven with BIML.
As this is a bring your own laptop invitation, we will build the solution together, and you will have a working BIML model, that you have built yourselves, and understands at the end of the day. Therefore; after this pre-con, you can go straight to work, and start implementing your new BIML meta-data framework.

About the speaker

This person is speaking at this event.
Rasmus Reinholdt Nielsen

Data Warehouse Architect at UNOPS, the implementation arm of the UN, based in Copenhagen, Denmark

Sign in to add slides, notes or videos to this session

Tell your friends!


Time 8:30am5:30pm GMT

Date Fri 11th September 2015

Session Hash Tag


Short URL


Official session page


View the schedule


See something wrong?

Report an issue with this session