Connecting R via JDBC

Follow

Comments

2 comments

  • Avatar
    Javier Gutierrez

    Hi Julian,

    For me it only works adding this to the string:

    "jdbc:datavirtuality:datavirtuality@mms://dvhost:31000;SHOWPLAN=ON"

    Does it also work for you without the 's'? 

  • Avatar
    Martin Lutzemann

    Hey Javier,

    you can use a JDBC connection with and without SSL-security and this is where the mm/mms part from the connection url comes from. You have

    jdbc:datavirtuality:datavirtuality@mm://localhost:31000; for unsecured connections and

    jdbc:datavirtuality:datavirtuality@mms://localhost:31001; for SSL-secured connections.

    Using mms but not the SSL port (default 31001) should result in an error saying that the SSL message was not recognized. Basically, the same combination of Port and SSL setting that works for the Studio connection will work for the JDBC connection in R as well.

    Cheers

Please sign in to leave a comment.

Powered by Zendesk