createDbiConnectionDetails {DatabaseConnector}

Create DBI connection details

Description

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

Usage

createDbiConnectionDetails(dbms, drv, ...)

Arguments

dbms

The type of DBMS running on the server. Valid values are

• "oracle" for Oracle

• "postgresql" for PostgreSQL

• "redshift" for Amazon Redshift

• "sql server" for Microsoft SQL Server

• "pdw" for Microsoft Parallel Data Warehouse (PDW)

• "netezza" for IBM Netezza

• "bigquery" for Google BigQuery

• "sqlite" for SQLite

• "sqlite extended" for SQLite with extended types (DATE and DATETIME)

• "spark" for Spark

• "snowflake" for Snowflake

drv

An object that inherits from DBIDriver, or an existing DBIConnection object (in order to clone an existing connection).

...

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

Value

A list with all the details needed to connect to a database.