QuNect ODBC for Quick Base on Linux
QuNect ODBC for QuickBase® is the world's first ODBC driver for Quick Base®.
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.
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:
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, yourQuickBasePassword with your Quick Base 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 Quick Base 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 Quick Base uid=yourQuickBaseUsername pwd=yourQuickBasePassword QuickBaseServer=yourcompany.quickbase.com apptoken=yourapptokengeneratedbyquickbase pwdispassword=1
Using a User Token
[QuickBaseViaQuNect] Driver=QuickBase Description=QuNect ODBC for Quick Base 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 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.