a·gen·tic a·gil·i·ty

MSBuild and Business Intelligence Packages, Ahhhhhh!

Discusses challenges in automating builds, testing, and deployment for SQL Server BI solutions, focusing on SSIS and SSAS packages and gaps in MSBuild support.

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

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

Subscribe

Related blog

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.​

Capita Secure Information Solutions Ltd Logo

Capita Secure Information Solutions Ltd

Ericson Logo

Ericson

Lean SA Logo

Lean SA

ALS Life Sciences Logo

ALS Life Sciences

Higher Education Statistics Agency Logo

Higher Education Statistics Agency

Cognizant Microsoft Business Group (MBG) Logo

Cognizant Microsoft Business Group (MBG)

Sage Logo

Sage

Alignment Healthcare Logo

Alignment Healthcare

Brandes Investment Partners L.P. Logo

Brandes Investment Partners L.P.

Milliman Logo

Milliman

Schlumberger Logo

Schlumberger

Xceptor - Process and Data Automation Logo

Xceptor - Process and Data Automation

Teleplan Logo

Teleplan

Flowmaster (a Mentor Graphics Company) Logo

Flowmaster (a Mentor Graphics Company)

Lockheed Martin Logo

Lockheed Martin

Philips Logo

Philips

Graham & Brown Logo

Graham & Brown

Slaughter and May Logo

Slaughter and May

Ghana Police Service Logo

Ghana Police Service

Washington Department of Transport Logo

Washington Department of Transport

New Hampshire Supreme Court Logo

New Hampshire Supreme Court

Department of Work and Pensions (UK) Logo

Department of Work and Pensions (UK)

Royal Air Force Logo

Royal Air Force

Nottingham County Council Logo

Nottingham County Council

ALS Life Sciences Logo

ALS Life Sciences

Flowmaster (a Mentor Graphics Company) Logo

Flowmaster (a Mentor Graphics Company)

Sage Logo

Sage

Qualco Logo

Qualco

Graham & Brown Logo

Graham & Brown

Brandes Investment Partners L.P. Logo

Brandes Investment Partners L.P.