Salesforce to BigQuery

Each of these CDPs lists a connector that reads from Salesforce and one that sends data to BigQuery. A route is a possible path, not a tested one: what travels depends on each connector, so check the documentation links.

• AMAmperity

  Reads from Salesforce

  Salesforce → Amperity

  Salesforce Sales Cloud (source). Pulls customer records from Salesforce Sales Cloud objects and reports into Amperity through its REST API, loading them in full each run.

  Docs ↗

  Sends to BigQuery

  Amperity → BigQuery

  Google BigQuery (destination). Gets Amperity data into Google BigQuery by sending Parquet or CSV files to cloud storage first, then loading them for analysis.

  Docs ↗

  Amperity ⇄ BigQuery

  Google BigQuery (Amperity Bridge). Shares data both ways between Amperity and Google BigQuery through Amperity Bridge, using BigQuery sharing exchanges rather than file exports.

  Docs ↗
• BLBlueConic

  Reads from Salesforce

  BlueConic ⇄ Salesforce

  Imports Salesforce records into BlueConic by object or SOQL query, including Service Cloud cases as timeline events, and exports segment profiles to Salesforce objects in batches.

  Docs ↗

  Sends to BigQuery

  BlueConic ⇄ BigQuery

  Imports BigQuery tables into BlueConic profiles and timeline events and exports profile and timeline data to BigQuery tables, replacing or partitioning a table on each batch run.

  Docs ↗
• CLCleverTap

  Reads from Salesforce

  Salesforce → CleverTap

  Import. Syncs standard and custom Salesforce objects into CleverTap profiles through a CleverTap package from AppExchange, sent per change or in 5 to 60 minute batches, available as an add-on.

  Docs ↗

  Sends to BigQuery

  CleverTap → BigQuery

  Export. Exports CleverTap data to Google BigQuery through Google Cloud Storage on a schedule, for analysis and reporting alongside other business data.

  Docs ↗
• INInformatica

  Reads from Salesforce

  Informatica ⇄ Salesforce

  Syncs Salesforce accounts, person accounts, contacts, relationships and hierarchies with Informatica Customer 360 SaaS both ways, in batches or real time, merging duplicates if you choose.

  Docs ↗

  Sends to BigQuery

  Informatica → BigQuery

  Publishes Informatica MDM SaaS master data to a Google BigQuery staging store and a sample analytical schema, with SQL views for customer, supplier, location and product reporting.

  Docs ↗
• IOInsider One

  Reads from Salesforce

  Salesforce → Insider One

  Pulls Salesforce contacts, leads, accounts or custom SOQL results into Insider One on a cron schedule through the REST API and OAuth, as incremental or full syncs.

  Docs ↗

  Sends to BigQuery

  Insider One → BigQuery

  Export. Gets Insider One events, their parameters and chosen user attributes into BigQuery by exporting CSV files to your Google Cloud Storage bucket for your own pipeline to load.

  Docs ↗
• KLKlaviyo

  Reads from Salesforce

  Salesforce → Klaviyo

  Syncs custom property data for each Salesforce lead into Klaviyo every hour, to target and personalize messages using CRM lead data.

  Docs ↗

  Sends to BigQuery

  Klaviyo → BigQuery

  Sends Klaviyo profile data, event data or both into BigQuery, and can skip events coming from integrations that BigQuery already receives.

  Docs ↗
• LYLytics

  Reads from Salesforce

  Lytics ⇄ Salesforce

  Imports Salesforce leads, opportunities and custom objects into Lytics and creates or updates Salesforce objects from Lytics audience members in real time.

  Docs ↗

  Sends to BigQuery

  Lytics ⇄ BigQuery

  Imports BigQuery tables into Lytics and exports user profiles, events, audience changes and definitions, metrics and system events from Lytics to BigQuery tables.

  Docs ↗
• MPmParticle

  Reads from Salesforce

  Salesforce → mParticle

  Sales and Service Cloud feed. Brings Salesforce Sales Cloud and Service Cloud records, such as leads and cases, into mParticle as a feed.

  Docs ↗

  Sends to BigQuery

  mParticle → BigQuery

  Audiences. Writes mParticle audience membership to tables in a BigQuery dataset in your Google Cloud project.

  Docs ↗

  mParticle → BigQuery

  Warehouse. Loads incoming mParticle data into a BigQuery dataset so you can query it directly with SQL.

  Docs ↗
