QuNect ODBC for QuickBase on Linux

QuNect ODBC for QuickBase� is the world's first ODBC driver for Quick Base�.

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.

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 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, yourQuickBasePassword with your Quickbase password, yourapptokengeneratedbyquickbase with an application token and yourcompany.quickbase.com with your QuickBaseServer. Please read the section entitled Create and assign an application token on the Quickbase help page entitled Application Tokens to learn how to get your application tokens. If you use a user token for your password then you don't need an application token. If you do use a user token for your password then be sure to add the line pwdispassword=0 to your DSN.

Using a Password

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

Using a User Token

[QuickBaseViaQuNect]
Driver=QuickBase
Description=QuNect ODBC for QuickBase
uid=yourQuickBaseUsername
pwd=yourQuickBaseUserToken
QuickBaseServer=yourcompany.quickbase.com
pwdispassword=0

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.