xQuery & XSJS: how to?

[Former Member]

Hi experts,

i wondering to know if XSJS natively supports xQuery definition. In my scenario i need to realize an XSJS that acts like a "middleware" between SAP Hana DB and external applications that process xQuery inputs: i should extract information from HDB, manipulate, suitably manipulate them and insert them within an xQuery.

Also, if XSJS doesn't support that particular solution, i'd like to know if there's a well-known (or just "known") way to solve this kind of issues.

Searching on various portals i can't find an answer to my issue.

Thanks in advance,

M.

[Former Member · Accepted solution]

Hi Marco,

XS does not support xQuery natively.

Theoretically, it should be possible to import a Javascript implementation of xQuery into you XS code.  A brief search for possible implementations did not turn up any good candidates.

Upon thinking about it some more, I want to know why you want to use xQuery which is XML based, whereas XS is better suited for working with JSON.   So perhaps you could consider using something like JSONPath (http://goessner.net/articles/JsonPath/) which would be a good candidate.

While not a an out of the box solution, hopefully this can provide a helpful starting point.

Good luck.

David

[Former Member · Accepted solution]

Hi David,

the reason why i'd like to use xQuery is that i want to test if its possible to move an XML-based DB into Hana, and how the performances will increase, where XS Engine behaves as a "middleware" between Application layer (that consumes XML data coming from DB) and the Hana DB where i'd like to insert properly XML documents (BLOB column inside a table).

Of course, JSON is a possibility that i was considering so, for this reason, i will test libraries that you have reported to me.