Is it possible to do POST (insert) on HANA using oData service from XS?

[rohith_deraje]

Hi Experts,

Can we do POST/PUT/DELETE on HANA using oData (XS engine)?

If Yes, can you please share some sample?

Regards

Rohith

[Former Member · Accepted solution]

Hi Rohith,

You cannot issue update commands via oData service, however you can use XSJS to post/update/delete records to HANA.

XSJS is a server side script that connects directly to the HANA server and can execute SQL statements such as SELECT/INSERT/UPDATE/DELETE. You can use a client side page which makes an ajax call passing certain parameters to the server side XSJS script, which can then insert/update/delete records to HANA.

You may refer to the following blog by Henrique Pinto which provides step by step details on how to insert values to HANA using an XSJS script.

http://scn.sap.com/docs/DOC-33902

Kind Regards,

Sharan

[Ashok_KumarM]

Hi Rohith,

Now you can perform complete CRUD using xsodata.

let me know if you need more info.

Best Regards,

Ashok.

[amit_upadhye2]

Hi Ashok ,

Can you please post more info on this topic ?

Regards,

Amit.

[former_member189561]

Hi Asiok,

Can can share some sample to us about CRUD using OData?

Thanks a lot.

Yuxin

[RichHeilman]

Not yet.  Currently Odata in XS is read-only. Support for insert, update, and delete is planned for SPS06.

CHeers,

Rich Heilman