Connecting to Oracle DB using Windows Authentication / Trusted Connection in R

There are many examples of how to connect to Oracle DB using password authentication (like user id + password) in R. However, I need to figure out how to set up a connection using Windows Authentication / Reliable Connection in R for Oracle DB.

Example

I've seen a similar case for a MySQL database where a connection string is listed containing trusted_connection=true

which, if I understand correctly, indicates Windows Authentication / Reliable Connection.

library(RODBC)
dbhandle <- odbcDriverConnect('driver={SQL Server};server=servername\\\\instancename,port;database=testing;trusted_connection=true')
res <- sqlQuery(dbhandle, 'select * from information_schema.tables')

      

1) What exactly would it look like for Oracle DB using the information below?

Additional information (possibly helpful):

In the config file, tsnames.ora

I added the following database address which works using MS Access.

DBNAME.XXX.COM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DBNAME.XXX.COM)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DBNAME.XXX.COM)
    )
  )

      

+3


source to share





All Articles