DatabaseConnector is part of HADES.
This R package provides function for connecting to various DBMSs. Together with the
SqlRender package, the main goal of
DatabaseConnector is to provide a uniform interface across database platforms: the same code should run and produce equivalent results, regardless of the database back end.
connectionDetails <- createConnectionDetails(dbms="postgresql", server="localhost", user="root", password="blah", schema="cdm_v4") conn <- connect(connectionDetails) querySql(conn,"SELECT COUNT(*) FROM person") disconnect(conn)
DatabaseConnector is an R package using Java's JDBC drivers.
Running the package requires R with the package rJava installed. Also requires Java 1.8 or higher.
See the instructions here for configuring your R environment, including Java.
To install the latest stable version, install from CRAN:
Download the database drivers as described here.
(Optionally) To use Windows Authentication for SQL Server, download the authentication DDL file as described here.
Documentation can be found on the package website.
PDF versions of the documentation are also available:
Read here how you can contribute to this package.
DatabaseConnector is licensed under Apache License 2.0. The JDBC drivers fall under their own respective licenses.
DatabaseConnector is being developed in R Studio.
Stable. The code is actively being used in several projects.
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.