Salesforce to Amazon Redshift

Each of these CDPs lists a connector that reads from Salesforce and one that sends data to Amazon Redshift. 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 Amazon Redshift

  Amperity → Amazon Redshift

  Gets Amperity data into Amazon Redshift by sending it to Amazon S3 first, then loading it with tools such as AWS Glue or a Lambda function.

  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 Amazon Redshift

  BlueConic ⇄ Amazon Redshift

  Imports Amazon Redshift tables or SQL query results into BlueConic profiles, orders, events and groups, and exports profiles in sync, replace or append mode staged through Amazon S3.

  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 Amazon Redshift

  Insider One → Amazon Redshift

  Export. Exports Insider One user or event data to an Amazon S3 bucket you own, from which your Amazon Redshift pipeline, for example the COPY command, loads it into tables.

  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 Amazon Redshift

  Klaviyo → Amazon Redshift

  Exports Klaviyo profiles and events to an Amazon Redshift instance, with the option to leave out events from integrations that already feed Redshift.

  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 Amazon Redshift

  Lytics ⇄ Amazon Redshift

  Imports user tables from Amazon Redshift into Lytics over a PostgreSQL connection and keeps a Redshift table of a Lytics audience updated by loading files staged in S3.

  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 Amazon Redshift

  mParticle → Amazon Redshift

  Loads all incoming mParticle data into an Amazon Redshift cluster, so you can query events and user data with SQL.

  Docs ↗
• OROracle

  Reads from Salesforce

  Salesforce → Oracle

  Import. Imports records from pre-defined Salesforce CRM source objects into Oracle Unity through a Salesforce CRM source that authenticates with a client ID and secret, security token and user login.

  Docs ↗

  Sends to Amazon Redshift

  Oracle → Amazon Redshift

  Export. Places Oracle Unity segments or data objects on an SFTP server as files, to be copied into an S3 bucket and loaded from there into Amazon Redshift.

  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 Amazon Redshift

  Redpoint Global ⇄ Amazon Redshift

  Connects a Redpoint Interaction tenant to Amazon Redshift as its data warehouse by picking the AWSRedshift provider and entering host, database and login details.

  Docs ↗
• SESegment

  Reads from Salesforce

  Salesforce → Segment

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

  Docs ↗

  Sends to Amazon Redshift

  Segment → Amazon Redshift

  Loads Segment event data into Amazon Redshift 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 Amazon Redshift

  Tealium → Amazon Redshift

  Loads full or custom event and visitor data into Amazon Redshift tables in micro-batches or batches, 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 Amazon Redshift

  Treasure AI → Amazon Redshift

  Export. Writes Treasure Data job results to tables in an existing Amazon Redshift cluster over JDBC, with no support for timestamp or date columns, which you must first convert to strings or Unix time.

  Docs ↗

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

• ACActionIQ

  Reads from Amazon Redshift

  Amazon Redshift → ActionIQ

  Connects ActionIQ to Amazon Redshift with HybridCompute, pushing generated SQL down to the warehouse and returning only the needed results, usually customer IDs, without copying the data.

  Docs ↗

  Sends to Salesforce

  ActionIQ → Salesforce

  Salesforce Sales Cloud
• AEAdobe Experience Platform

  Reads from Amazon Redshift

  Amazon Redshift → Adobe

  Brings Amazon Redshift 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 ↗
