HubSpot to Amazon Redshift

Each of these CDPs lists a connector that reads from HubSpot 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 HubSpot

  HubSpot → Amperity

  Source. Pulls contact lists, profiles, email preferences and campaign activity from HubSpot into Amperity, with Fivetran as the connector.

  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 HubSpot

  BlueConic ⇄ HubSpot

  Imports and exports BlueConic profiles and groups with HubSpot contacts, companies, deals and custom objects in batches, plus real-time profile syncs set off by property changes.

  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 HubSpot

  HubSpot → Insider One

  Pulls HubSpot contacts into Insider One on a cron schedule over OAuth and the CRM v3 REST API, syncing all contacts incrementally or one chosen contact as profiles and events.

  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 HubSpot

  Klaviyo ⇄ HubSpot

  Syncs HubSpot contacts, lifecycle stages, owners and deals into Klaviyo through KAV Labs, and logs Klaviyo opens, clicks and unsubscribes on the HubSpot timeline.

  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 HubSpot

  Lytics ⇄ HubSpot

  Keeps HubSpot contact lists and properties up to date with Lytics audiences in real time and imports HubSpot contacts and email events into Lytics.

  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 ↗
• SDSalesforce Data 360

  Reads from HubSpot

  HubSpot → Salesforce

  Brings HubSpot contacts, companies, deals, tickets, lists and forms into Data 360 in batches or through Zero Copy query federation (beta).

  Docs ↗

  Sends to Amazon Redshift

  Salesforce ⇄ Amazon Redshift

  Connects Data 360 and Amazon Redshift through Zero Copy, querying Redshift tables in place and sharing Data 360 data back to Redshift.

  Docs ↗
• SESegment

  Reads from HubSpot

  HubSpot → Segment

  Source. Pulls HubSpot 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 HubSpot

  HubSpot → Tealium

  Workflow webhook data source. Posts HubSpot contact records to Tealium from a Trigger a webhook action in HubSpot workflows, available on Marketing or Sales Professional and Enterprise plans.

  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 HubSpot

  HubSpot → Treasure AI

  Import. Imports HubSpot contacts, companies, contact lists, email events, engagements, deals and other objects into Treasure Data over OAuth, now reading lists from HubSpot's v3 API.

  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 HubSpot.

• 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 HubSpot

  Adobe → HubSpot

  Destination. Sends Real-Time CDP audiences to HubSpot through its Contacts API, updating matching contacts and stamping each with a property holding the audience name.

  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 HubSpot

  BlueConic ⇄ HubSpot

  Imports and exports BlueConic profiles and groups with HubSpot contacts, companies, deals and custom objects in batches, plus real-time profile syncs set off by property changes.

  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 HubSpot

  Blueshift → HubSpot

  Creates HubSpot contacts from Blueshift campaign journeys through cloud app templates that call the HubSpot CRM API, and updates existing ones using a stored HubSpot contact ID.

  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 HubSpot

  CaliberMind → HubSpot

  Activations. Syncs CaliberMind company and contact lists into HubSpot over OAuth with insert, update, upsert, delete or mirror strategies, on a manual, 15-minute, hourly, daily, weekly or cron schedule.

  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 HubSpot

  DinMo → HubSpot

  Custom objects. Writes DinMo segment records into HubSpot custom CRM objects, updating existing records by ID and, in insert or upsert mode, creating new ones.

  Docs ↗

  DinMo → HubSpot

  Objects. Inserts or updates HubSpot contacts, companies, deals or products from DinMo segments, matched on an object ID or for contacts an external attribute, with new custom properties created.

  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 HubSpot

  Fivetran Activations → HubSpot

  Syncs HubSpot contacts, companies, deals, leads, tickets, custom objects, list memberships and behavioral events from Fivetran Activations over OAuth.

  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 HubSpot

  Hightouch → HubSpot

  CRM. Syncs warehouse data such as product usage and invoices into HubSpot contacts and companies, for upsell targeting and personalized email.

  Docs ↗

  Hightouch → HubSpot

  HubDB. Publishes warehouse data to HubSpot HubDB tables to keep website and landing page content current.

  Docs ↗
• KLKlaviyo

  Reads from Amazon Redshift

  Amazon Redshift → Klaviyo

  Data warehouse import. Imports profile data from Amazon Redshift into Klaviyo on a schedule through a Klaviyo-only service user with the fewest rights it needs, with an Advanced KDP subscription.

  Docs ↗

  Sends to HubSpot

  Klaviyo ⇄ HubSpot

  Syncs HubSpot contacts, lifecycle stages, owners and deals into Klaviyo through KAV Labs, and logs Klaviyo opens, clicks and unsubscribes on the HubSpot timeline.

  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 HubSpot

  Lytics ⇄ HubSpot

  Keeps HubSpot contact lists and properties up to date with Lytics audiences in real time and imports HubSpot contacts and email events into Lytics.

  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 HubSpot

  Odie ⇄ HubSpot

  Imports HubSpot companies, contacts, deals, tasks, notes and calls into Totango over OAuth, and sends Totango tasks and touchpoints back to HubSpot as engagements.

  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 HubSpot

  Redpoint Global → HubSpot

  Creates and updates HubSpot CRM contact records by having Redpoint Data Management upload a mapped contact list file through a HubSpot private app token.

  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 HubSpot

  RudderStack → HubSpot

  Creates and updates HubSpot contacts and custom behavioral events from RudderStack users and events, in cloud mode or on the web in device mode.

  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 HubSpot

  Segment → HubSpot

  Classic. Sends identify, track, page and group calls from Segment to HubSpot for analytics and CRM in cloud or device mode.

  Docs ↗

  Segment → HubSpot

  HubSpot Cloud Mode (Actions). Sends Segment data to HubSpot for CRM and analytics through Actions such as Send Custom Behavioral Event and Upsert Custom Object Record.

  Docs ↗

  Segment → HubSpot

  HubSpot Web (Actions). Sends Segment data to HubSpot for CRM and analytics through Actions such as Upsert Contact, Track Custom Behavioral Event and Track Page View.

  Docs ↗
• SDSimon Data

  Reads from Amazon Redshift

  Amazon Redshift → Simon Data

  Lets Simon Data extract tables from Amazon Redshift through a dedicated user granted select privileges, after Simon's public IP addresses are allowed through any firewall.

  Docs ↗

  Sends to HubSpot

  Simon Data → HubSpot

  Connects Simon Data to HubSpot over OAuth to send transactional emails from HubSpot templates, enroll contacts in HubSpot workflows and keep HubSpot lists matched to Simon segments.

  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 HubSpot

  Tealium → HubSpot

  Client-side tag. Adds HubSpot's tracking code through Tealium iQ to record page views and tie visitors to HubSpot contacts for marketing and sales.

  Docs ↗

  Tealium → HubSpot

  Server-side connector. Creates and updates HubSpot contacts, in real time or batched, and adds them to or removes them from lists, from AudienceStream.

  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 HubSpot

  Treasure AI → HubSpot

  Export. Exports Treasure Data job results to HubSpot to create or update contacts and companies, update their properties in batches, or add contacts to lists.

  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 HubSpot

  Zeta Global → HubSpot

  Syndicates Zeta customers into HubSpot through a Channel Manager channel following HubSpot's CRM contacts objects API, authenticated with OAuth tokens, when an Experience decides.

  Docs ↗