| how to connect Oracle to PI OsiSoft? [message #253316] |
Mon, 23 July 2007 08:23  |
bbaz
Messages: 138
Registered: April 2007
|
Senior Member |
|
|
Hi all,
I am not sure if this is the right place to post this topic. But I thought this issue is related to Interfaces.
I have a PI historian from OSISOFT storing real-time data. I am developing an Oracle form but I need to connect to PI and fetch "live" on the fly data related to specific TAGS that are in the PI DB. I have the TAG name in ORACLE and I need to get the ACTUAL value associated with the TAG from PI.
Have someone ever tried doing this? What are the steps involved?
Is there a way to create an ORACLE stored procedure on the DB that can connect and retrieve data from PI?
Thanks in advance,
Baz
|
|
|
|
 Re: how to connect Oracle to PI OsiSoft? [message #267058 is a reply to message #253316] |
Wed, 12 September 2007 06:45  |
bbaz
Messages: 138
Registered: April 2007
|
Senior Member |
|
|
I have managed to Establish this connection by using Excel as a Middle Layer (Tier) between Oracle Forms and PI Historian (database).
STEPS involved:
1- Install PI-SDK and PI-DATALINK on the machine that needs to connect to PI.
2- Create and EXCEL sheet and List all the required Tags and their Sources in separate columns.
3- Specify INPUT CELLS AND OUTPUT CELLS in Excel
4- Create Lookup Cells that Take the INPUT from Oracle Form and Get the corresponding TAG from the sheet into the lookup Cell.
5- The OUTPUT CELLS should have the PI-call Functions:
=PIArcVal(D79,B80, 0,"PI_SERVER_NAME","interpolated")
Note: PI_SERVER_NAME is the PI Machine name, D79 is the TAG Name retrieved from the Lookup, B80 is the Time Cell passed to Excel From Oracle Form.
6- In Oracle Forms, Call the Excel Sheet by Creating OLE2 objects and pass into Excel the TAG Source and the Time, and Retrieve the Values.
I hope that others can benefit from this Solution as it took me some time to get Working Properly.
Cheers,
Baz
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
