You can translate the question and the replies:

JDBC connection to R with the Denodo 6 version

In response to the below Answer, Regarding the RJDBC and rJava packages, can you please elaborate more on this. Are these packages to be installed in denodo VDP Server? Thanks Hi, RJDBC and rJAVA packages are only useful when you try to connect to Denodo from R. Since you want to connect to R from Denodo, I am assuming that you want to import data from R file into Denodo. This way, you need to create a data source with the required input parameters referring to the location of the R data file and create a base view from it. For example if R data is in an Excel file, then you would have to create an excel data source and provide the data route to the file location. Hope this helps!
user
27-03-2020 11:21:28 -0400

1 Answer

Hi, Please note that RJDBC and rJava packages are only needed when you want to connect to Denodo from R, not from Denodo to R. rJava is a simple R-to-Java interface and provides a low-level bridge between R and Java which allows to create objects, call methods and access fields of Java objects from R. RJDBC is a package implementing database interface in R on the basis of JDBC. This allows the use of any DBMS in R through the JDBC interface. Have a look at [RJDBC](http://rforge.net/RJDBC/) for more information on this. You can refer to [Access Through JDBC](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/access_through_jdbc/access_through_jdbc) document and the similar community question [Connect to Denodo from R](https://community.denodo.com/answers/question/details?questionId=9060g000000XdIKAA0&Connect+to+Denodo+from+R) for more information. Hope this helps!
Denodo Team
30-03-2020 09:35:31 -0400
You must sign in to add an answer. If you do not have an account, you can register here