SharePoint Server 中商務智慧的軟體需求Software requirements for business intelligence in SharePoint Server

摘要:了解在 SharePoint Server 2016 和 SharePoint Server 2013 中執行商務智慧功能的基本軟體需求。Summary: Learn about the minimum software requirements to run business intelligence features in SharePoint Server 2016 and SharePoint Server 2013.

SharePoint Server 2016 的商務智慧工具包含下列軟體:The business intelligence tools for SharePoint Server 2016 include the following:

  • Microsoft Power View for SharePoint Server 2016Microsoft Power View for SharePoint Server 2016

  • Microsoft SQL Server 2016 Reporting Services (SSRS)Microsoft SQL Server 2016 Reporting Services (SSRS)

  • Microsoft Power Pivot for SharePoint Server 2016Microsoft Power Pivot for SharePoint Server 2016

  • Microsoft SQL Server 2016 Analysis Services (SSAS)Microsoft SQL Server 2016 Analysis Services (SSAS)

  • Office Online 伺服器 for Excel OnlineOffice Online Server for Excel Online

  • PerformancePoint ServicesPerformancePoint Services

  • Visio ServicesVisio Services

SharePoint Server 2013 的商務智慧工具包含下列軟體:The business intelligence tools for SharePoint Server 2013 include the following:

  • Microsoft Power View for SharePoint 2013Microsoft Power View for SharePoint 2013

  • 適用於 SharePoint 的 Microsoft SQL Server 2012 Reporting ServicesMicrosoft SQL Server 2012 Reporting Services for SharePoint

  • Microsoft Power Pivot for SharePoint 2013Microsoft Power Pivot for SharePoint 2013

  • Microsoft SQL Server 2012 SP1 Analysis Services (SSAS)Microsoft SQL Server 2012 SP1 Analysis Services (SSAS)

  • Excel ServicesExcel Services

  • PerformancePoint ServicesPerformancePoint Services

  • Visio ServicesVisio Services

Power Pivot for SharePoint Server 2016 的軟體需求Software requirements for Power Pivot for SharePoint Server 2016

Power Pivot for SharePoint Server 2016 的需求如下:The requirements for Power Pivot for SharePoint Server 2016 are as follows:

  • 在 Power Pivot 模式中安裝 Analysis Services - 若要使用 Excel Online 功能,例如 SharePoint Server 2016上的進階資料模型,SQL Server 2016 Analysis Services 的執行個體必須安裝於 Power Pivot 模式。Install Analysis Services in Power Pivot Mode - in order to use the Excel Online features such as advanced data models on SharePoint Server 2016, an instance of SQL Server 2016 Analysis Services must be installed in Power Pivot mode.

  • Office Online 伺服器 與 Excel Online 必須在伺服陣列上進行設定,而至少一個 Analysis Services在 SharePoint 模式中必須在 Office Online 伺服器 組態中註冊。Excel Online 可以使用多個 Analysis Services 伺服器,但它們必須全部使用 SQL Server Management Studio (SSMS) 的發行版本。如需詳細資訊,請參閱<下載 SQL Server Management Studio (SSMS)>。Office Online Server with Excel Online must be configured on the farm and at least one Analysis Services server in SharePoint mode must be registered in the Office Online Server configuration. Excel Online can use multiple Analysis Services servers, but they must all use the release version of SQL Server Management Studio (SSMS). For more information, see Download SQL Server Management Studio (SSMS).

  • 如果要為 Power Pivot 活頁簿設定排程資料重新整理,就必須在伺服器陣列上設定 Secure Store。Secure Store must be configured on the farm if you want to configure scheduled data refresh of Power Pivot workbooks.

重要

若為 SharePoint Server 2016,Power Pivot for SharePoint 2013必須從 SQL Server 2016 安裝。For SharePoint Server 2016, Power Pivot for SharePoint 2013 must be installed from SQL Server 2016.

Power Pivot for SharePoint 2013 的軟體需求Software requirements for Power Pivot for SharePoint 2013

