Using RStudio Professional Drivers
From an R prompt, install the
Test your connection in R with
odbc::odbc(). If you are using
the RStudio IDE, you can use the
New Connection dialog to help you write the
connection string, for example:
> con <- DBI::dbConnect(odbc::odbc(), Driver = "Driver Name", Database = "Database", UID = "User", PWD = "Password", Server = "Server", Port = 5432)
Refer to the support article on Using RStudio Connections for more information on integrating your data sources with the Connections pane in RStudio Server Pro.
Refer to the support article on Getting Started with RStudio Professional Drivers for additional information on installing and configuring RStudio Professional Drivers.