Solutions
Get Started
Guide
Guide Overview
Considerations
Write Effective Code
Connect to Data Sources and Systems
Manage Packages and Reproduce Environments
Secure Access
Implement Operational Patterns
Implement the Right Architecture
Gallery
Reference
Administrator Training
Admin Training Overview
Training Modules
Administering Posit Workbench
Administering Posit Connect
Administering Posit Package Manager
Guide
Connect to Data Sources and Systems
Best Practices in Working with Databases
Other resources
Guide
Write Effective Code
Minimum Viable Python — Working with Python
Installing Python
Installing Python Packages
Python-Based Tools
Sending Custom Emails from Posit Connect
Dash Applications
Flask APIs
Python with Jupyter Notebooks
Using Python with Posit Products
Reports using R Markdown
Setting up and deploying a project with
reticulate
Connect to Data Sources and Systems
Best Practices in Working with Databases
Overview
Connect to a Database
Database Queries With R
R Packages
Using an ODBC driver
Using DBI
Using dplyr with databases
Pooling database connections in R
Tooling
RStudio Connections Pane
Posit Professional Drivers
Best practices
Enterprise-ready dashboards
Securing Deployed Content
Setting up ODBC Drivers
Securing Credentials
Making scripts portable
Run Queries Safely
Schema selection
Selecting a database interface
Creating Visualizations
Databases
Athena
Google BigQuery
Cassandra
Databricks
Apache Hive
Apache Impala
Microsoft SQL Server
MonetDB
MongoDB
MySQL
Netezza
Oracle
Other Databases
PostgreSQL
Amazon Redshift
Salesforce
Snowflake
SQLite
Teradata
Advanced
Implementing a new backend
Connections Contract
RStudio Connections
SQL translation
Other resources
Media
Accessing Data for Analytics On Workbench
Deploying Data for Content On Connect
Microsoft 365
Clients
Calling APIs on Connect from curl
Calling APIs on Connect from Java
Calling APIs on Connect from Node.js
Calling APIs on Connect from PHP
Calling APIs on Connect from Python
Calling APIs on Connect from R
Manage Packages and Reproduce Environments
Managing Packages within Posit Team
Reproducible Environments
Use Cases
Safely Upgrade Packages
Validate Your Environment
Deploy to Production
Collaborate Within a Team
Strategies
Strategy Map
Snapshot and Restore
Shared Baseline
Validated
Tools
Installing — pak/remotes
Repositories — Package Manager
Libraries — renv
R Versions
Docker
Python
Understanding Repositories and Libraries
Setting Default Repositories in Workbench
BioConductor
Java and R
Connect Supervisor script examples
Setting Global Environment Variables
Secure Access
Content Security
Authentication in Posit Professional Products
Kerberos with Posit Professional Products
Configuring LDAP / Active Directory with Posit Team
Provisioning Users and Groups for Posit Professional Products
Implement Operational Patterns
Dev/Test/Prod with Posit Team
Diffable Data Science: A Demo
GitHub and GitLab Command Line Interfaces (CLIs)
Publishing Workflows for Connect
Options for Scheduling Data Science Tasks
Auditing and Monitoring Connect with the Connect Server API
Basic Content Usage Tracking
Interactive Content Usage Tracking
Basic Content Audit Report
Access Permissions Audit Report
Audit the R and Python Versions in Use on Connect
Audit the use of unsupported Python versions
Tag Usage on Connect
Unpublished Content Audit Report
Audit Vanity URLs on Connect
Publishing Methods for Connect
Deploying to Connect from CI/CD Pipelines
Publishing to Connect using Azure Pipelines
Publishing to Connect using Bitbucket Pipelines
Publishing to Connect using GitHub Actions
Publishing to Connect using GitLab CI/CD
Publishing to Connect using Jenkins CI/CD
Implement the Right Architecture
Configuring Python within Posit products
Running Posit Products in Containers
Using AWS managed File Systems with Workbench
Considerations for Migrations
Architectures
Connect Architectures
Posit Team Architectures
Package Manager Architectures
Workbench Architectures
Launcher
Auto-Scaling with Workbench and Kubernetes
Workbench with Slurm and Apptainer (formerly Singularity)
Sagemaker
Architecture for RStudio on SageMaker
Moving your Workbench Environment to RStudio on SageMaker
On this page
Media
Guide
Connect to Data Sources and Systems
Best Practices in Working with Databases
Other resources
Other resources
Media
A collection of talks on various R/Database related topics.
Read more
Back to top