get_cdw: Get data from the CDW

In tarakc02/getcdw: Query the CADS Data Warehouse from R

Get data from the CDW

Description

Get data from the CDW

Usage

get_cdw(query, dsn = config("default_dsn"), uid = NULL, pwd = NULL, ...)

Arguments

query	A SQL query. This can be either the text of the query, the name of a file that contains the query, or a valid connection that contains the text of the query.
dsn	The name of the connection, as it appears in your tnsnames
uid	Your username (see details)
pwd	Your password (see details)
...	Other arguments passed on to dbSendQuery in package odbc

Details

Returns a data.frame if the query is successful, otherwise an error. If you don't enter a username/password, get_cdw will check the global environment for these values. The first time you run a query against a given dsn, you will be prompted for your credentials. These will be saved in an encrypted database in your home directory, so that you won't be prompted for them again in the future. If you need to reset your credentials, use the function reset_credentials.

tarakc02/getcdw documentation built on April 2, 2022, 4:13 p.m.