![]() ![]() There are already some projects available, that can act as a reference on how to use cds-pg and cds-dbm, e.g. Start using cds-pg and cds-dbm in a CAP project cds-dbm provides this functionality for cds-pg and is designed to support other potential CAP database adapters (think of SQL Server, DB2, MySQL, MariaDB, Amazon RDS…) in the future (that’s why the functionality is not baked in cds-pg, but in its own module). While cds-pg contains the functionality to translate the CDS model to native PostgreSQL during runtime, there is a closely related library available, that deals with the deployment of the generated database schema (tables and views): cds-dbm.įor SAP HANA, SAP is providing the module, that handles all the relevant deployment tasks (analyze the delta between the current state of the database and the current state of the CDS model, deploy the changes to the database, load CSV files, etc.). cds-dbm – Database deployment for PostgreSQL on CAP Since then, some community members ( David Sooter, Lars Hvam, Mike Zaschka) contributed to the project and while it is not yet ready to be used in production, cds-pg already supports many features of CAP (which will be shown later in this post). They also shared their vision and invited others to contribute in a blog post. In August 2020, Volker Buzek and Gregor Wolf started their efforts to build cds-pg, a PostgreSQL adapter for CAP and made it Open Source on GitHub. Since PostgreSQL support is not natively available in CAP, the integration must be provided by others. But how can PostgreSQL can be used in CAP?īy using two Open Source Node.js modules in combination with cds-pgĬds-pg – The PostgreSQL adapter for SAP CDS While SAP HANA may be the better choice in CAP projects closely related to other SAP systems (S/4HANA, etc.), PostgreSQL may be a powerful and cheaper alternative in other scenarios (that maybe aren’t connected to SAP BTP at all). PostgreSQL is a powerful Open Source database, that can be downloaded and used for free and also is available on almost every PaaS-Provider, including SAP BTP ( PostgreSQL on SAP BTP). Out of the box CAP has native support for SAP HANA (and SQLite for development scenarios only), but is also designed to support bring-your-own-database-scenarios (at least since version 4.1). One major part of CAP is the domain model, in which all the domain entities can be defined via Core Data Services (CDS) and either be connected to external services or databases. It comes with pre-baked support for SAP technologies (SAP HANA, SAP Event Mesh, etc.), but is (more and more) designed to be open to other tools, platforms and standards. The SAP Cloud Application Programming Model is an opinionated framework of libraries, languages and tools by SAP to build enterprise-grade cloud-based services and applications. 22.11.20 – cds-dbm deploy now supports a -create-db flag to automatically create the database, see Add and setup the PostgreSQL database.30.11.20 – cds-dbm now supports a nice diff command, see Applying changes to the data model.30.11.20 – Also checkout the newest blog post showcasing the deployment to SAP BTP Cloud Foundry.07.03.21 – Modified names according to SAP’s new naming strategy.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |