This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Installing the ODBC driver on Mac OS X

You can download the Vertica ODBC driver for Mac OS X as a .pkg file from the.

You can download the Vertica ODBC driver for Mac OS X as a .pkg file from the Vertica driver downloads page. You can run the installer as a regular Mac OS X installer or silently.

The installer is designed to be used with the standard iODBC Driver Manager included in Mac OS X. While Mac OS X ships with the iODBC Driver Manager already installed, you may choose to download the most recent version of the driver at the iODBC.org website.

By default, the installer installs the driver in the following location: /Library/Vertica/ODBC/lib/libverticaodbc.dylib. The installer also automatically registers a driver named "Vertica" with the iODBC Driver Manager.

To use the unixODBC Driver Manager instead of Apple's iODBC Driver Manager, see the unixODBC.org website.

Before you download the driver

If you installed a previous version of the Vertica ODBC driver for Mac OS X, your system might already have a registered driver named "Vertica." In this case, you must remove or rename the older version of the driver before installing the Vertica ODBC driver .pkg file.

To have multiple versions of the driver installed on your system at the same time, you must rename the currently installed version of the driver to something other than "Vertica."

1 - Download the driver

Download the Macintosh OS X driver package from the .

Download the Macintosh OS X driver package from the Vertica driver downloads page.

2 - Install the Mac OS X ODBC driver

As a Mac OS X Administrator, double-click the installer to start the installation.

As a Mac OS X Administrator, double-click the installer to start the installation. Follow the prompts as the wizard guides you through each step of the process.

3 - Silently install the Mac OS X ODBC driver

Install the .pkg file containing the ODBC driver using the command:.

  1. Log into the client Mac in one of two ways:

    • As an administrator account, if you are installing the driver for system-wide use

    • As the user who needs to use the Vertica ODBC driver

  2. Open a terminal window. In the Finder, click Applications > Utilities > Terminal.

  3. Install the .pkg file containing the ODBC driver using the command:

    sudo installer -pkg ~/Downloads/vertica-odbc11.1.xpkg -target /

    In the preceding .pkg command, change the path to that of the downloaded file, if:

    • You downloaded the driver .pkg file to a directory other than your Downloads directory.
    • You downloaded the driver using another user account.

4 - Uninstall the Mac OS X ODBC driver

Uninstalling the Mac OS X ODBC Client-Driver does not remove any existing DSNs associated with the driver.

Uninstalling the Mac OS X ODBC Client-Driver does not remove any existing DSNs associated with the driver.

To uninstall:

  1. Open a terminal window.

  2. Enter the command:

    sudo /Library/Vertica/ODBC/bin/Uninstall

5 - Upgrade or downgrade the Mac OS X ODBC driver

All installations of the Vertica ODBC driver for Mac OS X are uniquely identified by a package ID and version number.

All installations of the Vertica ODBC driver for Mac OS X are uniquely identified by a package ID and version number. The package ID does not change between versions, but the version number does. If you attempt multiple installations of the same version of the driver, a name collision error occurs. Therefore, multiple installations of the same version of the driver cannot coexist on a single operating system.

  • Upgrading—Newly installed versions of the Vertica ODBC driver for Mac OS X automatically upgrade the relevant driver system settings. Any DSNs associated with a previous version of the driver are not affected, except that they begin using the newer version of the driver.

  • Downgrading—Run the uninstall script to remove the current version of the Vertica ODBC driver for Mac OS X. Complete this step before installing an older driver version.

6 - ODBC driver settings on Mac OS X

ODBC driver settings are automatically configured using the Vertica ODBC driver installer on Mac OS X.

ODBC driver settings are automatically configured using the Vertica ODBC driver installer on Mac OS X. It is not necessary to configure additional ODBC driver settings on Mac OS X platforms beyond what is automatically configured by the installer. You can, however, set the ODBC driver settings by editing the VERTICAINI environment variable in each user's ~/.MacOSX/environment.plist file. See the Environment Variables entry in the Apple Developer's Library for more information.

See Additional parameter settings for a list of the additional settings.