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