I'm trying to connect to a SQL Analysis Server Cube. But I'm unable to find documentation and/or example of what needs to be done to connect to an OLAP database cube.
KNIME supports connections to JDBC compliant databases. So if a JDBC driver exists to access your OLAP database cubes and the results of sql queries are standard JDBC results it should be possible to integrate it into KNIME. For details about how to register a JDBC drive have a look at the database documentation.
You might be also able to integrate the OLAP cube via another interface such as REST or SOAP if this is provided by the db server.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.