Question Re: Using a third party cloud database in a mobile app in Technology Q&A

Using a third party cloud database in a mobile app

Former Member — Tue, 30 Mar 2021 14:10:27 GMT

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

Re: Using a third party cloud database in a mobile app

gregorw — Tue, 30 Mar 2021 14:22:15 GMT

With cds-pg it might be an option for you to create a CAP application that exposes your PostgreSQL DB as an OData service that you can call from via the Mobile Service?

Re: Using a third party cloud database in a mobile app

ManuelStampp — Tue, 30 Mar 2021 14:25:55 GMT

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

Re: Using a third party cloud database in a mobile app

Former Member — Tue, 30 Mar 2021 14:28:43 GMT

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?

Re: Using a third party cloud database in a mobile app

Former Member — Tue, 30 Mar 2021 14:29:33 GMT

Hello!
Can be more?

Re: Using a third party cloud database in a mobile app

ManuelStampp — Tue, 30 Mar 2021 14:39:18 GMT

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.

Re: Using a third party cloud database in a mobile app

gregorw — Wed, 31 Mar 2021 05:33:21 GMT

SAP Cloud Application Programming Model (CAP)

Re: Using a third party cloud database in a mobile app

Former Member — Thu, 01 Apr 2021 07:19:57 GMT

Good day! I went through this tutorial and deployed the applications, but now the question arose - how can I bind it to a mobile project (created in Android Studio using Sap BTP For Android) as a backend?

Re: Using a third party cloud database in a mobile app

gregorw — Thu, 01 Apr 2021 08:06:24 GMT

Have you checked the Tutorials for Mobile Android:

https://developers.sap.com/tutorial-navigator.html?tag=topic:mobile&tag=operating-system:android

Re: Using a third party cloud database in a mobile app

Former Member — Fri, 02 Apr 2021 08:08:47 GMT

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

Re: Using a third party cloud database in a mobile app

Former Member — Fri, 02 Apr 2021 08:12:01 GMT

gregorw

I can't find something suitable

Re: Using a third party cloud database in a mobile app

Former Member — Fri, 02 Apr 2021 08:15:30 GMT

That is, is it possible to convert this application created according to your tutorial into an OData service to connect the backend to a mobile application?

Re: Using a third party cloud database in a mobile app

Former Member — Tue, 13 Apr 2021 07:36:00 GMT

Gregor, I welcome you! I figured out more or less with your adapter and was able to connect it to the mobile application - but tell me how the database change occurs on the backend (adding, deleting, etc.)

Re: Using a third party cloud database in a mobile app

gregorw — Tue, 13 Apr 2021 08:48:35 GMT

Can you provide more details what you define as your backend. Already the CAP application might be a backend as it persists data. But if you need to persist data in an SAP ERP or SAP S/4HANA system then you need to connect to this system and consume the OData service.