Open a connection to a PHS database

Source: R/phs_database_conn.R

Open a connection to a PHS database

phs_database_conn(dsn, username = Sys.getenv("USER"))

Arguments

dsn

The Data Source Name passed on to odbc::dbconnect the dsn must be setup first. e.g. SMRA or DVPROD
username

The username to use for authentication, if not supplied it first will check the environment variable and finally ask the user for input.

Value

a connection to the specified dsn