ps.connect.to.netezza: Connect to Netezza

Description Usage Arguments Details Value Examples

Description

Establishes a connection to the Netezza database

Usage

1
ps.connect.to.netezza(user.name, password, driver.location, db.prefix, db.host)

Arguments

user.name

Your user name (prid)

password

Your password

driver.location

Location of your netezza driver, usually "nzjdbc.jar". Can be specified as complete path or the directory where the driver file is located.

db.prefix

This + prid = your database

db.host

URL of netezza appliance

Details

This function creates a connection to the Netezza database using the supplied credentials. This connection can then be used to pull data from the database into R.

Value

Database connection object

Examples

1
2
3
4
## Not run: 
ps.connect.to.netezza("user123", "password123", "/users/user123/Documents/databaseDrivers")

## End(Not run)

OHDSI/Centaur documentation built on May 7, 2019, 8:22 p.m.