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 to work. Did anyone actually manage to connect to a SSAS?

Thanks in advance for any help and best regards

Jan