R and odbcDriverConnect() to connect R to teradata

Question

I am trying to connect R to Teradata and am not sure what the input items are to the RODBC::odbcDriverConnect(). There is a teradataR package, but it is only used with R versions 3 and under, which I neither have nor want to switch to. Below is a list of the input parameters to get ODBCDriverConnect to work. "Connection" I believe is most important. I need to get an address for a driver that I don't even know if I have. This is what I need most help with. How do I get a driver for Teradata to connect to R? IT at my work is not sure how to do this. Also, if anyone knows of another way to connect Teradata to R (some other package?), please let me know.

connection = ""
case
 believeNRows = TRUE
 colQuote, tabQuote = colQuote
interpretDot = TRUE
 DBMSencoding = "",
rows_at_time = 100
 readOnlyOptimize = FALSE

Thank you for your help!

Answer 1

I am able to connect to Teradata and created a Shiny app which reads data from it. Firstly we need to install RODBC package in our R. Prerequisite of it is R (? 4.0.0) version. No admin access is required to upgrade R even in enterprise laptops.

Follow below steps to successfully setup connection.

1. Create ODBC Data Sources to connect to Teradata. The connection should be either in 64bit or 32bit, depending on R software.

2. Use below code snippet to get the data into reactive variable

data <- reactive({
  ch <- odbcConnect(dsn = "DSNName", uid = "username", pwd = "password")
  sqlQuery(ch,paste('select * from emp ')
           })

DSNName - Name of DSN connection created

You can use data() to display and use the value stored in it. Enjoy!