IoT Central data export to Azure Data Explorer and Azure Synapse data explorer

Published Nov 20 2021 09:00 AM 1,215 Views
Microsoft

Azure Data Explorer is a powerful platform for providing IoT Analytics for your organization. Combining it with Azure IoT Central which is your gateway to connect and manage IoT Devices provides a seamless platform for managing and analyzing your IoT devices.

Now you can utilize data export in IoT Central to send data directly to Azure Data Explorer.

 

ManojRaheja_0-1637368181269.png

 

Check out this document and a quick demo video from Sekhar Kutikuppala, Sr. Program Manager, Azure IoT Central.

 

 

 

If you already have an IoT Application in IoT Central, you can simply select Azure Data Explorer as destination type in your data export and fill in following details:

  • Cluster URL:
    • For Azure Data Explorer clusters – the URL will be in the following format: https://{cluster}.{region}.kusto.windows.net.
    • For Azure Synapse data explorer, the URL will be in the following format: https://{data explorer pool name}.{synapse workspace name}.kusto.azuresynapse.net
  • Database name
  • Table name
    • Note: there is no need to specific mapping, in this case IoT Central is managing this for you
  • Client ID: enter your service principal ID (if you don’t have, refer this doc.
  • Tenant ID: enter your Azure Active Directly tenant ID
  • Client secret: enter your service principal secret

 

ManojRaheja_1-1637368181282.png

 

You can also try this functionality out in your own environment by following the below lab which will walk you through the entire process.

https://aka.ms/dx.iot.lab

%3CLINGO-SUB%20id%3D%22lingo-sub-2987626%22%20slang%3D%22en-US%22%3EIoT%20Central%20data%20export%20to%20Azure%20Data%20Explorer%20and%20Azure%20Synapse%20data%20explorer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2987626%22%20slang%3D%22en-US%22%3E%3CP%3EAzure%20Data%20Explorer%20is%20a%20powerful%20platform%20for%20providing%20IoT%20Analytics%20for%20your%20organization.%20Combining%20it%20with%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fiot-central%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20IoT%20Central%3C%2FA%3E%20which%20is%20your%20gateway%20to%20connect%20and%20manage%20IoT%20Devices%20provides%20a%20seamless%20platform%20for%20managing%20and%20analyzing%20your%20IoT%20devices.%3C%2FP%3E%0A%3CP%3ENow%20you%20can%20utilize%20data%20export%20in%20IoT%20Central%20to%20send%20data%20directly%20to%20Azure%20Data%20Explorer.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ManojRaheja_0-1637368181269.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F328298i2B3512D3364D0E50%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22ManojRaheja_0-1637368181269.png%22%20alt%3D%22ManojRaheja_0-1637368181269.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECheck%20out%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fiot-central%2Fcore%2Fhowto-transform-data-internally%3Fbranch%3Dpr-en-us-177766%23scenarios%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ethis%3C%2FA%3E%20document%20and%20a%20quick%20demo%20video%20from%20Sekhar%20Kutikuppala%2C%20Sr.%20Program%20Manager%2C%20Azure%20IoT%20Central.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252F7sPCvZqPM9U%253Flist%253DPL1ljc761XCiYlm8Rx58jLsUp4gAspw1SG%26amp%3Bdisplay_name%3DYouTube%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253D7sPCvZqPM9U%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252F7sPCvZqPM9U%252Fhqdefault.jpg%26amp%3Bkey%3Dfad07bfa4bd747d3bdea27e17b533c0e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22200%22%20height%3D%22112%22%20scrolling%3D%22no%22%20title%3D%22YouTube%20embed%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20already%20have%20an%20%3CA%20href%3D%22https%3A%2F%2Fapps.azureiotcentral.com%2Fmyapps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EIoT%20Application%3C%2FA%3E%20in%20IoT%20Central%2C%20you%20can%20simply%20select%20Azure%20Data%20Explorer%20as%20destination%20type%20in%20your%20data%20export%20and%20fill%20in%20following%20details%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ECluster%20URL%3A%3CUL%3E%0A%3CLI%3EFor%20Azure%20Data%20Explorer%20clusters%20%E2%80%93%20the%20URL%20will%20be%20in%20the%20following%20format%3A%20%3CA%20href%3D%22https%3A%2F%2F%257bcluster%257d.%257bregion%257d.kusto.windows.net%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2F%7Bcluster%7D.%7Bregion%7D.kusto.windows.net%3C%2FA%3E.%3C%2FLI%3E%0A%3CLI%3EFor%20Azure%20Synapse%20data%20explorer%2C%20the%20URL%20will%20be%20in%20the%20following%20format%3A%20https%3A%2F%2F%7Bdata%20explorer%20pool%20name%7D.%7Bsynapse%20workspace%20name%7D.kusto.azuresynapse.net%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3EDatabase%20name%3C%2FLI%3E%0A%3CLI%3ETable%20name%3CUL%3E%0A%3CLI%3ENote%3A%20there%20is%20no%20need%20to%20specific%20mapping%2C%20in%20this%20case%20IoT%20Central%20is%20managing%20this%20for%20you%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FLI%3E%0A%3CLI%3EClient%20ID%3A%20enter%20your%20service%20principal%20ID%20(if%20you%20don%E2%80%99t%20have%2C%20refer%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-explorer%2Fprovision-azure-ad-app%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ethis%3C%2FA%3E%20doc.%3C%2FLI%3E%0A%3CLI%3ETenant%20ID%3A%20enter%20your%20Azure%20Active%20Directly%20tenant%20ID%3C%2FLI%3E%0A%3CLI%3EClient%20secret%3A%20enter%20your%20service%20principal%20secret%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ManojRaheja_1-1637368181282.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F328297iA73753EB5F5144CF%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22ManojRaheja_1-1637368181282.png%22%20alt%3D%22ManojRaheja_1-1637368181282.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20also%20try%20this%20functionality%20out%20in%20your%20own%20environment%20by%20following%20the%20below%20lab%20which%20will%20walk%20you%20through%20the%20entire%20process.%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Faka.ms%252Fdx.iot.lab%26amp%3Bdata%3D04%257C01%257Cbwatts%2540microsoft.com%257C010ed320e2f54c4f4f7108d9a95c45e7%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637727036055527177%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26amp%3Bsdata%3D6S1WltCeWIjJaa4ecPPT1KjOLhcZQk7%252B3RBr3pP2glI%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Fdx.iot.lab%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2987626%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22transformations.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F328299i477F93D38B4C54F6%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22transformations.png%22%20alt%3D%22transformations.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIoT%20Central%20now%20supports%20direct%20export%20to%20Azure%20Data%20Explorer%20and%20Azure%20Synapse%20data%20explorer.%20Check%20out%20this%20blog%20to%20learn%20more.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2987626%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Explorer%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20Synapse%20data%20explorer%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EIoT%20Central%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EKusto%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Nov 19 2021 04:48 PM
Updated by: