CODEWITHSUNDEEP
roracle-databaseunixwallet
RevivedPicard
RevivedPicard

Reputation: 129

Connect with R/RStudio to an Oracle DB using Wallet

H, I'm quite a newbie on this.

I have a Unix machine with R/RStudio and Python installed. I need to connect to an Oracle DB in a secure way. I have created a wallet with mkstore given by Oracle and with Python and cx_Oracle library I have no problems in connecting to this DB, but how can I afford the same result with R?

Upvotes: 1

Views: 557

Answers (1)

Christopher Jones
Christopher Jones

Reputation: 10506

There's an example in the ROracle doc:

## Create connection authenticated with external credentials.
con <- dbConnect(drv, username ="", password="", external_credentials = TRUE)

You'll probably need to pass dbname too.

Upvotes: 1

Related Questions