Has anyone had luck connecting PI JDBC to SAP's Data Federator? After many challenges we have it to a point where it appears there is a Java compatability issue between DF (using JRE 1.5) and PI (requires JRE 1.6).
Please see the comment by Steve on Apr 26, 2011 in this thread. It looks like there may in fact be some versioning issues there.
You could get around the JRE version issue by using PI Linked Server via SQL, and use Microsoft's JDBC driver which supports JRE5. Pls report back if this route works.
My understanding is that you would like OSIsoft to add "retrograde" support for an older version of the Java environment in the PI JDBC Driver – correct? Have you had a chance to check with SAP on whether their latest version of the Data Federator supports JRE 1.6? I am asking because this version of Java was first released on December 11th, 2006 and most vendors are not on JRE 1.5 anymore.
There actually was an item in our "backlog" to add support for JRE 1.5; this item needed to be investigated and prioritized. As such, I wrote a blog post on the topic last year, where I asked the community about the need for this older version of the JRE (and the JDBC API). As you can see per the comments at the bottom of the post, the need for JRE 1.5 support did not seem to be a priority in the community. I also asked the same question at various events, seminars and webinars, and always got the same answer.
With that said, at this point we do not plan to add support for JRE 1.5 (a 7 year old technology) in our PI JDBC Driver. This is a major effort and would stop us from making progress (i.e. new features, bug fixes) in the PI JDBC product.
If it turns out JRE 1.6 really isn't an option, then I would encourage you to look into the other approach communicated by the vCampus community: on the SQL Server you use for the PI Asset Framework (AF), simply configure a "Linked Server" to the PI Data Archive using the classic PI OLEDB Provider, and another one to the PI Asset Framework using the PI OLEDB Enterprise provider. Then this SQL Server box becomes available to pretty much any version of popular standards (ODBC, JDBC, OLE DB).
Please let me know whether that addresses your questions and concerns, or whether you need additional information.
Retrieving data ...