Download the DatabaseConnector JDBC drivers from https://ohdsi.github.io/DatabaseConnectorJars/
downloadJdbcDrivers(
dbms,
pathToDriver = Sys.getenv("DATABASECONNECTOR_JAR_FOLDER"),
method = "auto",
...
)
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
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.
The method used for downloading files. See ?download.file
for details and options.
Further arguments passed on to download.file
.
Invisibly returns the destination if the download was successful.
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
if (FALSE) {
downloadJdbcDrivers("redshift")
}