Question 1

Does Polytomic read the whole table every time?

Accepted Answer

By default yes. Azure SQL offers no change data capture through this connector, so each reverse ETL run performs a full table read. You can nominate a monotonically increasing tracking field instead: the first run reads everything, and later runs read only rows beyond the value saved from the previous run.

Question 2

What makes a good tracking field?

Accepted Answer

One that only ever increases: an identity column, a sequence, or a timestamp always set forward on write. A column that can move backwards, or that a bulk edit rewrites to an older value, will leave rows behind permanently, because the checkpoint has already passed them.

Question 3

Which HubSpot objects can I write to?

Accepted Answer

Contacts, companies, deals, tickets, products, line items and custom objects, plus the associations between them. Records are upserted on the field you nominate as the identifier, so a second run updates rather than duplicates.

Question 4

How often should this run?

Accepted Answer

As often as sales actually acts on the data. A full table read on a schedule is not free, so on a large table a nightly run with a tracking field configured is usually the right shape rather than something every fifteen minutes.

Question 5

Does this replace our ETL into a data warehouse?

Accepted Answer

No, it sits beside it. ETL moves data into analytics. This is reverse ETL, taking a result out of the operational database and putting it in front of the people who live in HubSpot all day.

Sync Azure SQL to HubSpot

Sync Azure SQL to HubSpot with Polytomic

Full table reads by default

Or a tracking field

Upsert on your key

Or sync HubSpot to Azure SQL

Trusted by businesses worldwide

Step-by-step integration guide

Connect Azure SQL in Polytomic

Connect HubSpot in Polytomic

Create a sync between Azure SQL and HubSpot

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect Azure SQL with HubSpot?