Before configuring an ODBC driver on a Mac, you will need to download and install a Driver Manager, iODBC. Refer to your System Requirements documentation for iODBC versions compatible with your ODBC Driver:
Step 1: Install the ODBC Driver¶ To install the Snowflake ODBC driver for macOS: If you haven’t already downloaded the driver, download it now. For details, see Downloading the ODBC Driver. Double-click on the downloaded.dmg file, snowflakeodbcmac.dmg. ODBC driver manager is not distributed along with our driver and must be installed separately. ODBC Driver for SQLite is compatible with iODBC driver manager. In case when using other ODBC driver managers, ODBC Driver for SQLite will be installed, but it will require manual modification of configuration files of these managers.
iODBC can be downloaded from iODBC.org.
For this example, we are using version 3.52.12.
Download mxkozzzz.dmg file to your computer. Double click mxkozzzz.dmg file to mount the disk image
Double click iODBC-SDK.pkg to run the installer. You will be guided through the steps necessary to install this software. Now you can register your ODBC driver.
Permission setup for iODBC on Mac OS
Allow write permissions to enable value update of USER DSN in iODBC Administrator
- In Finder, from your home {username} folder, go to {username}/Library/ODBC folder and find the file named odbc.ini.
In this blog, we only need to allow the permission in user’s folder because we are only updating value in USER DSN. If you want to use a SYSTEM DSN instead, click “Go” in the finder menu and choose “Go to Folder…” or press Shift + Command + G as shortcut. Type in /Library/ODBC and click on “Go”.
You can find the file named odbc.ini. - Right click on odbc.ini, and choose Get Info option.
- In Sharing & Permission section, ensure your user group has the permission to Read & Write. You might need administrator permission to edit this section. Click on the lock icon at bottom right corner to unlock the permission to edit the list.
the list, click the “+” button at bottom left corner to add yourself. Then select your privilege to see the options and set it as Read & Write.
- Now you are all set with the permission settings.
Yesterday, Simba officially announced our suite of Mac ODBC drivers for Big Data. Every time I go to a Big Data conference like O’Reilly Strata or Hadoop Summit, I see a plethora of Macs. It seems that a lot of Data Scientists use Macs. In fact, Tableau, which seems to be the BI tool of choice in the Big Data space is soon coming out with a Mac version of Tableau. Microsoft Excel on the Mac is also quite popular and many of us have wondered when Microsoft will come out with a full version of Pivot Tables on Mac Excel.
Odbc Updated Driver
The Simba ODBC drivers on the Mac include Hive, HBase, Cassandra, and MongoDB. Some of these drivers are already in production like the Hive Mac ODBC driver we have with Hortonworks. Hortonworks has put together some good resources around this driver including this tutorial document: “Installing and Configuring the Hortonworks ODBC driver on Mac OS X“. If you are using HDP, you can download the Hive Mac ODBC driver here: http://hortonworks.com/products/hdp-2/?b=3#add_ons. Alternatively, you can go to the Simba website and get access to all the ODBC drivers. Some of the Mac ODBC drivers are in Beta so if you can’t find the one you want, please email us: solutions at Simba dot com and we can get you set up quite quickly.
Install Odbc For Microsoft Access
All of the Simba Mac ODBC drivers are based on the SimbaEngine ODBC SDK. SimbaEngine ODBC SDK is the core tool that Simba uses to build all of our drivers. SimbaEngine ODBC SDK is also the tool used by many database companies to build their own ODBC drivers. So, if there is an ODBC driver that you need but can’t find, we can easily build it using SimbaEngine. The advantage of SimbaEngine is that it is fully cross platform. This means SimbaEngine supports Mac, Windows, Linux, Solaris, AIX, and HP/UX. Therefore, an ODBC driver built using SimbaEngine can be deployed on any operating system.