|
|
Rank: Newbie
Groups: Member
Joined: 9/7/2011
Posts: 1
|
HI,
It is possible to get the PI data with a php query, only for read.
Should i use odbc ?
Someone an idea ?
THX
|
|
|
|
|
OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System. We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ or contact OSIsoft vCampus for more details.
|
|
|
Rank: Advanced Member
Groups: Member
Joined: 4/6/2011
Posts: 40
Location: Grimsby UK
|
Someone will correct me if I'm wrong but I think you need to use the PI ODBC (or OLEDB) drivers in order to get PI data using a query (SQL format I'm assuming). If you use ODBC then I think you need to setup a DSN connection in order to point the query to the right tables. If using PI OLEDB then you would setup a UDL link. Both methods of getting data back can be found in the relevant manuals (PI ODBC or PI OLEDB).
If you can get hold of the PI OLEDB tester it shows you how to construct the queries and what tables to use to getthe data you want. From memory the OLEDB connection gives you access to more tables than ODBC does.
|
|
|
|
Guest
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
