jdbcDrivers: How to download and use JDBC drivers for the various data...
In DatabaseConnector: Connecting to Various Database Platforms
jdbcDrivers R Documentation
How to download and use JDBC drivers for the various data platforms.
Description
Below are instructions for downloading JDBC drivers for the various data platforms. Once downloaded
use the pathToDriver argument in the connect() or createConnectionDetails()
functions to point to the driver. Alternatively, you can set the 'DATABASECONNECTOR_JAR_FOLDER' environmental
variable, for example in your .Renviron file (recommended).
SQL Server, Oracle, PostgreSQL, PDW, Snowflake, Spark, RedShift, Azure Synapse, BigQuery
Use the downloadJdbcDrivers() function to download these drivers from the OHDSI GitHub pages.
Netezza
Read the instructions
here
on how to obtain the Netezza JDBC driver.
Impala
Go to Cloudera's site, pick
your OS version, and click "GET IT NOW!'. Register, and you should be able to download the driver.
SQLite
For SQLite we actually don't use a JDBC driver. Instead, we use the RSQLite package, which can be installed
using install.packages("RSQLite").
DatabaseConnector documentation built on May 29, 2024, 6:14 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
| jdbcDrivers | R Documentation |
How to download and use JDBC drivers for the various data platforms.
Description
Below are instructions for downloading JDBC drivers for the various data platforms. Once downloaded
use the pathToDriver argument in the connect() or createConnectionDetails()
functions to point to the driver. Alternatively, you can set the 'DATABASECONNECTOR_JAR_FOLDER' environmental
variable, for example in your .Renviron file (recommended).
SQL Server, Oracle, PostgreSQL, PDW, Snowflake, Spark, RedShift, Azure Synapse, BigQuery
Use the downloadJdbcDrivers() function to download these drivers from the OHDSI GitHub pages.
Netezza
Read the instructions here on how to obtain the Netezza JDBC driver.
Impala
Go to Cloudera's site, pick your OS version, and click "GET IT NOW!'. Register, and you should be able to download the driver.
SQLite
For SQLite we actually don't use a JDBC driver. Instead, we use the RSQLite package, which can be installed
using install.packages("RSQLite").
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.