Solved

PI Historian database (OSISoft)

erik_jan
Rank
Userlevel 2
Badge +16

Has anybody tried reading data from a PI Historian database with FME?

I know it has both ODBC and JDBC connection options.

If so, could you share some knowledge?

Thanks, Erik Jan

icon

Best answer by erik_jan 11 January 2016, 22:38

View original

11 replies

erik_jan
Rank
Userlevel 2
Badge +16

I guess nobody has done this before.

Please reply if you know it can be done (even if you can not share further information).

erik_jan
Rank
Userlevel 2
Badge +16

@daleatsafe: No information on this data format at Safe Software?

erik_jan
Rank
Userlevel 2
Badge +16

I guess nobody has done this before.

Please reply if you know it can be done (even if you can not share further information).

Sometimes you have to accept that no information is available.

bjarne
Rank
Badge +3

Hi, I think you could put a Micosoft sql database in front of the Historian database, and then use the fme reader.

erik_jan
Rank
Userlevel 2
Badge +16

Hi, I think you could put a Micosoft sql database in front of the Historian database, and then use the fme reader.

Thanks Bjarne, I will keep that in mind.

fmelizard
Rank
Userlevel 4
Badge +13

@daleatsafe: No information on this data format at Safe Software?

So I dug a bit deeper and we had one query about this database before and in the end the best we could advise was the use the SQL Executor against a MS Access database that was somehow in front of the Historian one, which is similar to what @bjarne suggests below. We never received any samples so I can't provide anything more than that.

erik_jan
Rank
Userlevel 2
Badge +16

So I dug a bit deeper and we had one query about this database before and in the end the best we could advise was the use the SQL Executor against a MS Access database that was somehow in front of the Historian one, which is similar to what @bjarne suggests below. We never received any samples so I can't provide anything more than that.

Thanks @daleatsafe. Any information could be of value if we move on to do a project with this data format. I do not know if a MS (SQL server or Access) is available, but I will keep this in mind.

S

Hello Guys , I am new user however please advise if the PI server can send the data to SQL database and . FME reader can read the data from SQL staging table or PID SDK connectors , Does this sound the correct approach

scyphers
Rank
Badge +5

So I dug a bit deeper and we had one query about this database before and in the end the best we could advise was the use the SQL Executor against a MS Access database that was somehow in front of the Historian one, which is similar to what @bjarne suggests below. We never received any samples so I can't provide anything more than that.

Hi Erik & Dale,

 

I have been reading something similar is possible, as bjarne suggests with Wonderware Historian (schnieder electric). SQL server stands in front of that historian and the flat proprietary file forms are accessed through views in SQL server in my case.

 

 

please see InSQL ODBC setup for wonderware

 

and http://www.plctalk.net/qanda/showthread.php?t=69654" target="_blank">http://www.plctalk.net/qanda/showthread.php?t=69654 to configure an ODBC driver

 

and even exists a 3rd party tool to unpack the tab separated hex/bin files my historian stores. If you want some demo data gosh i have years of it. but i think it wise to just reach through the SQL database with some queries as these files presumably are continually moving/updating

 

 

but lets catch up at the user conf on this, i hope to have made some progress on mine soon over the next few weeks and maybe it will have benefit for your requirement Erik. I will have something to offer for at least the Wonderware type of historian soon.

 

S
Badge

Hi All,

In case it is still interesting for people I can share my way I could manage to connect and query PI server.

There is no way to connect to PI server directly, as many of you mentioned but FME can easily connect to SQL Server. So the idea was to add PI server to SQL server as linked server, then via SQL Executor simply query PI tables and use output.

Here is tutorial how to link PI server with SQL: https://techsupport.osisoft.com/Troubleshooting/KB/KB01143 and https://pisquare.osisoft.com/thread/1358

And here are some other options to link and pull data from and to PI or SQL:

https://techsupport.osisoft.com/Troubleshooting/KB/KB00102

Hope this helps!

wisegis
Rank
Badge +14

Hi All,

In case it is still interesting for people I can share my way I could manage to connect and query PI server.

There is no way to connect to PI server directly, as many of you mentioned but FME can easily connect to SQL Server. So the idea was to add PI server to SQL server as linked server, then via SQL Executor simply query PI tables and use output.

Here is tutorial how to link PI server with SQL: https://techsupport.osisoft.com/Troubleshooting/KB/KB01143 and https://pisquare.osisoft.com/thread/1358

And here are some other options to link and pull data from and to PI or SQL:

https://techsupport.osisoft.com/Troubleshooting/KB/KB00102

Hope this helps!

Could you please share how you are connecting. I am attempting to connect to a table from an ODBC, as well as an MS Access connection without much luck at the moment.

Clay Wise

Reply


Community Stats

28,721
Posts
109,502
Replies
36,560
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.