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 |
| Reference manual: | DatabaseConnector.pdf |
| Vignettes: |
Connecting to a database Using DatabaseConnector through DBI and dbplyr Querying a database |
| 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 depends: | Achilles, CohortAlgebra, CohortExplorer, CohortGenerator, CommonDataModel, FeatureExtraction, ResultModelManager |
| Reverse imports: | OhdsiShinyAppBuilder |
| Reverse suggests: | CDMConnector, Eunomia, TreatmentPatterns |
Please use the canonical form https://CRAN.R-project.org/package=DatabaseConnector to link to this page.