Follow our setup guide to connect Azure Functions to Fivetran.
Prerequisiteslink
To connect Azure Functions to Fivetran, you must have an Azure function.
Setup instructionslink
Create Azure functionlink
Create your Azure function. See Getting started with Azure Functions for instructions to create your function.
For more information about Azure Function implementation, see our Sample Azure Function.
Generate function keylink
-
Open the Microsoft Azure Portal.
-
On the navigation menu, click Function Apps.
-
Select the function for which you want to create the function key, and then click Manage.
-
Click Add new function key.
-
In the NAME field, enter a name for the new function key.
-
Click Save.
-
Select Click to show and make a note of the function key. You will need it to configure Fivetran.
Finish Fivetran configurationlink
-
In the connector setup form, enter your chosen Destination schema name.
-
Enter your Function App name.
-
Enter your Function Name.
-
Enter the Function Key you created in Step 2.
-
(Optional) Enter your Secrets. Use the following JSON format to enter your secrets:
{ "consumerKey": "", "consumerSecret": "", "apiKey": "yourApiKey" }
For more information on
secrets
, see our Function request and response documentation. -
Click Save & Test.
Fivetran tests and validates the Azure Functions connection. On successful completion of the setup tests, you can sync the data returned by the Azure function to your destination.
Setup testslink
Fivetran performs the following Azure Functions connection tests:
- The Validate Secrets test checks if you have entered the secrets in a valid JSON format.
- The Function Connection test checks if we can connect to your Azure Function and if the function’s response format is correct.
IMPORTANT: The setup tests may timeout if your function’s response size is more than 500 megabytes (MB). In the setup tests request, Fivetran passes the
setup_test
node astrue
; and your function must return a lightweight JSON object that doesn’t exceed 500 MB in size. The 500 MB size limitation is only applicable to the setup tests and not for your syncs.
Related Contentlink
description Connector Overview
settings API Connector Configuration