Installing Oracle MySQL ODBC Driver
To install the database driver, perform the following steps:
On Windows
-
Download the MSI installer from the Oracle MySQL website.
-
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
-
Download the debian installer file from the Oracle MySQL website.
-
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:
-
Download and extract the driver compressed .tar file from the MySQL website to the required location.
-
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
-
Download the Microsoft SQL Server ODBC Driver MSI installer file from the Microsoft website.
-
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
-
Download the PostgreSQL ODBC Driver MSI Installer file from https://odbc.postgresql.org/.
-
Run the executable installer.
ResultAfter installation, the PostgreSQL ODBC Driver in the ODBC Data Source Administrator (x64) program is now visible on the Drivers tab.
On macOS
-
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
-
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
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
-
Download the Amazon Redshift ODBC Driver MSI installer file from the Amazon Redshift website.
-
Run the executable installer.
After Installation, the Amazon Redshift ODBC driver in the ODBC Data Source Administrator (x64) program is now visible on the Drivers tab.
On macOS
-
Download the Redshift ODBC Driver installer from the Amazon Redshift website.
-
Extract and install the package.
The driver is installed at the default location.
For example:
/opt/amazon/redshift/lib/libamazonredshiftodbc.dylib
-
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
-
Download the driver file provided by Amazon.
-
Run the executable installer.
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