Please refer to the below forum question. They explained it to the Oracle database.
For Legacy Databases, in Mendix, you can´t direct import a legacy tables as a Mendix Entities!
Mendix has a proprietary domain model to work with his ORM
I think the safe Option (as a Free Account) is using Connectors or OQL and create your own ETL like App to Read legacy Data and populate Mendix Entity Objects.
- Connected to the Legacy Database
- Create SQL to retrieve data and convert do Mendix Objects
- Flows to read legacy data and expose as Rest Services
- Import data from LegacyExportApp
AKA CrashCurse Learning Path has some samples:
Hi Toril Opstvedt,
Go through the following link SQL Database setup in Mendix which explains all your queries related to SQL Setup into Mendix.
Hope this helps!