1. Install the AdventureWorks Sample DW BI Database
First, you need to install the AdventureWorks Sample DW BI database. You can download it from CodePlex.
I downloaded the full version for 2008 with the msi installer, which is nice because it installs the database and attaches it for you. Running the installation is pretty straight-forward, but if you have any trouble, you can refer to an earlier post on my blog here.
2. Install the Office SharePoint Server 2007 SDK (1.3)
Download and install the Office SharePoint Server 2007 SDK. I’m working against the 1.3 version of the SDK. The SDK contains a BDC application definition that were created for the SQL Server 2005 AdventureWorksDW database.
NOTE can download the SharePointPlatformSDK.exe for 2010.
Various Adventureworks sample downloads.