Skip to main content

PivotGridXmlaDataSource.ConnectionString Property

Specifies parameters used to connect to a data pump.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v22.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design

Declaration

public string ConnectionString { get; set; }

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.

Tip

You need an IIS server with a data pump configured on it to serve as a proxy to bind a PivotGridControl to an OLAP server via XMLA.

Documentation: Configure HTTP Access to Analysis Services on IIS 8.0

Example

This example demonstrates how to add connection settings to the Adventure Works cube on the OLAP server.

View Example

To bind the Pivot Grid control to an OLAP cube, follow the steps below.

  1. Set the PivotGridControl.OLAPDataProvider property to Xmla.
  2. Specify connection settings in the PivotGridControl.OLAPConnectionString property. The following connection string is used in this example:
    OLAPConnectionString = Data Source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;" +
                "Initial Catalog=Adventure Works DW Standard Edition;Cube Name=Adventure Works";
    
    Note that a valid connection string should include the following parameters: Provider, Data Source, Initial Catalog, and Cube Name.
using System;
using System.Windows.Forms;
using DevExpress.XtraPivotGrid;

namespace XtraPivotGrid_XMLA {
    public partial class Form1 : Form {
        public Form1() {
            InitializeComponent();
        }
        void Form1_Load(object sender, EventArgs e) {

            // Specifies that PivotGridControl should use the XMLA data access standard
            // to bind to an OLAP cube.
            pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Xmla;

            // Configures a data connection.
            // Specifies a string that encapsulates connection parameters 
            // required to access the desired OLAP cube.
            pivotGridControl1.OLAPConnectionString = 
                "Data Source=http://demos.devexpress.com/Services/OLAP/msmdpump.dll;" +
                "Initial Catalog=Adventure Works DW Standard Edition;Cube Name=Adventure Works";
        }
    }
}
See Also