QuNect Products

QuNect ODBC for QuickBase

Please watch this getting started video

Read, Write, Modify and Delete your Quickbase Data using any of thousands of ODBC Enabled Applications

New in 2024!

Schema caching to reduce API_GetSchema integration reads now uses a file attachment field to store schemas thereby accommodating tables with schemas exceeding one megabyte.

New in 2023!

Automatically maximizes number of records requested per API_DoQuery call to minimize integration reads.
Schema caching to reduce API_GetSchema integration reads.
WHERE clause scalar functions not dependent on columns are evaluated to literals and passed down to Quickbase.
Reduced memory footprint.

New in 2022!

Caching prepared statements dramatically improves performance
SQL Server INSERT statements and MS Access APPEND queries run ten times faster

New in 2021!

UNION ALL and UNION now supported
SSIS packages now load varchar(max) fields into Quickbase using batch processing
USERTOKEN connection string parameter lets users share Excel spreadsheets without sharing DSNs or passwords

New in 2020!

Uses new usefids parameter in Quickbase's HTTP API API_DoQuery to dramatically reduce network traffic and XML parsing overhead.
Read and write DB pages using SQL statements.
An enhanced QuNect Archive handles archiving of multi-megabyte records with rich text fields containing embedded pictures.

QuNect Backup

Please install the prerequisite QuNect ODBC for QuickBase first!

Please watch this getting started video

To learn more about QuNect Backup please visit its product page.

QuNect Restore

Please install the prerequisite QuNect ODBC for QuickBase first!

Please watch this getting started video

QuNect Restore imports records from the CSV (comma separated values) files created by QuNect Backup. QuNect Restore allows you to selectively choose which records are imported. In advance of importing it will check for missing required values and duplicates in unique fields. In bulk restore mode QuNect Restore traverses a directory of backup files created by QuNect Backup, restoring all the CSV files discovered in the directory and relinks restored child records to their restored parent records. QuNect Restore is available for a 30 day free trial. After the trial expires a license for QuNect ODBC for QuickBase is required. Licensees of QuNect ODBC for QuickBase can use QuNect Restore for free. QuNect Restore requires MS Windows and .NET Framework 4.5.

To learn more about QuNect Restore please visit its product page.

QuNect SQL

Please install the prerequisite QuNect ODBC for QuickBase first!

QuNect SQL builds SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE and DROP TABLE statements with the press of a button. Then you can edit the resulting statement or execute it as is with the press of a button. You can also write your own SQL statements and check their syntax before executing them. QuNect SQL is available for a 30 day free trial. After the trial expires a license for QuNect ODBC for QuickBase is required. Licensees of QuNect ODBC for QuickBase can use QuNect SQL for free. QuNect SQL requires MS Windows and .NET Framework 4.5.

To learn more about QuNect SQL please visit its product page.

QuNect ETL

Please install the prerequisite QuNect ODBC for QuickBase first!

QuNect ETL uploads records from any ODBC enabled database like mySQL, SQL Server, Oracle, MS Access, etc. QuNect ETL can be automated using Windows Task Scheduler or any other command line method. It writes out log files to detail its activity. Each upload job is configured in a simple text file that is created by pointing and clicking on tables and fields. QuNect ETL is available for a 30 day free trial. After the trial expires a license for QuNect ODBC for QuickBase is required. Licensees of QuNect ODBC for QuickBase can use QuNect ETL for free. QuNect ETL requires MS Windows and .NET Framework 4.5.

To learn more about QuNect ETL please visit its product page.

QuNect Copy

Please install the prerequisite QuNect ODBC for QuickBase first!

Please watch this getting started video

QuNect Copy copies records from one Quickbase table to another. QuNect Copy allows you to selectively choose which records are copied by choosing a table report in the source table. QuNect Copy will guess at a field mapping based on matching fields names. You can then adjust the field mapping by remapping columns or ignoring them. QuNect Copy will also copy the all revisions of file attachments if you map file attachment fields to one another. QuNect Copy is available for a 30 day free trial. After the trial expires a license for QuNect ODBC for QuickBase is required. Licensees of QuNect ODBC for QuickBase can use QuNect Copy for free. QuNect Copy requires MS Windows and .NET Framework 4.5.

To learn more about QuNect Copy please visit its product page.

QuNect Razor

Please install the prerequisite QuNect ODBC for QuickBase first!

QuNect Razor finds duplicate field names, empty columns and column names that cause SQL parsing errors. QuNect Razor is available for a 30 day free trial. After the trial expires a license for QuNect ODBC for QuickBase is required. Licensees of QuNect ODBC for QuickBase can use QuNect Razor for free. QuNect Razor requires MS Windows and .NET Framework 4.5.

QuNect Archive

Please install the prerequisite QuNect ODBC for QuickBase first!

Please watch this getting started video

QuNect Archive allows you to reduce your Quickbase table size by moving the data in your text fields into a CSV file that is stored in a file attachment field in an archive table created for that purpose by QuNect Archive. If your table has alot of information in text fields then you can significantly reduce the size of your table. QuNect Archive also creates a formula URL field in your table that will reconstitute the text fields with the data from the CSV file attachment archive. QuNect Archive is available for a 30 day free trial. After the trial expires a license for QuNect ODBC for QuickBase is required. Licensees of QuNect ODBC for QuickBase can use QuNect Archive for free. QuNect Archive requires MS Windows and .NET Framework 4.5.