createDbiConnectionDetails

For advanced users only. This function will allow <code>DatabaseConnector</code> to wrap any DBI driver. Using a driver that
<code>DatabaseConnector</code> hasn't been tested with may give unpredictable performance. Use at your own risk. No
support will be provided.

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. 

createDbiConnectionDetails function

<dl><dt>dbms</dt>
<dd>The type of DBMS running on the server. Valid values are<ul>
<li>"oracle" for Oracle</li>
<li>"postgresql" for PostgreSQL</li>
<li>"redshift" for Amazon Redshift</li>
<li>"sql server" for Microsoft SQL Server</li>
<li>"pdw" for Microsoft Parallel Data Warehouse (PDW)</li>
<li>"netezza" for IBM Netezza</li>
<li>"bigquery" for Google BigQuery</li>
<li>"sqlite" for SQLite</li>
<li>"sqlite extended" for SQLite with extended types (DATE and DATETIME)</li>
<li>"spark" for Spark</li>
<li>"snowflake" for Snowflake</li>
</ul></dd>
<dt>drv</dt>
<dd>An object that inherits from DBIDriver, or an existing DBIConnection object
(in order to clone an existing connection).</dd>
<dt>...</dt>
<dd>authentication arguments needed by the DBMS instance; these typically
include user, password, host, port, dbname, etc. For details see the appropriate DBIDriver</dd></dl>

Arguments

Create DBI connection details — createDbiConnectionDetails

<dl>

<dt>dbms</dt>
<dd>The type of DBMS running on the server. Valid values are<ul>
<li>"oracle" for Oracle</li>
<li>"postgresql" for PostgreSQL</li>
<li>"redshift" for Amazon Redshift</li>
<li>"sql server" for Microsoft SQL Server</li>
<li>"pdw" for Microsoft Parallel Data Warehouse (PDW)</li>
<li>"netezza" for IBM Netezza</li>
<li>"bigquery" for Google BigQuery</li>
<li>"sqlite" for SQLite</li>
<li>"sqlite extended" for SQLite with extended types (DATE and DATETIME)</li>
<li>"spark" for Spark</li>
<li>"snowflake" for Snowflake</li>
</ul></dd>


<dt>drv</dt>
<dd>An object that inherits from DBIDriver, or an existing DBIConnection object
(in order to clone an existing connection).</dd>


<dt>...</dt>
<dd>authentication arguments needed by the DBMS instance; these typically
include user, password, host, port, dbname, etc. For details see the appropriate DBIDriver</dd>

</dl>

createDbiConnectionDetails: Create DBI connection details

Description

Usage

Value

Arguments