Add SAP HANA Support to Your Project

Run the following command in your project root folder:

cds add hana --for production

This adds the hdb module for SAP HANA access to your package.json file and will configure kind sql as the database service.

Changes in the package.json file done by cds add hana:

{
    "name": "cpapp",
    ...
    "cds": {
        "requires": {
            "[production]": {
                "db": {
                    "kind": "hana-cloud"
                }
            },
            "db": {
                "kind": "sql"
            }
        }
    }
}

Different to CAP default behavior, kind sql uses the SQLite in-memory database for local testing and the SAP HANA database for productive usage in the cloud.

Additional Documentation:

• Using Databases
• CAP Configuration

Run cds watch in your project folder and check that your app still works locally as it used to work before at http://localhost:4004/.