Universe in IDT/UDT having RESTful Webservice (data coded using JSON) as the source

[mhmohammed]

Hello everyone,

I've already asked question, Creating a Universe in IDT on top of External RESTful Webservice, in the old SCN portal, but no one answered, so asking again in this new blog, as that project has become a priority now.

I want to be able to create a Universe whose source is RESTful Webservice, and data in that Webservice was coded using JSON. In response to my question on old SAP SCN blog, people asked me to try the blog Creating a Universe on top of a Webservice, which didn't help. Because, that blog is talking about WSDL webservice as the source, for which we get the driver already, and that doesn't help me.

I wanted to ask if SAP provides a connector/driver to the RESTful Webservice whose data was coded using JSON? If not, has someone created their own connector? If yes, I can try to recreate it, I don't know Java SDK, but can try to get SOME (not a lot) of help, if needed.

Appreciate any help on this,

Mahboob Mohammed

[Joe_Peters]

No direct way to do it, as far as I know.

Possible workarounds that I can think of:

• Create a Custom Data Source plug-in (must be built with Java SDK, and creates a source for WRC only; that is, it's not a universe)
• Create an intermediate web application that would retrieve the source data in JSON and covert it to XML, which can then be used as a source for the universe
• Use a jdbc driver that connects to the RESTful source. The universe then connects via jdbc. A quick Google search produced this commercial product: http://www.cdata.com/drivers/json/jdbc/. I don't know any more about it, or if there are non-commercial alternatives available

[mhmohammed]

Thanks Joe!!!

I knew about the 1st and 3rd workaround. My comments:

On 1st workaround: I don't know Java SDK, so can't build it myself, need a colleague to do it. So, I was wondering if someone has built it already.

On 3rd workaround: I don't know if my client wants to spend to get that CData drivers.

Thanks,

Mahboob Mohammed

[mhmohammed]

Anything? Anyone?

Thanks,

Mahboob Mohammed