Hubspot
Overview
Integrate with Hubspot using CData connector. We utilise official CData Python (opens in a new tab) connector to ingest your data.
Features
| Feature Name | Supported |
|---|---|
| Full Import | Yes |
| Incremental Import | Yes |
Supported streams
We support data extraction from tables and views (opens in a new tab) listed in the official CData documentation, according to the selected API version.
Getting started
Requirements and prerequisites
Hubspot Account.
Set up guide
Create a source
Create a new Source of type CData - Hubspot.
Configure a secret
Add a new secret (or use an existing one). Select OAuth authentication to login with your user account or create a PrivateAppToken in Hubspot. Go to Settings > Integrations in your Hubspot profile to create a PrivateAppToken.
Select the Hubspot API version that you want to use.
Define settings
Configure optional settings
- Use Display Names - Indicates whether or not technical names or display names are used for tables. We recommend to keep this to
falseas technical names are easier to process on the data warehouse side.
Limitations
- On the AnalyticsBreakdown and AnalyticsContents table you can only select one dimension. Use additional filters and group by to aggregate the data.