Power Pivot for SharePoint 2013 的需求如下:The requirements for Power Pivot for SharePoint 2013 are as follows:

  • SQL Server 2012 SP1:若要能夠將新的 Excel 2016 功能 (例如進階資料模型) 用於 SharePoint Server 2016,則必須以 SharePoint 部署模式安裝 SQL Server 2012 SP1 Analysis Services 執行個體。SQL Server 2012 SP1: To be able to use the new Excel 2016 features such as advanced data models on SharePoint Server 2016, an instance of SQL Server 2012 SP1 Analysis Services must be installed in SharePoint deployment mode.

  • 必須在伺服器陣列上設定 Excel Services,且必須在 Excel Services 組態中,以 SharePoint 模式至少登錄一部 Analysis Services 伺服器。SharePoint Server 2013 的 Excel Services 可以使用多重 Analysis Services 伺服器,但這些伺服器都必須是 SQL 2012 SP1。Excel Services must be configured on the farm and at least one Analysis Services server in SharePoint mode must be registered in the Excel Services configuration. Excel Services in SharePoint Server 2013 can use multiple Analysis Services servers, but they must all be SQL 2012 SP1.

  • 如果要為 PowerPivot 活頁簿設定排程資料重新整理,就必須在伺服器陣列上設定 Secure Store。Secure Store must be configured on the farm if you want to configure scheduled data refresh of PowerPivot workbooks.

重要

如果是 SharePoint Server 2016,則必須從 SQL Server 2012 SP1 安裝程式或 SQL Server 2012 SP1 Feature Pack 網頁安裝 Power Pivot for SharePoint 2013。For SharePoint Server 2016, Power Pivot for SharePoint 2013 must be installed from either SQL Server 2012 SP1 setup or the SQL Server 2012 SP1 Feature Pack web page.

SharePoint Server 2016 的 Reporting Services 軟體需求Software requirements for Reporting Services on SharePoint Server 2016

在 SharePoint Server 2016 上執行 Power View、從 SharePoint 啟動報表產生器以及檢視 Reporting Services 報表的需求如下:The requirements to run Power View, start Report Builder from SharePoint and view Reporting Services reports on SharePoint Server 2016 are as follows:

  • 適用於 Microsoft SharePoint 的 Microsoft SQL Server 2016 Reporting Services 增益集:若要能夠從 SharePoint Server 2016 啟動報表產生器和從 SharePoint Server 2016 檢視 Reporting Services 報告,SQL Server 2016 Reporting Services 的執行個體必須安裝在應用程式伺服器上的 SharePoint 模式,並指派 MinRole 自訂角色。Reporting Services 不支援 MinRole,而且無法在指派任何其他角色的應用程式伺服器上執行。Microsoft SQL Server 2016 Reporting Services Add-in for Microsoft SharePoint: To be able to start Report Builder from SharePoint Server 2016 and for viewing Reporting Services reports from SharePoint Server 2016, an instance of SQL Server 2016 Reporting Services must be installed in SharePoint mode on an application server assigned the MinRole Custom role. Reporting Services doesn't support MinRole and cannot run on application servers that are assigned any other role.

  • 若要在 SharePoint Server 2016 上檢視 Excel Online 活頁薄的 Power View 工作表,SQL Server 2016 Reporting Services與 Office Online 伺服器 必須在伺服陣列上進行設定,而至少一個 Analysis Services伺服器在 SharePoint 模式中必須在 Excel Online 組態中註冊。Excel Online 可以使用多個 Analysis Services 伺服器,但它們必須全部為 SQL Server 2016。To view Power View sheets in Excel Online workbooks on SharePoint Server 2016, SQL Server 2016 Reporting Services and Office Online Server must be configured on the farm and at least one Analysis Services server in SharePoint mode must be registered in the Excel Online configuration. Excel Online can use multiple Analysis Services servers, but they must all be SQL Server 2016.

SharePoint Server 2013 的 Reporting Services 軟體需求Software requirements for Reporting Services on SharePoint Server 2013

