connector-quickbase.md

title	titleSuffix	description	ms.author	author	ms.service	ms.subservice	ms.topic	ms.custom	ms.date
Transform data in Quickbase (Preview)	Azure Data Factory & Azure Synapse	Learn how to transform data in Quickbase (Preview) by using Data Factory or Azure Synapse Analytics.	jianleishen	jianleishen	data-factory	data-movement	conceptual	synapse	02/28/2022

Transform data in Quickbase (Preview) using Azure Data Factory or Synapse Analytics

[!INCLUDEappliesto-adf-asa-md]

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 activities:

• Mapping data flow

Create a Quickbase linked service using UI

Use the following steps to create a Quickbase linked service in the Azure portal UI.

1. Browse to the Manage tab in your Azure Data Factory or Synapse workspace and select Linked Services, then select New:

   Azure Data Factory

   :::image type="content" source="media/doc-common-process/new-linked-service.png" alt-text="Screenshot of creating a new linked service with Azure Data Factory U I.":::

   Azure Synapse

   :::image type="content" source="media/doc-common-process/new-linked-service-synapse.png" alt-text="Screenshot of creating a new linked service with Azure Synapse U I.":::

2. Search for Quickbase (Preview) and select the Quickbase (Preview) connector.

   :::image type="content" source="media/connector-quickbase/quickbase-connector.png" alt-text="Screenshot showing selecting Quickbase connector.":::

3. Configure the service details, test the connection, and create the new linked service.

   :::image type="content" source="media/connector-quickbase/configure-quickbase-linked-service.png" alt-text="Screenshot of configuration for Quickbase 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

Next steps

For a list of data stores supported as sources and sinks by the copy activity, see Supported data stores.