Question

Accessing the mendix database in mendix cloud

0

Hi, How can i access the mendix database related to my mendix cloud app from my local computer (via SQL, or Excel, or other querying tool)

asked 2019-07-02

Bobby Kareer

3 answers

Mitchel Mol · Answer 1 · 2019-07-02

@Bobby

Look at https://docs.mendix.com/refguide/published-odata-services for details on how to expose your data via OData.

Stèphan Numan TimeSeries · Answer 2 · 2019-07-02

Direct access to the database is prohibited.

You could try odata access to access your data from excel or other tool.

Rob Dekkers · Answer 3 · 2019-07-07

An option is the OQL-module from the appstore to create queries on the database. We have extended this module with GUI for saved query's with parameters. We export results to Excel. This is for query only, but is dynamic and direct on database. In a Data set you can write your OQL-queries with some syntax and join support of the modeller.