We have (fairly recently) installed IBM's Cognos 10 as our business intelligence reporting tool. Most of the databases that we report over are DB2 9.7 LUW Enterprise Edition. We installed the DB2 Runtime-Time Client in order for Cognos to have access to the driver to communicate with DB2.
We also have some legacy systems and databases on our iSeries (aka AS/400) - so this means DB2 for i. We need Cognos to now recognize these databases. From what we have read up on, we need to install DB2Connect to grant access to DB2 for i from a DB2 LUW perspective.
Our Cognos was installed on a Windows Server system. We installed the RTC on the same system and can catalog DB2 LUW databases. We can get Cognos to create data sources with those databases.
To get iSeries functionality, we recently installed DB2Connect (on the same system as Cognos and RTC) and were able to catalog the iSeries database and connect and call into it. But we cannot get Cognos to see the cataloged database. It just looks like it is not there.
Some of the documentation we looked at makes it seem like you cannot access two different DB2 drivers locally within the same process in Cognos.
- Uninstall RTC and just install DB2Connect with all the datasources cataloged through that and then have Cognos look them up. Our concern with this method is that we are afraid that Cognos may lose information for existing reports and projects that are already set up. We do not want to mess up/lose work already done by other teams.
- We are wondering if there would be a nice clean way to migrate from RTC to DB2Connect so we could move connections off of the one to the other. Our concern here...how do we get DB2Connect to be recognized by Cognos in the first place?
- Is there another way to catalog the iSeries databases and/or get them recognized by Cognos?
Edit: Our company has decided not to wait. They are bringing in a consultant to help us rebuild this from scratch so we better understand the product, how it installs, works, etc.
That being said, I would still welcome any thoughts or ideas on this one.