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', 'Snowflake', 'Spark', and 'SQLite'). Also includes support for fetching data as 'Andromeda' objects. Uses either 'Java Database Connectivity' ('JDBC') or other 'DBI' drivers to connect to databases.

Version: 6.3.2
Depends: R (≥ 4.0.0)
Imports: rJava, SqlRender (≥ 1.16.0), methods, stringr, readr, rlang, utils, DBI (≥ 1.0.0), urltools, bit64, checkmate, digest, dbplyr (≥ 2.2.0)
Suggests: aws.s3, R.utils, withr, testthat, DBItest, knitr, rmarkdown, RSQLite, ssh, Andromeda, dplyr, RPostgres, odbc, duckdb, pool, ParallelLogger
Published: 2023-12-11
DOI: 10.32614/CRAN.package.DatabaseConnector
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 ohdsi.org>
BugReports: https://github.com/OHDSI/DatabaseConnector/issues
License: Apache License version 1.1 | Apache License version 2.0 [expanded from: Apache License]
Copyright: See file COPYRIGHTS
DatabaseConnector copyright details
URL: https://ohdsi.github.io/DatabaseConnector/, https://github.com/OHDSI/DatabaseConnector
NeedsCompilation: no
SystemRequirements: Java (>= 8)
Materials: README NEWS
In views: Databases
CRAN checks: DatabaseConnector results

Documentation:

Reference manual: DatabaseConnector.pdf
Vignettes: Connecting to a database
Using DatabaseConnector through DBI and dbplyr
Querying a database

Downloads:

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

Reverse dependencies:

Reverse depends: Achilles, CohortAlgebra, CohortExplorer, CohortGenerator, CommonDataModel, FeatureExtraction, ResultModelManager
Reverse suggests: CDMConnector, Eunomia, TreatmentPatterns

Linking:

Please use the canonical form https://CRAN.R-project.org/package=DatabaseConnector to link to this page.