Event Trigger Data Sync from SQL Server to Synapse via Azure Data Factory / Synapse Pipeline

Problem Statement : Is it possible to instantaneously sync data from SQL server to Synapse in case of any data changes (Insert / Update /Delete) within a table. Prerequisites : Any SQL server wherein we can create a Linked server (So Azure SQL Servers are excluded) 2. Synapse / Azure SQL Datawarehouse (Dedicated Pool) 3. Azure Blob

Event Trigger of Synapse / Azure Data factory Pipeline on Arrival of N’th File in Azure Blob Storage

Problem Statement : There are several use cases wherein a data flow process is dependent on multiple entities / files and the flow needs to be triggered only in presence of all files / entities. So is there a way to trigger a Synapse /ADF pipeline flow at the arrival of N’th file rather than trigger