Azure Storage Queue and OSI PI Integration

Input and output integration overview

This plugin gathers sizes of Azure Storage Queues, providing users with metrics that enhance observability and management of their storage resources.

This setup converts Telegraf into a lightweight PI Web API publisher, letting you push any Telegraf metric into the OSI PI System with a simple HTTP POST.

Integration details

Azure Storage Queue

The Azure Storage Queue plugin allows users to gather various metrics concerning the size and message age of Azure Storage Queues. This plugin connects to Azure Storage, requiring specific credentials and offers configurable options to enhance performance. By collecting metrics, users gain valuable insights into the performance of their storage queues, enabling them to monitor usage patterns, peak loads, and optimize storage management effectively. The integration with Azure’s storage infrastructure provides a straightforward way to monitor queue metrics, ensuring that users can react to changes promptly, maintaining the efficiency and reliability of their applications.

OSI PI

OSI PI is an data management and analytics platform used in energy, manufacturing, and critical infrastructure. The PI Web API is its REST interface, exposing endpoints such as /piwebapi/streams/{WebId}/value that accept JSON payloads containing a Timestamp and Value. By pairing Telegraf’s flexible HTTP output with this endpoint, any metric Telegraf collects—SNMP counters, Modbus readings, Kubernetes stats—can be written directly into PI without installing proprietary interfaces. The configuration above authenticates with Basic or Kerberos, serializes each batch to JSON, and renders a minimal body template that aligns with PI Web API’s single-value write contract. Because Telegraf already supports batching, TLS, proxies, and custom headers, this approach scales from edge gateways to cloud VMs, allowing organizations to back-fill historical data, stream live telemetry, or mirror non-PI sources (e.g., Prometheus) into the PI data archive. It also sidesteps older SDK dependencies and enables hybrid architectures where PI remains on-prem while Telegraf agents run in containers or IIoT devices.

Configuration

Azure Storage Queue

[[inputs.azure_storage_queue]]
  ## Required Azure Storage Account name
  account_name = "mystorageaccount"

  ## Required Azure Storage Account access key
  account_key = "storageaccountaccesskey"

  ## Set to false to disable peeking age of oldest message (executes faster)
  # peek_oldest_message_age = true

OSI PI

[[outputs.http]]
  ## PI Web API endpoint for writing a single value to a PI Point by Web ID
  url = "https://${PI_HOST}/piwebapi/streams/${WEB_ID}/value"

  ## Use POST for each batch
  method       = "POST"
  content_type = "application/json"

  ## Basic-auth header (base64-encoded "DOMAIN\\user:password")
  headers = { Authorization = "Basic ${BASIC_AUTH}" }

  ## Serialize Telegraf metrics as JSON
  data_format           = "json"
  json_timestamp_units  = "1ms"

  ## Render the JSON body that PI Web API expects
  body_template = """
  {{ range .Metrics -}}
  { "Timestamp": "{{ .timestamp | formatDate \"2006-01-02T15:04:05Z07:00\" }}", "Value": {{ index .fields 0 }} }
  {{ end -}}
  """

  ## Tune networking / batching if needed
  # timeout     = "10s"
  # batch_size  = 1

Input and output integration examples

Azure Storage Queue

1. Monitoring Queue Performance in Real-time: Use the Azure Storage Queue plugin to continuously track the size and age of messages in queues, providing operators with real-time insights. This information can help teams understand throughput and delays, enabling them to adjust processing rates or troubleshoot bottlenecks.

2. Dynamic Alerting Based on Queue Metrics: Integrate metrics from the Azure Storage Queue plugin into an alerting system. By defining thresholds for message age and queue size, organizations can automate notifications, ensuring they promptly address situations where queues become too long or messages are delayed, maintaining a healthy and responsive system environment.

3. Optimizing Cost Management: Leverage the insights from the Azure Storage Queue metrics to identify periods of inactivity and implement cost-saving measures by adjusting storage scales. By analyzing queue size trends, organizations can make informed decisions about resource allocation, effectively balancing performance needs with cost efficiency.

4. Enhancing Application Fault Tolerance: Use the age metrics of the oldest message to design smarter retry strategies within applications. In scenarios where message processing fails, understanding how long messages sit in the queue allows developers to fine-tune their error handling logic, enhancing the resilience and reliability of their applications.

OSI PI

1. Remote Pump Stations Telemetry Bridge: Install Telegraf on edge gateways at oil-field pump stations, gather flow-meter and vibration readings over Modbus, and POST them to the PI Web API. Operations teams view real-time data in PI Vision without deploying heavyweight PI interfaces, while bandwidth-friendly batching keeps satellite links economical.

2. Green-Energy Micro-Grid Dashboard: Export inverter, battery, and weather metrics from MQTT into Telegraf, which relays them to PI. PI AF analytics can calculate real-time power balance and feed a campus dashboard; historical deltas inform sustainability reports.

3. Brownfield SCADA Modernization: Legacy PLCs logged to CSV are ingested by Telegraf’s tail input; each row is parsed and immediately sent to PI via HTTP, creating a live data stream that co-exists with archival files while the SCADA upgrade proceeds incrementally.

4. Synthetic Data Generator for Training: Telegraf’s exec input can run a script that emits simulated sensor patterns. Posting those metrics to a non-production PI server through the Web API supplies realistic datasets for PI Vision training sessions without risking production tags.

Feedback

Thank you for being part of our community! If you have any general feedback or found any bugs on these pages, we welcome and encourage your input. Please submit your feedback in the InfluxDB community Slack.