[ODBC Data Sources] CData GoogleAnalytics Source = CData ODBC Driver for GoogleAnalytics. This file contains ODBC drivers registered with the driver manager. With iODBC, drivers can be available to only one user account or drivers can be available system wide.
Note You need to control-click the package, and click Open to affirm that you really do want to open it, because Qubole is not currently an identified developer for the Mac. Qubole expects to rectify this shortly. In the folder that opens, click the icon labelled Qubole Mac ODBC Driver Installer.pkg. Click Agree to accept the software license agreement and the dialog is illustrated here.
Click Continue and on the resulting screen, click Install and the dialog is illustrated here. To launch the installation, provide an Administrator password for your Mac and the dialog is illustrated here. You should see a confirmation that the software was installed successfully as illustrated here. Testing the Installation To run a simple test:. Run the command: '/Library/Application Support/iODBC/bin/iodbctest' (Make sure you include the single quotes, or the space between Application and Support will cause the command to fail.). In the command-line utility, enter? To see a list of available data sources.
At the prompt, enter dsn=Qubole ODBC Driver DSN. At the SQL prompt, enter the SHOW TABLES command. To test the driver with Microsoft Excel:.
Open a new Excel Worksheet. In Data tab, choose Select New Database Query from Database option.
Gdal Driver List
Go to the System DSN tab and choose the appropriate driver, then click OK. Leave the username and password blank if prompted, and click OK.