Various ways to fetch data from SAP HANA

[former_member229997]

Hi Expert,

Could you please provide various ways to connect SAP HANA and fetch data from HANA and pass it to SAP System/Non SAP System.

OData Service best way to connect and fetch data or else any other ways ?

Appreciate if you could provide information on this.

Regards,

Chintan

[yakcinar · Accepted solution]

Hello Chintan,

These links may help.

Regards,

Yuksel AKCINAR

[SergioG_TX]

Chintan,

you can retrieve data from HANA via XSOData from HANA/non-HANA sources

you can also connect via odbc connection - slower than direct HANA connection

you can also connect with a .net native driver

what is your non-SAP source you are trying to use to fetch data from HANA?

[former_member229997]

Hi Sergio ,

Appreciate your reply.

My non SAP Source are JAVA,Dot Net,TP Linux and SAP source is SAP Hybris.

I want to publish Webservice and file size could be around 10 MB through internet.

Regards,

Chintan

[SergioG_TX]

there may be more questions you need answered, such as:

1) how will the users authenticate?

2) is this a public web service ?

3) xsodata may be a good option, but beware the consumers
may be making open requests, etc.

if you are going to create several APIs, then you can control outputs, limits on how many rows can be output, etc. if you are creating web services to do data dumps, there may be different approaches instead of having an odata service... just a few thoughts.

good luck!

[former_member229997]

Thanks for information.

Could you please tell me which are different approach.

Regards,

Chintan