src_connectR: src_connectR connect to Databases

In DyfanJones/connectR: Database backend for DBI, dplyr and dbplyr

Description

Connects to databases currently using the odbc api, and also ecrypt password for safe storage.

Usage

src_connectR(dsn = NULL, uid = NULL, pwd = NULL, Update = FALSE,
  db = NULL, ..., auto_disconnect = FALSE)

Arguments

dsn:The	Data Source Name.
uid:	User id for database connecting to.
pwd:	User password for database
db:	Database name i.e. TMG
Update:	Update encrypted password
...:	Additional ODBC keywords, these will be joined with the other arguments to form the final connection string.

Value

Connection to database

Examples

 #Standard connection to teradata and to database "postgres",
 unadviced as password in contained within the code:
   src_connectR(dsn = "POSTGRES", uid = "USERNAME", pwd = "PaSsword",
    db = "postgres", Update = F)

 #Standard connection to teradata and to all database,
 unadviced as password in contained within the code:
   src_connectR(dsn = "POSTGRES", uid = "USERNAME", pwd = "PaSsword",
    Update = F)

 #Connection to teradata and to all databases,
 R will take store encrypted username and password:
   connectR(dsn = "POSTGRES")

 #Connection to teradata and to all databases,
 as Update = TRUE, stored password will be updated:
   connectR(dsn = "POSTGRES",Update=T)

DyfanJones/connectR documentation built on May 23, 2019, 10:32 p.m.