Use Caselink
You want to programmatically create connectors at scale without using the Fivetran dashboard.
The following are the most common use cases:
- Powered by Fivetran
- Enterprise: Different Business Units
Recommendationslink
Our REST API is a crucial aspect of limiting manual work for setting up dozens or hundreds of connectors.
Once you know the destination you are using and have connected it to a Fivetran group, you can begin creating connectors using Connector Management.
Processlink
-
Find the source Connector Config that you want to sync.
-
In the request body of the Create a Connector endpoint, replace the
config
field with the specific connector’s config from Step 1. -
Change the payload parameters in the request body to the
service
andgroup_id
. -
Send a
POST
request to the Create a Connector endpoint. -
Validate that the new connector has been created successfully. Check that you’ve received the correct HTTP 201 response from Fivetran’s REST API.
-
(Optional) Send a
PATCH
request to the Modify a Connector endpoint to make additional changes to any of the following:- Sync frequency
- Daily sync time
- Schedule type (auto or manual)
- Authentication
- Config parameters
-
Repeat Steps 1 through 5 to set up additional sources.
Common Use Caseslink
See the following use cases and Connector Management API FAQ pages:
Considerationslink
-
Our REST API is available only for Standard Select, Standard, Enterprise, and Business Critical accounts.
-
Powered by Fivetran customers can leverage this process programmatically to implement a smooth customer onboarding process for all of your service applications or databases.