• RGRedpoint Global

  Reads from Salesforce

  Redpoint Global ⇄ Salesforce

  CRM channel. Keeps Salesforce leads, contacts or accounts in step with the Redpoint Interaction data warehouse, syncing either way through mapped fields and the Salesforce SOAP service.

  Docs ↗

  Redpoint Global ⇄ Salesforce

  Data Management. Reads Salesforce objects into Redpoint Data Management with SOQL queries and inserts, updates or deletes them with the Salesforce Output tool over the SOAP endpoint.

  Docs ↗

  Sends to BigQuery

  Redpoint Global ⇄ BigQuery

  Data Management. Bulk loads Google BigQuery tables from Redpoint Data Management with application default credentials or a service account, mapping its data types to BigQuery types.

  Docs ↗

  Redpoint Global ⇄ BigQuery

  Interaction. Sets up the Simba ODBC driver for Google BigQuery in the Redpoint Interaction Docker image, so RPI can reach BigQuery through a configured data source.

  Docs ↗
• SESegment

  Reads from Salesforce

  Salesforce → Segment

  Source. Pulls Salesforce objects into Segment on a schedule for syncing to a warehouse.

  Docs ↗

  Sends to BigQuery

  Segment → BigQuery

  Loads Segment event data into BigQuery on a schedule as a storage destination, ready for SQL analysis.

  Docs ↗
• TETealium

  Reads from Salesforce

  Salesforce → Tealium

  Apex triggers. Sends Salesforce lead and contact updates to Tealium Collect from Apex triggers and a TealiumCollect class, linking them to Customer Data Hub records through a Tealium ID field.

  Docs ↗

  Salesforce → Tealium

  Bulk data source. Imports records from a Salesforce object into Tealium as events on an hourly, daily or weekly schedule through the Bulk API 2.0, in early access for select customers.

  Docs ↗

  Sends to BigQuery

  Tealium → BigQuery

  Google BigQuery. Appends records (singly or batched), sends full event, visitor and log data and runs custom statements in Google BigQuery from AudienceStream or EventStream.

  Docs ↗
• TATreasure AI

  Reads from Salesforce

  Salesforce → Treasure AI

  Import. Imports Salesforce objects into Treasure Data with optional SOQL queries over related objects, using the Bulk API for large volumes, to combine CRM data with other sources.

  Docs ↗

  Sends to BigQuery

  Treasure AI → BigQuery

  Export v1. Writes Treasure Data job results into a BigQuery table that matches a predefined schema, in append, replace, replace backup or delete mode, with server-to-server API authentication.

  Docs ↗

  Treasure AI → BigQuery

  Export v2. Uploads large Treasure Data result sets to BigQuery as Parquet files through BigQuery load jobs, with append, replace, replace backup or truncate modes and JSON key or WIF sign-in.

  Docs ↗

  Treasure AI → BigQuery

  Open Catalog Access. Exposes Treasure Data's Iceberg tables to BigQuery as a federated dataset through BigQuery Omni, an experimental Open Catalog Access option that is not enabled by default.

  Docs ↗
• ZEZeotap

  Reads from Salesforce

  Salesforce → Zeotap

  Source. Syncs standard and custom Salesforce CRM objects, such as accounts, contacts and leads, into Zeotap daily, weekly or monthly through a connected app, keeping user IDs for matching.

  Docs ↗

  Sends to BigQuery

  Zeotap → BigQuery

  Analytics Hub. Shares Zeotap's unified profile store, with profile, consent, ID and campaign data, with your service accounts through a private BigQuery Analytics Hub listing you subscribe to.

  Docs ↗

  Zeotap → BigQuery

  Destination. Sends Zeotap segments with any identifiers and attributes into a BigQuery project, dataset and table, with a Google Cloud Storage bucket and folder also set up for the transfer.

  Docs ↗

