Exploratory Community

Connecting to Oracle Database through ODBC from Mac


Here is how I was able to set up ODBC DSN to connect to Oracle Database, to import Oracle data into Exploratory on Mac.
I used Actual ODBC Driver for Oracle, from Actual Technology.
Their trial version, which limits the query result to only 3 rows until you purchase a license key, is downloadable from their website. http://www.actualtech.com/download.php

  1. Download Actual ODBC Pack from the above website and install.

  2. It will also install ODBC Manager under /Applications/Utility folder. Locate it and double click to start it. ODBC Manager starts up like below. Here I will be adding my new DSN as System-wide DSN, but you can also choose to create a DSN only for your OS account. In that case choose “User DSN” tab.

  3. Click “Add…” to add a new ODBC DSN. A Popup window comes up like following.

  4. Select “Actual Oracle” as the driver for our new ODBC DSN, and click “OK”. Dialog that looks like the following comes up.

  5. Click Continue to see the following dialog.

  6. Name your ODBC DSN and type in the hostname and port of your Oracle Database server. Click Continue.

  7. Type in your Database name. We also recommend checking “Only show user’s schema in table lists” unless you need to do otherwise. (This makes Exploratory’s table info retrieval faster.) Click Continue.

  8. At this point, you can test your connection to your Oracle Database. Click “Test”. If test is successful, you can click Done.

  9. As you can see above, now you have a DSN that connects to Oracle Database. Follow instruction at http://docs.exploratory.io/import/odbc.html to register it to Exploratory, and you are all set to analyze the data in your Oracle Database!