QuNect ODBC for Quick Base on Linux

QuNect ODBC for QuickBase® is the world's first ODBC driver for Intuit's® QuickBase®.

QuNect ODBC for Quick Base allows you to access your data stored in Quick Base directly from many Linux applications including Informatica. It works with the unixODBC driver manager but not the DataDirect driver manager. Although QuNect ODBC for Quick Base functions perfectly with the DataDirect driver manager while it is on trial, once the DataDirect license manager kicks in it prevents the DataDirect driver manager from working with QuNect ODBC for Quick Base.

To use QuNect ODBC for QuickBase on Linux you'll need to have curl installed. Use the most recent version you are comfortable with provided it is later that 7.16.0. The curl API has been very stable since version 7.16.0 released in 2006. According to the curl web site libcurl promises API stability and guarantees compatibility over time. The last time they changed the API in an non-compatible way was for 7.16.0 in 2006 and they plan to never do it again.

Download Free Fully Functional 30 Day Trial

for x64 versions of RHEL 7.x Linux using versions of unixODBC equal to or greater than 2.2.12.
for x64 versions of RHEL 6.x Linux using versions of unixODBC equal to or greater than 2.2.12.
for x64 versions of Ubuntu Linux using versions of unixODBC equal to or greater than 2.2.12.

Installation Instructions

Please download the file libqunect64.so by clicking on the download button above. This can be placed in the directory /usr/lib. The remaining instructions assume that you have. If you have chosen to place it elsewhere make sure to take that into account when following the instructions below. If you're using the unixODBC driver manager, you can find the location of odbcinst.ini and odbc.ini by running the command:

        odbcinst -j
            

Edit the odbcinst.ini to add the following three lines:

[QuickBase]
Description=QuNect ODBC for Quick Base
Driver=/usr/lib/libqunect64.so
            

then you need to add the following lines to your odbc.ini file making sure to replace yourQuickBaseUsername with your Quick Base username, and of course replace yourQuickBasePassword with your Quick Base password.

[QuickBaseViaQuNect]
Driver=QuickBase
Description=QuNect ODBC for Quick Base
uid=yourQuickBaseUsername
pwd=yourQuickBasePassword
QuickBaseServer=yourcompany.quickbase.com
apptoken=yourapptokengeneratedbyquickbase

The name and value pairs you place in the odbc.ini file are the same ones you can put into a QuNect ODBC for Quick Base connection string.

To use a proxy server, just set DETECTPROXY=1 in your odbc.ini file and make sure you have an environment variable called https_proxy.