Add a Business Analytics Server Connection to SharePoint

The scope of the connection that you create is determined by your account and the farm or site where you add the connection.

Visibility for connections can also be affected by where you add the connection. Business Analytics Server connections defined for site collections are immediately visible while visibility at sites and site collections for Business Analytics Server connections defined for farms may be delayed up to 30 minutes because of caching.

a. Install the Business Analytics Server, if you have not already done so. See Install or Upgrade Business Analytics Servers for P4S for instructions.

c. Configure connections in the Business Analytics Server to the appropriate SharePoint farms, site collections and sites.

2. To create a connection to a Business Analytics Server in a farm:

a. Open SharePoint Central Administration as a farm administrator.

b. Click Application Management and click Manage Mashup Servers in the MashZone NextGen Administration category.

3. To create a connection to a Business Analytics Server in a site collection or a specific site:

a. Login is as site administrator for the site collection or specific site. If needed navigate to the home page for the site you want.

c. Click Manage MashupServers in the MashZone NextGen Administration category.

4. Click New Mashup Server from the Manage Mashup Server page. The Add Mashup Server page opens.

Name: choose a name that describes the location or purpose of the Business Analytics Server you are connecting to.

URL: enter the domain name and port, or IP address, for the URL to connect to this Business Analytics Server. For example: http://mashups.myorg.com:8080 or http://204.10.1.101:8080.

Note:

You may omit the port number in this URL if the Business Analytics Server uses port 80.

URLs cannot use the localhost domain name. Use the IP address instead.

6. Set authentication properties for this connection based on your authentication plan. See Authentication Designs for P4S 2010 for more information on the types of authentication you can use.

If you are using SSO + Token authentication, set these properties:

SSO Enabled: set this option to enable single sign-on authentication. You must have the Microsoft SharePoint Server (MSS) 2010 and use the Secure Store Service to provide single sign-on for Business Analytics Server connections.

Shares same Active Directory as SharePoint: set this option when the Business Analytics Server and SharePoint are sharing an Active Directory as the user repository.

See Authentication Designs for P4S 2010 for more information on the impacts of sharing a user repository and authentication.

SSO Application: if you have enabled SSO (see above), choose the appropriate target application to use for authentication of credentials when connecting to this Business Analytics Server.

If no SSO applications are listed, then SSO is not properly configured. See Configure the Secure Store Service for more information to correct this problem.

If you are using No SSO + Cookie authentication, set this property:

Cookie Forwarding: set this option to allow cookies to handle authentication credentials between SharePoint servers in this farm and this Business Analytics Server. The Business Analytics Server must be in the same domain as this SharePoint farm.

If you are using No SSO, Manual authentication, clear all the SSO and Cookie properties.

7. Set the Mashup Server Enabled option to activate this connection and click Verify Connection.

If the connection fails, check to make sure the URL you entered is correct and the Business Analytics Server you are connecting to is running.

8. Once you have verified the connection, click OK. The Manage Mashup Servers page appears, listing your new Business Analytics Server connection.