ODBC for Quick Base

Documentation for QuNect ODBC for Quick Base

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 Quick Base application.
• Writing SQL Statements for QuNect ODBC for Quick Base

Tables

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

Fields

• How QuNect ODBC for Quick Base changes Quick Base Field Names to Make them Compatible with Other Databases
• Quick Base User Field Behaviour
• Quick Base Field Names to Avoid
• How to find the FID of a Quick Base field.
• How to Manually set the Size of a Quick Base Field

• File Attachments

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

Security

• Security
• 12175 WinHTTPSendRequest A security error occurred

SQL Server

• Creating a Linked Server for Quick Base in SQL Server Using the UI
• Watch how to create a Linked Server for Quick Base in SQL Server Using the UI
• Creating a Linked Server for Quick Base in SQL Server Using SQL
• Writing SQL Statements in SSMS for SQL Server
• Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider MSDASQL

• from Quick Base

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

• to Quick Base

  • Mirroring a Quick Base Table to a SQL Server Table with one SQL Statement
  • Mirroring the Schema of a Single SQL Server Table in Quick Base
  • Synching a SQL Server table in Quick Base
  • Copying Records from SQL Server to Quick Base
  • Optimizing SQL Server OPENQUERY with INSERT, UPDATE and DELETE
  • Synchronize a SQL Server table in Quick Base with a trigger
  • Delete Quick Base 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 Quick Base in SQL Server Integration Services (SSIS)
• Sending Errors to a Text File in SQL Server Integration Services (SSIS)
• Creating a Data Source for Quick Base 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 Quick Base 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
• Excel 365 without DSN or Password

MS Access

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

Jitterbit

• Jitterbit and QuNect ODBC for Quick Base

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 Quick Base Table from VBScript
• VB.Net Console Application for Copying Rows from a SQL Server Table to a Quick Base Table
• VB.Net Console Application for Uploading files from a Directory to a Quick Base Table

Supported SQL Syntax

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

Licensing

• License for QuNect ODBC for Quick Base

Logging

• Logging SQL statements and API calls with QuNect ODBC for Quick Base
• How to turn on ODBC Tracing in Microsoft Windows
• Minimizing API calls with QuNect ODBC for Quick Base

DB Pages

• Reading and Writing DB Pages