OData with Native SQL

[former_member204370]

Hi

I am creating a SAPUI5 application.

One of the datasource is Oracle, a non-SAP database.

As part of OData implementation, I am planning to use native sql to fetch data from Oracle.

Can I use OData as usually irrespective of native/open-sql implementation?

Please confirm.

Thanks

[former_member184867]

OData Model is the consumption model which is to be used by the User Interface layer which in this  case is UI5. OData model is generic in nature and it hides the implementation complexities/details from the UI. So in short, what UI understands and cares about is only the OData model, not the nature of data source.

On the other hand, database for example Oracle stores data in Relational Model.

These two models are defined by different grammar rules.

Now you need "something" in between to convert this Relational Model to OData model. SAP Gateway, HANA XS are some frameworks that does the job for you.

In Java world we have olingo apis(https://olingo.apache.org/)

which are at much lower level and needs little more coding.

Also SAP Offers tools/products to convert data from non sap data sources to OData.

Have a look at

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

and

Message was edited by: Atanu Mallik