downloadJdbcDrivers function

Download DatabaseConnector JDBC Jar files

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
  • "bigquery" for Google BigQuery
  • "iris" for InterSystems IRIS
  • "all" for all aforementioned platforms

• 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.

Returns

Invisibly returns the destination if the download was successful.

Details

The following versions of the JDBC drivers are currently used:

• PostgreSQL: V42.7.3
• RedShift: V2.1.0.9
• SQL Server: V9.2.0
• Oracle: V19.8
• Spark (Databricks): V2.6.36
• Snowflake: V3.16.01
• BigQuery: v1.3.2.1003
• InterSystems IRIS: v3.10.2

Examples

## Not run:

downloadJdbcDrivers("redshift")
## End(Not run)