Configuring a Database Connection
The following example walks through configuring a database connection to the AdventureWorksDW2008 database. It also demonstrates a common issue that can happen when SharePoint Designer incorrectly recognizes the database schema and subsequent queries against the database fail and discusses use of Custom SQL Statements to overcome this issue.
Note
The following example uses the AdventureWorksDW2008 database, but you can also use the AdventureWorksDW database.
To create a new database connection, use the following steps.
1. Click the Data Sources tab in the left-hand navigation pane.
2. Click Data Connection in the New group in the ribbon.
3. In the Data Source Properties dialog, under the source tab, click ...
Get Microsoft® SharePoint® Designer 2010 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
