Create new CAP-CDS Model from existing OData-Metadata of an Abap onPremise System

[haykma]

Hi Community,

i am testing around with the cap model on btp. We already developed some Fiori-Apps with an OData-Backend on onPremise Abap-Systems.
For one solution it would be interesting to migrate the OData-Backend to CAP on BTP, so that we can:
a) Reuse the Fiori Frontend
b) Create the Backend Data-Model and Logic on BTP with no dependency to an backend Abap-Stack

To minimize the effort for this, it would be great if there is the possibility to create the cap-model from the OData-Metadata of the Abap-Backend.
Does anybody know if there is such a tool or possibility?

kind regards
Matthias

[david_kunz2]

Hi Matthias,

To some extend, this is possible using `mkdir someDirectory; cds import <path_to_your_metadata_file>`. This will generate a CSN file in the `srv/external` folder, you can have a look at it to e.g. see what data types to use.
You can also use it in your own CDS models (keep in mind to set @cds.persistence.skip: false if you want to also generate database tables for the entities).

Best regards,
David