why synapse analytics

Question

Hello,
Can you let me know a web link where it briefly summarizes the advantages of using azure synapse as opposed to ADF and databricks?
Thanks

Answer 1

As I understand the ask, you are looking for resources detailing when to use Databricks vs DataFactory vs Synapse.

I'm not certain if we have an official Microsoft document comparing all three @arkiboys , so I did a search/
A quick Bing (web) search of "Azure Synapse Analytics vs Databricks vs Azure Data Factory" returned these top results:

• differnce between synapse and databricks - Microsoft Q&A
• Data integration in Azure Synapse Analytics versus Azure Data Factory
• Youtube videos comparing the three

If you would like my own explanation, I can tell you this:
Azure Synapse leverages Azure Data Factory to do the data orchestration and data movement. If you only need orchestration / movement, consider Data Factory. If you need more, look to Synapse. You can think of Data Factory as a sub-set of Synapse. With this cleared up, the comparison can focus on Databricks and Synapse.
Both Synapse and Databricks offer Spark. Both offer "notebooks". Both can connect to SQL, but Synapse has more inbuilt SQL services. Both can do Delta. Both can work with streaming. Synapse has more native integrations with Azure products such as Data Explorer and requires less coding. I won't go into speed or numbers because that is situational and will change as the product develops.