SQL Server 2008 & AdventureWorksDW BDC Demo

  • Article

How to access SQL Server 2008 data directly with SharePoint ? Here is a sample demo :

After installing MOSS 2007 on Visual Studio 2008, I wanted to see if I could get the BDC working against the new version of the AdventureWorksDW database for SQL Server 2008.  

I used the AdventureWorks2005.xml application definition file that ships with the MOSS 2007 SDK to create a connection to the SQL Server 2008 AdventureWorksDW database. BDC’s can be very temperamental at times, so I was expecting some hiccups along the way. As it turns out it, it was pretty painless and worked without a hitch.  

The full article is here : SQL Server 2008 - AdventureWorksDW BDC Demo us

AdventureWorksDW BDC Web Part Demo Page