O'Reilly logo

Microsoft® SharePoint® Designer 2010 Unleashed by Kathy Hughes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a Joined Linked Data Source with Database Connections

The following example walks through creating a Linked Data Source and joining two tables from the AdventureWorksDW2008 database. See the following steps to learn how to configure a Linked Data Source.

Note

The following example assumes three database connections to the AdventureWorksDW2008 database: one to the dbo.DimProduct table, one to the dbo.DimProductSubcategory table, and one to the dbo.DimProductCategory table. You need a matching key mapped between each of the tables you are linking. If you are unsure about the relationship between tables then you can check by opening the Microsoft SQL Server Management Studio and expanding the AdventureWorksDW2008 and then expanding the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required