DatabaseConnector: Connecting to Various Database Platforms

An R 'DataBase Interface' ('DBI') compatible interface to various database platforms ('PostgreSQL', 'Oracle', 'Microsoft SQL Server', 'Amazon Redshift', 'Microsoft Parallel Database Warehouse', 'IBM Netezza', 'Apache Impala', 'Google BigQuery', and 'SQLite'). Also includes support for fetching data as 'Andromeda' objects. Uses 'Java Database Connectivity' ('JDBC') to connect to databases (except SQLite).

Version: 4.0.2
Depends: R (≥ 2.10)
Imports: rJava, SqlRender (≥ 1.7.0), methods, stringr, rlang, utils, DBI (≥ 1.0.0), urltools, bit64
Suggests: aws.s3, R.utils, withr, testthat, DBItest, knitr, rmarkdown, RSQLite, ssh, Andromeda, dplyr
Published: 2021-04-15
Author: Martijn Schuemie [aut, cre], Marc Suchard [aut], Observational Health Data Science and Informatics [cph], Microsoft Inc. [cph] (SQL Server JDBC driver), PostgreSQL Global Development Group [cph] (PostgreSQL JDBC driver), Oracle Inc. [cph] (Oracle JDBC driver), Amazon Inc. [cph] (RedShift JDBC driver)
Maintainer: Martijn Schuemie <schuemie at>
License: Apache License version 1.1 | Apache License version 2.0 [expanded from: Apache License]
Copyright: See file COPYRIGHTS
DatabaseConnector copyright details
NeedsCompilation: no
SystemRequirements: Java version 8 or higher (
Materials: README NEWS
CRAN checks: DatabaseConnector results


Reference manual: DatabaseConnector.pdf
Vignettes: Using DatabaseConnector


Package source: DatabaseConnector_4.0.2.tar.gz
Windows binaries: r-devel:, r-release:, r-oldrel:
macOS binaries: r-release (arm64): DatabaseConnector_4.0.2.tgz, r-release (x86_64): DatabaseConnector_4.0.2.tgz, r-oldrel: DatabaseConnector_4.0.2.tgz
Old sources: DatabaseConnector archive


Please use the canonical form to link to this page.