This connection string should not be enclosed in quotes and should be in the following format: This will allow you to enter an iODBC connection string for any of the DSNs listed using the ? command. Library/Application Support/iODBC/bin/iodbctest With this file updated with your Snowflake information you can now test the connection using the following command that is included with iODBC: Testing the Snowflake ODBC Installation and Configuration Here is an example of my local odbc.ini file: ĭriver = /opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib The real configuration comes into play in the ~/Library/ODBC/odbc.ini file. The ~/Library/ODBC/odbcinst.ini should be set up properly. This driver has its configuration files in ~/Library/ODBC/odbcinst.ini and ~/Library/ODBC/odbc.ini. I chose to not install the optional ODBC Manager and configure the connection manually through the odbcinst.ini and odbc.ini files.Īfter iODBC has been installed the next step is to actually install the ODBC driver. Īt the time of writing the link in the Snowflake documentation ( ) is not currently working. Snowflake actually has pretty good documentation for setting up a local environment for Mac OS. īefore digging into this integration I wanted to get my local environment set up so that I could experiment with querying the data outside of the application while we were settling on the presentation of what was to be included in the Snowflake views. After some research I came to the conclusion that one of the only ways to query the Snowflake views was through an ODBC connection using a combination of and. Not tested (probably because I don’t see any point in using SQL Server or other Microsoft technology, let alone Excel): Accessing MSSQL databases from Excel 2011 on Mac OS X 10.7 Lion.Recently I received a request to integrate a connection with an existing Rails application. Next adventures in “Data Land”: Connect from Emacs on my Airbook to a SAS server installed on another Mac running some Windows flavor (probably XP) installed on a USB key through Virtual Box! (I don’t really like the idea, but I have to use SAS for a course.) How about R with the RODBC package? Let’s try it: Mysql > CREATE DATABASE datasets mysql > USE datasets mysql > CREATE TABLE auto ( MAKE char ( 20 ), PRICE double, MPG double, REP78 double, HEADROOM double, TRUNK double, WEIGHT double, LENGTH double, TURN double, DISPLACEMENT double, GEAR_RATIO double, FOREIGNER double ) mysql > LOAD DATA LOCAL INFILE '/Users/chl/Documents/data/auto.txt' INTO TABLE auto FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES mysql > UPDATE auto SET rep78 = NULL WHERE rep78 = - 999 We can also check that it worked directly from the command line: Then I just used ODBC Administrator to configure a User DSN, according to the instructions. I copied the one in the test/ folder in ~/Library/ODBC (which I had to create), and changed absolute paths in there. As I used the tarball, I just copied files in bin/ and lib/ to my /usr/local. Unfortunately, there’s no file libmyodbc3S.so as reported in the above screenshot or in the on-line help. Please note that there is a packaged installer where we can see what’s going to be installed on the system: There are detailed instructions on how to install the ODBC connector from either a binary or source package. For example, the latest release of MySQL Connector/ODBC targets 10.6 (but it should work with 10.7 and onwards). However, ODBC connectors seem to be slowly updated for newer version of OS X. Mac OS X comes with iODBC, installed in /usr/bin. Starting with Mac OS X version 10.6 (Snow Leopard), ODBC Administrator is no longer shipped with the operating system and must be downloaded and installed separately: ODBC Administrator Tool for Mac OS X v1.0, or alternatively we can use ODBC Manager. A brief survey of ODBC and database connectivity on Mac OS X, since I wanted to test ODBC drivers on Stata (see How do I set up an ODBC Data Source Name for Stata on Mac or Linux/Unix?).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |