Eksporter (0) Skriv ut
Vis alt
EN
Dette innholdet er ikke tilgjengelig på ditt språk, men her er den engelske versjonen.

Software requirements for business intelligence in SharePoint Server 2013

SharePoint 2013
 

Applies to: SharePoint Server 2013

Topic Last Modified: 2013-12-18

Summary: Learn about the minimum software requirements to run business intelligence features in SharePoint Server 2013.

The business intelligence tools for SharePoint Server 2013 include Power View for SharePoint, SQL Server 2012 Reporting Services for SharePoint, Power Pivot for SharePoint, Excel Services, PerformancePoint Services, and Visio Services.

The requirements for Power Pivot for SharePoint 2013 are as follows:

  • SQL Server 2012 SP1: To be able to use the new Excel 2013 features such as advanced data models on SharePoint Server 2013, an instance of SQL Server 2012 SP1 Analysis Services must be installed in SharePoint deployment mode.

  • 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.

  • Secure Store must be configured on the farm if you want to configure scheduled data refresh of PowerPivot workbooks.

ImportantImportant:
For SharePoint Server 2013, 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.

The requirements to run Power View, start Report Builder from SharePoint and view Reporting Services reports on SharePoint Server 2013 are as follows:

  • SQL Server 2012 SP1: To be able to start Report Builder from SharePoint Server 2013 and for viewing Reporting Services reports from SharePoint Server 2013, an instance of SQL Server 2012 SP1 Reporting Services must be installed in SharePoint deployment mode.

  • To view Power View sheets in Excel 2013 workbooks on SharePoint Server 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 in SharePoint Server 2013 can use multiple Analysis Services servers, but they must all be SQL 2012 SP1. 3.

NoteNote:
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.

The requirements for Excel Services for SharePoint Server 2013 are as follows:

  • 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 2012 SP1.

  • 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 2013.

  • Kerberos constrained delegation must be configured if you want to delegate user credentials to an external data source for data refresh scenarios.

NoteNote:
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 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.

The requirements for PerformancePoint Services in SharePoint Server 2013 are as follows:

  • ADOMD.net V11

  • 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 2013.

  • Kerberos constrained delegation must be configured if you want to delegate user credentials to an external data source for data refresh scenarios.

NoteNote:
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.
NoteNote:
ADOMD.net V11 is not installed as part of the SharePoint Server 2013 prerequisite installer tool. However, if you are installing the SQL Server 2012 Reporting Services SQL Server 2012 Reporting Services in SharePoint Server 2013 mode on your application server, this file is included.

For information about how to plan for PerformancePoint Services, see PerformancePoint Services in SharePoint Server 2013 overview. For information about how to configure PerformancePoint Services, see Configure PerformancePoint Services (SharePoint Server 2013).

The requirements for Visio Services in SharePoint Server 2013 are as follows:

  • 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 Visio Services unattended service account. For more information, see Plan the Secure Store Service in SharePoint Server 2013.

  • Kerberos constrained delegation must be configured if you want to delegate user credentials to an external data source for data refresh scenarios.

For information about how to plan for Visio Services, see Overview of Visio Services in SharePoint Server 2013. For information about how to configure Visio Services, see Create a Visio Graphics Service service application in SharePoint Server 2013.

Vurderte du dette som nyttig?
(1500 tegn igjen)
Takk for tilbakemeldingen
Vis:
© 2014 Microsoft