Loading data from SQL Server to Mendix entities

0
Hi All, We are trying to replace an existing system with Mendix web application. It has historical data which needs to be kept. Is there any way to load data from SQL Server database to entities in Mendix domain model? We have a bulk historical data with lot of columns and rows, which is being stored in SQL Server. Re-creating 100+ columns and entering all data in each entity is not practical. Is there any way to pull schema from SQL Server and re-create it as entity? And also, to load data from SQL server to entity?
asked
2 answers
0

Hi Reshman,

You can use the database connector module in the app store. 

https://appstore.home.mendix.com/link/app/2888/Mendix/Database-Connector

 

Here is a link to the test project to help getting it setup.

https://github.com/mendix/database-connector

 

Hope this helps!

answered
0

you can use data base Replication module from Appstore, using which you will be able to get all data and put it into Mendix Database into respective tables

answered