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

1 answer

Jaliya Udagedara 2,821 Reputation points MVP

2021-07-22T04:35:11.233+00:00

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.
Please sign in to rate this answer.
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.!

.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer