使用 Excel 和 Excel Services 共用資料連線 (SharePoint Server 2013)Share data connections by using Excel and Excel Services (SharePoint Server 2013)

摘要:在 SharePoint Server 2013 中的 Excel Services 可讓您運用不同的外部資料來源來建立報表、 計分卡和自動維持最新的儀表板。Summary: Excel Services in SharePoint Server 2013 enables you to work with different external data sources to create reports, scorecards, and dashboards that remain up to date automatically.

Excel 可以連線到許多不同的資料來源。這些包括 SQL Server、 SharePoint 清單、 Access 資料庫、 Azure DataMarket 摘要、 OData 摘要等等。您可以使用 Excel 中的資料連線的許多支援為 Excel Services 中的資料連線。這表示使用者可以重新整理 Excel Services 報表、 計分卡及使用這些資料連線的儀表板中的資料。更明確 Excel Services 支援的 SQL Server 資料表、 SQL Server Analysis Services cube 及自訂的 OLE DB/ODBC 資料提供者的連線。Excel can connect to lots of different data sources. These include SQL Server, a SharePoint list, an Access database, an Azure DataMarket Feed, an OData feed, and so on. Many of the data connections that you can use in Excel are supported as data connections in Excel Services. This means that people can refresh data in Excel Services reports, scorecards, and dashboards that use those data connections. More specifically, Excel Services supports connections to SQL Server tables, SQL Server Analysis Services cubes, and custom OLE DB/ODBC data providers.

由 Excel Services 信任的資料連線庫中儲存資料連線、 人員可以輕鬆地存取您不必知道伺服器和資料庫的名稱所需之資料來源。資料連線項目可重複使用讓人員可以建立多個報表或使用這些資料連線的活頁簿。此外,使人員可以輕鬆存取目前的資訊可更新 Excel Services 信任的資料連線庫中使用連線的活頁簿。By storing data connections in an Excel Services trusted data connection library, people can easily access the data sources that they need without having to know the names of servers and databases. Data connections are reusable so that people can create multiple reports or workbooks using those data connections. In addition, Excel Services workbooks that use connections in a trusted data connection library can be updated so that people have easy access to current information.

使用本節中的文章了解如何建立及發佈使用 Excel Services 的外部資料連線。Use the articles in this section to learn how to create and publish external data connections using Excel Services.

In this sectionIn this section

另請參閱See also

概念Concepts

商務智慧功能的 Excel Service (SharePoint Server 2013)Business intelligence capabilities in Excel Service (SharePoint Server 2013)

支援的 Excel Services (SharePoint Server 2013) 資料來源Data sources supported in Excel Services (SharePoint Server 2013)