Azure IoT DevKit send sensor data to Azure SQL Database via IoT Hub using Stream Analytics
An end-to-end Demo how to set up the Azure IoT DevKit starter kit, upload code on the IoT DevKit, and then configure Azure IoT Hub, creating a Stream Analytics job to pull messages from IoT Hub and store it on a SQL Database in the Cloud.
Please support me on Patreon: https://www.patreon.com/thesolutionarchitect
Here is the SQL Script to create the table:
CREATE TABLE [dbo].[iotdevkittable]
(
[Id] [bigint] IDENTITY(1,1) NOT NULL,
[messageId] [varchar] (3) NULL,
[temperature] [nvarchar](200) NULL,
[humidity] [nvarchar](200) NULL,
[PartitionId] [varchar] (3) NULL,
[EventProcessedUtcTime] [datetime] NULL,
[EventEnqueuedUtcTime] [datetime] NULL,
[IoTHub] [nvarchar](200) NULL,
CONSTRAINT [PK_iotdevkittable] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Видео Azure IoT DevKit send sensor data to Azure SQL Database via IoT Hub using Stream Analytics канала The Solution Architect
Please support me on Patreon: https://www.patreon.com/thesolutionarchitect
Here is the SQL Script to create the table:
CREATE TABLE [dbo].[iotdevkittable]
(
[Id] [bigint] IDENTITY(1,1) NOT NULL,
[messageId] [varchar] (3) NULL,
[temperature] [nvarchar](200) NULL,
[humidity] [nvarchar](200) NULL,
[PartitionId] [varchar] (3) NULL,
[EventProcessedUtcTime] [datetime] NULL,
[EventEnqueuedUtcTime] [datetime] NULL,
[IoTHub] [nvarchar](200) NULL,
CONSTRAINT [PK_iotdevkittable] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
Видео Azure IoT DevKit send sensor data to Azure SQL Database via IoT Hub using Stream Analytics канала The Solution Architect
Показать
Комментарии отсутствуют
Информация о видео
10 октября 2019 г. 18:46:30
00:27:19
Другие видео канала
Azure IoT Tutorial : IoT Hub | Stream Analytics |Time Series Insights | SQLAzure Stream Analytics Tutorial | Processing stream data with SQLUsing Azure Automation Account to run your PowerShell scriptsAzure IoT quick start with IoT Central and Device TemplatesGetting Started with Azure PowerShellHosting Wordpress On Azure (Step by Step Tutorial)Building real-time enterprise analytics solutions with Azure Synapse Analytics | DB111Azure IoT Send Sensor Data DHT11 & NodeMCU ESP 8266Introduction to Building IoT Solutions with Microsoft AzureAZ-900 Episode 14 | Azure IoT Services | IoT Hub, IoT Central, Azure SphereAzure SQL Database Tutorial | Relational databases in Azure1 Hour Introduction to Azure - For Absolute BeginnersCapture streaming data using Azure Event Hub, Azure Stream Analytics, Power BI and Azure SQL DB.Hands-on Azure IoT with Node.js and the MXChipDeep Dive: Building IoT Solutions with IoT CentralAzure Data Factory Mapping Data Flows Tutorial | Build ETL visual way!Azure Event Hub Tutorial | Big data message streaming serviceAzure IoT Tutorial : How To Send Data To Azure IoT Cloud Using MQTTStreaming Sensor Data in Real-Time with Azure IoT HubGetting Started with Azure Maps