Database Reference
In-Depth Information
■
while communicating with SQL Server through Visio Services, you'll need to con-
figure an additional setting. If you're using SQL Server with windows Authentication, you'd
connect using:
Note
Kerberos/Integrated Windows Authentication
: This setting uses the current
logged-in user account, which requires Kerberos delegation to authenticate to the database
server. For more information on Kerberos, see
Secure Store Service (SSS)
: This setting uses either an individual user or group that's
mapped for authentication while using an office data connection file (*.ODC). SSS is
explained in more detail later in this chapter.
Unattended Service Account
: This is a low-privilege windows account mapped to a target
application that is impersonated while connecting to the database. (This is also what you'd
use with SQL Authentication.) we will be using this model with SSS while connecting to
SQL Server as a data source.
From the available databases, choose VisioServices and select the tblLandmarks
table. Click next to continue.
The next step gives you the option to save the data connection file (.odc) as a
physical file. Click on Browse to choose where to save the .odc file (or skip this step
by clicking on Finish). The .odc file can be repurposed to create a new data source
connection from the Data Selector window by choosing the previously created
connection option. Provide a friendly name for the file and click Finish to complete
the wizard.
■
To create a data-refreshable web drawing (.vsdx), you have to save the .odc file to
the same SharePoint site location as the data connection library.
Note
Under the 'Data Selector' screen, choose the columns and rows to include and click
next to continue. After a successful import message, click Finish.
The external Data window will now load and display the data from the selected
database table.
Make sure that the text in the Landmark column is identical to the Title of the
shapes. Drag row data from the external Data window to the shape on the page.
If the column text is identical to the shape text, the link will be created successfully
and you can then create the data graphics for the shape.
