ETL'ing data from artefacts' dynamic sections in CLM tools
Hello all,
Insight 1.0.1.1 and CLM 3.0.1
I need to ETL data that is located in the sections of Test Cases, Test Plans, etc. E.g. Pre-condition, post-condition, and various custom dynamic sections. I don't see that data coming OOTB ETL. Is this possible to do? If yes - is it documented anywhere?
Fast reply would be greatly appreciated as I am at the customer site.
Thanks!
Nataliya
Insight 1.0.1.1 and CLM 3.0.1
I need to ETL data that is located in the sections of Test Cases, Test Plans, etc. E.g. Pre-condition, post-condition, and various custom dynamic sections. I don't see that data coming OOTB ETL. Is this possible to do? If yes - is it documented anywhere?
Fast reply would be greatly appreciated as I am at the customer site.
Thanks!
Nataliya
4 answers
Hello Nataliya.
This page describes what information you can load from the REST
services: https://jazz.net/wiki/bin/view/Main/RqmApi.
For any additional data you need to follow the Insight customization
scenario (see tutorials in the online help), i.e. add additional DW
tables, update the XDC, update the DM ETL, update the FM Model.
Hope this helps,
Peter.
This page describes what information you can load from the REST
services: https://jazz.net/wiki/bin/view/Main/RqmApi.
For any additional data you need to follow the Insight customization
scenario (see tutorials in the online help), i.e. add additional DW
tables, update the XDC, update the DM ETL, update the FM Model.
Hope this helps,
Peter.
Peter,
The link does not work, can you please resend it?
I know how to customize ETL. That is not my question. My question is: are RQM dynamic sections visible via the RQM REST interface - so I can ETL them over? I do not see them in the xdc file. Is there a trick to make them visible?
Thank you for the help!
Nataliya
The link does not work, can you please resend it?
I know how to customize ETL. That is not my question. My question is: are RQM dynamic sections visible via the RQM REST interface - so I can ETL them over? I do not see them in the xdc file. Is there a trick to make them visible?
Thank you for the help!
Nataliya
Copy-Paste the URL. It seems that my newsreader or the jazz forum app
included the "." into the clickable link.
Custom sections are provided in the REST API, but ootb we do not ETL
them. You would need to use the Insight tools to extend the ETL to add
this data.
Hope this helps,
Peter.
On 9/27/2011 9:53 AM, chaycka wrote:
included the "." into the clickable link.
Custom sections are provided in the REST API, but ootb we do not ETL
them. You would need to use the Insight tools to extend the ETL to add
this data.
Hope this helps,
Peter.
On 9/27/2011 9:53 AM, chaycka wrote:
Peter,
The link does not work, can you please resend it?
I know how to customize ETL. That is not my question. My question is:
are RQM dynamic sections visible via the RQM REST interface - so I
can ETL them over? I do not see them in the xdc file. Is there a
trick to make them visible?
Thank you for the help!
Nataliya
Hi Nataliya,
Custom sections are available in the REST feed from RQM, however, the XML tags used for the custom sections vary from project area to project area. This makes them un-usable by Insight since it requires a fixed schema.
Custom sections are available in the REST feed from RQM, however, the XML tags used for the custom sections vary from project area to project area. This makes them un-usable by Insight since it requires a fixed schema.
Copy-Paste the URL. It seems that my newsreader or the jazz forum app
included the "." into the clickable link.
Custom sections are provided in the REST API, but ootb we do not ETL
them. You would need to use the Insight tools to extend the ETL to add
this data.
Hope this helps,
Peter.
On 9/27/2011 9:53 AM, chaycka wrote:
Peter,
The link does not work, can you please resend it?
I know how to customize ETL. That is not my question. My question is:
are RQM dynamic sections visible via the RQM REST interface - so I
can ETL them over? I do not see them in the xdc file. Is there a
trick to make them visible?
Thank you for the help!
Nataliya