Question 1

How is the upsert actually done?

Accepted Answer

Not with T-SQL MERGE, despite Azure SQL supporting it. Polytomic loads rows into a staging table, updates the target from staging by primary key, deletes the matched rows out of staging, then runs INSERT SELECT for whatever is left. Three statements rather than one, which is more predictable to reason about when a load goes wrong halfway through.

Question 2

What write modes are available?

Accepted Answer

Retain and merge, rebuild, and truncate. Keyed incremental data stages and merges. Rebuild drops and replaces the destination table. Truncate keeps the table definition and reloads its contents. Event like or unkeyed incremental data is appended rather than upserted, which is worth knowing before you point history objects at this.

Question 3

How does the incremental read work?

Accepted Answer

The first ETL run reads everything you selected, then Polytomic checkpoints on SystemModstamp, or CreatedDate for history objects, with a ten minute lookback to absorb Salesforce's eventual consistency. Objects with no usable unique identifier and change timestamp fall back to a full read every run.

Question 4

Do deleted Salesforce records show up?

Accepted Answer

Yes, which is unusual for a SaaS source. Reads go through queryAll so records in the recycle bin come back with IsDeleted set, and the row is retained and flagged rather than dropped, which keeps historical joins resolvable.

Question 5

Will this exhaust our Salesforce API limit?

Accepted Answer

No, because Polytomic caps itself. Calls are tracked over a rolling twenty four hours, shown per sync, and paused at a default of seventy five percent of the allowance your org reports. Schema discovery, Tooling API objects and formula catch up runs all draw on that same budget.

Sync Salesforce to Azure SQL

Sync Salesforce to Azure SQL with Polytomic

Staged, then merged

No native MERGE

Deletes actually arrive

Or sync Azure SQL to Salesforce

Trusted by businesses worldwide

Step-by-step integration guide

Connect Salesforce in Polytomic

Connect Azure SQL in Polytomic

Create a sync between Salesforce and Azure SQL

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 Salesforce with Azure SQL?