Hi,
I am about to get some data in the Azure Synapse Analytics from dataverse... How data can be brought to another SQL from Azure Synapse Analytics on Azure VM ( without writing data to Datalake/Blob)
So your source data is the dataverse and your target is SQL Server on Virtual Machine. Right?
If this is the case, then according to this request, you speak about using Azure Synapse only as an Intermediate layer (or Intermediate tool) to move data from external source to external target. In this case, you can think about other options of migrating data from the source to the target - This is not he goal of Azure Synapse Analytics and probably not the best tool for the task
Azure Synapse Analytics fits great for ETL, Analytics and working on the data but for migrating data directly from dataverse to SQL Server you can use dataflows, Power Query, Azure Data Factory, Azure Logic Apps, and Power Automate for example. Each one of these tool might fit your needs.
Check this document about Importing and exporting data from/to dataverse. It covers all the options which I mentioned above and all these can connect to SQL Server on VM.
Note! All these tools can also be used to move the data from Azure Synapse Analytics to SQL Server, if you insist/need on using the Azure Synapse Analytics as Intermediate layer