ODBC for QuickBase

Documentation for QuNect ODBC for QuickBase

First Steps

• Getting Started
• A detailed tour of the DSN dialog
• Application Tokens
• User Tokens instead of passwords for Single Sign On (SSO) organizations
• How to find the APPID of a Quickbase application.
• Writing SQL Statements for QuNect ODBC for QuickBase

Tables

• Accessing Quickbase table reports
• Using a CREATE TABLE and ALTER TABLE statement
• How to find the DBID of a Quickbase table.
• Archiving Records from one Quickbase Application to a copy of the Application
• How to Use Table Aliases
• Getting Started with QuNect Backup

Records

• How many records fit in one keyset?

Fields

• How QuNect ODBC for QuickBase changes Quickbase Field Names to Make them Compatible with Other Databases
• Quickbase User Field Behaviour
• Quickbase Field Names to Avoid
• How to find the FID of a Quickbase field.
• How to Manually set the Size of a Quickbase Field
• Reading and Writing Quickbase Specific Field Properties

• File Attachments

  • Bulk Uploading of Files to File Attachment Fields
  • Copying File Attachments from one Quickbase Table to another Quickbase Table
  • Deleting File attachments from Quickbase
  • Downloading File Attachments from Quickbase into SQL Server

Minimizing Integration Reads

• Minimizing Integration Reads
• Eliminating Integration Reads When Keeping a Quickbase table in Sync with an on Premises Table
• Reducing Integration Reads When Keeping an on Premises Table in Sync with Quickbase
• Schema Caching to Reduce Integration Reads
• Attribute Integration Reads to Each Particular Piece of Code that uses QuNect ODBC for QuickBase

Security

• Security
• 12175 WinHTTPSendRequest A security error occurred

SQL Server

• Creating a Linked Server for Quickbase in SQL Server Using the UI
• Watch how to create a Linked Server for Quickbase in SQL Server Using the UI
• Creating a Linked Server for Quickbase in SQL Server Using SQL
• Writing SQL Statements in SSMS for SQL Server
• Minimizing Integration Reads
• Eliminating Integration Reads When Keeping a Quickbase table in Sync with an on Premises Table
• Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider MSDASQL

• from Quickbase

  • Quickbase Table reports as Views and System Tables in SQL Server
  • Listing all your Quickbase Applications in SQL Server
  • Listing all your Quickbase Tables in SQL Server
  • Writing a Simple Select Statement for Quickbase in SQL Server
  • Synching All Quickbase Tables in SQL Server
  • Mirroring All Quickbase Tables in SQL Server
  • Synching a Quickbase Table in SQL Server
  • Downloading File Attachments from Quickbase into SQL Server
  • Mirroring a Single Quickbase Table in SQL Server
  • Create a table with all the fields in your Quickbase tables

• to Quickbase

  • Mirroring a Quickbase Table to a SQL Server Table with one SQL Statement
  • Mirroring the Schema of a Single SQL Server Table in Quickbase
  • Synching a SQL Server table in Quickbase
  • Copying Records from SQL Server to Quickbase
  • Optimizing SQL Server OPENQUERY with INSERT, UPDATE and DELETE
  • Synchronize a SQL Server table in Quickbase with a trigger
  • Delete Quickbase records when SQL Server deletes occur with a trigger

SSIS

• Build an SSIS Package and run it with Windows Task Scheduler
• Using SQL Agent to Run an SSIS Package
• Creating an SSIS Connection Independent of Machine Architecture
• Creating a Data Source for Quickbase in SQL Server Integration Services (SSIS)
• Sending Errors to a Text File in SQL Server Integration Services (SSIS)
• Creating a Data Source for Quickbase in SQL Server Integration Services (SSIS) and Visual Studio 2017
• Using the Send Mail Task to Report Errors in SSIS
• Using the Script Task to Report Errors in SSIS

Tableau

• Connecting Tableau to Quickbase via QuNect ODBC for QuickBase
• A QuNect TDC file for Tableau
• Using a TDC file with Tableau
• Tableau Custom SQL with QuNect ODBC for QuickBase

Azure

• Connect to QuickBase from an Azure Data Factory

PowerBI

• Working with PowerBI
• PowerBI, faster previews

MS Excel

• Create an Excel Pivot Table Dynamically Linked to QuickBase
• Create an Excel Office 365 Pivot Table Dynamically Linked to QuickBase
• Changing the Quickbase password in an Excel Workbook
• Excel 365 without DSN or Password
• Quickbase to Excel Best Practices

MS Access

• Dynamically Linking Quickbase tables in MS Access Office 365
• Dynamically Linking Quickbase tables in MS Access 2007
• Exporting a table via QuNect ODBC for QuickBase from MS Access
• Using Pass-Through Queries with QuNect ODBC for QuickBase from MS Access (text version)
• Using Pass-Through Queries with QuNect ODBC for QuickBase from MS Access (video version)

Jitterbit

• Jitterbit and QuNect ODBC for QuickBase

VB.Net, VB6 and VBScript

• Backing up a table to a CSV file
• Creating a connection string
• Opening up a table and reading the first column
• Inserting and Adding Records to a Quickbase Table from VBScript
• VB.Net Console Application for Copying Rows from a SQL Server Table to a Quickbase Table
• VB.Net Console Application for Uploading files from a Directory to a Quickbase Table

Supported SQL Syntax

• SQL Syntax Supported by QuNect ODBC for QuickBase
• Using a CREATE TABLE and ALTER statement
• Scalar String Functions Supported by QuNect ODBC for QuickBase
• Scalar Numeric Functions Supported by QuNect ODBC for QuickBase
• Scalar Date and Time Functions Supported by QuNect ODBC for QuickBase
• Scalar Type Conversion Function Supported by QuNect ODBC for QuickBase
• Adding a Master Record and a Linked Detail Record

Licensing

• License for QuNect ODBC for QuickBase

Logging

• Logging SQL statements and API calls with QuNect ODBC for QuickBase
• How to turn on ODBC Tracing in Microsoft Windows
• Minimizing Integration Reads with QuNect ODBC for QuickBase
• Measuring Integration Reads with Quickbase Realm Administration Features

DB Pages

• Reading and Writing DB Pages