Fivetran Activations (formerly Census) integrations

Azure Blob Storage. Exports warehouse data from Fivetran Activations as CSV, TSV, JSON, NDJSON or Parquet files in Azure Blob Storage, with date variables in the path and optional PGP encryption.

SFTP. Delivers warehouse data from Fivetran Activations to your SFTP server as CSV, TSV, JSON, NDJSON or Parquet files, signing in with a password or SSH key pair.

PostgreSQL (destination). Writes rows into PostgreSQL tables from Fivetran Activations, matching on primary keys or unique columns, with insert, upsert, update and mirror options.

PostgreSQL (source). Reads PostgreSQL tables and views for Fivetran Activations syncs with read-only grants, plus a CENSUS schema it manages unless you work in read-only mode.

MySQL (destination). Writes warehouse rows into MySQL tables from Fivetran Activations, matching on primary keys or unique columns, with an optional SSH tunnel.

MySQL (source). Gives Fivetran Activations read-only access to MySQL tables and views to sync to destinations, connecting through IP allow lists or an SSH tunnel where needed.

Kafka. Publishes messages to a Kafka topic from Fivetran Activations as flat JSON or a mustache template, connecting through bootstrap servers with a username and password.

Microsoft SQL Server (destination). Writes rows into Microsoft SQL Server tables from Fivetran Activations, matching on primary keys or unique columns that are not uniqueidentifier types.

Microsoft SQL Server (source). Reads Microsoft SQL Server tables and views for Fivetran Activations syncs, with extra permissions when the Advanced Sync Engine tracks state in the warehouse.

Azure Synapse. Gives Fivetran Activations read-only access to Azure Synapse tables and views over a SQL Server JDBC driver, so their rows can be synced to destinations.

Microsoft Fabric. Connects a Microsoft Fabric warehouse or lakehouse SQL endpoint to Fivetran Activations as a source through a service principal given access to the workspace.

MongoDB. Syncs warehouse data into a MongoDB database from Fivetran Activations through a connection string, casting 24-character hex identifiers to ObjectIDs.

Elasticsearch (destination). Indexes warehouse records as Elasticsearch documents by document ID from Fivetran Activations, with upsert and mirror syncs authenticated by an API key.

Elasticsearch (source). Queries an Elasticsearch deployment as a Fivetran Activations source through Elastic's SQL JDBC driver, connecting with the deployment endpoint, port, user and password.

Amazon EventBridge. Publishes changes in warehouse data as events to an Amazon EventBridge bus from Fivetran Activations, connecting through a cross-account IAM role in your AWS region.

Google Drive. Saves warehouse data as CSV, JSON and other files in a Google Shared Drive folder from Fivetran Activations, shared with a Google identity email the platform supplies.

ClickHouse. Connects a ClickHouse database to Fivetran Activations as a source with a database user, optionally through an SSH tunnel, and supports only the Basic Sync Engine.

Oracle Database. Writes rows into Oracle Database tables from Fivetran Activations, matching on primary keys or unique columns, with TLS on port 2484 or an SSH tunnel.

Trino. Uses Trino, with any supported Trino catalog, as a Fivetran Activations source over JDBC, including the Starburst Galaxy and Starburst Enterprise distributions.

Box. Writes files of warehouse data from Fivetran Activations into a Box folder over OAuth, with date-based file paths and a 50MB size limit per file.

SingleStore. Gives Fivetran Activations read-only access to SingleStore tables and views to sync to destinations, with support for region limits and IP allow lists.

Amazon Athena. Runs Amazon Athena queries in a chosen workgroup for Fivetran Activations syncs, with IAM keys or a cross-account role and an S3 bucket for query results.

Amazon DynamoDB. Syncs warehouse rows into Amazon DynamoDB tables from Fivetran Activations, keyed on the partition key and connected through cross-account role-based access.

Greenplum. Reads Greenplum tables and views for Fivetran Activations syncs, keeping sync state on the platform's own servers or, with the Advanced Sync Engine, in a schema in your database.

