Transform data in Quickbase (Preview) using Azure Data Factory or Synapse Analytics
APPLIES TO: Azure Data Factory Azure Synapse Analytics
Tip
Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!
This article outlines how to use Data Flow to transform data in Quickbase (Preview). To learn more, read the introductory article for Azure Data Factory or Azure Synapse Analytics.
Important
This connector is currently in preview. You can try it out and give us feedback. If you want to take a dependency on preview connectors in your solution, please contact Azure support.
Supported capabilities
This Quickbase connector is supported for the following capabilities:
Supported capabilities | IR |
---|---|
Mapping data flow (source/-) | ① |
① Azure integration runtime ② Self-hosted integration runtime
For a list of data stores that are supported as sources/sinks, see the Supported data stores table.
Create a Quickbase linked service using UI
Use the following steps to create a Quickbase linked service in the Azure portal UI.
Browse to the Manage tab in your Azure Data Factory or Synapse workspace and select Linked Services, then select New:
Search for Quickbase (Preview) and select the Quickbase (Preview) connector.
Configure the service details, test the connection, and create the new linked service.
Connector configuration details
The following sections provide information about properties that are used to define Data Factory and Synapse pipeline entities specific to Quickbase.
Linked service properties
The following properties are supported for the Quickbase linked service:
Property | Description | Required |
---|---|---|
type | The type property must be set to Quickbase. | Yes |
url | The application URL of the Quickbase service. | Yes |
userToken | Specify a user token for the Quickbase. Mark this field as SecureString to store it securely. Or, you can reference a secret stored in Azure Key Vault. | Yes |
Example:
{
"name": "QuickbaseLinkedService",
"properties": {
"type": "Quickbase",
"typeProperties": {
"url": "<application url>",
"userToken": {
"type": "SecureString",
"value": "<user token>"
}
}
}
}
Mapping data flow properties
When transforming data in mapping data flow, you can read tables from Quickbase. For more information, see the source transformation in mapping data flows. You can only use an inline dataset as source type.
Source transformation
The below table lists the properties supported by Quickbase source. You can edit these properties in the Source options tab.
Name | Description | Required | Allowed values | Data flow script property |
---|---|---|---|---|
Table | Data flow will fetch all the data from the table specified in the source options. | Yes when use inline mode | - | table |
Report | Data flow will fetch the specified report for the table specified in the source options. | No | - | report |
Quickbase source script examples
source(allowSchemaDrift: true,
validateSchema: false,
store: 'quickbase',
format: 'rest',
table: 'Table',
report: 'Report') ~> Quickbasesource
Related content
For a list of data stores supported as sources and sinks by the copy activity, see Supported data stores.