How to access data or files in SAP CloudFoundry environment?

[Former Member]

Hi,

I have deployed an app and binded it to a mongo instance. I would like to access db, add data etc. I tried to connect to the DB in my local machine's DB client, it said "Not reachable". I understand that the behaviour is due to security reasons.

For time being, I have deployed MongoExpress (web-based mongo client) as an app and access / add data using that. What is the ideal way to achieve that?

If possible, I would need access to terminal (SSH). How can I do that?

[Ivan-Mirisola]

Hi Kavitha,

Yes, it is possible to access the file system via SSH. All you need is to issue the following command:

cf enable-ssh <app_name>
cf ssh <app_name>

In order to gain access to the DB residing on your local machine, you will need to open a db tunnel via SSH. For that, please follow the instructions from this page:

But if you really need to connect an application to a DB that is running on your local machine then I would recommend you looking into DB synchronization (from your local to the cloud) using other approaches like Liquibase. On HANA this could be achieved via CDS or Design Time Repository Artifacts and Database import files.

Regards,
Ivan