Connect to mendix database from external system

0
Hi All,  I just want to know that is there any way to connect mendix database through external systems? Say we are using builtin database. And want to access mendix database using python script with some sql query to get the data and with username and password. Is that is possible?  Thanks in advance
asked
3 answers
0

Hi Thmanampudi,

This configuration shown in the image is only used for you to connect to an external database locally. To consume the Mendix database through Python, you can create a service that allows this same consumption. You can create an oData service, a rest API or a webservice.

 

Docs:

oData - https://www.mendix.com/blog/odata-apis-in-mendix/

Rest API - https://www.mendix.com/blog/publishing-rest-apis-in-mendix/

 

You can have access to multiple tutorials in this YT Channel: https://www.youtube.com/@MendixWithMe

 

If this answer helped you, mark this as accept

 

Best Regards,

Ricardo Pereira

answered
0

Hello Thmanampudi Lokesh Parameswara Reddy,

 

I would advice if you want to do something like this to use hte OData publish tool, this is within the tooling of Mendix and gives you a good overview and a good interface to decide what you want to share and what not.

 

Hope this helps,

 

Good luck!

answered
0

You can run sql queries on the app database using the java api. See: https://docs.mendix.com/howto/extensibility/howto-datastorage-api/#5-retrieving-objects-using-sql

answered