Export Azure application Insight log files to Azure Data Lake storage

Question

I am beginner of the azure portal , I configured the Azure Application insight in front-end side (Angular 2) and Back-end side (Asp.net core)

I can track my application log file through azure application insight,and export the xls sheet also http://dailydotnettips.com/2015/12/04/exporting-application-insights-data-to-excel-its-just-a-single-click/ ,But i need to store all my log file into azure data lake storage for the Backup tracking purpose

I need to debug the issue on my application while facing issues.but i got the link https://learn.microsoft.com/en-us/azure/application-insights/app-insights-code-sample-export-sql-stream-analytics and Can I download data collected by Azure Application Insights (events list)? continues export for sql,blob storage,i dont want unwanted storage for storing my data in azure resources.

So If there is any way for connect application insight to Azure Data lake through connector or plugins.IF its could you please share me the link.

Thank you..

Answer 1

Automatic

If you export the events to azure blob storage you can do multiple things:

• Use Azure Data Factory to copy the data from blob storage to Azure Data Lake
• Use AdlCopy to copy the data from blob storage to Azure Data Lake
• Write an U-Sql job to copy the data to Azure Data Lake

Manual

To manually place exported Application Insights data (in .xls format) you can use the portal to upload the file to Azure Data Lake.

If you need to have more control about the exported data you can use Application Insights Analytics to create a query based on the available data and export it to an .xls file.

If course you can also create a small app to export the .xls file to Azure Data Lake if you do not want to upload it using the portal. You can use the api for that.