QuNect

Application Notes 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.
• How to find the DBID of a Quick Base table.
• Writing SQL Statements for QuNect ODBC for Quick Base

Tables

• 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.
• Bulk Uploading of Files to File Attachment Fields
• Copying File Attachments from one Quick Base Table to another Quick Base Table
• How to Manually set the Size of a Quick Base Field

Security

• Security

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
• Creating a Data Source for Quick Base in SQL Server Integration Services (SSIS)

• 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

• to Quick Base

  • Slaving 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

Tableau

• Working with Tableau

PowerBI

• Working with PowerBI

MS Excel

• Create an Excel Pivot Table Dynamically Linked to QuickBase
• Create an Excel Office 365 Pivot Table Dynamically Linked to QuickBase

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

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