Access MongoDB data in SAP HANA

[Former Member]

I'm looking for a way to access and process data with SAP HANA which are stored in a MongoDB. Is there an alternative to SAP Data Services? Does anyone have some experience?

[pfefferf]

Hi Matthias,

please can you share more details, what you plan to do with the interface. Is it just to process some data or to replicate some data? Of course the SAP DS Adapter for MongoDB would be a good solution.

If you just wanna process or access some Data on MongoDB you could use XS Classic or XS Advanced (if you have it in place):
- With XS Classic you could use the MongoDB HTTP/REST interface to access the data via an XSHTTPDestination in an XSJS service.

- With XS Advanced you could use a Node.js implementation using one of the MongoDB Adapters (like Mongoose) or also a Java implementation using one of the Java libraries for MongoDB access.

Maybe if you share more details, some more hints can be given.

Regards,
Florian

[former_member235395]

Hi Matthias,

Try using ABAP Proxy and JSON.

Regards,

[pfefferf]

Hi David,

maybe you are able to explain a little bit more your solution you suggest. Saying using an "ABAP Proxy and JSON" is something like it would say use "Node.js and JSON" or use a "USB Stick and copy the data".

Maybe you are thing about the fact, that Matthias does only use HANA system with no ABAP system on top, so your suggestion would be not appropriate (yes, it is hard to believe but SAP is not only ABAP anymore - for some years already).

So why I comment to your answer in that not really serious manner: People should think about there answer, before they post them, to give a qualified answer, instead of a nothing saying "one sentence answer".

Regards,
Florian

[former_member235395]

Dear Florian,

Mongo DB like SAP HANA has a Database, in that way, you will need use a programming language for access the data. Talking of SAP its possible use ABAP for reach de goal.

Regards,

[pfefferf]

I think you have not read my comment and understood what I wanted to say. 😞