Requisitos de software de inteligencia empresarial en SharePoint ServerSoftware requirements for business intelligence in SharePoint Server

Resumen: obtenga información sobre los requisitos mínimos de software para ejecutar las características de inteligencia empresarial en SharePoint Server 2016 y SharePoint Server 2013.Summary: Learn about the minimum software requirements to run business intelligence features in SharePoint Server 2016 and SharePoint Server 2013.

Las herramientas de inteligencia empresarial de SharePoint Server 2016 incluyen lo siguiente:The business intelligence tools for SharePoint Server 2016 include the following:

  • Microsoft Power View para 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 para 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 Server para Excel OnlineOffice Online Server for Excel Online

  • PerformancePoint ServicesPerformancePoint Services

  • Servicios de VisioVisio Services

En las herramientas de inteligencia empresarial de SharePoint Server 2013 se incluye lo siguiente:The business intelligence tools for SharePoint Server 2013 include the following:

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

  • Microsoft SQL Server 2012 Reporting Services para SharePointMicrosoft SQL Server 2012 Reporting Services for SharePoint

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

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

  • Servicios de ExcelExcel Services

  • PerformancePoint ServicesPerformancePoint Services

  • Servicios de VisioVisio Services

Requisitos de software para Power Pivot para SharePoint Server 2016Software requirements for Power Pivot for SharePoint Server 2016

Los requisitos para Power Pivot para SharePoint Server 2016 son los siguientes:The requirements for Power Pivot for SharePoint Server 2016 are as follows:

  • Instalación de Analysis Services en el modo PowerPivot. Para usar las características de Excel Online, como los modelos de datos avanzados en SharePoint Server 2016, debe estar instalada una instancia de SQL Server 2016 Analysis Services en el modo de 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 Server con Excel Online debe estar configurado en la granja y al menos un servidor de Analysis Services en modo de SharePoint debe estar registrado en la configuración de Office Online Server. Excel Online puede usar varios servidores de Analysis Services, pero todos deben usar la versión de lanzamiento de SQL Server Management Studio (SSMS). Para obtener más información, consulte Descarga de 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).

  • Almacén seguro debe estar configurado en la granja si quiere configurar la actualización programada de datos en los libros de Power Pivot.Secure Store must be configured on the farm if you want to configure scheduled data refresh of Power Pivot workbooks.

Importante

Para SharePoint Server 2016, Power Pivot para SharePoint 2013 debe instalarse desde SQL Server 2016.For SharePoint Server 2016, Power Pivot for SharePoint 2013 must be installed from SQL Server 2016.

Requisitos de software Power Pivot para SharePoint 2013Software requirements for Power Pivot for SharePoint 2013

Los requisitos para Power Pivot para SharePoint 2013 son los siguientes:The requirements for Power Pivot for SharePoint 2013 are as follows:

  • SQL Server 2012 SP1: para poder usar las nuevas características de Excel 2016 como modelos de datos avanzados en SharePoint Server 2016, necesita tener instalada una instancia de SQL Server 2012 SP1 Analysis Services en el modo de implementación de SharePoint.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.

  • Servicios de Excel debe estar configurado en la granja y al menos un servidor de Analysis Services en modo de SharePoint debe estar registrado en la configuración de Servicios de Excel. Servicios de Excel en SharePoint Server 2013 puede usar varios servidores de Analysis Services, pero todos deben ser 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.

  • El almacenamiento seguro debe estar configurado en la granja si desea configurar la actualización programada de datos en los libros de PowerPivot.Secure Store must be configured on the farm if you want to configure scheduled data refresh of PowerPivot workbooks.

Importante

Para SharePoint Server 2016, Power Pivot para SharePoint 2013 debe estar instalado desde el programa de instalación de SQL Server 2012 SP1 CTP3 o desde la página web de SQL Server 2012 SP1 Feature Pack.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.

Requisitos de software para Reporting Services en SharePoint Server 2016Software requirements for Reporting Services on SharePoint Server 2016

