I am currently trying to connect to an Amazon Web Service database through the RJDBC package within R.
I have all the information about the driver, jarfile & URL needed in order to connect to the database, however the problem occurs with trying to get the username and password as access is given through a single sign-on site for which I get access to all other apps.
This is the current code setup I have to obtain connection to the database
jdbcConnection <- dbConnect(drv,
The credentials to access the sign on site itself does not work. Is it possible to use another method other than requiring:
user = <>,
password = <>)