CRAN/E | DatabaseConnector

DatabaseConnector

Connecting to Various Database Platforms

Installation

About

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.

ohdsi.github.io/DatabaseConnector/
github.com/OHDSI/DatabaseConnector
Copyright See file COPYRIGHTS DatabaseConnector copyright details
System requirements Java (>= 8)
Bug report File report

Key Metrics

Version 6.3.2
R ≥ 4.0.0
Published 2023-12-11 137 days ago
Needs compilation? no
License Apache License version 1.1
License Apache License version 2.0
CRAN checks DatabaseConnector results

Downloads

Yesterday 632 0%
Last 7 days 2.546 -59%
Last 30 days 20.496 -23%
Last 90 days 63.157 +538%
Last 365 days 94.402 +183%

Maintainer

Maintainer

Martijn Schuemie

schuemie@ohdsi.org

Authors

Martijn Schuemie

aut / cre

Marc Suchard

aut

Observational Health Data Science
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)

Material

README
NEWS
Reference manual
Package source

In Views

Databases

Vignettes

Connecting to a database
Using DatabaseConnector through DBI and dbplyr
Querying a database

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

r-oldrel

x86_64

Windows

r-devel

x86_64

r-release

x86_64

r-oldrel

x86_64

Old Sources

DatabaseConnector archive

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

Reverse Depends

Achilles
CohortAlgebra
CohortExplorer

Reverse Suggests

CDMConnector
TreatmentPatterns