Establish the connection for an SSAS Server

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 SSAS by using connection string:

C#

OlapDataManager dataManager = new OlapDataManager("DataSource=localhost; Initial Catalog=Adventure Works DW");

VBNET

Dim dataManager As New OlapDataManager("DataSource=localhost; Initial Catalog=Adventure Works DW")

C#

Syncfusion.Olap.DataProvider.IDataProvider dataProvider = new Syncfusion.Olap.DataProvider.AdomdDataProvider("DataSource=localhost; Initial Catalog=Adventure Works DW");

OlapDataManager dataManager = new OlapDataManager(dataProvider);

VBNET

Dim dataProvider As Syncfusion.Olap.DataProvider.IDataProvider = New Syncfusion.Olap.DataProvider.AdomdDataProvider("DataSource=localhost; Initial Catalog=Adventure Works DW")

Dim dataManager As New OlapDataManager(dataProvider)