From MTA template to CAP model (hdbcsd, hdbprocedure and xsjs)

[former_member571305]

Hi everyone!

After more than one year working on our current project, we got new requirements that are causing lot's of headaches.

We started using the "Multi-Target Application” template on SAP WebIDE, and now the project contains 3 different modules:

db = database module, defined using HANA CDS (.hdbcds) and HANA procedures to speed up the execution of our kpis. SAP Hana database was a strict requirement because we are using HANA textual analysis.

js = node.js module, based on xsjs files and two different oData services.

ui = html5 module, a classic sapiu5 app.

To archive Multitenancy and the Deploy With Confidence principle, it seems that we need to migrate to CAP model.

I can understand that is a complex scenario but I'd like to ask you a few questions, hoping that some of you know the answers!

1) Is there any way to avoid the conversion of hdbcds to cds? We are using things like "Integer generated by default as identity" that are not supported in cds.

2) Can we still use our HANA procedures (hdbprocedure)? They are optimized to increase performance and usually the load in our app is huge.

3) The node.js module is based on xsjs files. This means that from the ui we are performing ajax calls to execute them. Cal we still use them in CAP?

4) An important requirement is to convert our app in a multitenant app. This means that we need to take care of the subscription and creation of tenents for our customers. Do you know any library to archive it?

Thanks in advance!

Best regards,

Italo

[vLeonkev · Accepted solution]

Hi Italo,

To 1) and 2): CAP supports native HANA artifacts:

https://cap.cloud.sap/docs/advanced/hana/

3) CAP offers OData actions and functions, you can not call xsjs directly:

https://cap.cloud.sap/docs/guides/providing-services#actions-and-functions

4) https://cap.cloud.sap/docs/guides/extensibility

Best

Vladislav