Workday. Updates or creates Workday organizations from Fivetran Activations through an integration system user, keeping HR records in line with the warehouse.

AlloyDB (destination). Writes warehouse data into Google AlloyDB tables from Fivetran Activations through Google's Auth proxy, matching rows on primary keys or unique columns.

AlloyDB (source). Reads Google AlloyDB tables and views through Google's Auth proxy so Fivetran Activations can sync them onward, with an optional SSH tunnel for private networks.

Anaplan. Loads warehouse data into Anaplan financial models by running file-based import actions from Fivetran Activations, with Anaplan user credentials or a self-service OAuth client.

dbt. Brings dbt models from a GitHub, GitLab or Bitbucket repository into Fivetran Activations as sync sources, and can run syncs after dbt Cloud rebuilds them.

Pinecone. Upserts and mirrors records in a Pinecone index from Fivetran Activations with a Pinecone API key, through a destination that is still in beta.

Google Cloud SQL for PostgreSQL. Reads tables and views from Google Cloud SQL for PostgreSQL so Fivetran Activations can sync them, with a CENSUS schema for its own tables unless run read-only.

Google Datastore. Upserts records into Google Datastore from Fivetran Activations through a Google service account that you grant the Cloud Datastore User role in your project.

Labelbox. Sends datasets from your warehouse to Labelbox via a partner-built destination in Fivetran Activations, whose setup guide Labelbox hosts.

MotherDuck. Connects MotherDuck to Fivetran Activations as a source with a MotherDuck service token, using only the Basic Sync Engine.

turbopuffer. Upserts and mirrors records in turbopuffer namespaces from Fivetran Activations with an API key, through a destination that is in beta.

Marketo. Syncs Marketo leads, named accounts, custom objects, static list membership and custom activities from Fivetran Activations through Marketo's REST API endpoint.

Airship. Sends events to Airship from Fivetran Activations and keeps its static lists and email channels current, using an Airship token and your region.

Attentive. Updates existing Attentive users by email or phone number and sends user events from Fivetran Activations through an OAuth connection.

Oracle Eloqua. Upserts Oracle Eloqua contacts, contact lists and custom objects from Fivetran Activations through an OAuth connection to your Eloqua account.

Oracle Responsys. Upserts recipients in Oracle Responsys profile lists and profile extension tables from Fivetran Activations, signing in as a Responsys user with API access.

Emarsys. Upserts Emarsys contacts on an indexed field and mirrors contact list membership by email from Fivetran Activations, using an Emarsys API user and secret.

ActiveCampaign. Syncs contacts, accounts and custom objects from Fivetran Activations into ActiveCampaign with its API URL and key, and can add contacts to lists from an array column.

Customer.io. Syncs people, devices, events, collections, manual segments and objects to Customer.io from Fivetran Activations, using a site ID with Track and App API keys.

MoEngage. Upserts MoEngage customers and sends events from Fivetran Activations with a Data API ID and key, the app ID and the REST endpoint that matches your MoEngage URL.

Pardot. Updates or creates Pardot prospects by Pardot ID or email from Fivetran Activations over OAuth, and can add prospects to lists through a lookup.

Sailthru. Updates or creates Sailthru users by email from Fivetran Activations, connecting with the API credentials from your Sailthru account.

Brevo. Upserts Brevo contacts by email or external ID from Fivetran Activations and mirrors their list membership, connecting with a Brevo API key.

Campaign Monitor. Adds and updates Campaign Monitor subscribers by email from Fivetran Activations with a Campaign Monitor API key, and also offers a mirror sync.

Mandrill. Sends emails from existing Mailchimp Transactional (Mandrill) message templates with Fivetran Activations, passing extra fields as merge variables, using a Mandrill API key.

Bloomreach. Sends customer attributes and events from Fivetran Activations to Bloomreach, matching customers on registered or cookie IDs, with Bloomreach API keys and a project token.

