Application Note for QuNect ODBC for Quick Base

Jitterbit and QuNect ODBC for Quick Base

Jitterbit is an ETL tool that will move data into and out of Quick Base. It can transform the data as it moves it from source to destination as well. In the QuNect ODBC for Quick Base DSN configuration dialog under Characters allowed in field names (except for MS Access) please choose: letters, numbers and underscores, no colons.

This will allow Jitterbit to display the field names in it's mapping configuration dialog. Below is the a screenshot of the dialog that you need to configure in Jitterbit to connect to Quick Base. Notice that you'll need to use the connection string option. In the connection string you just refer to your DSN name. If you've got a 64 bit installation of Jitterbit then you would use DSN=QuickBase via QuNect 64 bit.