open_con: open_con

In acuitas-health/ahUtils: Acuitas Utils

open_con

Description

Uses config.yml and ~/.Renviron to open a database connection to the Acuitas EDW. In your .Renviron file you must have the following edw_user and edw_pass defined. In your config.yml file, you must have dsn_name defined for both the default and rsconnect configurations.

Usage

open_con(config = NULL)

Arguments

config

A configlist. If not provided, the function will open config.yml itself.

Details

The function can use any list with a dsn_name variable named. If not, it will open config.yml and find the dsn_name for itself.

You an use dbDisconnect with the con object because it is NO different than any other DBI connection object.

Value

A connection object.

acuitas-health/ahUtils documentation built on April 14, 2022, 9:41 a.m.