Los requisitos para ejecutar Power View, iniciar el Generador de informes desde SharePoint y ver informes de Reporting Services en SharePoint Server 2016 son los siguientes:The requirements to run Power View, start Report Builder from SharePoint and view Reporting Services reports on SharePoint Server 2016 are as follows:

  • Complemento de Microsoft SQL Server 2016 Reporting Services para Microsoft SharePoint: Para poder iniciar el Generador de informes desde SharePoint Server 2016 y para ver los informes de Reporting Services desde SharePoint Server 2016, debe estar instalada una instancia de SQL Server 2016 Reporting Services en el modo de SharePoint en un servidor de aplicaciones asignado al rol personalizado MinRole. Reporting Services no es compatible con MinRole y no puede ejecutarse en servidores de aplicaciones que tienen asignado cualquier otro rol.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.

  • Para ver hojas de Power View en libros de Excel Online en SharePoint Server 2016, SQL Server 2016 Reporting Services y Office Online Server debe estar configurado en la granja y al menos un servidor de Analysis Services en modo de SharePoint debe estar registrado en la configuración de Excel Online. Excel Online puede usar varios servidores de Analysis Services, pero todos deben ser 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.

Requisitos de software para Reporting Services en SharePoint Server 2013Software requirements for Reporting Services on SharePoint Server 2013

Estos son los requisitos para usar Power View, iniciar el Generador de informes desde SharePoint y ver informes de Reporting Services en SharePoint 2013: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: para iniciar el Generador de informes desde SharePoint 2013 y ver informes de Reporting Services desde SharePoint 2013, necesita tener instalada una instancia de SQL Server 2012 SP1 Reporting Services en el modo de implementación de SharePoint.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.

  • Para ver hojas de Power View en libros de Excel 2016 en SharePoint 2013, Servicios de Excel debe estar configurado en la granja y al menos un servidor de Analysis Services en modo de SharePoint debe estar registrado en la configuración de Servicios de Excel. Servicios de Excel puede usar varios servidores de Analysis Services, pero todos deben ser 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.

Nota

El componente Report Viewer ya no es necesario. SQL Server 2012 SP1 Reporting Services en modo de implementación de SharePoint incluye todos los componentes web de front-end necesarios.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.

Requisitos de software para Excel OnlineSoftware requirements for Excel Online

Los requisitos para Excel Online en Office Online Server para SharePoint Server 2016 son los siguientes:The requirements for Excel Online in Office Online Server for SharePoint Server 2016 are as follows:

Nota

Para los datos de Analysis Services, la opción EffectiveUserName es un método alternativo de obtener acceso a los datos. Cuando está habilitado, todas las conexiones a los datos de Analysis Services para los usuarios individuales se realizarán mediante la propiedad de cadena de conexión EffectiveUserName en lugar de la delegación de Windows. Para obtener más información, consulte "Configurar EffectiveUserName de Analysis Services en Excel Online" en Configurar las opciones administrativas de Excel Online.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.

Para obtener información sobre la planeación de Excel Online, consulte Planeación con Office Online Server. Para obtener información sobre la configuración de Excel Online, consulte 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.

Requisitos de software para Servicios de Excel en SharePoint Server 2013Software requirements for Excel Services in SharePoint Server 2013

Los requisitos de Servicios de Excel para SharePoint Server 2016 son los siguientes:The requirements for Excel Services for SharePoint Server 2016 are as follows:

  • Si desea usar Servicios de Excel con modelos de datos avanzados, al menos un servidor de Analysis Server en modo SharePoint debe estar registrado en la configuración de Servicios de Excel. Servicios de Excel puede usar varios servidores de Analysis Services, pero todos deben ser 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).

  • Servicio de almacenamiento seguro debe estar configurado en la granja si desea almacenar credenciales cifradas para escenarios de actualización de datos o si desea usar la cuenta de servicio sin supervisar de Servicios de Excel. Para más información, vea Planear el Servicio de almacenamiento seguro en SharePoint Server.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.

  • La delegación limitada de Kerberos debe estar configurada si desea delegar credenciales de usuario a una fuente de datos externa para escenarios de actualización de datos.Kerberos constrained delegation must be configured if you want to delegate user credentials to an external data source for data refresh scenarios.

Nota

Para los datos de Analysis Services, la opción EffectiveUserName es un método alternativo de obtener acceso a los datos. Cuando está habilitado, todas las conexiones a los datos de Analysis Services para los usuarios individuales se realizarán mediante la propiedad de cadena de conexión EffectiveUserName en lugar de la delegación de Windows. Para más información, vea Utilice EffectiveUserName de Analysis Services en SharePoint Server.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.

Para obtener información acerca de la planeación de Servicios de Excel, vea Información general sobre Servicios de Excel en SharePoint Server 2013. Para obtener información acerca de la configuración de Servicios de Excel, vea 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.

Requisitos de software para PerformancePoint Services en SharePoint Server 2016Software requirements for PerformancePoint Services in SharePoint Server 2016

