Objects from Azure SQL can be mapped to entities in Syncari using the powerful Sync Studio. Changes on the records for these objects are periodically (near real time) synced from Oracle into Syncari. Syncari provides a flexible conflict resolution strategy in cases where multiple updates are noticed for the same record. The data can be enriched, deduped and cleansed before storing it in Syncari. Data flowing from different systems into Syncari is synced to Azure SQL. Any schema changes like addition of new column or column rename in Jira are auto detected and the user has the option of auto mapping.
The Azure SQL Synapse allows synchronization on all custom objects.
Syncari synchronizes Azure SQL schema and its mappings with Syncari’s schema during every sync cycle. The newly added columns on the Azure SQL tables and newly added tables are detected automatically and available for usage in the pipelines.