mikeloria

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 

Outcomes