Extract metadata from Data Modules

[Vishnu Priya]

Hi,

Currently, I am working on Cognos 11 and building some reports that use data modules as a data source. I am trying to get the metadata of both the report and the data modules. Parsing the reports using the Cognos SDK gives me the XML version of the report. But if I try to do the same, it gives me an encrypted response.

Also, not able to decrypt the response message as I am not sure on what encoding is used and tried using base-64 encoding but that did not work.

Read on a lot of blogs on this. But didn't get any answer for this problem. Any response on how to approach this problem, could even be of great help. Thanks in advance.

[MFGF]

Hi,

Currently, I am working on Cognos 11 and building some reports that use data modules as a data source. I am trying to get the metadata of both the report and the data modules. Parsing the reports using the Cognos SDK gives me the XML version of the report. But if I try to do the same, it gives me an encrypted response.

Also, not able to decrypt the response message as I am not sure on what encoding is used and tried using base-64 encoding but that did not work.

Read on a lot of blogs on this. But didn't get any answer for this problem. Any response on how to approach this problem, could even be of great help. Thanks in advance.

Hi,

Report authoring still uses the old SOAP/XML BI Bus architecture, meaning you can grab the XML easily. Data Modules are different though - they use the newer REST API and they don't resolve to XML at all. As far as I'm aware IBM haven't yet provided a SDK for this newer piece of the architecture.

Probably not what you wanted to hear, sorry...

MF.

[bus_pass_man]

Just out of curiosity, what are you trying to accomplish?   What are you trying to do which you can't do via the UI?

[Vishnu Priya]

Hi,

Thank you for the immediate response and your input is of great help @MFGF.

@bus_pass_man Feeding your curiosity.. I am actually trying to get the metadata of the data module to retrieve the lineage of reports using the data module and as well as use the data module for other work around in Cognos 11.

Someone who has an hint on this, please do suggest.

[amikron07]

Hi!
I have the same task. is there a solution to this issue?
Thanks!

[MFGF]

Hi!
I have the same task. is there a solution to this issue?
Thanks!

I think IBM has now added an SDK for the REST API including Data Modules.

https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_api.doc/c_ca_api_rest.html

Cheers!

MF.