RQM & RQM Custom Reporting (Cognos/Insight) Integration
Just finshed configuring RQM & RQM Custom Reporting to work together and wanted to share a crucial step with everyone which was missed out in the setup documentation.
When setting up the integration you need to tell cognos where to look when pulling data from RQM.
Using the XML Data Configuration tool open
"C:\Program files\IBM\rqmreporting\dataconfig\configs\Configurations\rqm.xdc"
within this file navigate to
"XML Data Configuration -> Resources -> RationalQualityManager -> RQM"
Select the properties of the RQM Resource Group and change the URL paramiter to point to your server.
The URL will look something like this:
https://localhost:9443/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager
Don't worry about testing the connection as it will fail, the full URL is build on runtime.
You should now be able to fun the ETL job without it failing.
Hope this helps.
When setting up the integration you need to tell cognos where to look when pulling data from RQM.
Using the XML Data Configuration tool open
"C:\Program files\IBM\rqmreporting\dataconfig\configs\Configurations\rqm.xdc"
within this file navigate to
"XML Data Configuration -> Resources -> RationalQualityManager -> RQM"
Select the properties of the RQM Resource Group and change the URL paramiter to point to your server.
The URL will look something like this:
https://localhost:9443/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager
Don't worry about testing the connection as it will fail, the full URL is build on runtime.
You should now be able to fun the ETL job without it failing.
Hope this helps.
One answer
Note: This post is 5+ years old.
Please upgrade to the latest version of RQM (see https://jazz.net/downloads/rational-quality-manager/) and review the product documentation (see https://jazz.net/help-dev/clm/topic/com.ibm.help.common.jazz.calm.doc/com.ibm.help.common.jazz.calm.doc_eclipse-gentopic1.html) and jazz.net resources (see https://jazz.net/help). If your issue persists, please ask a new question (https://jazz.net/forum/questions/ask), open a defect (see https://jazz.net/mystuff/#tab=workitems), or open a PMR (see http://www-01.ibm.com/support/docview.wss?uid=swg21507639).
Please upgrade to the latest version of RQM (see https://jazz.net/downloads/rational-quality-manager/) and review the product documentation (see https://jazz.net/help-dev/clm/topic/com.ibm.help.common.jazz.calm.doc/com.ibm.help.common.jazz.calm.doc_eclipse-gentopic1.html) and jazz.net resources (see https://jazz.net/help). If your issue persists, please ask a new question (https://jazz.net/forum/questions/ask), open a defect (see https://jazz.net/mystuff/#tab=workitems), or open a PMR (see http://www-01.ibm.com/support/docview.wss?uid=swg21507639).