COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Data Modules => Topic started by: Vishnu Priya on 11 Jul 2019 02:46:51 AM

Title: Extract metadata from Data Modules
Post by: Vishnu Priya on 11 Jul 2019 02:46:51 AM
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.
Title: Re: Extract metadata from Data Modules
Post by: MFGF on 11 Jul 2019 08:06:46 AM
Quote from: Vishnu Priya on 11 Jul 2019 02:46:51 AM
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.
Title: Re: Extract metadata from Data Modules
Post by: bus_pass_man on 11 Jul 2019 08:49:11 AM
Just out of curiosity, what are you trying to accomplish?   What are you trying to do which you can't do via the UI?

Title: Re: Extract metadata from Data Modules
Post by: Vishnu Priya on 12 Jul 2019 01:06:15 AM
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.
Title: Re: Extract metadata from Data Modules
Post by: amikron07 on 30 Mar 2021 08:31:26 AM
Hi!
I have the same task. is there a solution to this issue?
Thanks!
Title: Re: Extract metadata from Data Modules
Post by: MFGF on 30 Mar 2021 09:27:50 AM
Quote from: amikron07 on 30 Mar 2021 08:31:26 AM
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.