We are currently running Cognos 8 and wish to integrate PI as a data source for Cognos 8. What is the best route for doing this? I am confused now because we have all these different connectivity methods such as OLEDB and JDBC,.... I was originally considering PI OLEDB. We are currently running PI 2010 and are in process of obtaining a PSA server license.
One concern that I have is the complex querying. many times I need to do multiple inner joins to bring back a several values at once. Is there a different startegy for doing this if the target is Cognos.
I thank you very much for your kind response,