Denodo and BI Tools

Applies to: Denodo 8.0 BETA , Denodo 7.0 , Denodo 6.0
Last modified on: 19 Jun 2020
Tags: JDBC driver Best practices Connectivity External clients ODBC driver

Download document

You can translate the document:

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 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

How to connect to Denodo from Alteryx

IBM Cognos

Since version 11.0.3: Native Connector to Denodo

Connecting to Denodo from Cognos

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

Connecting Looker to Denodo

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

Microstrategy Data Source Connectors

OBIEE

JDBC

ODBC

How to access to Denodo from OBIEE

Pentaho

JDBC

ODBC

How to connect to Denodo from Pentaho

Power BI Desktop

Since 2.63.3272.40461 64-bit (October 2018) a Denodo Connector is available out of the box

Qlik

ODBC

Qlik Denodo Integration: How to guide

Qlik connectors documentation

SAP Business Objects

JDBC

ODBC

How to access VDP from SAP BusinessObjects

SAP Lumira

JDBC

How to use VDP as a SAP Lumira Data Source

Splunk

JDBC

Splunk integration with Denodo

Tableau

Since Tableau 10.4: Native Connector to Denodo

Previous Versions (before 10.4):  ODBC adapter

How to connect to Denodo from Tableau Desktop

Tibco Spotfire

JDBC

Connecting to Denodo from Tibco Spotfire

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training