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
Solved
PI Historian database (OSISoft)
+17- Contributor
Best answer by erik_jan
I guess nobody has done this before.
Please reply if you know it can be done (even if you can not share further information).
+17- Contributor
I guess nobody has done this before.
Please reply if you know it can be done (even if you can not share further information).
+17- Contributor
erik_jan wrote:
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.
+5- Contributor
Hi, I think you could put a Micosoft sql database in front of the Historian database, and then use the fme reader.
+17- Contributor
bjarne wrote:
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.
+17- Contributor
erik_jan wrote:
@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.
+17- Contributor
fmelizard wrote:
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.
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
+5- Participant
fmelizard wrote:
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.
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.
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!
+15- Contributor
siriosus wrote:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.