Search code examples
sql-servermendix

How to connect Mendix to SQL Server?

I'm just learning how to use Mendix and I'm running into a problem. I have a database that holds things such as Landing Zones, County, and Helicopter information. I can't seem to figure out how to connect my SQL Server database to the application. Any ideas?

Solution

  • If you want to get data from another database, you will have to use appservices or webservices.

    Alternatively, you can connect your application to your MSSQL Database Settings -> Profile

    enter image description here enter image description here

    Create entities in your domainmodel for the data, and import your data into the table using the sql tool of your preference (SQL Express)

    This will work for static data. If the data is dynamic, you will need webservices

    Read more on how to import or publish a webservice

    And here on consuming one

    If the data are in another mendix application, you might need to consume a published appservice to do it.

    Finally, you might get more feedback on the Mendix forum