# Interface between Ignition and Osi pi database

**URL:** <https://forum.inductiveautomation.com/t/interface-between-ignition-and-osi-pi-database/36072>\
**Category:** Ignition\
**Tags:** database\
**Created:** [June 26, 2020, 4:00am UTC](https://forum.inductiveautomation.com/t/interface-between-ignition-and-osi-pi-database/36072 "2020-06-26T04:00:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vrush.dahivalkar](https://avatars.discourse-cdn.com/v4/letter/v/dc4da7/32.png) [@vrush.dahivalkar](https://forum.inductiveautomation.com/u/vrush.dahivalkar)\
**Post date:** [June 26, 2020, 4:00am UTC](https://forum.inductiveautomation.com/t/interface-between-ignition-and-osi-pi-database/36072/1 "2020-06-26T04:00:20Z")

</div>

I am trying to connect osi pi database to Ignition database.

I have configer osi pi JDBC driver with dbVisualizer and can successfully see my tables and data.

And when I connect osi pi with Ignition the driver is connected correctly and shows installed and database connction says valid, however I can’t read data tables in the DB Browser and the error below is shown;

"  
GatewayException: Unable to read response fron Gateway.  
org.xml.sax.SAXParseException: The end-tag for element type “Response” must end with a ‘\>’ deliminter.  
"

Any help would be greatly appreciated.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/d/4d9254843f93efd5b4ef13cbf4f4ca3bb9887f65.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/b/fb3607050e090c9275a19e26785f4379ddd04812.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/5/352f4626e7b594c9be4173ab6bd2a951038e665e.png)

---

<div class="post-metadata">

**Author:** ![vrush.dahivalkar](https://avatars.discourse-cdn.com/v4/letter/v/dc4da7/32.png) [@vrush.dahivalkar](https://forum.inductiveautomation.com/u/vrush.dahivalkar)\
**Post date:** [June 27, 2020, 12:08pm UTC](https://forum.inductiveautomation.com/t/interface-between-ignition-and-osi-pi-database/36072/2 "2020-06-27T12:08:43Z")

</div>

Hi

The Osi pi is the Rockwell Historian and I want to use Ignition to generate reports and site SCADA reading Rockwell HIstorian.

Is there any one how has doen this before. can you Please help me?

Thanks

---

<div class="post-metadata">

**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\
**Post date:** [June 27, 2020, 5:25pm UTC](https://forum.inductiveautomation.com/t/interface-between-ignition-and-osi-pi-database/36072/3 "2020-06-27T17:25:41Z")

</div>

Looks like there was another person with the same error you experienced:

> [@\[BUG\] Error on Perspective and Named Queries with 3rd Party JDBC Driver](http://forum.inductiveautomation.com/t/bug-error-on-perspective-and-named-queries-with-3rd-party-jdbc-driver/20800):
>
> Attempting to query to a 3rd party historian through their JDBC driver I ran into a few issues. Running a named query or a perspective based system.db.runQuery against this driver yields this error: GatewayException: sun.nio.ch.DirectBuffer.cleaner()Lsun/misc/Cleaner; caused by NoSuchMethodError: sun.nio.ch.DirectBuffer.cleaner()Lsun/misc/Cleaner; Running a query within Vision, the Script Console, or the Database Query Browser yields the expected returned results, though I receive a HttpChan…

Maybe try what Kevin mentioned in that thread

---

<div class="post-metadata">

**Author:** ![mscott](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@mscott](https://forum.inductiveautomation.com/u/mscott)\
**Post date:** [January 15, 2021, 3:39pm UTC](https://forum.inductiveautomation.com/t/interface-between-ignition-and-osi-pi-database/36072/4 "2021-01-15T15:39:49Z")

</div>

I am also looking for any feedback on this. I have read that Rockwell compression method does not play well with accessing from other connectors.