Periodic export of Application Insights data to Azure SQL DB

Question

Periodic export of Application Insights data to Azure SQL DB

Udaya Bhaskar (UBHAS.TI) 106

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

0 comments

1 answer

Your answer

Answer 1

Jaliya Udagedara 2,856 MVP Volunteer Moderator

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.

Udaya Bhaskar (UBHAS.TI) 106 Reputation points

2021-07-22T16:05:52.58+00:00
Hi Jaliya, Thanks for the quick response.

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

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.

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

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.!

.

Share via

Periodic export of Application Insights data to Azure SQL DB

1 answer

Your answer