
The method may vary with different commercial drivers. You will define a Data Source Name (DSN), typically providing information like the server, port, database name, user/password, etc.
#ODBC MANAGER MAC ADD DRIVER INSTALL#
Obtain and install the driver of your choice.įollow the instructions provided with the driver you choose to configure and define the connection. DBeaver DBeaver is a free, multi-platform database. Use the following commands to install the Microsoft ODBC driver 13.1 for SQL Server on OS X 10.11 (El Capitan) and macOS 10.12 (Sierra). While the free PostgreSQL ODBC driver can successfully be used from Windows, you must currently use a commercial ODBC driver on a Mac. The following sections provide instructions for installing previous versions of the Microsoft ODBC driver on macOS.

If you will be using a secure ODBC connection, you will need to download and install the SSL certificate from this page and install it on your local machine.

To confirm that configuration has been completed, and obtain the relevant settings to use when setting up your driver, users can select (username) > External Tool Access.

Learn more in this support topic on the Microsoft support site: These drivers may only be used with BigQuery and may not be used with any other product or service. Note: At this time, only commercial ODBC drivers can be used for using Excel from OSX.
