Help connecting KNIME to a SQL Server Analysis Services Olap Cube
Hi there, I am looking for some information on how to connect KNIME to a SQL Server Analysis Services OLAP Cube. I have tried both JDBC4olap and olap4j, but am having troube in different places.
For olap4j, I have added the olap4j-1.1.0.jar as a driver to my preferences, but it doesn't seem to show up when I go into the 'configure option' on a database connector. I can't figure out how to have the driver recognized in the preferences so that it is actually usable to configure a DB connector.
For jdbc4olap, I can add it to my preferences as a driver, and see it as a driver option when configuring a database connector, but I can't seem to get the URL syntax figured out, or perhaps I am having some other problem. Either way, I get the error, "failed to apply settings: Database table place holder (#table#) not replaced." when I try to map the URL in the configure option.
Sorry for the newb questions - Any help and recommendations would be greatly appreciated. - Thank you one and all.