How to connect and export data from Azure monitor and log analytics into Azure Synapse dedicated pool

Question

Hi

I want to export all monitoring and log data from azure monitor into a SQL table to store it for historical analysis, is it possible to create a direct connection between azure monitor/log analytics into synapse? and if so, how could I implement it, is there any MS Learn documentation?

Answer 1

Thanks for posting your question in the Microsoft Q&A forum. May this articles help you: https://techcommunity.microsoft.com/t5/azure-observability-blog/how-to-analyze-data-exported-from-log-analytics-data-using/ba-p/2547888 https://learn.microsoft.com/en-us/azure/synapse-analytics/monitoring/how-to-monitor-using-azure-monitor ** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **

Answer 2

@Gustavo Adolfo Alemán Sánchez For your requirement, you can export the data from log analytics to azure synapse using event hubs.

On how to send the data from log analytics to event hub, you can refer to this document. And to send data from event hub to Azure Synapse, you can refer to this document.

Some reference documents for additional information.

• https://techcommunity.microsoft.com/t5/fasttrack-for-azure/real-time-ingestion-with-event-hub-and-synapse/ba-p/3518504
• https://learn.microsoft.com/en-us/azure/architecture/example-scenario/data/stream-ingestion-synapse