• BLBlueConic

  Reads from Amazon Redshift

  BlueConic ⇄ Amazon Redshift

  Imports Amazon Redshift tables or SQL query results into BlueConic profiles, orders, events and groups, and exports profiles in sync, replace or append mode staged through Amazon S3.

  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 Amazon Redshift

  Amazon Redshift → Blueshift

  Loads Amazon Redshift data into Blueshift by unloading customer, event or catalog tables to Amazon S3 for import, or by syncing customers and events through Census or RudderStack.

  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 Amazon Redshift

  Amazon Redshift → CaliberMind

  Reads data straight from your Amazon Redshift instance into CaliberMind instead of standard connectors, with a possible setup fee for schema mapping and monthly fees tied to data volume.

  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 Amazon Redshift

  Amazon Redshift → CleverTap

  Imports data from an Amazon Redshift cluster into CleverTap using the cluster endpoint, port, database credentials and an optional schema that defaults to public.

  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 Amazon Redshift

  Amazon Redshift → DinMo

  Connects Amazon Redshift, provisioned or Serverless, to DinMo as the source for models, segments and activations, reached directly or through AWS PrivateLink, an SSH tunnel or SSM.

  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 Amazon Redshift

  Amazon Redshift → Fivetran Activations

  Source. Extracts Amazon Redshift tables and views for Fivetran Activations syncs with the UNLOAD command, which in a VPC deployment needs an S3 VPC endpoint.

  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 Amazon Redshift

  Amazon Redshift → Hightouch

  Source. Connects Amazon Redshift 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 Amazon Redshift

  Lytics ⇄ Amazon Redshift

  Imports user tables from Amazon Redshift into Lytics over a PostgreSQL connection and keeps a Redshift table of a Lytics audience updated by loading files staged in S3.

  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 Amazon Redshift

  Amazon Redshift → mParticle

  Warehouse Sync. Brings user and event data from Amazon Redshift or Redshift Serverless into mParticle, with access through an IAM role that mParticle assumes.

  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 Amazon Redshift

  Amazon Redshift → Odie

  Retrieves Amazon Redshift schema tables into Totango with SQL, signing in as a user in a read-only group that has select rights on the schema.

  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 ↗
• OROracle

  Reads from Amazon Redshift

  Amazon Redshift → Oracle

  Import. Takes Amazon Redshift data into Oracle Unity from files on an SFTP server, using a Secure FTP source with an RSA key and an ingest job, with optional decryption.

  Docs ↗

  Sends to Salesforce

  Oracle → Salesforce

  Export. Upserts Oracle Unity segment data into Salesforce CRM objects through a Salesforce CRM destination, matching records on an external ID field set in the field mapping.

  Docs ↗
• RGRedpoint Global

  Reads from Amazon Redshift

  Redpoint Global ⇄ Amazon Redshift

  Connects a Redpoint Interaction tenant to Amazon Redshift as its data warehouse by picking the AWSRedshift provider and entering host, database and login details.

  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 Amazon Redshift

  Amazon Redshift → RudderStack

  Source. Reads tables or SQL models from Amazon Redshift with RudderStack Reverse ETL and syncs the rows to downstream tools on a schedule.

  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 Amazon Redshift

  Amazon Redshift → Segment

  Data Graph. Connects a Redshift cluster to Segment's Data Graph through its own role and user, so Linked Audiences and Linked Events can use warehouse entity tables next to Profiles Sync data.

  Docs ↗

  Amazon Redshift → Segment

  Reverse ETL source. Lets Segment Reverse ETL query an Amazon Redshift cluster as a dedicated database user and send the results to destinations, keeping sync state in its own schema.

  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 Amazon Redshift

  Amazon Redshift → Tealium

  Cloud data source. Reads a table or view from an Amazon Redshift cluster into Tealium attributes over JDBC, using the cluster's hostname, port, database, schema and credentials.

  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 Amazon Redshift

  Amazon Redshift → Treasure AI

  Import. Imports a table from Amazon Redshift into Treasure Data with an optional WHERE condition, and can load only rows added since the last scheduled run.

  Docs ↗

  Amazon Redshift → Treasure AI

  Live Connect zero-copy. Runs federated Trino queries from Treasure Data against Amazon Redshift tables through a Live Connect zero-copy source, once enabled, keeping results seven days unless saved.

  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 ↗
• ZGZeta Global

  Reads from Amazon Redshift

  Amazon Redshift → Zeta Global

  Queries Amazon Redshift provisioned clusters from Zeta Data Flows to ingest selected data, connecting with host, port and database plus optional IAM authentication.

  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 ↗