Each of these CDPs lists a connector that reads from BigQuery and one that sends data to Salesforce.

• ACActionIQ

  Reads from BigQuery

  BigQuery → ActionIQ

  BigQuery

  Sends to Salesforce

  ActionIQ → Salesforce

  Salesforce Sales Cloud
• AEAdobe Experience Platform

  Reads from BigQuery

  BigQuery → Adobe

  Brings Google BigQuery table data into Experience Platform for Real-Time CDP Ultimate customers.

  Docs ↗

  Sends to Salesforce

  Adobe → Salesforce

  Destination. Sends Real-Time CDP audiences and profile attributes to Salesforce CRM as either leads or contacts, keeping audience membership current through the composite API.

  Docs ↗
• AMAmperity

  Reads from BigQuery

  Amperity ⇄ BigQuery

  Google BigQuery (Amperity Bridge). Shares data both ways between Amperity and Google BigQuery through Amperity Bridge, using BigQuery sharing exchanges rather than file exports.

  Docs ↗

  Sends to Salesforce

  Amperity → Salesforce

  Salesforce Sales Cloud (destination). Sends customer profiles from Amperity to Salesforce Sales Cloud through its SOAP API.

  Docs ↗
• BLBlueConic

  Reads from BigQuery

  BlueConic ⇄ BigQuery

  Imports BigQuery tables into BlueConic profiles and timeline events and exports profile and timeline data to BigQuery tables, replacing or partitioning a table on each batch run.

  Docs ↗

  Sends to Salesforce

  BlueConic ⇄ Salesforce

  Imports Salesforce records into BlueConic by object or SOQL query, including Service Cloud cases as timeline events, and exports segment profiles to Salesforce objects in batches.

  Docs ↗
• BLBlueshift

  Reads from BigQuery

  BigQuery → Blueshift

  Import. Imports customer data, events, catalogs and recommendation feeds from BigQuery into Blueshift over a direct connection authenticated with a service account key.

  Docs ↗

  Sends to Salesforce

  Blueshift → Salesforce

  Creates or updates records of any Salesforce object, such as leads, contacts and accounts, from Blueshift campaign journeys through a connected app and cloud app templates.

  Docs ↗
• CACaliberMind

  Reads from BigQuery

  BigQuery → CaliberMind

  Ingests warehouse data loaded into a BigQuery dataset CaliberMind creates, or connects directly to your own BigQuery instance, with possible setup fees to map it into CaliberMind.

  Docs ↗

  Sends to Salesforce

  CaliberMind → Salesforce

  Push connector. Lets CaliberMind write, deduplicate and merge Salesforce records and push data such as ABM scores through Flows, once its CaliberMind OAuth2 connected app is installed and authorized.

  Docs ↗
• CLCleverTap

  Reads from BigQuery

  BigQuery → CleverTap

  Import. Imports data from Google BigQuery into CleverTap over a connection set up with a project ID, dataset ID and service account JSON key under the partner settings.

  Docs ↗

  Sends to Salesforce

  CleverTap → Salesforce

  Export. Pushes CleverTap user profiles, event properties and campaign responses, such as NPS feedback, into Salesforce in real time through an OAuth 2.0 webhook calling a custom Apex REST endpoint.

  Docs ↗
• DIDinMo

  Reads from BigQuery

  BigQuery → DinMo

  Connects a BigQuery project to DinMo through a Google Cloud service account, with DinMo datasets for segments, statistics and predictions and optional daily alerts on unusual billed usage.

  Docs ↗

  Sends to Salesforce

  DinMo → Salesforce

  Custom objects. Pushes DinMo model rows into a Salesforce custom object, inserting new records or updating fields on existing ones by ID, with each custom object set up as its own destination.

  Docs ↗

  DinMo → Salesforce

  Standard objects. Inserts, updates or upserts Salesforce accounts, cases, contacts, contracts or leads from DinMo models, one object per destination, using fields that already exist.

  Docs ↗