在 SharePoint 2013 上執行 Power View、從 SharePoint 啟動報表產生器以及檢視 Reporting Services 報表的需求如下:The requirements to run Power View, start Report Builder from SharePoint and view Reporting Services reports on SharePoint 2013 are as follows:

  • SQL Server 2012 SP1:若要能夠從 SharePoint 2013 啟動報表產生器以及從 SharePoint 2013 檢視 Reporting Services 報表,則必須以 SharePoint 部署模式安裝 SQL Server 2012 SP1 Reporting Services 執行個體。SQL Server 2012 SP1: To be able to start Report Builder from SharePoint 2013 and for viewing Reporting Services reports from SharePoint 2013, an instance of SQL Server 2012 SP1 Reporting Services must be installed in SharePoint deployment mode.

  • 若要在 SharePoint 2013 上檢視 Excel 2016 活頁簿中的 Power View 工作表,則必須在伺服器陣列上設定 Excel Services,且必須在 Excel Services 組態中,以 SharePoint 模式至少登錄一部 Analysis Services 伺服器。Excel Services 可以使用多重 Analysis Services 伺服器,但這些伺服器都必須是 SQL 2012 SP1。To view Power View sheets in Excel 2016 workbooks on SharePoint 2013, Excel Services must be configured on the farm and at least one Analysis Services server in SharePoint mode must be registered in the Excel Services configuration. Excel Services can use multiple Analysis Services servers, but they must all be SQL 2012 SP1. 3.

注意

不再需要報表檢視器元件。SharePoint 部署模式中的 SQL Server 2012 SP1 Reporting Services 包括所有必要的 Web 前端元件。The Report Viewer component is no longer needed. The SQL Server 2012 SP1. Reporting Services in SharePoint deployment mode includes all of the web-front-end components required.

Excel Online 的軟體需求Software requirements for Excel Online

在適用於 SharePoint Server 2016 之 Office Online 伺服器 的 Excel Online 需求如下:The requirements for Excel Online in Office Online Server for SharePoint Server 2016 are as follows:

注意

若為 Analysis Services 資料,則 EffectiveUserName 選項是存取資料的替代方法。當它啟用時,個別使用者與 Analysis Services 資料之間的所有連線都會使用 EffectiveUserName 連線字串屬性 (而非 Windows 委派) 來進行。如需詳細資訊,請參閱<設定 Excel Online 系統管理設定>中的<在 Excel Online 中設定 Analysis Services EffectiveUserName>。For Analysis Services data, the EffectiveUserName option is an alternative method of accessing data. When it is enabled, all connections to Analysis Services data for individual users will be made by using the EffectiveUserName connection string property instead of Windows delegation. For more information, see "Configure Analysis Services EffectiveUserName in Excel Online in Configure Excel Online administrative settings.

如需有關 Excel Online的規劃資訊,請參閱<規劃 Office Online Server>。如需設定 Excel Online的詳細資訊,請參閱<Configure Excel Online administrative settings>。For information about planning for Excel Online, see Plan Office Online Server. For information about configuring Excel Online, see Configure Excel Online administrative settings.

SharePoint Server 2013 的 Excel Services 的軟體需求Software requirements for Excel Services in SharePoint Server 2013

SharePoint Server 2016 的 Excel Services 需求如下:The requirements for Excel Services for SharePoint Server 2016 are as follows:

  • 如果打算使用 Excel Services 搭配進階資料模型,則必須在 Excel Services 組態中,以 SharePoint 模式至少登錄一部 Analysis Server。Excel Services 可以使用多重 Analysis Services 伺服器,但這些伺服器都必須是 SQL Server 2012 SP1 Analysis Services (SSAS)。If you plan to use Excel Services with advanced data models, at least one Analysis Server in SharePoint mode must be registered in the Excel Services configuration. Excel Services can use multiple Analysis Services servers, but they must all be SQL Server 2012 SP1 Analysis Services (SSAS).

  • 如果要儲存加密認證以用於資料重新整理案例,或是要使用 Excel Services 自動服務帳戶,則必須在伺服器陣列中設定 Secure Store Service。如需詳細資訊,請參閱<規劃 SharePoint Server 的 Secure Store Service>。The Secure Store Service must be configured in the farm if you want to store encrypted credentials for data refresh scenarios, or if you want to use the Excel Services unattended service account. For more information, see Plan the Secure Store Service in SharePoint Server.

  • 如果要將使用者認證委派給外部資料來源以用於資料重新整理案例,則必須設定 Kerberos 限制委派。Kerberos constrained delegation must be configured if you want to delegate user credentials to an external data source for data refresh scenarios.

