src_oracle: Connect to oracle.

In tomasgreif/dplyrOracle: Connect R to Oracle using dplyr

Description

Connect to oracle.

Usage

src_oracle(dbname = NULL, host = NULL, port = NULL, user = NULL,
  password = NULL, ...)

Arguments

dbname	Oracle database name
host	Host name
port	Port
user	User name
password	Password
...	Other arguments passed to function.

Details

Note that you can also use SID based connection if supported by your infrastructure

Examples

## Not run: 
host <- "11.111.11.11"
port <- 1521
sid <- "mydbident"

connect.string <- paste(
 "(DESCRIPTION=",
 "(ADDRESS=(PROTOCOL=tcp)(HOST=", host, ")(PORT=", port, "))",
 "(CONNECT_DATA=(SID=", sid, ")))", sep = "")

my_db <- src_oracle(username = "ilikedb", password = "verysecret",
                   dbname = connect.string)

## End(Not run)

tomasgreif/dplyrOracle documentation built on May 31, 2019, 5:15 p.m.