Netezza

Driver Options

  • Posit Professional Drivers - Workbench, RStudio Desktop Pro, Connect, or Shiny Server Pro users can download and use Posit Professional Drivers at no additional charge. These drivers include an ODBC connector for Apache Hive. Posit delivers standards-based, supported, professional ODBC drivers. Use Posit Professional Drivers when you run R or Shiny with your production systems. See the Posit Professional Drivers for more information.

Package Options

The odbc package, in combination with a driver, provides DBI support and an ODBC connection.

Connection Settings

There are six settings needed to make a connection:

  • Driver - See the Drivers section for setup information
  • Server - The database server’s IP address
  • Port - Should be set to 5480
  • Database - The name of the database to default to
  • UID - The user’s network ID or server local account
  • PWD - The account’s password

con <- DBI::dbConnect(odbc::odbc(),
                      Driver = "[your driver's name]",
                      Server   = "[your server's path]",
                      Port = "5480",
                      Database = "[your database's name]",
                      UID    = rstudioapi::askForPassword("Database user"),
                      PWD    = rstudioapi::askForPassword("Database password")
                      )
Back to top