Trying to use OAuth authentication from a RStudio Server web browser doesn’t seem to work. It throws an rJava error.
From the desktop app, it will launch a small java window with a URL we can copy/paste a link into a browser, get a one-time token, then paste into the java window.
We had a similar problem with the bigrquery R package but they allow us to override the OAuth app and use the commandline in RStudio instead (https://bigrquery.r-dbi.org/) (https://support.rstudio.com/hc/en-us/articles/217952868-Generating-OAuth-tokens-from-a-server)
That doesn’t seem to work for the DatabaseConnector. Has anyone else found a workaround for RStudio Server (or maybe cloud) with one-off authentications?