Los requisitos para PerformancePoint Services en SharePoint Server 2016 son los siguientes:The requirements for PerformancePoint Services in SharePoint Server 2016 are as follows:

  • ADOMD.net V11ADOMD.net V11

  • Configure una cuenta administrada de SharePoint Server 2016 para la cuenta del grupo de aplicaciones de PerformancePoint Services. Para obtener más información, consulte Configurar PerformancePoint Services.Configure a SharePoint Server 2016 managed account for the PerformancePoint Services application pool account. For more information, see Configure PerformancePoint Services.

Nota

Para los datos de Analysis Services, la opción EffectiveUserName es un método alternativo de obtener acceso a los datos. Cuando está habilitado, todas las conexiones a los datos de Analysis Services para los usuarios individuales se realizarán mediante la propiedad de cadena de conexión EffectiveUserName en lugar de la delegación de 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.

Nota

ADOMD.net V11 no se instala como parte de la herramienta de instalación requerida de SharePoint Server 2016. Instale ADOMD.NET desde SQL Server 2012 Feature Pack. En cambio, si está instalando SQL Server 2016 Reporting Services en el modo de SharePoint en su servidor de aplicaciones, este archivo está incluido.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.

Para más información sobre cómo planear y configurar el PerformancePoint Services, consulte Introducción a PerformancePoint Services en SharePoint Server 2016 y Configurar 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.

Requisitos de software para PerformancePoint Services en SharePoint Server 2013Software requirements for PerformancePoint Services in SharePoint Server 2013

Estos son los requisitos para PerformancePoint Services:The requirements for PerformancePoint Services are as follows:

  • ADOMD.net V11ADOMD.net V11

  • SQLSERVER2008_ASAMO10SQLSERVER2008_ASAMO10

  • Almacén seguro debe estar configurado en la granja si desea almacenar credenciales cifradas para escenarios de actualización de datos o si desea usar la cuenta de servicio sin supervisar de PerformancePoint Services. Para más información, vea Planear el Servicio de almacenamiento seguro en SharePoint Server.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.

  • La delegación limitada de Kerberos debe estar configurada si desea delegar credenciales de usuario a una fuente de datos externa para escenarios de actualización de datos.Kerberos constrained delegation must be configured if you want to delegate user credentials to an external data source for data refresh scenarios.

Nota

Para los datos de Analysis Services, la opción EffectiveUserName es un método alternativo de obtener acceso a los datos. Cuando está habilitado, todas las conexiones a los datos de Analysis Services para los usuarios individuales se realizarán mediante la propiedad de cadena de conexión EffectiveUserName en lugar de la delegación de 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.

Nota

ADOMD.net V11 no se instala como parte de la herramienta de instalación requerida de SharePoint 2013. No obstante, si va a instalar SQL Server 2012 Reporting Services SQL Server 2012 Reporting Services en modo de SharePoint 2013 en el servidor de aplicaciones, este archivo está incluido.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.

Para más información acerca de cómo planear PerformancePoint Services, vea Introducción a PerformancePoint Services en SharePoint Server 2016. Para más información acerca de cómo configurar PerformancePoint Services, vea Configurar 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.

Requisitos de software para Servicios de Visio en SharePointSoftware requirements for Visio Services in SharePoint

Estos son los requisitos para Servicios de Visio en SharePoint:The requirements for Visio Services in SharePoint are as follows:

  • Almacén seguro debe estar configurado en la granja si quiere almacenar credenciales cifradas para escenarios de actualización de datos. Para obtener más información, consulte Planear el Servicio de almacenamiento seguro en SharePoint Server.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.

  • La delegación limitada de Kerberos debe estar configurada si desea delegar credenciales de usuario a una fuente de datos externa para escenarios de actualización de datos.Kerberos constrained delegation must be configured if you want to delegate user credentials to an external data source for data refresh scenarios.

Para obtener más información sobre cómo planear Servicios de Visio, consulte Información general sobre los Servicios de Visio en SharePoint Server. Para más información sobre cómo configurar Servicios de Visio, consulte Configurar Servicios de Visio.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.

Consulte tambiénSee also

Other ResourcesOther Resources

SQL Server 2016 con SP1SQL Server 2016 with SP1

Instalación de SQL 2012 SP1SQL 2012 SP1 Installation

Implementar PowerPivot y Power View de SQL Server 2016 en SharePoint 2016Deploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016

Implementar PowerPivot y Power View de SQL Server 2016 en una granja de servidores de SharePoint 2016 de varios nivelesDeploying SQL Server 2016 PowerPivot and Power View in a Multi-Tier SharePoint 2016 Farm