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
Details: APIs URL
The following are the connector capabilities mentioned below:
Supported objects for Crawling are:
- Table Columns
See this article Profile Data to know more about 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|
|Sample Profiling||Not Supported|
|Table lineage||Not Yet Supported|
|Column lineage||Not Yet 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|
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.
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.
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)
- Port number: 80
- Username: User account login credential (only for MySql Authentication)
- Password: Password (only for MySql Authentication)
|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|
|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|