• FAFivetran Activations

  Reads from BigQuery

  BigQuery → Fivetran Activations

  Source. Reads BigQuery tables and views for Fivetran Activations syncs through IAM roles for viewing data and running unload jobs, with an optional read-only mode.

  Docs ↗

  Sends to Salesforce

  Fivetran Activations → Salesforce

  Syncs any standard or custom Salesforce object from Fivetran Activations over OAuth through the bulk API, with create, upsert, mirror and delete options and multi-destination lead syncs.

  Docs ↗
• HIHightouch

  Reads from BigQuery

  BigQuery → Hightouch

  Iceberg source. Reads Apache Iceberg tables managed in BigQuery as a Hightouch source.

  Docs ↗

  BigQuery → Hightouch

  Source. Connects BigQuery to Hightouch as a source, so SQL, dbt or table-based models built there can sync to any destination.

  Docs ↗

  Sends to Salesforce

  Hightouch → Salesforce

  Syncs leads, accounts and product-usage data such as health scores from your warehouse into Salesforce CRM records.

  Docs ↗

  Hightouch → Salesforce

  Sandbox. Syncs warehouse data into a Salesforce sandbox org, to test syncs before production.

  Docs ↗
• LYLytics

  Reads from BigQuery

  Lytics ⇄ BigQuery

  Imports BigQuery tables into Lytics and exports user profiles, events, audience changes and definitions, metrics and system events from Lytics to BigQuery tables.

  Docs ↗

  Sends to Salesforce

  Lytics ⇄ Salesforce

  Imports Salesforce leads, opportunities and custom objects into Lytics and creates or updates Salesforce objects from Lytics audience members in real time.

  Docs ↗
• MPmParticle

  Reads from BigQuery

  BigQuery → mParticle

  Warehouse Sync. Imports user and event data from a BigQuery dataset into mParticle through a Google Cloud service account with read access, as one-time or scheduled syncs.

  Docs ↗

  Sends to Salesforce

  mParticle → Salesforce

  Sales and Service Cloud events. Sends mParticle event data to Salesforce Sales Cloud and Service Cloud through the Bulk API 2.0, for CRM and support teams.

  Docs ↗
• ODOdie

  Reads from BigQuery

  BigQuery → Odie

  Runs read-only SQL queries against BigQuery from Totango's Customer Data Hub, authenticating with an uploaded key for a service account given Viewer and BigQuery Data Viewer roles.

  Docs ↗

  Sends to Salesforce

  Odie → Salesforce

  Embedded app. Adds a Totango tab to Salesforce through a managed package, which needs an Enterprise or Unlimited license, so licensed Totango users can open Totango there.

  Docs ↗

  Odie → Salesforce

  Insights widget. Shows Totango health, engagement, usage and account tags in a Visualforce widget on Salesforce account layouts, fed by an outbound insights job and readable without a Totango license.

  Docs ↗

  Odie ⇄ Salesforce

  CRM sync. Imports Salesforce accounts, users, tasks, touchpoints and, with an add-on, opportunities into Totango on a schedule, and exports tasks, touchpoints, insights and users to Salesforce.

  Docs ↗
• RGRedpoint Global

  Reads from BigQuery

  Redpoint Global ⇄ BigQuery

  Data Management. Bulk loads Google BigQuery tables from Redpoint Data Management with application default credentials or a service account, mapping its data types to BigQuery types.

  Docs ↗

  Redpoint Global ⇄ BigQuery

  Interaction. Sets up the Simba ODBC driver for Google BigQuery in the Redpoint Interaction Docker image, so RPI can reach BigQuery through a configured data source.

  Docs ↗

  Sends to Salesforce

  Redpoint Global ⇄ Salesforce

  CRM channel. Keeps Salesforce leads, contacts or accounts in step with the Redpoint Interaction data warehouse, syncing either way through mapped fields and the Salesforce SOAP service.

  Docs ↗

  Redpoint Global ⇄ Salesforce

  Data Management. Reads Salesforce objects into Redpoint Data Management with SOQL queries and inserts, updates or deletes them with the Salesforce Output tool over the SOAP endpoint.

  Docs ↗
• RURudderStack

  Reads from BigQuery

  BigQuery → RudderStack

  Source. Syncs BigQuery tables or SQL models to downstream tools with RudderStack Reverse ETL, on a schedule or on demand.

  Docs ↗

  Sends to Salesforce

  RudderStack → Salesforce

  Creates and updates Salesforce leads, contacts and other objects from RudderStack identify calls and warehouse records.

  Docs ↗
