Question Re: How to develop cap application with external database in Technology Q&A

How to develop cap application with external database

trimbandaru34 — Mon, 11 Dec 2023 03:06:24 GMT

Hi Everyone

We have MySql databse hosted on AWS.

I want to develop CAP application connecting to this external database.

Is this scenario possible? if so, could you please share references/steps?

Thanks

-Trim

Re: How to develop cap application with external database

vbalko-claimate — Mon, 11 Dec 2023 07:38:59 GMT

I cannot answer, but I`m also interested in this topic - if it is possibility to deploy (or at least connect) to the external db.

Re: How to develop cap application with external database

vobu — Mon, 11 Dec 2023 08:30:34 GMT

for PostgreSQL it's absolutely possible with https://github.com/cap-js/cds-dbs/tree/main/postgres, see sample config over at https://github.com/cap-js/cds-dbs/blob/main/postgres/test/service-az.json

For MySQL there is https://github.com/Soontao/cds-mysql - haven't tried it, but might be worth a shot 🙂

Re: How to develop cap application with external database

vbalko-claimate — Mon, 11 Dec 2023 08:49:21 GMT

Thanks vobu,

what is the downsides of such app - deployed to external db? Cannot use other BTP services like XSUAA ?

I`m trying to figure out, how that CAP app is deployed.

1) after deployment, the app is "sitting" in BTP, but connects to external DB as a storage for data only

2) after deployment, app resides somewhere (where?), where DB sits.

Sorry for maybe dumb questions - I`m still in phase of discovery - even, when we have few CAP apps deployed (on PG on BTP)

Re: How to develop cap application with external database

vobu — Mon, 11 Dec 2023 09:46:12 GMT

well, CAP apps don't deploy to a DB, but into a runtime env such as CF. The DB used by the CAP app is just "another service" (in CAP "speak"), whether it sits within the same runtime env or remote. Note that "within the same runtime env" doesn't necessarily mean HTTP roundtrip cost saving as for example the PostgreSQL service "in BTP" also sits externally, requiring HTTP roundtrips.

Additionally, the CAP doc is excellent in terms of deployment: https://cap.cloud.sap/docs/guides/deployment/

Re: How to develop cap application with external database

trimbandaru34 — Tue, 12 Dec 2023 02:33:18 GMT

Thank you vobu for sharing the references. Very helpful.

I will go through the mysql link and try it out.

during my search, I found the below information

https://cap.cloud.sap/docs/about/features#database-support

Does this mean, there is no official support for MySql from SAP CAP implementation point of view?

Thanks

-Trim

Re: How to develop cap application with external database

vobu — Tue, 12 Dec 2023 07:53:40 GMT

correct, no official MySQL support for CAP, "only" community support.

Re: How to develop cap application with external database

lleyton — Wed, 31 Jan 2024 14:52:43 GMT

Hello,

did someone manage to connect to MySQL?

Would be highly appreciated if someone can share.

Thank you!