Troubleshoot RStudio connection to corporate databases

RStudio IDE
#1

I am using a desktop version of RStudio. My colleagues are very excited by visuals and narratives that I can create in RStudio, but our database admins are not very interested in supporting RStudio. They only support PyCharm.

I have managed to create a package that connects RStudio to Vertica through RJDBC, but we also have a lot of data in AWS, Redshift, and Athena. I have tried using the available online resources but have not been able to connect RStudio to Redshift and Athena. We can connect PyCharm to all our databases, but I am wondering if there is there any kind of paid service that can help trouble shoot connections to corporate databases?

#2

RStudio maintains a set of ODBC drivers as part of our professional products, described here:

And RStudio does indeed provide a dedicated support team for its professional products. Does this seem like the right fit, or are you specifically looking for support with the existing set of open-source drivers you're using?

#3

Thank you Kevin, what is the difference between a professional and open-source driver?

#4

By open source drivers, I mean whatever drivers might be available as open source -- for example, https://github.com/softace/sqliteodbc links to an open-source ODBC driver for SQLite databases.

#5

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.