Connect to Azure Analysis Service server

[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