Using PowerPivot for SharePoint 2013 - Business Intelligence in Microsoft SharePoint 2013 - page 201

FIGURE 7-16 The Credentials options on the Manage Data Refresh page—specifying a Target Application ID.
Note Setting up and maintaining SSS is beyond the scope of this topic. For more infor-
mation about it, read the TechNet article at http://technet.microsoft.com/en-us/library/
ee806866.aspx .
data Sources
A workbook can have many data sources, each with different characteristics. Figure 7-17 shows that
you can choose to create a data refresh schedule by using different settings for each data source,
or even disable the data refresh for it (by clearing its corresponding check box). You can have, for
instance, one data source scheduled to refresh daily and a second source scheduled monthly.
FIGURE 7-17 The Data Sources section on the Manage Data Refresh page.
The schedule definition page provides options for choosing the data sources to be refreshed, when
to refresh them, and which security options to use for each one. It also provides fields for specifying
database credentials or other non-Windows credentials used on the database connection.
You must select at least one data source to save the schedule. The data source's credentials are not
used for impersonation but are instead included on the connection string as UserName and Password .
These credentials override those used on the connection string for the original data import.
Figure 7-18 shows that different settings are available for each data source. You can specify a cus-
tom schedule data source or use the general schedule specified for the workbook.
Note The only modifiable elements in the connection string are the UserName and
Password elements. To edit any of the other elements—for example, to change the source
server name—you must download the workbook to your desktop, edit it in Excel 2013, and
then republish it to SharePoint.