createDbiConnectionDetails function

Create DBI connection details

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.

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
  • "iris" for InterSystems IRIS

• 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

Returns

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