使用 Excel Services 搭配 Secure Store Service in SharePoint Server 2016Use Excel Services with Secure Store Service in SharePoint Server 2016

摘要:了解使用 Secure Store Service 與 SharePoint Server 2013 中的 Excel Services 重新整理外部資料來源的資料可用的選項。Summary: Learn about the options available for using the Secure Store Service with Excel Services in SharePoint Server 2013 to refresh data from external data sources.

此系列文章說明如何設定 SharePoint Server 2013 中的 Excel Services 資料重新整理使用 Secure Store Service 將使用者和群組認證對應至外部資料來源的認證。This series of articles describes how to configure data refresh in Excel Services in SharePoint Server 2013 by using the Secure Store Service to map user and group credentials to the credentials of external data sources.

在 Secure Store 中您可以指定您要授與資料來源的存取權的使用者群組以及一組認證且可存取該資料來源。使用者資訊會儲存在 Secure Store 目標應用程式和相關聯的認證會儲存加密、 安全認證儲存資料庫中。然後您可以指定目標應用程式或 Excel Services 通用設定] 中的活頁簿、 Office 資料連線 (ODC) 檔案,以及 Excel Services 將用於儲存代表指定之使用者的認證重新整理資料連線的活頁簿中的資料。In Secure Store you specify a group of users to whom you want to grant access to a data source and a set of credentials that has access to that data source. The user information is stored in a Secure Store target application and the associated credentials are stored, encrypted, in the Secure Store database. You can then specify the target application in a workbook, an Office Data Connection (ODC) file, or in Excel Services Global Settings, and Excel Services will use the stored credentials on behalf of the specified users to refresh data in a data-connected workbook.

注意

這些文章假設您已部署 Secure Store Service 應用程式。如果您尚未部署 Secure Store,請參閱 < Plan Secure Store Service in SharePoint Server設定 Secure Store Service in SharePoint ServerThese articles assume that you have already deployed a Secure Store Service Application. If you have not deployed Secure Store, see Plan the Secure Store Service in SharePoint Server and Configure the Secure Store Service in SharePoint Server.

Excel Services 可以搭配 Secure Store 中三個主要的案例:Excel Services can be used with Secure Store in three primary scenarios:

自動服務帳戶: 自動的服務帳戶是由 Excel Services 用來提供廣泛的資料庫存取權給伺服器陣列中的所有使用者帳戶。使用自動的服務帳戶存取,不會被視為為機密或其中您不想限制特定使用者群組存取資料。如需如何設定此案例的資訊,請參閱 < Configure Excel Services 資料重新整理使用中 SharePoint Server 2016 自動的服務帳戶Unattended Service Account: The unattended service account is an account that is used by Excel Services to provide broad database access to all users in the farm. Use the unattended service account for accessing data that is not considered sensitive or where you do not want to restrict access to a certain group of users. For information about how to configure this scenario, see Configure Excel Services data refresh by using the unattended service account in SharePoint Server 2016.

內嵌連線: 在 Excel 中,您可以直接在活頁簿中指定的安全認證儲存目標應用程式。當活頁簿發佈至 SharePoint 文件庫與再使用 Excel Services 轉譯時,將指定的目標應用程式用來重新整理資料。如需如何設定此案例的資訊,請參閱 < Configure Excel Services 資料重新整理使用內嵌的資料連線Embedded Connections: In Excel, you can specify a Secure Store target application directly in the workbook. When the workbook is published to a SharePoint document library and then rendered by using Excel Services, the specified target application is used to refresh the data. For information about how to configure this scenario, see Configure Excel Services data refresh by using embedded data connections.

外部資料連線: 您可以在 Office 資料連線 (ODC) 檔案中指定的安全認證儲存目標應用程式,然後連線至 Excel 中的 ODC 檔案。當您將活頁簿發佈至 SharePoint 文件庫時,它會保留其連線至 ODC 檔案。Excel Services 重新整理活頁簿中的資料時使用的 ODC 檔案中的連線資訊。使用 ODC 檔案有下列優點:External Data Connections: You can specify a Secure Store target application in an Office Data Connection (ODC) file and then connect to that ODC file in Excel. When you publish the workbook to a SharePoint document library, it maintains its connection to the ODC file. The connection information in the ODC file is used when Excel Services refreshes the data in the workbook. Using an ODC file has the following advantages:

- <span data-ttu-id="71565-p106">單一的 ODC 檔案可以參照多個活頁簿。如果資料來源連線參數變更 (例如,如果您想要使用的不同比原先指定安全認證儲存目標應用程式) 您只需要更新的 ODC 檔案並不自己的活頁簿。</span><span class="sxs-lookup"><span data-stu-id="71565-p106">A single ODC file can be referenced by multiple workbooks. If the data source connection parameters change (for example, if you want to use a different Secure Store target application than the one originally specified) you need only update the ODC file and not the workbooks themselves.</span></span>

- <span data-ttu-id="71565-p107">使用 ODC 檔案可讓管理員建立及維護組織所使用的資料連線。您可以為使用者建立適當的資料連線,將資料連線置於信任的資料連線庫,然後通知使用者可用於查詢的 ODC 檔案。</span><span class="sxs-lookup"><span data-stu-id="71565-p107">Using ODC files allows administrators to create and maintain the data connections that are used by the organization. You can create data connections appropriate for users, place them in a trusted data connection library, and then notify the users of which ODC files to use for their queries.</span></span>

<span data-ttu-id="71565-126">如需如何設定此案例的資訊,請參閱 < [Configure Excel Services 資料重新整理使用外部資料連線](http://technet.microsoft.com/library/0d33c049-3f9e-42e9-be48-aeecd4ad7b66.aspx)。</span><span class="sxs-lookup"><span data-stu-id="71565-126">For information about how to configure this scenario, see [Configure Excel Services data refresh by using external data connections](http://technet.microsoft.com/library/0d33c049-3f9e-42e9-be48-aeecd4ad7b66.aspx).</span></span>