How does an Mendix database in the Mendix cloud work?
I am working on a project and I was told that there is a database in Mendix cloud for Mendix apps and it has to sync with my Oracle database. I've done all the learning paths and I didn't find any special things about how Mendix stores data in the cloud. My understanding is there is no differences, but just a regular JDBC link to a similar RMBMS database (PostgreSQL most likely), and it can work in on-prem mode? Can Mendix customers who have experience on this topic share your thoughts? Thanks.
That's correct. As a default, running in the Mendix cloud your application will sit on a Postgres database. If you deploy on prem or private cloud of your choosing then Mendix can run on any of the database types available under "Project/Settings/Configurations" then New/Edit and drop down on "Type"
I have experience with remote Postgres DB of AWS integrated with multiple Mendix servers. Works perfect (absolute URL) if you have just setup correctly.