Send multiple Quickbase tables data to Azure SQL database by COZYROC

This gem ensures that data stored in Quickbase tables can be seamlessly transferred to Azure SQL Database for further processing, reporting, or analytics, leveraging the strengths of both platforms.

This gem will require you to connect and expose your Azure SQL Database to the COZYROC Cloud for seamless data integration and management. To find out how to expose your Azure SQL database to COZYROC Cloud, please refer to article Expose Azure SQL Database to COZYROC Cloud

Setup Guide

This gem will establish a connection between Quickbase and the desired Azure SQL database instance. Once the connection is established, the gem will then pull the data from each Quickbase table specified in the Mapping parameter and send each table data to its allocated table in the Azure SQL database.

When specifying values for the Mapping parameter, please follow the format: QBTableName:"SqlSchema"."SqlTableName". Here the QBTableName and SqlSchema.SqlTableName are separated by colon (:).

For example: Customer:"dbo"."tbl_Customer"

Note: This gem will assume that the destination tables are already created.

To run this gem and connect Quickbase to the Azure SQL database instance, you need to configure the parameters that are mentioned below.

QuickBase

• Server Host Required. The server host is by default set to https://api.quickbase.com/v1. Keep it at default unless there is a new API version available and you want to use the latest version in the base URL.
• Realm Required. Specify your QuickBase domain.
• Token Required. Follow the QuickBase documentation on how to generate a user token. Prefix permanent token with QB-USER-TOKEN {token}. Prefix temporary token with QB-TEMP-TOKEN {token}.
• Application Required. QuickBase application identifier. One way to extract the identifier is by opening the QuickBase application page in a browser. The identifier will be displayed in the navigation link.
• Batch Size Required. The default is set to 200.
• where Optional. The filter, using the Quickbase query language, which determines the records to return.
• sortBy Optional. An json array of field IDs and sort directions.

Azure SQL Database

• Server Name Required. Specify the server name.
• Database Required. Specify the database name.
• Username Required. Specify the username.
• Password Required. Specify the password.

Mapping

• Mapping Required. This parameter accepts comma-separated values if you want to pull data from multiple Quickbase tables and send each Quickbase table data to its allocated table in the Azure SQL database, e.g. Contact:"dbo"."tbl_Contact" etc.