Download DatabaseConnector JDBC Jar files

Source: R/Drivers.R

Download the DatabaseConnector JDBC drivers from https://ohdsi.github.io/DatabaseConnectorJars/

downloadJdbcDrivers(
  dbms,
  pathToDriver = Sys.getenv("DATABASECONNECTOR_JAR_FOLDER"),
  method = "auto",
  ...
)

Arguments

dbms

The type of DBMS to download Jar files for.

  • "postgresql" for PostgreSQL

  • "redshift" for Amazon Redshift

  • "sql server", "pdw" or "synapse" for Microsoft SQL Server

  • "oracle" for Oracle

  • "spark" for Spark

  • "snowflake" for Snowflake

pathToDriver

The full path to the folder where the JDBC driver .jar files should be downloaded to. By default the value of the environment variable "DATABASECONNECTOR_JAR_FOLDER" is used.

method

The method used for downloading files. See ?download.file for details and options.

...

Further arguments passed on to download.file.

Value

Invisibly returns the destination if the download was successful.

Details

The following versions of the JDBC drivers are currently used:

  • PostgreSQL: V42.2.18

  • RedShift: V2.1.0.9

  • SQL Server: V8.4.1.zip

  • Oracle: V19.8

  • Spark: V2.6.21

  • Snowflake: V3.13.22

Examples

if (FALSE) {
downloadJdbcDrivers("redshift")
}