DatabaseConnector: dbConnect-DatabaseConnectorDriver-method – R documentation

Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

dbConnect-DatabaseConnectorDriver-method

Create a connection to a DBMS

Description

Connect to a database. This function is synonymous with the connect function. except a dummy driver needs to be specified

Usage

## S4 method for signature 'DatabaseConnectorDriver'
dbConnect(drv, ...)

Arguments

`drv`	The result of the `link{DatabaseConnectorDriver}` function
`...`	Other parameters. These are the same as expected by the `connect` function.

Value

Returns a DatabaseConnectorConnection object that can be used with most of the other functions in this package.

Examples

## Not run: 
conn <- dbConnect(DatabaseConnectorDriver(),
                  dbms = "postgresql",
                  server = "localhost/ohdsi",
                  user = "joe",
                  password = "secret")
querySql(conn, "SELECT * FROM cdm_synpuf.person;")
dbDisconnet(conn)

## End(Not run)

DatabaseConnector

Connecting to Various Database Platforms

v4.0.2

Apache License

Authors

Martijn Schuemie [aut, cre], Marc Suchard [aut], Observational Health Data Science and Informatics [cph], Microsoft Inc. [cph] (SQL Server JDBC driver), PostgreSQL Global Development Group [cph] (PostgreSQL JDBC driver), Oracle Inc. [cph] (Oracle JDBC driver), Amazon Inc. [cph] (RedShift JDBC driver)

Initial release

2021-04-12