can i access PI server data with an odbc interface ? How ?
(I apologize in advance for the long reply, but there are various things to take into consideration... read on to the end and let us know if you need anything else!)
So, the answer is: yes, we do have a product to do that (PI ODBC Driver) but it is not part of the recommended approaches at this time (and hence not provided in the vCampus Kit of PI Products). The reason is, our PI ODBC Driver was developed a while ago and is based on technologies/protocols that:
Plus, the current implementation of the PI ODBC Driver is in "maintenance only" mode, meaning that no new features are being implemented.
With that said a first option for you would be to make use the PI OLEDB Provider - whether you configure it as a Linked Server in MS SQL Server (or another RDBMS) and access it via an ODBC Driver or you use some "ODBC - OLEDB gateway" to run ODBC clients against an OLEDB provider (see the PI OLEDB Provider Manual on the vCampus Library).
Something else you might be interested in is the upcoming release of the PI JDBC Driver, to support Java applications natively as middleware and as programming environment. The first version will target Windows and Linux operating systems and will be a Type 1 JDBC driver (Bridge), which means it will require the PI OLEDB Provider. For more details on this and other 'data access' products, you might want to watch the recording the "Discoveries from UC2009" webinar.
This is a helpful writeup on the status of our relational data access tools (PI ODBC, PI OLEDB, and soon, PI JDBC). As Steve mentioned, we have been focusing our efforts on OLEDB and JDBC. All three products are typically used when integrating with 3rd party software using standards-based connections and SQL queries. Does this match your use case and if so, does your 3rd party software support OLEDB or JDBC access?
The PI JDBC Driver is currently in beta. I would like to extend an invitation to vCampus members to send an e-mail to email@example.com mailbox and let us know if you are interested in testing this new product. Please describe your use case (e.g. are you planning to program using JDBC, or which 3rd party application you are integrating with) and your environment (e.g. Client operating system where PI JDBC Driver is running). We will follow up with these requests directly over e-mail. By the way, PI JDBC will likely be included in vCampus in future.
Regards, Jay Lakumb
Product Manager, Data Access
this is very interisting.
finally some thing in java.
fcamposcan i access PI server data with an odbc interface ? How ?
Just to complete the other answers (which I fully support btw):
If you already have a Data Access License and if you're satisfied with the limited functionality,
you can of course use PIODBC instead of PIOLEDB ...
(I'm not sure if techsupport can help you much more than vCampus, which is not supporting it)
Retrieving data ...