Today, we’re continuing our blog series on new features in RStudio 1.1. If you’d like to try these features out for yourself, you can download a preview release of RStudio 1.1.
Connecting to data sources in R isn’t always straightforward; even when you’re able to establish a connection, navigating within it and understanding the shape of the data inside can be difficult. We built the Connections tab to make it easy to establish connections to data sources and access the data they contain.
RStudio 1.1 includes a new Connection wizard which makes it easy to connect to any data source on your system.
Clicking on a connection type shows a form which you can fill to create the appropriate R code for creating a new connection. It’s now just as easy to connect to a data source as it is to import a CSV file.
RStudio can show you data sources from a variety of places, including:
Once you have established a connection, RStudio saves it for future reference (even if you didn’t create it using the wizard!). This makes it easy to connect to the same data again later, without having to find the connection command in your R console history or dig up the R script you used to establish the connection.
Your connection history is available in all your projects. Never look up a server name again!
When you’re connected to a data source, RStudio will show you all of the objects available. You can explore this list, and preview the data, using the tools in the Connections pane.
Finally, RStudio will be providing professional ODBC drivers for the most important enterprise databases to our Pro customers. We developed the Connections tab to work seamlessly with these drivers; they will give your users easy, consistent access to the data in your company’s systems. More news about these ODBC drivers is coming soon!
The Connections tab is just one part of a larger effort at RStudio to advance the state of the art in data connectivity with R. Here’s some more reading on both the big picture and the technical details:
In this series, we walk through lesser-known tips and tricks to help you work more effectively and efficiently in R Markdown. This first post focuses on working with R Markdown in the RStudio IDE.
Announcing the 2021.10.0 release of the RStudio Professional Drivers, with single sign-on (SSO) for Hive and Impala.