Need help, Mobile App to sync with Oracle database is it possible?

[Acid0]

Hi there,

is there a simple method or way to transfer data from a mobile app to a Oracle database?

I understand that you will need a database on the mobile app like sqllite to be able to work offline and store the data.

What I am trying to aim for is to be able to actually sync maybe once or twice a day with the main oracle database to the mobile app and back to the oracle database.

We are currently on Oracle 12c and starting to develop apps on the Android platform.

In your opinion what would be the easiest way to accomplish this?

You ont be able to install a jdbc driver on the mobile so in my limited understanding it would be either something like googles firebase or the Oracle Database Mobile Server

Any help or guidance would be appreciated

 

[Spacerat]

No please dont try to talk to the DBs directly. Create a WebApi on the back-end that exposes a REST/JSON type API. The mobile then talks to that. What is the mobile OS? The mobile can get pull data from / push data to the WebAPI. Depends a bit on what the use-case is though

 

[Acid0]

No please dont try to talk to the DBs directly. Create a WebApi on the back-end that exposes a REST/JSON type API. The mobile then talks to that. What is the mobile OS? The mobile can get pull data from / push data to the WebAPI. Depends a bit on what the use-case is though

So far we are in the dev phase but it will more than likely be Android with sqllite to Oracle database.

It wont be massive data per device we look at maybe 1000 - 500 records per day up or down

 

[Spacerat]

So far we are in the dev phase but it will more than likely be Android with sqllite to Oracle database.

It wont be massive data per device we look at maybe 1000 - 500 records per day up or down

Ok sure but that is even more support for my suggestion. Putting it behind a webapi completely abstracts the mobile side from the tech on the backend. And opens it up to any type of client device

 

[zippy]

As Spacerat says. Webapi. Tried and tested method for mobile apps. With security of course

Btw, this question has been asked and answered many times already.

As a rule, don’t ever connect directly to a corporate database. Only allow direct connections on the internal network. Even then it should always be through an app. Very, very few people, a handful should have direct access to a production dB, and they better have a really good reason.