Speaking the language of business intelligence with an Australian accent

Tuesday, November 24, 2009

Beginning Master Data Services (Part 1 of 7)

Like many other geeks out there I learn by doing. One of the things on my todo list has been to get familiar with MDS. During my experimentation with the recently released CTP I figured I'd take some notes on what I learned. These notes have evolved into a series of posts that will walk through some of the basics in putting MDS to work.

At this point we're only in the first public CTP, but everyone's just a bit curious to kick the MDS tires a bit. We all know there's quite a lot of functionality baked into the product in terms of workflow, versioning, web services and APIs but how about just the basics. These posts act as a quick start to see MDS in action. Once you’ve put some data into the system you can pull back the covers and have a look at how it happened and where the data is. We all learn something that way.

The walkthroughs will go through the creation of a very simple Geography MDS model based on the data contained in the DimGeography table in the SQL 2008R2 release of the AdventureWorks DW database. In the posts to follow we will walk through the following:

All posts assume that you have already installed MDS and have the AdventureWorksDW2008R2 DB set up on the same server.

On to Creating a Model

5 comments:

Rock said...

Why the new SQL R2 MDM only available on 64 bits?

Nick Barclay said...

Not sure, Rock. My guess is that in line with things like Windows Server 2008 R2 and MOSS 2010 maybe Microsoft have decided to only support a 64 bit version. Then again we may see a 32 bit version in the RTM... I'll see what I can fine out.

Cheers,
NB

Anonymous said...

Hi,
I downloaded and installed Sql Server 2008 R2 CTP Enterprise version on a 64 bit machine. where i can find Master Data Services?

Thanks.

Nick Barclay said...

On the SQL installation media there will be a Master_Data_Services folder. Inside you'll find the appropriate MSI that will install MDS.

HTH,
Nick

Anonymous said...

Thanks