[Python] Connect to Essbase cubes web service using Python (Adomd)

Trying to connect Essbase cubes from Python using Adomd

import clr

clr.AddReference(r"C:\Program Files\Microsoft.NET\ADOMD.NET\160\Microsoft.AnalysisServices.AdomdClient")
from Microsoft.AnalysisServices.AdomdClient import AdomdConnection

server = "http://servernameort/essbase/xmla"
database = "dbname"

username = username
password = password

connection_string = f"Data Source={server};Initial Catalog={database};DataSourceInfo=\"Provider=Essbase;Data Source=EssbaseCluster\";User ID={username};Password={password};"

conn = AdomdConnection(connection_string)
conn.Open()
conn.Close()


Error:

System.Xml.XmlException: Element 'return' was not found. Line 1, position 252.

at System.Xml.XmlReader.ReadStartElement(String name)

at Microsoft.AnalysisServices.AdomdClient.XmlaReader.ReadStartElement(String name)

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SupportsProperties (IList 1 propertyList)

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Connect()

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA (Boolean createSession, Boolean isHTTP)

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()

Did any same the issue ? Or any other way to connect to Essbase cubes using Python. Any help is appreciated. Thank you!

Continue reading...