• SESegment

  Reads from BigQuery

  BigQuery → Segment

  Data Graph. Gives Segment's Data Graph a BigQuery service account that reads entity tables for Linked Audiences and Linked Events and keeps checkpoints in its own dataset (in active development).

  Docs ↗

  BigQuery → Segment

  Reverse ETL source. Reads BigQuery tables through a service account so Segment Reverse ETL can sync query results onward, granted either broad predefined roles or a narrower custom role.

  Docs ↗

  Sends to Salesforce

  Segment → Salesforce

  Actions. Sends Segment data to Salesforce for CRM through Actions such as Lead, Custom Object and Case.

  Docs ↗
• TETealium

  Reads from BigQuery

  BigQuery → Tealium

  Google BigQuery (cloud data source). Imports a Google BigQuery table or view into Tealium attributes through a service account holding the Data Viewer and Job User roles, with STRUCT columns flattened through a view.

  Docs ↗

  Sends to Salesforce

  Tealium → Salesforce

  Connector, customer credentials. Inserts and updates leads, contacts and custom objects, converts leads and adds them to campaigns in Salesforce from AudienceStream or EventStream, with your own connected app.

  Docs ↗

  Tealium → Salesforce

  Connector, Tealium credentials. Inserts and updates leads, contacts and custom objects, converts leads and adds them to campaigns in Salesforce from AudienceStream or EventStream, with Tealium-managed OAuth.

  Docs ↗

  Tealium → Salesforce

  Standard Objects connector. Creates, updates or deletes Salesforce standard objects from AudienceStream or EventStream.

  Docs ↗
• TATreasure AI

  Reads from BigQuery

  BigQuery → Treasure AI

  Composable Audience Studio. Sets up Composable Audience Studio on BigQuery with a GCP service account key and a zero-copy catalog, so Treasure Data segments are built on BigQuery data without copying it.

  Docs ↗

  BigQuery → Treasure AI

  Import v1. Imports BigQuery tables or query results into Treasure Data with the original BigQuery connector, whose connections can also serve exports unless they use OAuth.

  Docs ↗

  BigQuery → Treasure AI

  Import v2. Imports BigQuery tables or query results into Treasure Data with version 2 of the connector, which signs in with a service account JSON key or Workload Identity Federation, not OAuth.

  Docs ↗

  BigQuery → Treasure AI

  Live Connect zero-copy. Queries BigQuery tables in place from Treasure Data's Trino engine as Live Connect zero-copy federated queries, with no ETL, after the feature is enabled for the account.

  Docs ↗

  Sends to Salesforce

  Treasure AI → Salesforce

  Export. Writes Treasure Data job results to an existing Salesforce object in append, truncate, update or upsert mode, signing in with client credentials or OAuth.

  Docs ↗
• ZEZeotap

  Reads from BigQuery

  BigQuery → Zeotap

  Source. Connects Zeotap directly to data held in Google BigQuery and syncs it in as a source for building customer segments, personalized content and ad targeting.

  Docs ↗

  Sends to Salesforce

  Zeotap → Salesforce

  Batch. Sends Zeotap audience data into Salesforce objects such as contacts, accounts, leads, cases, opportunities, tasks, campaigns or custom objects, after a sign-in on your Salesforce domain.

  Docs ↗

  Zeotap → Salesforce

  Real-time. Upserts Salesforce contact or custom object records from Zeotap Journeys in real time, through an API user and an external ID field on the target object.

  Docs ↗
• ZGZeta Global

  Reads from BigQuery

  BigQuery → Zeta Global

  Connects Google BigQuery to Zeta with a service account key so marketers can segment on tables in place with Zero Copy Database Explorer or ingest data through Data Flows.

  Docs ↗

  Sends to Salesforce

  Zeta Global → Salesforce

  Creates Salesforce CRM customers from Zeta through a Channel Manager channel referenced to the sObject Basic Information API, with Experiences choosing when.

  Docs ↗