Goal
This document describes how some commonly used Business Intelligence tools can be connected to the Denodo Platform.
Content
In the table below, a list of BI tools is presented with the possible ways to connect them to the Denodo Virtual DataPort Server.
In general, any BI tool which provides a JDBC or ODBC interface can connect to the Denodo Virtual DataPort Server. We recommend referring to the articles mentioned in the references as well as to the documentation provided by the vendor of the BI tools for further details.
BI Tool |
Access Interface |
Additional information |
Alteryx |
ODBC |
|
IBM Cognos |
Since version 11.0.3: Native Connector to Denodo JDBC |
|
Informatica Cloud |
JDBC ODBC |
|
Looker |
JDBC |
|
Microsoft SQL Server Reporting Services (SSRS) |
ODBC |
How to access Denodo Virtual DataPort from Microsoft SQL Server Reporting Services |
Microstrategy |
Since version 10: JDBC Older versions: ODBC |
|
OBIEE |
JDBC ODBC |
|
Pentaho |
JDBC |
|
Power BI Desktop |
ODBC Since 2.63.3272.40461 64-bit (October 2018) a Denodo Connector is available out of the box, the connector also uses ODBC |
|
SAP Business Objects |
JDBC ODBC Since 4.3: Connector included |
|
SAP Lumira |
JDBC |
|
Splunk |
JDBC |
|
Spotfire |
Since Spotfire 10.3: Custom Connector to Denodo (ODBC) Previous Versions (before 10.3): JDBC or ODBC |
Custom Connector for Spotfire to Connect to Denodo |
Tableau |
JDBC ODBC |
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.
Recommended resources
Questions
