Connectivity between Oracle DVD and Denodo

Hi, I am trying to connect to Denodo from Oracle DVD. I have some data on Denodo platform and would like to create some visualizations on Oracle DVD or Oracle analytic cloud. I am trying to connect using ODBC connection but its not working. Could you please help me in this. Thanks. Regards, Manikanth
user
28-02-2019 15:09:05 -0500

5 Answers

Hi, In the Denodo Platform, it is recommended to connect to the Virtual DataPort server using the **JDBC** driver over the [**ODBC**](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/access_through_odbc/access_through_odbc). Hence, you could connect to the Denodo Platform from Oracle DVD through **JDBC connection** by using the Denodo JDBC driver “**denodo-vdp-jdbcdriver**” which is available in the directory <DENODO_HOME>\tools\Client-drivers\jdbc and providing the JDBC URI as below, > jdbc:vdb://<host>:<port>/<databaseName> You can refer the section [Access Through JDBC ](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/access_through_jdbc/access_through_jdbc) of Virtual DataPort Developer Guide for more information. Hope this helps!
Denodo Team
01-03-2019 03:32:13 -0500
Hello Team, Thanks for the answer. I have tried with jdbc driver and it went fine. I was able to successfully create the connection. When i am trying to create the data set, its showing empty. jdbc:vdb://hostname:9999/admin Driver Class Name:com.denodo.vdp.jdbc.Driver Username: admin ![Screen Shot 2019-03-01 at 2.49.53 PM](http://)
user
 Edited on: 28-03-2019 16:16:08 -0400
Here I have attached the image of my Oracle DVD. Could you please help me fix this. Thanks. <blockquote class="imgur-embed-pub" lang="en" data-id="a/IfQXu4N"><a href="//imgur.com/IfQXu4N"></a></blockquote><script async src="//s.imgur.com/min/embed.js" charset="utf-8"></script>
user
 Edited on: 28-03-2019 16:16:08 -0400
Sorry for my continuous posts. Here, sharing the screenshot of Oracle DVD. Please let me know if you need more details. Thanks. https://imgur.com/a/IfQXu4N
user
 Edited on: 28-03-2019 16:16:08 -0400
Hi, For this scenario, I would use the “**Enter SQL**” option in the Oracle DVD to query the view of the Denodo Platform and was able to create datasets for it. Also, Oracle DVD has some problems introspecting the databases not having the schemas because of this it could not introspect the Denodo Platform. In Denodo Platform it is always recommended to use the JDBC connection but for this case, since the Oracle DVD using the JDBC connection could not introspect the Denodo views, I have tested using the ODBC and I was able to successfully connect and introspect Denodo from Oracle DVD. If any error occurs while trying to connect the Denodo Platform from Oracle DVD then you can check the “vdp-requests.log” and “vdp.log” files located at **<DENODO_HOME>/logs/vdp**. You can refer to the Knowledge Base article [DSN configuration for ODBC connections to VDP](https://community.denodo.com/kb/view/document/DSN%20configuration%20for%20ODBC%20connections%20to%20VDP?category=Northbound+Connections) for more information. Hope this helps!
Denodo Team
13-03-2019 08:51:49 -0400
You must sign in to add an answer. If you do not have an account, you can register here