src_vertica: Establishes a connection to Vertica and returns a dplyr 'src'...

In vertica/vertica.dplyr: A dplyr connector for Vertica

Description

Provide either the DSN to use ODBC, or set DSN to NULL to use JDBC.

Usage

src_vertica(dsn = NULL, jdbcpath = NULL, dbname = NULL, host = NULL,
  port = 5433, user = NULL, password = "", load_udf = TRUE)

Arguments

dsn	The name of the ODBC DSN to use for connecting to Vertica. Must be a string. If NULL, JDBC-use is assumed.
jdbcpath	(Only required for JDBC) Path to the JDBC driver on your system.
dbname	(Only required for JDBC) The name of the Vertica database instance that you plan to connect to.
host	(Only required for JDBC) Host IP of the machine hosting the Vertica instance.
port	(Only required for JDBC) Port number of the Vertica server. The Vertica default is 5433.
user	(Only required for JDBC) Username of the owner of the database.
password	(Only required for JDBC) Password, if any, of the database.
load_udf	A boolean value. If TRUE (default), this will automatically register the UDFs into the session.

Value

A dplyr::src object, src_vertica, to be used with dplyr functions.

Examples

## Not run: 
vertica_connection <- src_vertica(dsn="VerticaDSN")
vertica_connection <- src_vertica(dsn=NULL,jdbcpath="/opt/vertica/java/lib/vertica_jdbc.jar",
                                  dbname="foo",host="localhost",port=5433,
                                  user="dbadmin",password="secret")

## End(Not run)

vertica/vertica.dplyr documentation built on May 3, 2019, 6:11 p.m.