Search This Blog

Sunday, April 24, 2011

Connect a PowerPivot Service Application to a SharePoint Web Application

A PowerPivot service application can be used by any number of SharePoint Web applications in the farm. To make a PowerPivot service application available, you add it to a service association list.

Add powerPivot Services Application to Default Group

A service association list is a list of shared services that provide resources to other SharePoint Web applications in the farm. There is one default group of service associations for the farm.
To be on the list, a PowerPivot service application can either be added when you create the application or afterwards by using the following steps.
  1. In Central Administration, in Application Management, click Configure service application associations.
  2. In Application Proxy Group, click default.
  3. Select the checkbox next to the PowerPivot service application (indicated by type name PowerPivot Service Application Proxy). If you have more than one PowerPivot service application, choose just one.
  4. Click OK.

Add PowerPivot Services Application a Custom Service Association List

The default group can be replaced by a custom list. A custom list is created specifically for a single SharePoint Web application. It overrides the default group and replaces it with only those service associations that a farm or service administrator specifies. If you created multiple PowerPivot service applications, you must use a custom list to specify which one to use. A custom list cannot be reused by other Web applications. It applies only to the Web application for which it was created.
  1. In Central Administration, in Application Management, click Manage web applications.
  2. Select the application (for example, SharePoint -80).
  3. In Web Applications, in Manage, click Service Connections.
  4. In Edit the following group of connections, select [custom].
  5. Select the checkbox next to each service application connection you want to use. If you have multiple PowerPivot service applications (indicated by Type set to PowerPivot Service Application Proxy), be sure to choose only one.
  6. Click OK.

No comments:

Post a Comment