I'm trying to use the SQL engine within knitr: <http://rmarkdown.rstudio.com/authoring_knitr_engines.html#sql>

The documentation states that "to use the knitr SQL engine you first need to establish a DBI connection to a database"

And it provides the following example:

```
library(DBI)
db <- dbConnect(RSQLite::SQLite(), dbname = "sql.sqlite")

```

Now I'm trying to connect to Teradata. I've successfully accomplished this in the past using the RODBC and RJDBC packages, and there's quite a bit of useful documentation out there. I have not connected directly via the DBI package, however, nor can I find any examples.

I'm guessing that the syntax is similar to an RJDBC connection (referenced [here](http://developer.teradata.com/connectivity/articles/how-to-use-the-teradata-jdbc-driver-with-teradatar)):

```
drv = JDBC("com.teradata.jdbc.TeraDriver","ClasspathForTeradataJDBCDriverFiles") 
conn = dbConnect(drv,"jdbc:teradata://DatabaseServerName/ParameterName=Value","User","Password") 
dbGetQuery(conn,"SQLquery")

```

But are there any exmaples of a DBI connnection to Teradata?