README.md
In chappers/dplyrNetezza: Extends dplyr to use JDBC SQL drivers.

dplyrNetezza

An R package that provides a database interface to Netezza.

This package wraps Netezza JDBC driver and extends dplyr.

Installation

Install via github:

install.packages('devtools')
devtools::install_github('chappers/dplyrNetezza')

Usage

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"), "'"))
}