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

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

Questions

Ask a question

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