Connecting to Various Database Platforms [R package DatabaseConnector version 7.0.0]

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

Version: 7.0.0

Depends: R (≥ 4.0.0)

Imports: rJava, SqlRender (≥ 1.19.2), 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, bigrquery, pool, ParallelLogger, AzureStor

Published: 2025年09月23日

DOI: 10.32614/CRAN.package.DatabaseConnector

Author: Martijn Schuemie [aut, cre], Marc Suchard [aut], Adam Black [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]

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