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 'DBI' 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, BigQuery

Read the instructions
<a href="https://www.ibm.com/docs/en/netezza?topic=dls-installing-configuring-jdbc">here</a>
on how to obtain the Netezza JDBC driver.

Netezza

Go to <a href="https://www.cloudera.com/downloads/connectors/impala/jdbc.html">Cloudera's site</a>, pick
your OS version, and click "GET IT NOW!'. Register, and you should be able to download the driver.

Impala

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

SQLite

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

Read the instructions
<a href='https://www.ibm.com/docs/en/netezza?topic=dls-installing-configuring-jdbc'>here</a>
on how to obtain the Netezza JDBC driver.

Go to <a href='https://www.cloudera.com/downloads/connectors/impala/jdbc.html'>Cloudera's site</a>, pick
your OS version, and click "GET IT NOW!'. Register, and you should be able to download the driver.

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, BigQuery

Netezza

Impala

SQLite