Hi all,
I would like to know if there are any workshops, courses, events where I may learn the automation process using RStudio. I am working on a process that gets the data from a database and process it and return reports. But want to know more how to use API and SQL to get the data, save final reports. Know how to better understand R Server so I may use it for my team.
Thank you!
Hi @EGjika ,
RStudio is just an IDE—it helps you write and organize R code, but the automation comes from the tools you choose. For your goals (API calls, SQL queries, and report generation), you can stay fully in the R ecosystem with:
- DBI or odbc for database connections
- httr2 or curl for APIs
- Quarto for dynamic reporting and publishing
Beyond that, there are other R-based options too, like plumber2 for building APIs, targets or drake for workflow automation, and shiny for interactive dashboards.
These give you flexibility while keeping everything in R.
Welcome, @EGjika! We have a few resources on this topic:
- Best Practices in Working with Databases
- Working with databases and SQL in RStudio (a bit old, but hopefully still helpful)
- Easing the pain of connecting to databases
- Creating a Shiny app that interacts with a database
Here is a blog post that shows a more end-to-end workflow using Databricks that could be adapted to use your database: Crossing Bridges: Reporting on NYC taxi data with RStudio and Databricks - Posit
I hope that they are helpful!