0

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?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
William Hodges
  • 661
  • 10
  • 24
  • Hi @william-hodges, have you tried that https://world.mendix.com/display/refguide4/Configuration ? – Andy K Jan 16 '16 at 06:14
  • What would the url path be for a on premises database running in sqlexpress? – William Hodges Jan 16 '16 at 06:16
  • @willam-hodges, have a read on that https://mxforum.mendix.com/questions/711/Does%20Mendix%20run%20on%20Microsoft%20SQL%20Server%20Express%20Edition? – Andy K Jan 16 '16 at 06:28
  • I haven't but I will now. I literally just downloaded Mendix so it's all new. I'm used to writing all the code in c# and xaml lol – William Hodges Jan 16 '16 at 06:29
  • @willam-hodges ok matey – Andy K Jan 16 '16 at 06:30
  • I read you post, but it didn't tell me much. I already have an established database, can I use mendix to access that on local sqlexpress? – William Hodges Jan 16 '16 at 06:32
  • @William, you are trying to get data from your sqlexpress instance? Or do you want to store your data there. – Rik Feb 11 '16 at 15:04
  • posted an answer below, so I could add screenshotd – Rik Feb 12 '16 at 08:50
  • If the other database is not intended as the primary Mendix app database, but you want to access it from Mendix, you can use the Database Connector from the Mendix Marketplace https://marketplace.mendix.com/link/component/2888 – Colin M Oct 01 '21 at 11:25

1 Answers1

1

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

Rik
  • 3,647
  • 2
  • 25
  • 34