注意

若為 Analysis Services 資料,則 EffectiveUserName 選項是存取資料的替代方法。當它啟用時,個別使用者與 Analysis Services 資料之間的所有連線都會使用 EffectiveUserName 連線字串屬性 (而非 Windows 委派) 來進行。如需詳細資訊,請參閱<在 SharePoint Server 中使用 Analysis Services EffectiveUserName>。For Analysis Services data, the EffectiveUserName option is an alternative method of accessing data. When it is enabled, all connections to Analysis Services data for individual users will be made by using the EffectiveUserName connection string property instead of Windows delegation. For more information, see Use Analysis Services EffectiveUserName in SharePoint Server.

如需規劃 Excel Services 的資訊,請參閱<SharePoint Server 2013 的 Excel Services 概觀>。如需設定 Excel Services 的資訊,請參閱<Configure Excel Services in SharePoint Server 2013>。For information about planning for Excel Services, see Overview of Excel Services in SharePoint Server 2013. For information about configuring Excel Services, see Configure Excel Services in SharePoint Server 2013.

SharePoint Server 2016 中的 PerformancePoint 服務 的軟體需求Software requirements for PerformancePoint Services in SharePoint Server 2016

SharePoint Server 2016 中的 PerformancePoint 服務 的需求如下:The requirements for PerformancePoint Services in SharePoint Server 2016 are as follows:

  • ADOMD.net V11ADOMD.net V11

  • 為 PerformancePoint Services 設定 SharePoint Server 2016應用程式集區帳戶。如需詳細資訊,請參閱<設定 PerformancePoint Services>。Configure a SharePoint Server 2016 managed account for the PerformancePoint Services application pool account. For more information, see Configure PerformancePoint Services.

注意

若為 Analysis Services 資料,則 EffectiveUserName 選項是存取資料的替代方法。當它啟用時,個別使用者與 Analysis Services 資料之間的所有連線都會使用 EffectiveUserName 連線字串屬性 (而非 Windows 委派) 來進行。For Analysis Services data, the EffectiveUserName option is an alternative method of accessing data. When enabled, all connections to Analysis Services data for individual users will be made using the EffectiveUserName connection string property instead of Windows delegation.

注意

ADOMD.net V11 並未作為 SharePoint Server 2016 必要條件安裝程式工具的一部分進行安裝。從 SQL Server 2012 功能套件 安裝 ADOMD.NET。不過,如果您正在應用程式伺服器上的 SharePoint 模式下安裝 SQL Server 2016 Reporting Services,則已包含此檔案。ADOMD.net V11 is not installed as part of the SharePoint Server 2016 prerequisite installer tool. Install ADOMD.NET from the SQL Server 2012 Feature Pack. However, if you are installing the SQL Server 2016 Reporting Services in SharePoint mode on your application server, this file is included.

如需如何規劃並設定 PerformancePoint Services 詳細資訊,請參閱<SharePoint Server 2016 中的 PerformancePoint 服務概觀>和<設定 PerformancePoint Services>。For information about how to plan for and configure PerformancePoint Services, see PerformancePoint Services in SharePoint Server 2016 overview and Configure PerformancePoint Services.

SharePoint Server 2013 中 PerformancePoint Services 的軟體需求Software requirements for PerformancePoint Services in SharePoint Server 2013

