Skip to contents

Open a connection to a PHS database

Source: R/get_connection_PHS_database.R
phs_db_connection.Rd

Opens a connection to PHS database given a Data Source Name (DSN) it will try to get the username, asking for input if in an interactive session. It will also use keyring to find an existing keyring called 'createslf' which should contain a db_password key with the users database password.

Usage

phs_db_connection(dsn, username)

Arguments

dsn

The Data Source Name (DSN) passed on to odbc::dbConnect() the DSN must be set up first. e.g. SMRA or DVPROD

username

The username to use for authentication, if not supplied it will try to find it automatically and if possible ask the user for input.

Value

a connection to the specified Data Source.