Using a third party cloud database in a mobile app

[#1]

Hello!

There was such a question (I could not find the answer on the Internet): Is it possible to connect a third-party storage database (for example, PostreSQL) to a mobile application?

For example, in the "Mobile Connectivity" point, specify a route (url) to the database and for the application to take data from there?

If this is possible, can you show an example / guide / tell how you can do this?

Thanks in advance

[ManuelStampp]

Hello,

do you really want to connect the database directly to an app or is this rather an open question?

In most use-cases you'd implement an application server in front of your database for several reasons, but also in the baseline to allow communication by HTTP, and to integrate with our SDKs, specifically OData.

With SAP Mobile Services Mobile Back-End Tools you can either generate a service based on existing SQL tables (Working with Existing Database Tables - SAP Mobile Services Documentation).

Or you can create a new data model that creates its tables automatically (Service Generator Tool - SAP Mobile Services Documentation) in a bindable database (e.g. PostgreSQL).

Kind regards

Manuel

[Former Member]

Hello!

Rather, I would like to connect a third-party database (PostreSQL) located on another cloud, so as not to interact with Hana. For example, we use Yandex.CLoud with PostreSQL, and register the url from our database in our mobile application. Is this option possible?

[ManuelStampp]

Neither Gregor nor I mentioned HANA.

The question is, which protocol do you connect the app with?

Do you have secured query support via HTTP in your PostgreSQL DB?

If you want to leverage the benefits of our SDKs it should be OData protocol.

SAP as well offers tools for creating OData services with little effort (depending on complexity), like CAP and MBT and you can run them in any supported environment with specific restrictions.

[Former Member]

manuel.stampp, greetings!

I beg your pardon for the long answer. The point is what: I went through the tutorial from Gregor on "Run and Deploy CAP with PostgreSQL on SAP BTP Cloud Foundry" and I would like to understand how now this application can be linked to an Android mobile application built on Sap BTP For Android