Consume ODM JSON objects in HANA Cloud

[juraj_woletz]

Dear all,

we plan to start consuming business objects in form of official ODM model (CDS) which will be received in form of their JSON representation.

To be more specific let's say that we would like to be able to consume Expense Report (header+lines) which will be landed into S3 bucket in JSON ODM format.

What is the best way to consume such business objects? Aim is to store these objects in form of HANA Cloud tables - e.g. using the CDS models of the business objects (Expense Report) to create persistence layer in HANA Cloud and then find the ideal mechanism of consuming landed JSONs in ODM format and store these in HANA Cloud for analytical use cases.

Based on the documentation it seems that CAP should be the ideal way of doing this - can you please provide more info or sample projects of how exactly to consume official ODM CDS models, use these for creating matching persistence layer and then to start consuming business objects in ODM JSON format?

As the middle layer we might be using Data Intelligence, but ideally if you could provide more hints where this consumption layer should live in - maybe in SAP Cloud Platform?

Thanks a lot,

Juraj Woletz

[vansyckel]

Dear juraj.woletz,

You are right that CAP is ideal for this scenario.

An outline of the solution could be:

• Once available, import required ODM models from SAP API Business Hub (cf. https://blogs.sap.com/2020/06/05/sap-one-domain-model-the-lingua-franca-of-the-integrated-intelligen...) in order to create the data structure in your HANA
• Let your CAP app know about new Expense Reports, etc., e.g., via messaging (GA planned for later this year) or OData (you'd need to parse the JSON in the sending entity)
• In case of messaging, register custom handlers (cf. https://cap.cloud.sap/docs/node.js/api#cds-event-handlers) that insert the parsed JSON into your HANA using CAP's query language (cf. https://cap.cloud.sap/docs/node.js/api#cds-ql)

Best,
Sebastian