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
See this article Profile Data to know more about Profiling.
| Feature | Support |
| 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
| Lineage Entities | Details |
| Table lineage | Not Yet Supported |
| Column lineage | Not Yet Supported |
| Lineage Sources |
Querying
| Operation | Details |
| 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.
| Property | Details |
| 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 |