Introduction

This article describes how to retrieve user credentials for applications deployed to the SAP Business Technology Platform (BTP), in order to access data in the schemas within database backups.

Environment

Applications hosted in SAP Business Technology Platform

Instructions/Procedure

Mendix creates a service instance of HANA service for deployments, which in turn creates a user and schema.

These credentials can be viewed in the service instance credentials along with all the service binding configurations at SAP BTP cockpit:

Alternatively, these credentials and all service binding configurations can also be obtained via the CLI. This can be achieved by following the steps outlined below:

1. Sign in to the SAP BTP, Cloud Foundry environment (containing the PostgreSQL service) using the Cloud Foundry command line.

2. Get the PostgreSQL service instance details from the environment variables of the application using the following command:

   cf env {application-name}

Please note that backups for applications on SAP BTP are not managed by Mendix. 

Outcome

The user credentials required to access the HANA schemas within database backups will be retrieved.

Additional information 

Not applicable