Ignition Azure IoT Hub Integration: Enterprise Cloud Analytics

# Azure CLI: Create IoT Hub and register device
az iot hub create \
  --name ignition-iothub \
  --resource-group ignition-rg \
  --sku S1 \
  --partition-count 4

# Register Ignition gateway as IoT device
az iot hub device-identity create \
  --hub-name ignition-iothub \
  --device-id ignition-gateway-01 \
  --auth-method shared_private_key

# Retrieve the device connection string
az iot hub device-identity connection-string show \
  --hub-name ignition-iothub \
  --device-id ignition-gateway-01 \
  --output tsv

# MQTT Transmission Settings in Ignition Gateway
# Server URL:
#   ssl://ignition-iothub.azure-devices.net:8883
#
# Username:
#   ignition-iothub.azure-devices.net/ignition-gateway-01/?api-version=2021-04-12
#
# Password:
#   SharedAccessSignature sr=ignition-iothub.azure-devices.net
#     %2Fdevices%2Fignition-gateway-01&sig=<GENERATED_SAS>&se=<EXPIRY>

# Generate SAS Token via Azure CLI
az iot hub generate-sas-token \
  --hub-name ignition-iothub \
  --device-id ignition-gateway-01 \
  --duration 86400

# MQTT Transmission Tag Tree configuration:
# Topic: devices/ignition-gateway-01/messages/events/
# QoS: 1 (At least once)
# Publish rate: 1000ms

-- Azure Stream Analytics Query
-- Process incoming Ignition tag data from IoT Hub

-- Real-time aggregation to Power BI
SELECT
    IoTHub.ConnectionDeviceId AS DeviceId,
    System.Timestamp() AS EventTime,
    AVG(CAST(temperature AS float)) AS AvgTemperature,
    MAX(CAST(pressure AS float)) AS MaxPressure,
    COUNT(*) AS EventCount
INTO [powerbi-output]
FROM [iothub-input]
TIMESTAMP BY EventEnqueuedUtcTime
GROUP BY
    IoTHub.ConnectionDeviceId,
    TumblingWindow(minute, 5)

-- Archive all raw data to Blob Storage
SELECT *
INTO [blob-archive-output]
FROM [iothub-input]

-- Alerts to Azure SQL for high-priority events
SELECT
    IoTHub.ConnectionDeviceId AS DeviceId,
    System.Timestamp() AS AlertTime,
    temperature, pressure, status
INTO [sql-alerts-output]
FROM [iothub-input]
WHERE CAST(temperature AS float) > 85.0
   OR CAST(pressure AS float) > 150.0

# Power BI REST API: Create streaming dataset
# POST https://api.powerbi.com/v1.0/myorg/datasets

{
  "name": "Ignition Real-Time Metrics",
  "defaultMode": "PushStreaming",
  "tables": [
    {
      "name": "ProductionMetrics",
      "columns": [
        { "name": "DeviceId", "dataType": "String" },
        { "name": "EventTime", "dataType": "DateTime" },
        { "name": "AvgTemperature", "dataType": "Double" },
        { "name": "MaxPressure", "dataType": "Double" },
        { "name": "EventCount", "dataType": "Int64" }
      ]
    }
  ]
}

# In Power BI Desktop:
# 1. Add "Azure Stream Analytics" as output in your SA job
# 2. Select your Power BI workspace and dataset
# 3. Create dashboard tiles using real-time dataset
# 4. Pin visuals for live monitoring