Establish the connection for a Cube file

2 Jun 20211 minute to read

A valid string is required to establish connection for an OlapDataManager.

Here is the code snippet that demonstrates how to connect cube file by using connection string:

C#

OlapDataManager dataManager = new OlapDataManager("DataSource= AdventureWorks_Ext.cub; Provider=MSOLAP");

VBNET

Dim dataManager As New OlapDataManager("DataSource= AdventureWorks_Ext.cub; Provider=MSOLAP")

C#

Syncfusion.Olap.DataProvider.IDataProvider dataProvider = new Syncfusion.Olap.DataProvider.AdomdDataProvider("DataSource= AdventureWorks_Ext.cub; Provider=MSOLAP");

OlapDataManager dataManager = new OlapDataManager(dataProvider);

VBNET

Dim dataProvider As Syncfusion.Olap.DataProvider.IDataProvider = New Syncfusion.Olap.DataProvider.AdomdDataProvider("DataSource= AdventureWorks_Ext.cub; Provider=MSOLAP")

Dim dataManager As New OlapDataManager(dataProvider)