Installing Oracle MySQL ODBC Driver

To install the database driver, perform the following steps:

On Windows

  1. Download the MSI installer from the Oracle MySQL website.

  2. Run the executable installer.

Oracle MySQL ODBC Driver in the ODBC Data Source Administrator (x64) program is now visible on the Drivers tab.

On Ubuntu

  1. Download the debian installer file from the Oracle MySQL website.

  2. Run the executable installer.

Oracle MySQL ODBC Driver is now visible in the odbcinst.ini file with the driver path.

For prior versions of Ubuntu 22.04, perform the following steps:

  1. Download and extract the driver compressed .tar file from the MySQL website to the required location.

  2. Use the installer utility from the bin folder of the extracted driver folder, run the following command:

    ./myodbc-installer -d -a -n "MySQL ODBC Unicode Driver" -t “DRIVER=/path/to/driver/libmyodbc8w.so;"

Installing Microsoft SQL Server ODBC Driver

To install the database driver, perform the following steps:

On Windows

  1. Download the Microsoft SQL Server ODBC Driver MSI installer file from the Microsoft website.

  2. Run the executable installer.

Microsoft SQL Server ODBC Driver in the ODBC Data Source Administrator (x64) program is now visible on the Drivers tab.

On macOS and Ubuntu

  • To install the Microsoft ODBC Driver for SQL Server, perform the instructions provided as follows:

Microsoft SQL Server ODBC Driver is now visible in the odbcinst.ini file with the driver path.

Installing PostgreSQL and Greenplum ODBC Drivers

To install the PostgreSQL and Greenplum ODBC drivers on specific platforms, perform the following steps:

On Windows

  1. Download the PostgreSQL ODBC Driver MSI Installer file from https://odbc.postgresql.org/.

  2. Run the executable installer.

    Result

    After installation, the PostgreSQL ODBC Driver in the ODBC Data Source Administrator (x64) program is now visible on the Drivers tab.

On macOS

  1. Run the following command:

    brew install psqlodbc

    The driver is installed at the default location.

    For example: /usr/local/Cellar/psqlodbc/16.00.0000/lib/psqlodbcw.so or /opt/homebrew/Cellar/psqlodbc/16.00.0000/lib/psqlodbcw.so

  2. Edit the odbcinst.ini file with the following text with driver file path and name as per your system.

    [PostgreSQL]
    Description=PostgreSQL ODBC Driver
    Driver=<default driver location>

On Ubuntu

  • Run the following command:

apt install odbc-postgresql
Result

After installation, the PostgreSQL ODBC driver in the odbcinst.ini file is now visible with the driver path.

Installing Amazon Redshift Database Drivers

To install the Amazon Redshift database drivers on specific platforms, perform the following steps:

On Windows

  1. Download the Amazon Redshift ODBC Driver MSI installer file from the Amazon Redshift website.

  2. Run the executable installer.

Result

After Installation, the Amazon Redshift ODBC driver in the ODBC Data Source Administrator (x64) program is now visible on the Drivers tab.

On macOS

  1. Download the Redshift ODBC Driver installer from the Amazon Redshift website.

  2. Extract and install the package.

    The driver is installed at the default location.

    For example: /opt/amazon/redshift/lib/libamazonredshiftodbc.dylib

  3. Edit the odbcinst.ini file with the following text with driver file path and name as per your system.

    [Amazon Redshift]
    Description=Amazon Redshift ODBC Driver
    Driver=<default driver location>

On Ubuntu

  1. Download the driver file provided by Amazon.

  2. Run the executable installer.

Result

After installation, the Amazon Redshift ODBC driver in odbcinst.ini file is now visible with the driver path.

For more information, see, https://docs.aws.amazon.com/redshift/latest/mgmt/odbc20-install-config-linux.html