How to consume oData from HANA?

[Former Member]

Hi All:

I am starting using HANA (the trial public version), and I want to expose an oData service that allows me to feed an aplication. How it is possible to do this? Is possible to do it from HANA Studio?

Thanks!

[tomas-krojzl · Accepted solution]

Hello,

I am not sure if I understand - at the moment SAP HANA is not supporting oData - you can choose from following interfaces:

u2022 SQLDBC (only on windows) - SAP native database SDK

u2022 ODBO (OLE DB for OLAP)

u2022 ODBC

u2022 JDBC

Or you might use other SAP technology to provide this... maybe SAP NetWeaver Gateway

http://help.sap.com/saphelp_gateway20/helpdata/en/2f/d48687c1e14e87915d41e595a4285d/frameset.htm

I will also quote what Juergen said about oData (Dec 5, 2011)

Later versions of HANA may include an ODATA interface, so you can talk to your tables and models in the same way you talk to NW Gateway. It won't require a Gateway system, it will just look like one from a protocol point of view. No definite roadmap published as far as I know, so take this information with the appropriate amount of salt..

Tomas

[Former Member · Accepted solution]

Thanks Tomas!

Do you know where is possilbe to get information about to connect JDBC with HANA?

Thanks again!

[tomas-krojzl · Accepted solution]

Hello,

SAP HANA Database - SQL Script Guide

page 45 - chapter Calling SQLScript from Java

https://service.sap.com/~sapidb/011000358700000604932011

SAP HANA - Development Guide

pages 61-65 - chapter 3.5 Using the JDBC Driver

https://service.sap.com/~sapidb/011000358700001168062011

Tomas

[Former Member · Accepted solution]

Thanks!

[Former Member]

Hi, you can checkout my new blog post where I describe how to consume OData services in SAP HANA:

http://scn.sap.com/people/lucas.sparvieri/blog/2012/09/11/sap-hana-odata-services-and-jquery

Hope you like it