In my previous post I covered the journey into Snow Software and SAM. It was at times a tortuous journey learning the intricacies of software licensing, mainly from reverse engineering Sql stored procs and views. Times were moving quickly and work needed to be done.

My first job was to produce an on premise PowerBI template that could be applied to our local install of our application server to extract pertinent information and present useful BI insights into the client organisation. This was my first foray into understanding the intricacies of SAM and this led my thinking and intricacies of a never ending changing dataset.

The lessons I learned from this exercise that was it was pretty much commercial suicide. The services side of the business would be flooded with support requests to support multiple versions of our installed server applications. This is where my experience of distributed ETL rang true.