insert data into hana from JSON .

[Former Member]

being a newbie to HANA space i would like to explore more from SCN for my use case.

My scenario is to insert data into HANA from a JSON file. I have a JS file which can send data in JSON format. The JSON format data is to be inserted in to HANA database.

Any suggestions to bring this into action?

[Former Member]

Hi All,

I have a similar requirement, Inserting json file into HANA to create views.

I have to achieve this use-case in web development (in cloud)

Could you please help me with the steps that I need follow to achieve this use-case.

Thanks in Advance.

[sreehari_vpillai]

hi,

try the below document .

Sreehari

[Former Member]

Hi David,

You can create table and expose it via an Odata service as mentioned by John through the blog and after that you can use the documentation here to Write to HANA using the JSON payload.

--
Shreepad

[Former Member]

The above link not working

[Former Member]

Hi Shashank,

Please try this one.

--

Regards,

Shreepad

[Former Member]

You can create this using HANA XS, with OData or XSJS. Here is a good guide:

You can POST JSON to OData no problem using Postman, or Python, or whatever you want.

John

[rohit_chowdhury17]

Hi John ,

I am completely new to XSODATA . Need your suggestion and guidance on how to post and update records from hybris using XSODATA interface to  HANA .

Also wanted to know if multiple records can be posted from hybris using odata interface to  HANA  as most of the examples in the forum talks about

post single  record using POSTMAN plugin added to chrome.But i need the operation automated .

What would be the approach ,will a separate code needs to be written using UI5 or using XSJS to receive the data and then posting it to HANA or there is any other way by which the url generated for the odata service be utilized for posting data to HANA.

Please provide your valuable insight. Thanks in advance 

Regards

Rohit