# OSI PI JDBC connection

**URL:** <https://forum.inductiveautomation.com/t/osi-pi-jdbc-connection/15230>\
**Category:** Ignition\
**Created:** [September 1, 2017, 3:59pm UTC](https://forum.inductiveautomation.com/t/osi-pi-jdbc-connection/15230 "2017-09-01T15:59:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Curlyandshemp](https://avatars.discourse-cdn.com/v4/letter/c/bcef8e/32.png) [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\
**Post date:** [September 1, 2017, 3:59pm UTC](https://forum.inductiveautomation.com/t/osi-pi-jdbc-connection/15230/1 "2017-09-01T15:59:37Z")

</div>

Anyone create a new JDBC connection to a PI data source? I need to run queries on Pi data and not historical data.  
Just wondering if anyone has done it. I know some modules are required on the Pi side

Thanks

---

<div class="post-metadata">

**Author:** ![nathan.boeger](https://avatars.discourse-cdn.com/v4/letter/n/7feea3/32.png) [@nathan.boeger](https://forum.inductiveautomation.com/u/nathan.boeger)\
**Post date:** [June 11, 2020, 4:42pm UTC](https://forum.inductiveautomation.com/t/osi-pi-jdbc-connection/15230/2 "2020-06-11T16:42:25Z")

</div>

Reviving very old topic. Came up on a search when I had the same question about accessing OSI Pi data from Ignition. Attached 2 documents on options (JDBC for SQL queries, legacy OPC-HDA access). Neither approach is perfect, but may be useful in some applications.

[JDBC\_Pi\_Ignition.pdf](https://forum.inductiveautomation.com/uploads/short-url/1BqQed0cIXEcWHh1Xh6kzdcckZG.pdf) (4.3 KB)  
[Ignition\_OPC\_HDA\_Pi.pdf](https://forum.inductiveautomation.com/uploads/short-url/g7XInSbOWTLqvt5vYTACZnLLCj6.pdf) (3.8 KB)