Connecting SAP Cloud Platform IoT service to HANA Cloud Database

[geert-janklaps]

Hi Experts,

I'm currently looking into connecting the SAP Cloud Platform Internet of Things service (Cloud Foundry) to a SAP HANA Database running in Cloud Foundry. I've figured out that the SQL message processing service can only be updated using the Message Processing API.

So currently I've uploaded following configuration, which is accepted by the IoT service but unfortunately doesn't seem to work.

I've pulled the connection string from a service key I generated on the HANA Database Service. Only difference is the fact that the service key contains a certificate and the IoT service requires a username and password for configuration. If I pull the schema for the SQL configuration using the API I don't see any property in which I can provide the certificate data from the generated service key.

Can anyone guide me in the right direction to get this connection setup?

Thanks in advance!

Geert-Jan Klaps

[johannes_hoenger · Accepted solution]

Dear Geert-Jan Klaps,

the service key you obtained cannot be used to connect IoT Services with your SAP HANA database. Instead use the JDBC user credentials of your SAP HANA Database.

Here is how you can create such user credentials or explore already existing once:

1) navigate to your SAP HANA Service Dashboard

2) click "Go to SAP HANA Cockpit"

3) click "Manage users" in the User & Role Management

Regards,

Johannes