PI Linked Server Access Through JDBC?

Discussion created by mikeloria on Feb 23, 2012
Latest reply on Feb 27, 2012 by spilon

AS I am now planning to make PI a linked Server on a SQL 2008 R2 server to support Cognos, I am wondering how feasible/possible it would be to use the SQL JDBC type 4 driver to access PI, having PI as a linked server?


We are a Java shop and we are running java on Open VMS itanium based machines which I believe is not supported with the current OSIsoft JDBC driver. I am also very partial to a pure java solution (type 4 driver) which  provides flexibility and simplifies migration.


My questions are:


1) Is this feasible/possible?


2) What are the repercussions/performance issues (if any) in doing so?




Any thoughts/experiences on this architecture would be highly appreciated.




Thank you in advance for your considerations