Connecting to Mondrian Server through XMLA

2 Jun 20211 minute to read

The following code illustrates how to connect to the Mondrian server:

C#

// Connecting to Mondrian Server

OlapDataManager DataManager = new OlapDataManager(@"Data Source = http://localhost:8080/mondrian/xmla; Initial Catalog = FoodMart;"); //Where localhost is the machine name which has installed Mondrian Services. For example http://bi.syncfusion.com:8080/mondrian/xmla



DataManager.DataProvider.ProviderName = Syncfusion.Olap.DataProvider.Providers.Mondrian;

VBNET

' Connecting to Mondrian Server

Dim DataManager As New OlapDataManager("Data Source = http://localhost:8080/mondrian/xmla; Initial Catalog =FoodMart;")
'Where localhost is the machine name which has installed Mondrian Services. For example http://bi.syncfusion.com:8080/mondrian/xmla



DataManager.DataProvider.ProviderName = Syncfusion.Olap.DataProvider.Providers.Mondrian

Refer here for more information about Mondrian XMLA configurations.