在 SharePoint Server 2013 中規劃信任的資料連線庫Plan Trusted Data Connection Libraries in SharePoint Server 2013

摘要:使用 Excel Services 信任的資料連線庫來管理並保護 Excel Services 在 SharePoint Server 2013 中的資料連線。Summary: Use Excel Services trusted data connection libraries to manage and secure data connections for Excel Services in SharePoint Server 2013.

Excel Services 提供能夠連線至外部資料來源及它在瀏覽器中呈現這些後重新整理資料連線的 Excel 活頁簿的資料。可以使用資訊從活頁簿檔案載入資料連線,但使用資料連線庫提供多一層的資料連線,讓他們可以分別從管理活頁簿。Excel Services provides the ability to connect to external data sources and refresh the data in data-connected Excel workbooks when it renders them in a browser. Data connections can be loaded by using information from the workbook file, but using a data connection library provides an additional layer for data connections so that they can be managed separately from workbooks.

信任的資料連線庫是包含要用來連接至資料庫會信任 Excel Services 的資料連線檔案的 SharePoint Server 2013 資料連線庫。這些檔案包含所有 Excel Services 及 Excel 用戶端必須要有連線至外部資料來源的項目。Trusted data connection libraries are SharePoint Server 2013 data connection libraries that contain data connection files that Excel Services will trust to use to connect to databases. These files contain everything that Excel Services and Excel client have to have to connect to an external data source.

資料連線庫啟用廣泛重複使用和共用的資料連線。使用與 Excel Services 信任的資料連線庫,您可以建立、 部署及管理您的使用者使用的資料連線。您可以藉由管理連線以這種方式,確保連線已正確設定和維護適當地與該使用者所有使用一致群組之已建立並授權的使用者與管理員核准的連線檔案.Data connection libraries enable broad reuse and sharing of data connections. By using trusted data connection libraries with Excel Services, you can create, deploy, and manage the data connections that your users use. By managing connections in this way, you can ensure that connections are configured correctly and maintained properly and that your users are all using a consistent group of connection files that have been created and approved by authorized users and administrators.

Excel Services 不使用不會儲存在信任的資料連線庫中的資料連線檔案。不過,可以直接在嘗試進行連線的活頁簿中內嵌資料連線資訊。Excel Services does not use data connection files that are not stored in a trusted data connection library. However, data connection information can be embedded directly in a workbook that is trying to make a connection.

可以針對不同的用途或專案建立不同的信任資料連線庫,也可以據此為文件庫自訂設定與權限。You can create different trusted data connection libraries for different purposes or projects, and you can customize the settings and permissions to the libraries accordingly.

對於使用相同資料連線檔案的活頁簿,若要變更連線資訊,則必須變更資料連線檔案,不需變更個別的活頁簿。For workbooks that use the same data connection file, changing the data connection file is all that is required to change connection information; changing the individual workbooks is not necessary.

最初有無 Excel Services 信任的資料連線庫。若要儲存資料連線檔案,您必須建立至少一個信任的資料連線庫。Initially, there are no Excel Services trusted data connection libraries. To store data connection files, you must create at least one trusted data connection library.

如需建立信任的資料連線庫的資訊,請參閱 < Manage Excel Services 信任的資料連線庫 (SharePoint Server 2013)For information about creating trusted data connection libraries, see Manage Excel Services trusted data connection libraries (SharePoint Server 2013).

另請參閱See also

概念Concepts

規劃 SharePoint Server 2013 中的信任的檔案位置Plan Trusted File Locations in SharePoint Server 2013