Connect to Azure Analysis Service server

[vstefano]

Hi All,
I am not a big expert on DB connection. I would like to understand if and how it is possible to connect to a datamodel created in Azure Analysis service and the procedure to follow.

Thanks in advance,
Stefano

[vstefano]

Good morning,
is there someone that has managed to set this type of connection successfully?

[aliasghar_marvi]

Hello @vstefano ,

Were you able to follow this doc? If yes, then at which step do you see that something went wrong

Best,
Ali

[vstefano]

Hi Aly,
thanks for the suggesion.
I had had a look at the document but could not find a node for Azure Analysis Service nor I am sure that Azure Analysys Service objects can be queried with actual nodes (datalake gen2 and blob store).

I have done some tests but I was not able to get any data.

Stefano

[k10shetty1]

Hi @vstefano,

We have a ticket for SQL Server Analysis Services (SSAS) connection (Internal reference: AP-16218).

In the meantime here are some topics that might help you out to get your data from SSAS to KNIME:

Connecting to SQL Server Analysis Services

Hey everyone I need to MDX query data from a SQL Server Analysis Services (SSAS) into my KNIME workflows. This topic has been asked in the past, but it’s been a while ever since, so I hope there is a solution for that by now. I tried (old) suggestions for days, but I’ve not been able to establish a connection that allows me to launch an MDX query and receive back a table into my workflow. Most older threads refer to either commercial JDBCs drivers (e.g. CData) or jdbc4olap - both I can’t get …

how to connect analysis services on Knime

Hello Simone, you could also try to use the KNIME REST nodes to work with the Analytics Service REST API. Bye Tobias

Connecting to Microsoft SSAS OLAP cube

This continues to be a major issue for me as well Polestar01. Hopefully there’s some better answers than I am going to suggest. The way I worked round this was to set up the SSAS server as a Linked Server on a on-prem SQL Server instance. Then you can connect (from KNIME) to a database on the same server as the Linked Server using a normal KNIME Microsoft SQL Connector node and use SELECT * FROM openquery(’[LinkedServer]’, ‘MDX/DAX as appropriate’) to query your cube or tabular model. If you …

Hope this helps.

Best,
Keerthan