Connection to an OLAP database


has anyone succeeded in connecting KNIME to an OLAP (ie a multidimensional) database, like Microsoft Analysis Services, Hyperion Essbase, Mondrian or SAP BW? Using the jdbc4olap driver?


Francesco Civardi


Yes, this sounds about right to use this driver within the KNIME preferences.


I'm facing similar issue. Has anyone succeded to solve this? If yes, please share the solution with us.


There was another post on this a while ago, with a suggestion on forming the connection URL.  Does that help?