Question Re: insert data into hana from JSON . in Technology Q&A

insert data into hana from JSON .

Former Member — Mon, 06 Jan 2014 09:38:32 GMT

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?

Re: insert data into hana from JSON .

Former Member — Mon, 06 Jan 2014 21:52:09 GMT

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

Re: insert data into hana from JSON .

Former Member — Tue, 07 Jan 2014 06:21:18 GMT

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

Re: insert data into hana from JSON .

Former Member — Mon, 01 Sep 2014 12:08:48 GMT

The above link not working

Re: insert data into hana from JSON .

Former Member — Thu, 04 Sep 2014 05:08:32 GMT

Hi Shashank,

Please try this one.

Regards,

Shreepad

Re: insert data into hana from JSON .

sreehari_vpillai — Thu, 04 Sep 2014 05:18:53 GMT

hi,

try the below document .

Sreehari

Re: insert data into hana from JSON .

Former Member — Tue, 13 Oct 2015 21:49:03 GMT

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.

Re: insert data into hana from JSON .

rohit_chowdhury17 — Thu, 26 Nov 2015 08:46:10 GMT

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