Goal
This document describes how some of the most commonly used Business Intelligence tools can be connected to Denodo.
Content
In the table below, a list of BI tools is presented and 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 Virtual DataPort Server. We recommend referring to the articles mentioned in the references as well as to the documentations 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 |
|
Informatica Power Center |
ODBC JDBC |
How To Access to VDP from Informatica PowerCenter through ODBC How to access to VDP from Informatica PowerCenter Express on Linux |
Looker |
Since Looker 3.50: 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 ODBC |
|
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 |
|
Qlik |
ODBC |
|
SAP Business Objects |
JDBC ODBC |
|
SAP Lumira |
JDBC |
|
Splunk |
JDBC |
|
Tableau |
JDBC ODBC |
|
Tibco Spotfire |
Since Tibco Spotfire 10.3: Custom Connector to Denodo (ODBC) Previous Versions (before 10.3): JDBC - ODBC |
Custom Connector for TIBCO Spotfire to Connect to Denodo |