Skip to content
Fivetran logo

Connectors / Data and analytics · HTTP Connector

Automate Fivetran with Tray.ai

Create a connection and create a destination in Fivetran, and start a workflow when Fivetran sends “Sync started”.

What can you do with Fivetran on Tray.ai?

Fivetran is a managed data movement service that copies data from apps, databases and files into warehouses and lakes on a schedule, keeping schemas up to date. Tray.ai connects to Fivetran through the HTTP Connector, so your workflows can call the Fivetran API alongside the rest of your stack.

  • When Fivetran sends “Sync ended”, run the downstream data models in your transformation tool.
  • Create a connection in Fivetran when the data team approves a new data source.
  • Invite a user to Fivetran when an analyst joins the data team in your HR system.
Connects through
HTTP Connector
Authentication
Basic authentication
Base URL
https://api.fivetran.com/v1

Set it up

Connect Fivetran to Tray.ai

Each step uses Fivetran's own API details, from its documentation.

Step 1

Save Fivetran's username and password

Save the credentials Fivetran gives you as a Tray.ai authentication. The HTTP Client sends them as basic auth. They stay out of the workflow and out of the logs.

Step 2

Point the HTTP Client at the API

Add an HTTP Client step and use https://api.fivetran.com/v1 as the base URL. Or paste a cURL example from Fivetran's API docs, and Tray.ai fills in the method, URL, and headers.

Step 3

Start with “List groups”

It's one of 17 documented actions, under Groups. The response comes back as data the next step can map into your other apps.

Step 4

Start workflows from Fivetran events

Give Fivetran the URL of a Tray.ai webhook trigger. “Sync started” can then start a workflow, and so can 1 other event.

Workflows to build with Fivetran

Each one uses actions and events from Fivetran's own API documentation.

Alert the data team when a Fivetran sync ends

When

Sync ended

Then

  1. Post the sync result to the data channel in Slack
  2. Create a Jira issue if the sync failed

With Slack and Jira

Invite new data team members to Fivetran

When

A user is added to the data group in Okta

Then

  1. Invite a user
  2. Update a user with their role

With Okta

Remove Fivetran users when Okta deactivates them

When

A user is deactivated in Okta

Then

  1. List users to find the account
  2. Delete a user

With Okta

Apps you can build on Fivetran data

Internal tools your team can build with an AI assistant, each one using Fivetran calls from its API documentation.

Data sync monitor

Lists connections by group and shows when each sync started and ended so data teams spot late loads.

Fivetran user access review

Lists every user with their role and lets an admin update or remove access during a quarterly review.

Give your AI agents Fivetran tools

Build an MCP server on Fivetran in Agent Gateway and choose which actions your agents can call. Every call runs with access control and an audit trail. How Agent Gateway works

  • Create a connection
  • Create a destination
  • List groups
  • List users
  • List webhooks
  • Update a connection
  • Delete a connection
  • Update a connection schema

What the Fivetran API covers

5 resources and 17 documented actions, each one a call the HTTP Connector can make from a Tray.ai workflow. Connecting it takes a few clicks: here's how.

Connections

  • Create a connection
  • Update a connection
  • Delete a connection
  • Update a connection schema

Destinations

  • Create a destination
  • Update a destination

Groups

  • List groups
  • List connections in a group

Users

  • List users
  • Invite a user
  • Update a user
  • Delete a user

Webhooks

  • List webhooks
  • Create a webhook
  • Update a webhook
  • Delete a webhook
  • Test a webhook

Events Fivetran can send to a Tray.ai webhook trigger

  • Sync started
  • Sync ended

Checked against Fivetran's own documentation on 2026-10-22

fivetran.com/docs/rest-api

Frequently asked questions

What can a Tray.ai workflow do in Fivetran?

+

The Fivetran API documents 17 actions across 5 resources (Connections, Destinations, Groups, Users, Webhooks). For example: Create a connection; Create a destination; List groups. A workflow can make any documented call through the HTTP Connector.

How does Tray.ai authenticate with Fivetran?

+

The Fivetran API uses basic authentication. You save it once as a Tray.ai authentication, and the HTTP Connector adds it to every request.

Which Fivetran events can start a Tray.ai workflow?

+

Fivetran sends 2 events to a webhook URL, for example: Sync started; Sync ended. A Tray.ai webhook trigger receives them and starts a workflow.

See Fivetran working against your stack.

We'll walk through a tailored demo with your systems plugged in.

Great — a couple more details

This helps us connect you with the right person. Optional, and you can skip it.