Quickbase
Connectivity Summary
An out-of-the-box connector is available for QuickBase databases to support crawling database objects, profiling sample data, and relationships building.

The drivers used by the connector are mentioned below:
Driver/ API: API
Version: 1.0
Details: APIs URL
https://help.quickbase.com/api-guide/intro.html
https://developer.quickbase.com/
Technical Specifications
The following are the connector capabilities mentioned below:
Crawling
Supported objects for Crawling are:
Tables
Table Columns
Profiling
Table Profiling
Row count, Columns count, View sample data
View Profiling
Row count, Columns count, View sample data
Column Profiling
Min, Max, Null count, distinct, top 50 values
Full Profiling
Supported
Sample Profiling
Not Supported
Lineage Building
Table lineage
Not Yet Supported
Column lineage
Not Yet Supported
Lineage Sources
Querying
Select
Supported
Insert
Not supported, by default.
Update
Not supported, by default.
Delete
Not supported, by default.
Joins within database
Supported
Joins outside database
Not supported
Aggregations
Supported
Group By
Supported
Order By
Supported
By default, the service account provided for the connector will be used for any query operations. If the service account has write privileges, then Insert / Update / Delete queries can be executed.
Pre-requisites
To use the connector, the following need to be available:
Connection details as specified in the following section should be available.
An admin/service account with read privileges.
Connection Details
The following are the connection settings that need to be added for connecting to QuickBase database:
Database Type: Quickbase
License Type: Standard
Connection Name: Select a Connection name for the QuickBase database. The name that you specify is a reference name to easily identify your QuickBase database connection in OvalEdge. Example: Quickbase Connection1
Server: Database instance URL (on-premises/cloud-based) Example: premanvithatatikonda.quickbase.com
Port number: 80
Username: User account login credential (only for MySql Authentication)
Password: Password (only for MySql Authentication)
Once connectivity is established, additional configurations for Crawling and Profiling can be specified.
Crawler configurations
Tables, views & columns
By default, it is selected true
Relationships
Need to select for crawl relationships
Crawler rules
Default includes tables regex has regex = (.*), which can crawl all the tables
Profile Settings
Tables and columns
By default, it is selected true
Views and columns
By default, it is selected true
Profile Rules
Default includes tables regex has regex = (.*), which can profile all the tables
Copyright © 2025, OvalEdge LLC, Peachtree Corners GA USA
Was this helpful?

