Is it possible to save data directly into an external database without saving it in mendixs?
Is it possible to save data directly into an external database without saving it in mendix’s database? I am currently using an OracleDB to export my data. But there is some sensitive info that my client would prefer to be only stored in the external DB, as opposed to both. We also have the problem that mendix’s db’s storage is somewhat small, which could be problematic in the future. The client does not want to switch to a payed plan.
In this case I think you have two options that I can think of:
Save the data in a non-persistent entity and immediately use a rest service to send the data to another program that can store it in it's database.
If that is not possible you can add the Database connector widget to you project. (https://marketplace.mendix.com/link/component/2888). This will allow you to connect to an external database and add the data to the external database through SQL querys.
You can find more information here: https://docs.mendix.com/howto/integration/execute-an-sql-statement-on-an-external-database
You can do this with NPEs (Non Persistent Entities) and the database connector. NPEs only live in memory, and are not persisted to your local database. Retrieve your data from the oracle database into NPEs, edit them in a page, and then save them back to the oracle database using the database connector.