Topic
  • 11 replies
  • Latest Post - ‏2013-08-06T12:41:15Z by Dragos.Cojocari
Liora Milbaum
Liora Milbaum
5 Posts

Pinned topic RPE - RAM integration

‏2013-06-16T11:40:13Z |

Hi,

I am trying to produce a document using RPE which contains data retrieved from Rational Asset Manager.

Following the instructions in my previous question, I have identified the reporting url which will be used by the document template:

http://<ram_server_name>:9080/ram.ws/reporting/asset:shortcut=ramSearch:(1fTag,policy)

In the document template, used the REST Resource Discovery tool:

Name -  REST1

Description -

Base URL - http://<ram_server_name>:9080/ram.ws/reporting/asset:shortcut=ramSearch:(1fTag,policy)

Authenitication type - Basic

User - myuser

Password - mypassword

The "Locate Resource Using Data Service" shows

Current URL: http://<ram_server_name>:9080/ram.ws/reporting/asset:shortcut=ramSearch:(1fTag,policy)?metadata=schema

XML Schema: BLANK

Element Attributes: BLANK

The Finish button is grey and cannot be processed.

Please advise.

 RPE 1.1.1.2

RAM 7.5.1.2

Thanks,

Liora

  • Dragos.Cojocari
    Dragos.Cojocari
    1622 Posts

    Re: RPE - RAM integration

    ‏2013-06-18T07:18:41Z  

    Hey Liora,

    what do you get if you put this URL in a browser: http://<ram_server_name>:9080/ram.ws/reporting/asset:shortcut=ramSearch:(1fTag,policy)?metadata=schema

    Regards,

       Dragos

  • Liora Milbaum
    Liora Milbaum
    5 Posts

    Re: RPE - RAM integration

    ‏2013-06-18T16:59:25Z  

    Hey Dragos,

    The output is the same as if i put the URL 

    http://<ram_server_name>:9080/ram.ws/reporting/asset:shortcut=ramSearch:(1fTag,policy)

    which is the result of the search query inside RAM.

    Thanks,

    Liora

  • Dragos.Cojocari
    Dragos.Cojocari
    1622 Posts

    Re: RPE - RAM integration

    ‏2013-06-19T07:38:59Z  

    Hey Dragos,

    The output is the same as if i put the URL 

    http://<ram_server_name>:9080/ram.ws/reporting/asset:shortcut=ramSearch:(1fTag,policy)

    which is the result of the search query inside RAM.

    Thanks,

    Liora

    Hey Liora,

     

    for the RPE Schema Discovery to work the : http://<ram_server_name>:9080/ram.ws/reporting/asset:shortcut=ramSearch:(1fTag,policy)?metadata=schema must return a schema not the results of a query. This means that this is not the URL to use.  I am not familiar with RAM so I will fw this question to my colleagues from RAM but I suggest you also raise this question on the RAM forums.

     

    Regards,  

        Dragos

  • sranderson8
    sranderson8
    1 Post

    Re: RPE - RAM integration

    ‏2013-06-19T15:16:26Z  

    Hey Liora,

     

    for the RPE Schema Discovery to work the : http://<ram_server_name>:9080/ram.ws/reporting/asset:shortcut=ramSearch:(1fTag,policy)?metadata=schema must return a schema not the results of a query. This means that this is not the URL to use.  I am not familiar with RAM so I will fw this question to my colleagues from RAM but I suggest you also raise this question on the RAM forums.

     

    Regards,  

        Dragos

    There is no API in RAM that returns a schema when you append ?metadata=schema to the URL.  @Dragos, does RPE require a schema?

    In addition to reporting, you may want to look at using the OSLC 2.0 API if you're using RAM 7.5.1.2.  Here are some links.

    http://open-services.net/wiki/asset-management/OSLC-Asset-Management-2.0-Specification/

    http://open-services.net/wiki/asset-management/OSLC-Asset-Management-2.0-Samples/

    https://jazz.net/wiki/bin/view/Main/RamV2RestApiMain

    Not sure if RPE has special support for OSLC APIs.  Maybe Dragos could probably comment on that.

     

  • Liora Milbaum
    Liora Milbaum
    5 Posts

    Re: RPE - RAM integration

    ‏2013-06-23T05:32:28Z  

    There is no API in RAM that returns a schema when you append ?metadata=schema to the URL.  @Dragos, does RPE require a schema?

    In addition to reporting, you may want to look at using the OSLC 2.0 API if you're using RAM 7.5.1.2.  Here are some links.

    http://open-services.net/wiki/asset-management/OSLC-Asset-Management-2.0-Specification/

    http://open-services.net/wiki/asset-management/OSLC-Asset-Management-2.0-Samples/

    https://jazz.net/wiki/bin/view/Main/RamV2RestApiMain

    Not sure if RPE has special support for OSLC APIs.  Maybe Dragos could probably comment on that.

     

    How do I use the OSLC 2.0 API?  I am a newbie.

    Should I embed the API in a HTML file? How is it done?

    Thanks,

    Liora

  • Hagai
    Hagai
    1 Post

    Re: RPE - RAM integration

    ‏2013-06-25T21:56:32Z  

    How do I use the OSLC 2.0 API?  I am a newbie.

    Should I embed the API in a HTML file? How is it done?

    Thanks,

    Liora

    RAM does not return the schema information. I am not a RPE expert, but if you can "manually" create a schema from the (query's) sample result set and use it. eg: (http://www.freeformatter.com/xsd-generator.html) . Would that help you with RPE?

    Thanks

    Hagai

    Updated on 2013-06-25T22:15:40Z at 2013-06-25T22:15:40Z by Hagai
  • Dragos.Cojocari
    Dragos.Cojocari
    1622 Posts

    Re: RPE - RAM integration

    ‏2013-06-27T08:23:02Z  
    • Hagai
    • ‏2013-06-25T21:56:32Z

    RAM does not return the schema information. I am not a RPE expert, but if you can "manually" create a schema from the (query's) sample result set and use it. eg: (http://www.freeformatter.com/xsd-generator.html) . Would that help you with RPE?

    Thanks

    Hagai

    Hey,

     

    >>> RAM does not return the schema information. I am not a RPE expert, but if you can "manually" create a schema from the (query's) sample result set and use it. eg: (http://www.freeformatter.com/xsd-generator.html)

    This should indeed work. If you manage to get an XSD for your data ( using that tool or even manually creating it) you could design your template with it and then just point RPE to the OSLC API and have it process the data. As long as the OSLC API returns XML that matches the schema you will get your report.

     

    Regards,

       Dragos

  • Liora Milbaum
    Liora Milbaum
    5 Posts

    Re: RPE - RAM integration

    ‏2013-08-03T10:13:20Z  

    Hey,

     

    >>> RAM does not return the schema information. I am not a RPE expert, but if you can "manually" create a schema from the (query's) sample result set and use it. eg: (http://www.freeformatter.com/xsd-generator.html)

    This should indeed work. If you manage to get an XSD for your data ( using that tool or even manually creating it) you could design your template with it and then just point RPE to the OSLC API and have it process the data. As long as the OSLC API returns XML that matches the schema you will get your report.

     

    Regards,

       Dragos

    I have created manually the schema from the query's sample result set. Configured a "Simple XML" Data source which uses the result set xml file. The RPE generated a document with data from the XML file.

    But, the next scenario did not work: configured the Data Source as REST 2, using RAM OSLC 2.0 query.

    The Data Preview returned the result set (after authenticating) correctly.  The document generated with no data from the data source.

    I do not know how to troubleshoot this issue any further.

    Please assist,

    Liora

     

     

  • Dragos.Cojocari
    Dragos.Cojocari
    1622 Posts

    Re: RPE - RAM integration

    ‏2013-08-05T08:54:22Z  

    I have created manually the schema from the query's sample result set. Configured a "Simple XML" Data source which uses the result set xml file. The RPE generated a document with data from the XML file.

    But, the next scenario did not work: configured the Data Source as REST 2, using RAM OSLC 2.0 query.

    The Data Preview returned the result set (after authenticating) correctly.  The document generated with no data from the data source.

    I do not know how to troubleshoot this issue any further.

    Please assist,

    Liora

     

     

    Hey Liora,

     

    if the report is empty most likely the schema you created does not match  the data. If you upload the schema, template and the XML file you get from RAM ( use Save As from the preview function of RPE) we can take a look.

     

    Regards,

       Dragos

  • Liora Milbaum
    Liora Milbaum
    5 Posts

    Re: RPE - RAM integration

    ‏2013-08-05T18:54:22Z  

    Hey Liora,

     

    if the report is empty most likely the schema you created does not match  the data. If you upload the schema, template and the XML file you get from RAM ( use Save As from the preview function of RPE) we can take a look.

     

    Regards,

       Dragos

    Hi Dragos,

    My machine is in the cloud. I can give all the information to get in and see the problem.

    I'll send you the details by mail.

     

    Liora

  • Dragos.Cojocari
    Dragos.Cojocari
    1622 Posts

    Re: RPE - RAM integration

    ‏2013-08-06T12:41:15Z  

    Hi Dragos,

    My machine is in the cloud. I can give all the information to get in and see the problem.

    I'll send you the details by mail.

     

    Liora

    Hey Liora,

     

    please provide the information or the data through this forum or contact IBM support. I'm not doing RPE support via email.

     

    Regards,

       Dragos