Cloud Application Model UI5 + Java/node.js + CDS + PostgreSQL/MongoDB

[a_seibel]

Hello,

is there a way to build an application using UI5 as UI Layer, Java/nods.js + CDS as middelware and PostgreSQL Service on AWS as Database in the Cloud Foundry Environment? Especially the connection between Java/node.js + CDS + PostgreSQL Service on AWS is my main question. All tutorials I can find are always Java + CDS + HANA as Database related.

Does anybody have already experience with Java/node.js + CDS + Other DBs instead of HANA/sqlite or a good tutorial?

Regards

Alex

[gregorw]

Hi Alex,

unfortunately SAP has not yet released the PostreSQL driver that seems to exist internally. For the latest developments please check out this thread on Twitter. But you can help to get Postgres support from the community by contributing to gregorwolf/cap-postgres. The current state is that the connection to a PostreSQL server is made and the query is issued. But now the resultset must be mapped to what CAP expects.

Best regards
Gregor

[gregorw]

Hi Alex,

with the now available Service class a first implementation of a PostgreSQL adapter was created at cds-pg. Looking forward for your contributions.

Best regards
Gregor

[gregorw]

Hi a.seibel,

I hope you've followed the progress that we made on cds-pg thanks to the contributions from david.sooter2, mike_za and vobu. And with cds-dbm from mike_za there is now also support for the provisioning of the schema and delta deployment. Check out his blogpost Run and Deploy CAP with PostgreSQL on SAP Cloud Platform Cloud Foundry (Node.js) for more details.

Best regards
Gregor