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
2 Answers
-
-
Dec 29, 2016 at 01:32 PM
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
Add comment
Add comment