How to use the Teradata JDBC Driver with R

Connectivity
Connectivity covers the mechanisms for connecting to the Teradata Database, including driver connectivity via JDBC or ODBC.
Enthusiast

Re: How to use the Teradata JDBC Driver with R

Done. Thanks Dave.

 

-Suhail

Enthusiast

Re: How to use the Teradata JDBC Driver with R

This worked. A big big thank you to David Repshas from Teradata who helped us troubleshoot this. Thank you once again David.

 

 

library(RJDBC)

library(DBI)

library(rJava)

 

JAR_DIR <- "C:/Users/myuser/Downloads/TeraJDBC__indep_indep.16.10.00.03/"

drv <- try(JDBC("com.teradata.jdbc.TeraDriver", paste0(JAR_DIR, 'terajdbc4.jar')))

.jaddClassPath(paste(JAR_DIR, "terajdbc4.jar", sep=""))

.jaddClassPath(paste(JAR_DIR, "tdgssconfig.jar", sep=""))

drv <- JDBC(driverClass="com.teradata.jdbc.TeraDriver")

 

databse <- dbConnect(drv,"jdbc:teradata://myprodsystem/LOG=DEBUG,LOGMECH=LDAP,charset=UTF8","myuser","myldappwd123")