jdbcDrivers

Below are instructions for downloading JDBC drivers for the various data platforms. Once downloaded
use the <code>pathToDriver</code> argument in the <code>connect()</code> or <code>createConnectionDetails()</code>
functions to point to the driver. Alternatively, you can set the 'DATABASECONNECTOR_JAR_FOLDER' environmental
variable, for example in your .Renviron file (recommended).

An R 'DataBase Interface' ('DBI') compatible interface to various database platforms ('PostgreSQL', 'Oracle', 'Microsoft SQL Server',
'Amazon Redshift', 'Microsoft Parallel Database Warehouse', 'IBM Netezza', 'Apache Impala', 'Google BigQuery', 'Snowflake', 'Spark', and 'SQLite'). Also includes support for
fetching data as 'Andromeda' objects. Uses either 'Java Database Connectivity' ('JDBC') or other DB I drivers to connect to databases.

Martijn Schuemie

DatabaseConnector

Connecting to Various Database Platforms

Marc Suchard

Observational Health Data Science and Informatics 

Microsoft Inc. 

PostgreSQL Global Development Group 

Oracle Inc. 

Amazon Inc. 

jdbcDrivers function

Use the <code>downloadJdbcDrivers()</code> function to download these drivers from the OHDSI GitHub pages.

SQL Server, Oracle, PostgreSQL, PDW, Snowflake, Spark RedShift, Azure Synapse

Read the instructions
<a href="https://www.ibm.com/docs/en/SSULQD_7.2.1/com.ibm.nz.datacon.doc/t_datacon_setup_JDBC.html">here</a>
on how to obtain the Netezza JDBC driver.

Netezza

Go to <a href="https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers">Google's site</a> and
download the latest JDBC driver. Unzip the file, and locate the appropriate jar files.

BigQuery

Go to <a href="https://www.cloudera.com/downloads/connectors/impala/jdbc/2-5-5.html">Cloudera's site</a>, 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 <code>install.packages("RSQLite")</code>.

Impala

How to download and use JDBC drivers for the various data platforms. — jdbcDrivers

Read the instructions
<a href='https://www.ibm.com/docs/en/SSULQD_7.2.1/com.ibm.nz.datacon.doc/t_datacon_setup_JDBC.html'>here</a>
on how to obtain the Netezza JDBC driver.

Go to <a href='https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers'>Google's site</a> and
download the latest JDBC driver. Unzip the file, and locate the appropriate jar files.

Go to <a href='https://www.cloudera.com/downloads/connectors/impala/jdbc/2-5-5.html'>Cloudera's site</a>, 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 <code>install.packages("RSQLite")</code>.

jdbcDrivers: How to download and use JDBC drivers for the various data platforms.

Description

Arguments

SQL Server, Oracle, PostgreSQL, PDW, Snowflake, Spark RedShift, Azure Synapse

Netezza

BigQuery

Impala