QuNect ODBC for QuickBase on Linux

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

QuNect ODBC for QuickBase allows you to access your data stored in QuickBase directly from many Linux applications including Informatica. It works with the unixODBC driver manager but not the DataDirect driver manager. Although QuNect ODBC for QuickBase 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 QuickBase.

Download Free Fully Functional 30 Day Trial

for x64 versions of RHEL 5.x Linux using versions of unixODBC 2.2.12 and beyond.
for x64 versions of RHEL 6.x Linux using versions of unixODBC 2.2.12 and beyond.
for x64 versions of RHEL 5.x Linux using versions of unixODBC before 2.2.12.
for x64 versions of RHEL 6.x Linux using versions of unixODBC before 2.2.12.
for x64 versions of Ubuntu Linux using versions of unixODBC before 2.2.12.
for x64 versions of Ubuntu Linux using versions of unixODBC 2.2.12 and beyond.

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 QuickBase
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 QuickBase username, and of course replace yourQuickBasePassword with your QuickBase password.

[QuickBaseViaQuNect]
Driver=QuickBase
Description=QuNect ODBC for QuickBase
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 QuickBase 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.