export quote details created within mendix to link with Oracle database in Tableau

0
Hi  In my Mendix App I'm creating quotes based on multiple microflows etc. each Quote will have the part (asset Number) inserted by a user.   At the moment I manually copy all created quotes and references to excel then loading excel to link with Tableau... is there a way to extract data stored behind each Mendix quote? Is there an SQL database behind it or is the only way to do it is via this Odata functionality which I can't really find any useful tutorials or detailed enough documentation how to create it so it is "usable" in tableau.   
asked
1 answers
1

Hi Maciej Bedlin,

If your application is hosted on Mendix Default Cloud, you will not have user credential access to the database, which is part of the agreement while procuring the cloud.

 

Odata is best in your case because you can write dynamic queries in the URL to filter the data.

 

You can also publish a REST service, but you will have to create separate methods when you are changing query parameters.

 

Mendix documentation: https://docs.mendix.com/refguide/exposing-data-to-bi-tools-using-odata/

 

answered