Downloading Drivers ​

You can connect ODBC, JDBC, and ADO.NET applications to Yellowbrick databases using drivers downloaded from some or all of the following sources (depending on the driver type and client operating system):

• Yellowbrick System Manager (under Cloud Native 7.x)
• Yellowbrick System Management Console (SMC) (under Yellowbrick appliances)
• Your Linux or MacOS package manager from their default or PostgreSQL repository
• Directly downloading from the PostgreSQL site

Note that installing the ODBC or ADO.NET drivers typically requires Administrator privileges.

ADO.NET: ​

Connecting to a Yellowbrick database from a .NET application requires an ADO .NET driver for PostgreSQL. Npgsql is the PostgreSQL developed ADO.NET Data Provider. Yellowbrick supports the 7.x and 8.x driver versions.

These Npgsql drivers are installed using the NuGet client tools. NuGet is the central package repository for .NET authors and consumers.

For further information, including connection strings, see:

• Using the ADO.NET Driver in this documentation section
• Npgsql Getting Started Guide
• Npgsql home

JDBC: ​

The most recent supported PostgreSQL JDBC driver for Java 8 and later is 42.7. The same driver is used across all platforms and no installer is needed. Download the driver jar file from the Yellowbrick SMC or System Manager, or directly using the following link postgresql-42.7.4.jar.

ODBC: ​

The currently supported ODBC drivers for Yellowbrick are the PostgreSQL developed version 12 drivers. Many enterprise ETL and BI tools ship with DataDirect ODBC drivers for PostgreSQL which can also be used.

Linux and MacOS clients require unixODBC to already be installed. For general instructions on using ODBC on Linux and macOS platforms, go to unixODBC.

ODBC for Windows: ​

You can download PostgreSQL ODBC drivers for Windows from the Yellowbrick SMC or System Manager, or directly using the following links:

• 64-bit MSI: https://ftp.postgresql.org/pub/odbc/versions.old/msi/psqlodbc_12_02_0000-x64.zip

• 32-bit MSI: https://ftp.postgresql.org/pub/odbc/versions.old/msi/psqlodbc_12_02_0000-x86.zip

• Combined Installer (64-bit and 32-bit): https://ftp.postgresql.org/pub/odbc/versions.old/msi/psqlodbc_12_02_0000.zip

ODBC for RHEL/CentOS Linux ​

The currently supported EL 7 and 8 PostgreSQL driver version is 12.x. The EL 9 recommended driver version is 13.x. You can obtain the drivers from your EL distribution, your package manager (using the PostgreSQL EPEL repository), the Yellowbrick SMC or System Manager, or download the RPM directly using the links provided below.

• EL 7: https://ftp.postgresql.org/pub/repos/yum/12/redhat/rhel-7.9-x86_64/postgresql12-odbc-12.01.0000-1PGDG.rhel7.x86_64.rpm

• EL 8: https://ftp.postgresql.org/pub/repos/yum/12/redhat/rhel-8.12-x86_64/postgresql12-odbc-12.01.0000-1PGDG.rhel8.x86_64.rpm

• EL 9: https://ftp.postgresql.org/pub/repos/yum/12/redhat/rhel-9.12-x86_64/postgresql12-odbc-13.02.0000-2PGDG.rhel9.x86_64.rpm

The recomended method is to use your package manager with the EPEL repository; it ensures the additional required packages are installed.

Note: Driver version 13 is the oldest PG 12 compatible driver under EL 9.

Ubuntu/Debian Linux ​

The Ubuntu PostgreSQL drivers can be installed from your distribution or the PostgreSQL APT repository using the package manager, or directly from PostgreSQL (based on your Ubuntu version). If downloading directly from PostgreSQL, the top-level PostgreSQL ODBC driver URL is: https://ftp.postgresql.org/pub/repos/apt/dists/. The recomended method is to use your package manager with the EPEL repository; it ensures the additional required packages are installed.

ODBC for macOS ​

There are many ways to install the PostgreSQL ODBC drivers on macOS. The recommended method is by using Homebrew with the following command:

brew install unixodbc psqlodbc