An R package that provides a database interface to Netezza.
This package wraps Netezza JDBC driver and extends dplyr.
Install via github:
install.packages('devtools')
devtools::install_github('chappers/dplyrNetezza')
library(RNetezza)
# JDBC URL FORMAT: jdbc:netezza://<host>:<port>/<dbname>
nzr <- src_JDBC(drv = NetezzaSQL(), url=url, user=user, password=password)
# Caches data from Netezza
NZtable <- tbl(nzr, "NZtable")
Normal plyr
actions should then be able to take place.
n.b. the NetezzaSQL()
function is as follows:
NetezzaSQL<-function(){
return(JDBC(driverClass="org.netezza.Driver",
classPath=system.file("java", "nzjdbc.jar", package="RNetezzaServer"), "'"))
}
All credit goes to the projects below that inspired and make up parts of dplyrNetezza:
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.