Hi
I think the important part I am missing is the Driver name and I just can't seem to figure it out. I have installed ODBC but still can't find the driver for Teradata? Does it have to be instally locally in PC ? Is there package for R interface to the Teradata
con <- DBI::dbConnect(odbc::odbc(),
Driver = "[your driver's name]",
Host = "[your server's path]",
DBCName = "[IP Address or Alias]"
UID = rstudioapi::askForPassword("Database user"),
PWD = rstudioapi::askForPassword("Database password"))
I have a big project which is depended on R connecting to Teradata