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