Skip to main content

HubSpot Reader

HubSpot is a CRM application suite. HubSpot’s customer platform offers enterprise software for marketing, sales, customer service, content management, operations, and commerce. The Striim HubSpot Reader uses HubSpot APIs to read data from an instance of the HubSpot CRM platform. HubSpot Reader ingests HubSpot data and emits WAEvents that can be processed with continuous queries or directed to a Striim target.

Typical use cases for reading from HubSpot include:

  • Integration with CDP: Move data from HubSpot in real time to a datawarehouse to build a Customer Data Platform

  • Analytics workflow: Integrate HubSpot CRM data with ML/analytics systems for workflows like Next best action/Offer, LTV analysis and churn analysis

You can read from HubSpot as follows, and write to any target supported by Striim.

  • For initial load, you can set the Mode in HubSpot

  • For near real-time continuous replication after initial load, you can use HubSpot in “Incremental Load” mode whereby the adapter reads new source data at regular intervals.

Typically, you can set up data pipelines that will read from HubSpot in two phases, as explained in this concept article on Pipelines. The first step is the initial load, where you can create a point-in-time copy of the existing source HubSpot dataset at the target. After the initial load has completed, you can start continuous replication by continuously reading the new data created in the same HubSpot dataset after the initial load was started, and then writing this new source data to the target. When set to “Automated” mode, the HubSpot Reader first completes the initial load (as of the start time of the application) and on completion of initial load, it will automatically start polling for incremental changes at the specified interval.

Summary information and supported objects

APIs used/data supported

HubSpot API v3

Data supported

Standard HubSpot objects

Supported targets

Databases and data warehouses without continuous query (CQ) processing. Can support other types of targets with appropriate CQ processing.

Security and authentication

  • Private app token

  • OAuth 2.0

Operations / modes supported

  • Automated mode (consisting of both initial load and incremental load)

  • Initial load

  • Incremental load

Schema management

The HubSpot Reader supports initial schema creation, but not schema evolution currently.

Resilience / recovery

  • Configurable automatic retries

  • A1P recovery

Performance

Striim Platform supported parallel execution

Programmability

  • Wizards

  • Striim Flow Designer

  • Striim TQL

Metrics and auditing

Key metrics available through Striim monitoring

Key limitations

  • Currently we do not capture DELETE events

  • Records for objects that do not support incremental load are synced at every polling interval, which can result in duplicate records.