HubSpot Source Connector

The HubSpot source connector lets DataSync retrieve data from HubSpot using HubSpot and load it into your data warehouse. Authentication is handled through a HubSpot Private App Access Token, which gives DataSync secure access to the data your app is authorized to retrieve.

Once your source connection is ready, configure your destination connection to finish the setup.

Step 1: Create a private app in HubSpot

To connect DataSync to HubSpot, you need a Private App Access Token. Set the AuthScheme property to PrivateAppToken and OAuthAccessToken to your token value in the Additional Connection Properties in DataSync. For full details on private apps, see the HubSpot Private Apps documentation.

1. Log in to HubSpot.
2. Click the gear icon on the upper‑right corner to open Settings.
3. In the left sidebar, select Integrations, then Legacy apps.
4. Click Create, then choose Private.
5. On the Basic Info tab, enter your app name and an optional description.
6. Select the Scopes tab and select Add new scope.
7. Select Read or Write for each scope your app needs. These scopes determine which HubSpot data DataSync can retrieve. Refer to the OAuthRequiredScopes and OAuthOptionalScopes properties for recommended selections.
8. Select Update, then Create app.
9. Review the access token information and select Continue creating.
10. Select Show token to reveal your access token.
11. Select Copy to copy the token.

note

You will use this token as the value for two aditionnal properties in DataSync: OAuthAccessToken and AuthScheme.

View your access token later

If you need to retrieve your token again:

1. Select the gear icon in the upper-right corner to open Settings.
2. In the left sidebar, select Integrations, then Legacy apps.
3. Select your private app and open the Auth tab.
4. Select Show token, then Copy.

Step 2: Create the source connection in DataSync

1. Log in to DataSync.
2. From the welcome screen, select Connections.
3. Next to Source Connections, click New.
4. Select HubSpot.
5. Enter all required connection properties.
6. (Optional) In the Additional Connection Properties panel, click Add property and enter any extra parameters you need.
7. Configure the advanced settings to match your environment, including Tracking Type.
8. Click Save.

Connection properties

Property	What to enter
Description	Unique name for the connection. Example: HubSpot
Timeout	Time in seconds to wait before a connection attempt or query execution times out.
Verbosity	Controls how much detail the connector writes to the log. Each level includes everything from the level below it, plus additional detail. 1 logs queries, row counts, execution start and end times, and errors. 2 adds cache queries and HTTP headers. 3 adds request and response bodies. 4 adds transport-level communication. 5 adds all interface commands.
Enable Pooling	Enables connection pooling, which keeps a set of database connections open and reuses them across extractions instead of opening a new connection each time. This reduces overhead and improves performance when multiple extractions run at the same time.
Pool idle timeout	Time in seconds a connection can stay idle before returning to the pool.
Max Pool Size	Maximum number of connections allowed in the pool at the same time.
Pool wait time	Time in seconds DataSync waits for an available connection before throwing an error.

Additional connection properties

Use this panel to enter connection string properties not available in the Connection Properties panel. For sensitive values such as passwords, set the type to Encrypted. The value is hidden in the interface and stored encrypted in the back end.

Property	What to enter
OAuthAccessToken	Access token for your HubSpot private app. Example: pat-na1-12345678-abcdefgh-ijklmno.
OAuthOptionalScopes	Comma-separated list of API scopes available to your app. Refine the list based on the data you need to retrieve. Example: automation,business-intelligence,crm.lists.read,crm.objects.contacts.read,crm.objects.deals.read,oauth.
AuthScheme	Authentication scheme for the connection PrivateAppToken when using a private app access token.

Advanced settings

These settings control how the connector tracks data changes, handles time and regional configuration, and processes records during extraction. Configure them to match your Hubspot environment so that results stay accurate and consistent.

Setting	What to select
Tracking Type	Method for tracking data changes: None or Date.
Region	Region setting for the connector, if required by your setup.
Time Zone	Time zone matching your Hubspot environment.
Time Offset	Refresh offset in seconds to compensate for timing issues in record selection. Minimum 0, maximum 3600.
Batch Size	Number of records processed per batch during extraction. Larger batches can improve performance but use more memory. Default is 2000, maximum is 10000. Adjust based on your network speed and disk performance. The default works well in most cases.

Example setup

Completed Hubspot source connection in DataSync, with all properties and settings filled in.