Install Posit Professional Drivers for macOS#
Apple Silicon Support
The following drivers are not yet supported and cannot be used on Apple silicon (M1/M2/M3 chips):
- Athena
- Hive
- Impala
- MongoDB
- Oracle
Step 1. Install dependencies#
-
Install the unixODBC driver manager. We recommend using Homebrew since it is the easiest method:
Terminalbrew install unixodbc
Additional steps for using the Oracle database driver
If you are working with the Oracle database, you must:
- Install version 19.21 of the Oracle Instant Client. Either the Basic Package or the Basic Light Package is required.
- Once the zip file is downloaded, follow the installation instructions for Installing Instant Client 19.x on macOS.
For more information on connecting to Oracle Databases look at this support article.
Step 2. Install the drivers#
The drivers are installed using RStudio Desktop Pro:
- Open RStudio Desktop Pro.
- In the Connections pane, click New Connection.
- Select the data source from the list.
- Specify where the driver will be installed (the default path is
/Users/<user>/.local/share/rstudio/odbc/drivers
) and click Next. - After the installation completes, click Next. The driver has now been installed.
- You can either:
- Click Cancel
- Enter the connection details to test and/or establish a connection.
Installing the drivers this way automatically updates entries in the odbcinst.ini
file used by unixODBC.
-
To determine the path to the file that is used, run the following in the terminal:
Terminal$ odbcinst -j
The output may resemble:
TerminalunixODBC 2.3.16 DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources USER DATA SOURCES..: /Users/username/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8
The
DRIVERS...
entry shows the location of theodbcinst.ini
file.
Step 3. Testing database connectivity#
Database connectivity can be tested directly from within RStudio Desktop pro:
- Open RStudio Desktop Pro.
- In the Connections pane, click New Connection.
- Select the data source from the list.
- Enter the requested information and click Test.
- If prompted, enter the database password.
Configure ODBC DSNs for testing and making database connections
If you prefer, you can also set up ODBC DSNs to test and make database connections.
-
DSNs can be defined in
~/.odbc.ini
. For example:File: ~/. odbc.ini[test] Driver = SQLServer Server = my.server.name Database = dbname Port = 1433
-
Then you may access the DSN directly from the New Connection dialog or test from the terminal with the following:
Terminal$ isql test
Uninstallation#
The drivers are uninstalled using RStudio Desktop Pro:
- Open RStudio Desktop Pro.
- Within the Connections pane, click New Connection.
- Select the data source from the list.
- Click Uninstall....
- When prompted to uninstall the driver, click Yes.
This removes the driver files and deletes the driver entry from odbcinst.ini
.