Latest commit 15393a8 Nov 30, 2017

README.md

Databases with RStudio

With RStudio Professional Drivers

Nathan Stephens

November 29, 2017

RStudio makes it easy to access and analyze your data with R. RStudio Professional Drivers are ODBC data connectors that help you connect to some of the most popular databases. These drivers will help you:

  • Explore your databases using the RStudio IDE
  • Develop and deploy Shiny applications that depend on databases
  • Use databases with R in a production environment
  • This webinar will introduce you to our standards-based, supported, professional ODBC drivers. These are the drivers to use when you run R or Shiny with your production systems. It will also cover some of the most popular databases available today that we connect to including:
    • Microsoft SQL Server
    • Oracle
    • PostgreSQL
    • Amazon Redshift
    • Apache Hive
    • Apache Impala
    • Salesforce
    • Teradata

Code examples

  1. Connections - Use RStudio to connect to your database.
  2. Queries with SQL Server - Three ways to query data with R example 1.
  3. Queries with Teradata - Three ways to query data with R example 2.
  4. Basics with Oracle - Functions for interacting with your database.
  5. Plots with dbplot - Push computation to your database. High density plotting with dbplot.
  6. Shiny dashboard - Push computation to your database. Shiny application using a database backend.

HTML notebooks

  1. Connections - Use RStudio to connect to your database.
  2. Queries with SQL Server - Three ways to query data with R example 1.
  3. Queries with Teradata - Three ways to query data with R example 2.
  4. Basics with Oracle - Functions for interacting with your database.
  5. Plots with dbplot - Push computation to your database. High density plotting with dbplot.

References