You can translate the question and the replies:

Connecting Denodo to Oracle Autonomous Data Warehouse (ADW) and Oracle Analytics cloud (OAC).

Hi Team, I have following question. Can we connect Denodo to Oracle ADW and OAC from denodo. If Yes then can we utilize the OAC security policies as is in Power BI desktop or Power BI service. Thanks & Regards, Nisarg Shah
user
19-03-2021 00:41:59 -0400

1 Answer

Hi, Based on the question, I believe you are asking if it is possible to create a southbound connection to Oracle Autonomous Data Warehouse in Denodo, if so, yes you can connect using the access mechanisms like [JDBC](https://docs.oracle.com/en/cloud/paas/event-hub-cloud/admin-guide/jdbc-connector-adwc.html) connection. For more information on creating data sources, you can refer to the section [JDBC sources](https://community.denodo.com/docs/html/browse/8.0/en//vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#jdbc-sources) of Virtual DataPort Administration Guide. Regarding the Oracle Analytics Cloud, it seems that you are trying to connect to Denodo as a northbound connection, in that case you can establish an ODBC connection to Denodo from Oracle Analytics Cloud. In this case, you can set up similar security rules for access in Oracle Analytics Cloud as the PowerBI as, both are Data Visualization tools and falls under the same use case category. Hope this helps!
Denodo Team
19-03-2021 09:11:46 -0400
You must sign in to add an answer. If you do not have an account, you can register here