the container path within LabKey Server), user/password, etc. You will define a Data Source Name (DSN), typically providing information like the server, port, 'database' (i.e. Obtain and install the driver of your choice.įollow the instructions provided with the driver you choose to configure and define the connection. While the free PostgreSQL ODBC driver can successfully be used from Windows, you must currently use a commercial ODBC driver on a Mac.

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. Prerequisite: External ODBC and JDBC Connections.ODBC drivers that are compatible with Excel for MacĪn administrator must already have enabled ODBC connections on LabKey Server following this topic:.Learn more in this support topic on the Microsoft support site: Note: At this time, only commercial ODBC drivers can be used for using Excel from OSX.

Setup jodbc r mac os x