Connection to a PI Database

Archived Topics
1

Hi,
I was wondering if anybody has experiance in connecting Ignition to a PI database from OSIsoft.
I am an in the investigation phase with a customer that is asking if Ignition can connect to his PI database. So any help is much appreciated.

I have noticed on OSIsoft’s home page that they offer an addon tool called “PI Data Access” with the following description:

[quote] SQL Data Access Tools expose the PI System as a relational database – with tables and relationships –
and make it accessible through SQL queries. The PI Data Access SQL tools support the three major
relational database standards (OLE DB, ODBC, and JDBC). This allows you to integrate your
PI System data with external systems and facilitates the development of custom applications.[/quote]
Is this the right way to access the PI database?
Can i use one of the 6 JDBC drivers in ignition 7.7?
Can i use ODBC in ignition?

Thanks

1 Like
2

Ignition supports generic JDBC drivers. With the OSI documentation to help with the URL format and general SQL syntax, you should be able to add it to your Ignition server. Look at “Databases” => “Drivers” => “Create new JDBC Driver…”

1 Like
3

What Ignition version?

If you are using Ignition 7.7.x version, there are a OPC-COM-HDA module to access historical OSI-PI data (and others HDA complaint system) in a way very similar to the SQLTag Historian way…

See this video: fast.wistia.net/embed/iframe/py … pover=true

At time 40:45 aprox.

Regards,

2 Likes
4

Hi again
Thanks pturmel for the JDBC way
Thanks pdibenedetto for bringing up the OPC HDA alternative. This is probably the easiest way.