Connection from OAC to DENODO model

Sébastien Roux

Summary:

Can OAC connect to a Denodo data model

Content (required):

Hi there a connector or a workaround to connect OAC to Denodo. The objective is to establish a connection from BI administration tool and/or from Analytics interface.

Are there other ways? APIs

Thank you

Version (include the version you are using, if applicable):

Latest version (6.2, 6.x)

Code Snippet (add any code snippets that support your topic, if applicable):

EloiLopes-Oracle

Hi Sébastien,

If denodo has a JDBC you can use the generic JDBC of OAC.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/supported-data-sources.html

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-remote-data-using-generic-jdbc.html#GUID-93DD9541-37A8-4947-AF3E-BDF1E108A678

Regards

Jean-Pierre Hoedenaeken

Hi,

If we can indeed use the JDBC connection to Denodo views, the reload of the Dataset failed in error.

So actually it's unfortunately unusable and we are still waiting for the connection to Denodo to be fully functionnal because our data architecture is based on Denodo and without a quick solution to that issue, this could lead to abandon Oracle Analytics !

Jean-Pierre