Database Reference
In-Depth Information
■
If you need to configure advanced options, you might have to use SharePoint
Designer. You can extend and build custom interfaces to address connections to other web
parts on the page using the IwebPartParameters interface. For more details, visit
Note
So far, you've seen publishing Visio drawings either with data (using a SharePoint
list) or without data. Now let's see how to connect using SQL Server as a data source,
publish the diagrams to SharePoint, and configure security options.
Using a SQL Server Data Source
Now that you've seen how to establish a data connection with a SharePoint list, let's try
to connect a Visio diagram to a SQL Server table. First, of course, you'll need to create a
database table and then populate the table with some data.
PROBLEM CASE
Display washington, D.C., mall monuments with the number of visitors in a year and
the landmarks' popularity ratings. Publish this diagram to SharePoint and use Visio
Services to display real-time data.
Solution
Create a new database named VisioServices.
Create a table named “tblLandmarks” in the new database and create the columns
shown in Figure
4-24
. Populate the columns with data, as shown in Figure
4-25
.