Applies to:
Denodo 8.0
,
Denodo 7.0
,
Denodo 6.0
Last modified on: 19 Jun 2020
Tags:
Best practices
Connectivity
External clients
JDBC driver
ODBC driver
This document describes how some of the most commonly used Business Intelligence tools can be connected to Denodo.
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 to refer 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 |
Since 2.63.3272.40461 64-bit (October 2018) a Denodo Connector is available out of the box |
|
Qlik |
ODBC |
|
SAP Business Objects |
JDBC ODBC |
|
SAP Lumira |
JDBC |
|
Splunk |
JDBC |
|
Tableau |
Since Tableau 10.4: Native Connector to Denodo Previous Versions (before 10.4): ODBC adapter |
|
Tibco Spotfire |
JDBC |