How do I connect PI System data to Grafana?

How do I connect PI System data to Grafana?

Grafana can display PI System data for modern dashboarding. Several integration approaches are available.

Option 1: PI Web API Data Source Plugin

The community Grafana plugin for PI Web API:

Install the plugin: grafana-cli plugins install gridprotectionalliance-osisoftpi-datasource.
In Grafana, go to Configuration > Data Sources > Add data source.
Select OSIsoft PI and enter your PI Web API URL.
Configure authentication (Basic or Kerberos).

Option 2: SQL via PI OLEDB

Use Grafana's built-in SQL data source with PI OLEDB:

Set up a SQL Server linked server pointing to PI OLEDB.
Create views that query PI data.
Connect Grafana to SQL Server using the MSSQL data source.

-- Create a view for Grafana
CREATE VIEW dbo.vw_PI_Temperature AS
SELECT
    CAST(time AS DATETIME) AS time,
    CAST(value AS FLOAT) AS value,
    tag
FROM OPENQUERY(PI_LINKED_SERVER,
    'SELECT tag, time, value FROM piarchive..picomp2
     WHERE tag IN (''Temp1'', ''Temp2'')
     AND time > ''t-7d''')

Option 3: PI Integrator → PostgreSQL/SQL → Grafana

For the best performance:

Use PI Integrator to publish data to PostgreSQL or SQL Server.
Connect Grafana directly to the published database.
Native SQL queries with full Grafana features.

Tips

Use Option 3 for production dashboards (best performance and reliability).
Use Option 1 for quick ad-hoc visualization.
Set appropriate refresh intervals — don't poll faster than your scan class.
Use Grafana variables for tag/element selection.

Want to ask a follow-up?

PiChat can help with your specific PI System use case. Ask follow-up questions, get code examples, and troubleshoot issues.

Ask a Follow-Up Try Without Login

Related Questions

How do I connect Power BI to PI System?How do I write SQL queries against PI using PI OLEDB?

Dive Deeper

Mastering the PI Web API: A Deep Dive for Developers Integrating PI System Data: React Front-End with .NET Backend

More Questions

How do I configure PI AF templates?How do I authenticate with PI Web API from Python?What's the difference between snapshot and archive values in PI?What's the difference between PI Vision and PI ProcessBook?How do I build effective PI Vision displays?What are PI Event Frames and how do I use them?How do I write PI AF Analytics expressions?How do I use PI DataLink in Excel?Should I use PI Web API or AF SDK for my application?How do I write data to PI Data Archive?What are the main components of PI System architecture?How do I optimize PI Data Archive performance?How do I set up the PI Interface for OPC DA?How do I use PI Connector for UFL to import file data?How do I set up PI Data Archive high availability with collectives?What are the security best practices for PI System?How do I migrate PI Data Archive to a new server?How do I connect Power BI to PI System?How do I manage units of measure in PI System?What's the best way to learn PI System?How does PI time syntax work?What are good PI tag naming conventions?How do I access PI System data from Java or Linux?How do I set up PI AF notification rules?How do I use batch requests in PI Web API?How do I connect to PI AF Server using AF SDK in C#?How do I write VBA macros in PI ProcessBook?How does PI data compression work?How do I get real-time streaming updates from PI Web API?How do I troubleshoot PI AF Analysis errors?How do I write SQL queries against PI using PI OLEDB?What is PI interface buffering and how do I configure it?How do I search and query PI Event Frames?What is PI Integrator for Business Analytics?How do I fix the 'Point does not exist' error in PI System?What is the difference between PI ACE and AF Analytics?How do I manually enter data into PI Data Archive?What are AF hierarchy design best practices?What is a WebID in PI Web API and how does it work?How do I configure Kerberos authentication for PI System?Can I deploy PI System in the cloud?How do I calculate summaries (average, total, min, max) in PI?What are PI digital states and how do I use them?How do I backup and restore PI Data Archive?How do I create custom symbols in PI Vision?How do I automate PI System tasks with PowerShell?What is AVEVA Connect and how does it relate to PI System?How do I check and handle data quality in PI System?How do I handle pagination in PI Web API responses?How does AVEVA PI System licensing work?How do I plan a PI System upgrade?