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.|
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 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.