PerformancePoint Services 的需求如下:The requirements for PerformancePoint Services are as follows:

  • ADOMD.net V11ADOMD.net V11

  • SQLSERVER2008_ASAMO10SQLSERVER2008_ASAMO10

  • 如果要儲存加密認證以用於資料重新整理案例,或是要使用 PerformancePoint Services 自動服務帳戶,則必須在伺服器陣列中設定 Secure Store。如需詳細資訊,請參閱<規劃 SharePoint Server 的 Secure Store Service>。Secure Store must be configured in the farm if you want to store encrypted credentials for data refresh scenarios, or if you want to use the PerformancePoint Services unattended service account. For more information, see Plan the Secure Store Service in SharePoint Server.

  • 如果要將使用者認證委派給外部資料來源以用於資料重新整理案例,則必須設定 Kerberos 限制委派。Kerberos constrained delegation must be configured if you want to delegate user credentials to an external data source for data refresh scenarios.

注意

若為 Analysis Services 資料,則 EffectiveUserName 選項是存取資料的替代方法。當它啟用時,個別使用者與 Analysis Services 資料之間的所有連線都會使用 EffectiveUserName 連線字串屬性 (而非 Windows 委派) 來進行。For Analysis Services data, the EffectiveUserName option is an alternative method of accessing data. When enabled, all connections to Analysis Services data for individual users will be made using the EffectiveUserName connection string property instead of Windows delegation.

注意

ADOMD.net V11 並非 SharePoint 2013 先決條件安裝程式工具的一部分。不過,如果在應用程式伺服器上以 SharePoint 2013 模式安裝 SQL Server 2012 Reporting Services SQL Server 2012 Reporting Services,則會包含此檔案。ADOMD.net V11 is not installed as part of the SharePoint 2013 prerequisite installer tool. However, if you are installing the SQL Server 2012 Reporting Services SQL Server 2012 Reporting Services in SharePoint 2013 mode on your application server, this file is included.

如需如何規劃 PerformancePoint Services 的詳細資訊,請參閱<SharePoint Server 2016 中的 PerformancePoint 服務概觀>。如需如何設定 PerformancePoint Services 的資訊,請參閱<設定 PerformancePoint Services>。For information about how to plan for PerformancePoint Services, see PerformancePoint Services in SharePoint Server 2016 overview. For information about how to configure PerformancePoint Services, see Configure PerformancePoint Services.

SharePoint 的 Visio Services 的軟體需求Software requirements for Visio Services in SharePoint

SharePoint 的 Visio Services 的需求如下:The requirements for Visio Services in SharePoint are as follows:

  • 如果要儲存加密認證以用於資料重新整理案例,則必須在伺服器陣列中設定 Secure Store。如需詳細資訊,請參閱<規劃 SharePoint Server 的 Secure Store Service>。Secure Store must be configured in the farm if you want to store encrypted credentials for data refresh scenarios. For more information, see Plan the Secure Store Service in SharePoint Server.

  • 如果要將使用者認證委派給外部資料來源以用於資料重新整理案例,則必須設定 Kerberos 限制委派。Kerberos constrained delegation must be configured if you want to delegate user credentials to an external data source for data refresh scenarios.

如需如何規劃 Visio Services 的詳細資訊,請參閱<SharePoint Server 的 Visio Services 概觀>。如需如何設定Visio Services 的詳細資訊,請參閱<設定 Visio Services>。For information about how to plan for Visio Services, see Overview of Visio Services in SharePoint Server. For information about how to configure Visio Services, see Configure Visio Services.

另請參閱See also

其他資源Other Resources

含 SP1 的 SQL Server 2016SQL Server 2016 with SP1

SQL 2012 SP1 安裝SQL 2012 SP1 Installation

在 SharePoint 2016 中部署 SQL Server 2016 PowerPivot 和 Power ViewDeploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016

在多層式 SharePoint 2016 伺服器陣列中部署 SQL Server 2016 PowerPivot 和 Power ViewDeploying SQL Server 2016 PowerPivot and Power View in a Multi-Tier SharePoint 2016 Farm