Create data connections (PerformancePoint Services)

Applies to: SharePoint Server 2010 Enterprise

Data sources defined in PerformancePoint Dashboard Designer are stored in a trusted data connection library on UNRESOLVED_TOKEN_VAL()SharePoint Server 2010. A trusted data connection library is a document library that you have determined as safe. It restricts using the data source files, but still lets them be read. However, by default, a document library is created when provisioning PerformancePoint Services. Administrators can manage data connections on the server by creating more than one data connection library. If a user updates a data source connection in the document library, the information is shared and updated when a workspace file is opened in Dashboard Designer.

In PerformancePoint Services the security settings for data sources are stored in each data source. You have the choice of having users connect by using the Unattended Service Account, the Unattended User Account and add authenticated user in connection string (Analysis Services only), or you can authenticate using Per-User Identity. Per-User Identity requires Kerberos protocol.

In this section:

• Create an Analysis Services data connection (PerformancePoint Services)

• Create a PowerPivot data connection (PerformancePoint Services)

• Create a SharePoint List data connection (PerformancePoint Services)

• Create an Excel Services data connection (PerformancePoint Services)

• Create a SQL Server table data connection (PerformancePoint Services)

• Create an Excel Workbook data connection (PerformancePoint Services)