question

UdayaBhaskarUBHASTI-0257 avatar image
0 Votes"
UdayaBhaskarUBHASTI-0257 asked UdayaBhaskarUBHASTI-0257 edited

Periodic export of Application Insights data to Azure SQL DB

Hi Team,
The ask is very simple: we want to set up a scheduled export of this data from Application Insights to Azure SQL DB.

what is the best/easiest way to achieve this?

I tried the continuous export and Diagnostic settings but seems not much handy.

Can you please guide.

Thanks in advance.
Udaya Bhaskar

azure-sql-databaseazure-monitor
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JaliyaUdagedara avatar image
0 Votes"
JaliyaUdagedara answered UdayaBhaskarUBHASTI-0257 edited

The preferred way for exporting telemetry is using the Diagnostic Settings.

Continuous export has been deprecated and is only supported for classic Application Insights resources. Workspace-based Application Insights resources must use diagnostic settings.

Alternatively, you can use Application Insights REST API to build custom solutions.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Jaliya, Thanks for the quick response.

I have tried 'Diagnostic settings' , below is the three approaches summary:

  1. Storage account: But the JSON file is being stored so deep inside the container inside many folders (Date wise, hourwise, minute wise) , I count not able to figure out how to upload all JSON files to SQL DB.

  2. EventHub: Eventhub approach good (StreamAnalystics --> SQL), Yet to create Azure SQL DB

  3. RETS API: Tried this, but some how I did not see the data in the Response window. I see only data structure but not the data rows. See two images below.

Conclusion for now: I would like test REST API scenario again to see the data rows. and then choose between EventHub approach or REST approach.

I will get back to you in few days with the full results.
Appreciate your help.!

117100-rest-response.png

117147-rest-response2.png.




0 Votes 0 ·
rest-response.png (67.6 KiB)
rest-response2.png (26.7 KiB)