Quickbase
Quickbase ETL connector for data replication
Snapshot
Integrate Quickbase with Daton
Signin to Daton
Select Quickbase from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your Quickbase api token, Quickbase app id and Quickbase realm Host name to authorize Daton to periodically extract data Quickbase.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
Workflow
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Quickbase Data
Reports
Purpose: Get the schema (properties) of all reports for a table. If the user running the API is an application administrator, the API will also return all personal reports with owner's user id.
Source-Api documentation: https://developer.quickbase.com/operation/getTableReports
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Relationships
Purpose: Get a list of all relationships, and their definitions, for a specific table. Details are provided for both the parent and child sides of relationships within a given application. Limited details are returned for cross-application relationships.
Source API Documentation https://developer.quickbase.com/operation/getRelationships
Replication: Full Replication
Replication Key: NA
Fields
Fields
Purpose: Gets the properties for all fields in a specific table. The properties for each field are the same as in Get field.
Source API Documentation https://developer.quickbase.com/operation/getFields
Replication: Full Replication
Replication Key: NA
Fields
Tables
Purpose: Gets a list of all the tables that exist in a specific application. The properties for each table are the same as what is returned in Get table.
Source API Documentation https://developer.quickbase.com/operation/getAppTables
Replication: Full Replication
Replication Key: NA
Fields
UsageFields
Purpose: Get all the field usage statistics for a table. This is a summary of the information that can be found in the usage table of field properties.
Source API Documentation https://developer.quickbase.com/operation/getFieldsUsage
Replication: Full Replication
Replication Key: NA
Fields
App
Purpose: Returns the main properties of an application, including application variables.
Source API Documentation https://developer.quickbase.com/operation/getApp
Replication: Full Replication
Replication Key: NA
Fields
Last updated