PivotGridXmlaDataSource.ConnectionString Property
Specifies parameters used to connect to a data pump.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.PivotGrid.v14.2.Core.dll
#Declaration
#Property Value
| Type | Description |
|---|---|
| String | A String that encapsulates parameters used to connect to a data pump. |
#Remarks
A sample connection string is shown below:
Data Source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;Initial Catalog=Adventure Works DW Standard Edition;Cube Name=Adventure Works;Query Timeout=100;
The connection string contains the following parameters:
- Data Source - the path to a data pump - a component that will serve as a proxy between clients and the MS Analysis Services server.
- Initial Catalog - a data catalog that contains cubes.
- Cube Name - the name of a cube that provides OLAP data.
- Query Timeout (optional) - the maximum amount of time, in seconds, to wait for a query for SSAS to complete. If the parameter is set to 0, each query can last for an indefinite time.
To learn how to set up a data pump on an IIS server, see How to Configure HTTP Access to SQL Server 2008 Analysis Services on IIS7.
#Examples
The following example demonstrates how to bind a PivotGridControl to an OLAP cube via the XMLA data access standard.
In this example, OLAP connection parameters are specified in a connection string passed to the PivotGridControl.OlapConnectionString property.
The following parameters are provided:
- Data Source - a path to a data pump that was previously configured on an IIS server and will be used as a middle-ware component to access the datasource;
- Initial Catalog - a data catalog that contains cubes;
- Cube Name - the name of the cube that provides OLAP data.
To learn how to bind a pivot grid to an OLAP cube step-by-step, see Lesson 1 - Binding a Pivot Grid to an OLAP Cube.