Server Defined Data Sources

Data sources can either be created and stored locally on the client machine or centralized on the SharePoint server. When selecting data source for the web part there are two choices:

  1. Create and/or select a data source locally on the client machine. See Locally defined data sources for how to select and create local data sources.
  2. Select defined data sources stored on the server.

Server data sources are maintained and stored in the web.config file on your SharePoint server. If you have multiple extended virtual servers you have to edit the web.config for each virtual server.

A data source definition has an Id and a ConnectionString. The Id is the identifier stored in the definition of the web part and also the caption displayed in the list of available data sources in the wizard. The ConnectionString attribute is used for connection parameters used when opening a connection to the data source. The connection string must at least have Provider, Data Source, Initial Catalog and Initial Cube specified.

  1. If not already exists add following elements to the <configSection> section.
    <sectionGroup name="DecisionSupportPanel">
    <section name="WebPart"
    DecisionSupportPanel. SharePoint.WebPart,Version=, Culture=neutral, 
    PublicKeyToken=4e98b37828e9cbce" />
  2. Add following xml elements to the <configuration> section.
      <DataSource Id="Example1" ConnectionString="connection parameters" />
      <DataSource Id="Example2" ConnectionString="connection parameters" />
      <DataSource Id="Example3" CacheResult="false" CacheResultPerUser="false" 
                ConnectionString="connection parameters" />

Example of a data source definition:

<DataSource Id="MyDataSource" ConnectionString="Provider=MSOLAP;
Data Source=MyServer; Initial Catalog=MyCatalog;Initial Cube=MyCube;
MDX Unique Name Style=3;MDX Compatibility=2;" />

Optional attribute settings for configure caching per data source (overrules settings done in the cache/olap part of web.config)

Attribute Description Default (if not specified)
CacheResult On/Off caching of result set. True
CacheResultPerUser Result cached per user. Set to False if all users are accessing the cube with same security restrictions. That is if all users are in the same database role or users accessing the cube with same user account (See using COM+). True
OlapImpersonate If impersonation will be done when accessing the cube (true/false) True

If you have more then one OLEDB for OLAP provider installed you may need to specify the version of the provider, then use:

  • MSOLAP.1 for MSAS 7.0
  • MSOLAP.2 for MSAS 2000
  • MSOLAP.3 for MSAS 2005
  • MSOLAP.4 for MSAS 2008
  • MSOLAP.5 for MSAS 2012

Connect to data source through HTTP

  • pe/serverconfiguration/serverdefineddatasources.txt
  • Last modified: 2014/03/14 08:07
  • by pcevli