Integration with Cognos 8

Discussion created by mikeloria on Feb 24, 2011
Latest reply on Feb 24, 2011 by spilon

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,