tech·nic·al·ly agile

MSBuild and Business Intelligence Packages, Ahhhhhh!

Explore the challenges of automating Business Intelligence builds with MSBuild. Discover solutions for SSIS and SSAS package deployment and testing.

Published on
2 minute read
Image
https://nkdagility.com/resources/lttzdaIlzel

I have been trying to get a handle on doing an automated build of our Business Intelligence solutions and I am always running into problems around the (IMO badly build) BI Packages that are installed via SQL. They do not support Test, they do not support build. There has been no thought given to how people working on them are going to build test and support them and even the project files are not written in the same schema as the rest of the Visual Studio bits. I would have thought, with Team Foundation Server in its third year and second version that this would have been rectified in SQL 2008, but no such luck.

Today there are enormous BI solutions out there. Some built using these tools, and everyone needs to come up with their own solutions to this problem.

Here are some of the problems:

There are some answers. The visual studio team has taken on board the database piece with Visual Studio Team Edition for Databases. But the rest are languishing in perdition and there are no elegant solutions.

I am bookmarking my investigation on delicious  , but it will be a long slog…

Technorati Tags: ALM    TFBS 

Comments

Related blog posts

No related videos found.

Connect with Martin Hinshelwood

If you've made it this far, it's worth connecting with our principal consultant and coach, Martin Hinshelwood, for a 30-minute 'ask me anything' call.

Our Happy Clients​

We partner with businesses across diverse industries, including finance, insurance, healthcare, pharmaceuticals, technology, engineering, transportation, hospitality, entertainment, legal, government, and military sectors.​

Big Data for Humans Logo
Emerson Process Management Logo
Ericson Logo
Deliotte Logo
Sage Logo
Higher Education Statistics Agency Logo
Boeing Logo
Flowmaster (a Mentor Graphics Company) Logo
ProgramUtvikling Logo

CR2

NIT A/S

Capita Secure Information Solutions Ltd Logo
Slaughter and May Logo
Workday Logo
Cognizant Microsoft Business Group (MBG) Logo
Genus Breeding Ltd Logo
Qualco Logo
Akaditi Logo
Royal Air Force Logo
Washington Department of Transport Logo
Washington Department of Enterprise Services Logo
Nottingham County Council Logo
Department of Work and Pensions (UK) Logo
Ghana Police Service Logo
MacDonald Humfrey (Automation) Ltd. Logo
Kongsberg Maritime Logo
Freadom Logo
Lean SA Logo
Alignment Healthcare Logo
Philips Logo