Type changes are archived
Old column renamed, new one added beside it.
Replicate Harmonic into Azure SQL with Polytomic so company and people intelligence is queryable in T-SQL. When an enrichment field changes type, the table does not break: the old column is renamed to an archival name and a correctly typed replacement appears beside it.
Old column renamed, new one added beside it.
Added on the next schema refresh.
Removed columns stay put in retain mode.
Polytomic is bi-directional by default, so you can move data the other way just as easily.

Jonathan Krangel
VP Global Head of Revenue Operations
“Polytomic handles so many ETL and sync jobs at Cursor. They are a true partner to us.”
Follow these simple steps to connect Harmonic with Azure SQL in minutes
Connect Harmonic
Connect Azure SQL
Create sync
Enable sync
Connect Harmonic to Polytomic with an API key from your Harmonic account.
Connect Azure SQL to Polytomic with server, database, and SQL authentication credentials.
Sync data in either direction between Harmonic and Azure SQL. Choose the source data and destination objects for the direction you need.
Map the fields, choose the sync schedule and behavior, then save and enable the sync.
Get answers to common questions about the integration process
Sync data in either direction between Harmonic and Azure SQL.
Use both integrations' source and destination capabilities in one managed sync workflow.
Enterprise encryption and security protocols ensure your data remains protected.
Get up and running in minutes with our step-by-step integration guide.