Skip to main content

Fivetran integration for AI agents

Manage Fivetran connections, syncs, and transformations

Fivetran is a Sim integration in the Databases category. Sim is the AI workspace where teams build and deploy AI agents. Sim's Fivetran integration provides 34 tools and 16 triggers that AI agents can use inside Sim's visual workflow builder. Fivetran connects with one-click OAuth. Free to start at sim.ai.

View docs

Last updated

What Sim agents can do with Fivetran

List, create, update, pause, resume, and delete connections, trigger syncs and historical re-syncs, read sync history, warnings, and schema configs, enable or disable schemas and tables, run setup tests, generate Connect Card links, look up connector setup fields, create and inspect groups and destinations, run and cancel transformations, review users, and react to sync, connection, and transformation webhooks.

Category
Databases
Authentication
OAuth
Tools
34
Triggers
16
Documentation
Fivetran docs

How to automate Fivetran with Sim

  1. Create a free account

    Sign up at sim.ai in seconds. No credit card required. Your workspace is ready immediately.

  2. Add a Fivetran block

    Open your workspace, drag a Fivetran block onto the workflow builder, and connect your account with one-click OAuth.

  3. Configure, connect, and run

    Pick the tool you need, wire in an AI agent for reasoning or data transformation, and run. Your Fivetran automation is live.

Fivetran triggers

Add a Fivetran trigger to a Sim agent and it starts a run whenever one of these Fivetran events occurs.

Fivetran Sync Ended

Trigger workflow when a connection sync finishes, succeeds, fails, or is rescheduled

Fivetran Sync Started

Trigger workflow when a connection starts syncing

Fivetran Connection Failed

Trigger workflow when Fivetran fails to connect to a source

Fivetran Connection Succeeded

Trigger workflow when Fivetran connects to a source successfully

Fivetran Connection Created

Trigger workflow when a connection is created

Fivetran Connection Edited

Trigger workflow when connection credentials, sync frequency, or other settings change

Fivetran Connection Paused

Trigger workflow when a connection is paused, by a user or automatically

Fivetran Connection Resumed

Trigger workflow when a connection is resumed

Fivetran Connection Deleted

Trigger workflow when a connection is deleted

Fivetran Manual Sync Triggered

Trigger workflow when someone triggers a manual sync of a connection

Fivetran Connection Re-sync Triggered

Trigger workflow when a historical re-sync of a connection is triggered

Fivetran Table Re-sync Triggered

Trigger workflow when a historical re-sync of a table is triggered

Fivetran Transformation Started

Trigger workflow when a transformation run starts

Fivetran Transformation Succeeded

Trigger workflow when a transformation run succeeds

Fivetran Transformation Failed

Trigger workflow when a transformation run fails

Fivetran All Events

Trigger workflow on any Fivetran sync, connection, or transformation event

Agent templates

Ready-to-use templates featuring Fivetran. Click any to build it instantly.

Fivetran tools

34 Fivetran tools available to Sim agents.

List Connections

List Fivetran connections with their sync state, schedule, and last success or failure, optionally filtered by group or schema name.

Get Connection

Get a Fivetran connection, including its setup, sync, and update state, open tasks and warnings, and schedule.

Create Connection

Create a Fivetran connection in a group. The config object holds the connector-specific settings and the destination naming: schema for most connectors, schema_prefix for databases, or schema and table for file connectors.

Update Connection

Update a Fivetran connection: pause or resume it, change its sync frequency or schedule, or update its configuration.

Pause Connection

Resume Connection

Delete Connection

Delete a Fivetran connection. This cannot be undone.

Sync Connection

Start an incremental sync of a Fivetran connection now, without changing its schedule.

Re-sync Connection

Run a full historical re-sync of a Fivetran connection, or only of the tables listed in scope. Fivetran returns 409 if a running sync cannot finish first.

Re-sync Tables

Run a historical re-sync of specific tables in a Fivetran connection without changing its schedule.

Run Connection Setup Tests

Run the setup tests of a Fivetran connection without changing its configuration, and return each test result.

Get Sync History

List the recent syncs of a Fivetran connection with their outcome, failure reason, and data volume per stage. The time window is at most 7 days and defaults to the last hour.

Get Connection Warnings

List the active warnings on a Fivetran connection, grouped by destination table.

Get Schema Config

Get the schemas, tables, and columns a Fivetran connection syncs, and whether each is enabled.

Reload Schema

Reload the schema config of a Fivetran connection from its source to pick up new schemas, tables, and columns. Large sources can take a long time.

Update Table Sync

Enable or disable syncing of one table in a Fivetran connection, and optionally change its sync mode.

Update Schema Sync

Enable or disable syncing of one schema in a Fivetran connection, optionally changing several of its tables at once.

Update Schema Config

Update how a Fivetran connection handles new schemas, tables, and columns, and enable or disable schemas and tables in one call.

Create Connect Card

Generate a Connect Card link that lets someone authorize and finish setting up a Fivetran connection in a Fivetran-hosted form.

List Groups

List the groups in the Fivetran account. Each group pairs with one destination, so the group ID is also the destination ID.

Get Group

Get a Fivetran group by ID.

Create Group

Create a Fivetran group. Each group holds one destination, so create the group first, then its destination.

List Destinations

List the destinations in the Fivetran account, such as Databricks or Snowflake, with their region and setup status.

Get Destination

Get a Fivetran destination with its region, time zone, and setup status.

Create Destination

Create the destination for a Fivetran group, such as a Databricks workspace. The config object holds the destination-specific connection settings.

Run Destination Setup Tests

Run the setup tests of a Fivetran destination, such as a Databricks workspace, and return each test result.

List Transformations

List Fivetran transformations (dbt Core and Quickstart) with their status, schedule, and last run times.

Get Transformation

Get a Fivetran transformation with its status, schedule, and output models.

Run Transformation

Start a run of a Fivetran transformation now.

Cancel Transformation

Cancel a running Fivetran transformation.

Get Account Info

Get the Fivetran account and the user or system key that the API key belongs to.

List Users

List the users and service accounts in the Fivetran account with their role, status, and last login, for access reviews.

List Connector Types

List the source connector types available in Fivetran, with the service ID to use when creating a connection.

Get Connector Type

Get the configuration and authorization fields a Fivetran connector type takes, to build the config for Create Connection.

Frequently asked questions

Sim's Fivetran integration adds 34 tools and 16 triggers to the AI agents you build in Sim's visual workflow builder. Manage Fivetran connections, syncs, and transformations.

Every agent your company runs. All in one place.