How to access to Denodo from OBIEE

Applies to: Denodo 7.0 , Denodo 6.0 , Denodo 5.5
Last modified on: 13 Dec 2019
Tags: OBIEE Connectivity Oracle

Download document

You can translate the document:

Goal

This document contains the references to the KB articles that show how to connect Denodo as Data Source from OBIEE.

Denodo Virtual DataPort as Analytics Data Source

OBIEE allows creating repositories files (RPD) in order to import the metadata from your data sources into the Oracle BI Server. Importing metadata directly from data sources entails importing the structure of the physical layer. Data from these Oracle data sources can be displayed on Oracle BI Interactive Dashboards.

Important: it is possible to import the metadata through an ODBC and, from OBIEE 12c, it is also possible to perform the connection through JDBC. However, OBIEE sends queries with a syntax that is not currently supported by the Denodo JDBC driver. Therefore we strongly recommend using the ODBC interface.

The following articles show the steps to set up Denodo Virtual DataPort as Analytic data source:

How to access to VDP from OBIEE via ODBC in Linux

Denodo Virtual DataPort as Data Source for the OBIEE BI Publisher.

Oracle BI Publisher is a reporting tool that provides the ability to create and manage formatted reports from a wide range of data sources.

Oracle BI Publisher allows us to define your data model using existing OBIEE analysis but also it can take the data from different data sources. The data can come from a database, an HTTP XML feed, a Web service, etc.

The following article shows the steps to set up Denodo Virtual DataPort as Oracle BI Publisher data source: How to access to VDP from OBIEE via JDBC

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