windowsforms-devexpress-dot-xtrapivotgrid-dot-pivotgridcontrol-ff1a9f1f.md
Gets or sets which data provider should be used to bind to an OLAP cube.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.XtraPivotGrid.v25.2.dll
NuGet Package : DevExpress.Win.PivotGrid
[DefaultValue(OLAPDataProvider.Default)]
public OLAPDataProvider OLAPDataProvider { get; set; }
<DefaultValue(OLAPDataProvider.Default)>
Public Property OLAPDataProvider As OLAPDataProvider
| Type | Default | Description |
|---|---|---|
| OLAPDataProvider | Default |
A OLAPDataProvider enumeration member that specifies which data provider should be used to bind to an OLAP cube.
|
Available values:
| Name | Description |
|---|---|
| Default |
The default OLAP provider (see the respective property description for details).
| | Adomd |
The ADOMD.NET data provider.
| | OleDb |
The OLE DB data provider.
| | Xmla |
The XMLA data access standard.
|
Pivot Grid Control can use one of the following data providers to communicate with the Microsoft Analysis Services server.
OLE DB for OLAP
ADOMD.NET
XMLA
The following code snippets (auto-collected from DevExpress Examples) contain references to the OLAPDataProvider property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
winforms-pivot-grid-connect-to-an-olap-datasource/CS/WinOlapRetrieveFieldsExample/Form1.cs#L9
// Specify the OLAP connection settings.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Adomd;
pivotGridControl1.OLAPConnectionString =
winforms-pivotgrid-bind-to-an-olap-cube-via-xmla/CS/XtraPivotGrid_XMLA/Form1.cs#L14
// to bind to an OLAP cube.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Xmla;
// to bind to an OLAP cube.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Adomd;
winforms-pivot-grid-connect-to-an-olap-datasource/VB/WinOlapRetrieveFieldsExample/Form1.vb#L12
' Specify the OLAP connection settings.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Adomd
pivotGridControl1.OLAPConnectionString = "Provider=MSOLAP;
winforms-pivotgrid-bind-to-an-olap-cube-via-xmla/VB/XtraPivotGrid_XMLA/Form1.vb#L17
' to bind to an OLAP cube.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Xmla
' Configures a data connection.
' to bind to an OLAP cube.
pivotGridControl1.OLAPDataProvider = OLAPDataProvider.Adomd
' Configures a data connection.
See Also