Please refer to the below forum question. They explained it to the Oracle database.
Hi Toril,
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
https://docs.mendix.com/studio7/domain-models/
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.
Example:
LegacyExportApp
- Connected to the Legacy Database
- Create SQL to retrieve data and convert do Mendix Objects
https://docs.mendix.com/appstore/connectors/database-connector/
- Flows to read legacy data and expose as Rest Services
NewApp
- Import data from LegacyExportApp
AKA CrashCurse Learning Path has some samples:
https://academy.mendix.com/link/modules/313/lectures/2362/4.2-Integration-with-Mendix
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!