CleverTap. Sends events and upserts CleverTap profiles from Fivetran Activations with an account ID, passcode and region, matching profiles on identity or other supported IDs.

Mailgun. Adds Mailgun mailing list members and sends messages by email address from Fivetran Activations, using an API key and your Mailgun sending domain.

Ortto (Autopilot Journeys). Upserts contacts by email into Autopilot Journeys from Fivetran Activations, using an Autopilot API key copied or generated on its Autopilot API settings page.

Ortto (people and organizations). Syncs people and organizations to Ortto from Fivetran Activations with an API key from an Ortto custom API data source, set to your US, AU or EU region.

Postscript. Updates existing Postscript subscribers by ID from Fivetran Activations, connecting with the private key from Postscript's API settings.

Vero. Sends events and upserts users by email in Vero Cloud from Fivetran Activations, connecting with a Vero auth token.

Courier. Updates Courier recipient profiles and list membership from Fivetran Activations with a Courier API key, so notifications can use current user attributes.

Loops. Syncs contacts and triggers loops in Loops from warehouse data with Fivetran Activations, through a destination that Loops built and documents as a partner.

Constant Contact. Upserts Constant Contact contacts by email into existing contact lists from Fivetran Activations, after you sign in to Constant Contact to authorize access.

Criteo. Syncs warehouse audiences to Criteo audience segments from Fivetran Activations over OAuth, matching people on email, mobile ad IDs, GUM cookie IDs or LiveRamp IDs.

Pinterest. Syncs customer lists and sends conversions to Pinterest from Fivetran Activations over OAuth, which needs admin rights on the Pinterest business account.

The Trade Desk. Syncs CRM data segments, conversion events and campaign, ad group, advertiser and tracking tag records to The Trade Desk from Fivetran Activations.

X Ads. Mirrors audiences and sends web and mobile conversion events to X Ads from Fivetran Activations, once X approves the account for audience access.

Amazon Ads. Sends conversion events and hashed customer records to Amazon Ads DSP from Fivetran Activations over OAuth and keeps DSP audiences current, with country fields for DMA.

Reddit. Sends conversion events and mirrors email or mobile ad ID audiences to Reddit Ads from Fivetran Activations over OAuth, with conversions open only to managed accounts.

Google Display & Video 360. Syncs Customer Match audiences of contact details or mobile device IDs to Google Display & Video 360 from Fivetran Activations, with one OAuth connection per advertiser.

Rokt. Sends events and syncs email-based custom audiences to Rokt from Fivetran Activations, using your Rokt account ID with an API key and a public-private key pair.

Google Campaign Manager 360. Sends offline conversions from Fivetran Activations to Google Campaign Manager 360 over OAuth, tied to Floodlight activities, with one connection per advertiser.

Singular. Sends events and sessions from Fivetran Activations to Singular through its server-to-server (S2S) integration, for attribution and ROI reporting.

Impact.com. Sends conversion records from Fivetran Activations to Impact, authenticated with the Impact account SID and auth token.

Yahoo DSP. Fills Yahoo DSP email audiences from Fivetran Activations, hashing addresses or taking them prehashed, once Yahoo has enabled DSP API access.

Google Search Ads 360. Sends conversion events from Fivetran Activations to Google Search Ads 360 through an OAuth connection, keyed on a conversion ID.

LiveIntent. Builds LiveIntent custom audiences from Fivetran Activations with email, AAID and IDFA identifiers, using credentials from your LiveIntent account team.

Spotify Ads. Mirrors custom audiences and sends Conversions API events to Spotify Ads from Fivetran Activations, hashing raw emails and device IDs with SHA-256 first.

Kevel. Syncs Fivetran Activations segments to Kevel as user interests keyed on the user key, using a Kevel API key and network ID, for custom ad platforms.

CJ Affiliate. Sends order records from Fivetran Activations to CJ Affiliate, authenticated with a personal access token generated in CJ's developer portal.

RollWorks. Replaces RollWorks CRM audiences with email lists from Fivetran Activations after you authorize your RollWorks or AdRoll account.