Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

downloadJdbcDrivers

Download DatabaseConnector JDBC Jar files

Description

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

Usage

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" or "pdw" for Microsoft SQL Server

  • "oracle" for Oracle

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

Details

The following versions of the JDBC drivers are currently used:

  • PostgreSQLV42.2.18

  • RedShiftV1.2.27.1051

  • SQL ServerV8.4.1.zip

  • OracleV19.8

Value

Invisibly returns the destination if the download was successful.

Examples

## Not run: 
downloadJdbcDrivers("redshift")

## End(Not run)
DatabaseConnector

Connecting to Various Database Platforms

v4.0.2
Apache License
Authors
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)
Initial release
2021-04-12

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.