accessing mendix data via sql /snowflake / tableau

0
Hi  We are using Mendix as a quoting tool for our customers.   I would like to be able to connect to Mendix tables and run some analitics what products are most quoted, how many times discount was offered etc so essentially the table with values for end quote.    We are at the moment on varsion 9.11.1, so potentially would need to upgrade first to enable latest features.    The question here is, how difficult is it to connect to those tables?   What steps should I undertake first?      Side question.  Would I be able somehow recreate the logic in SQL to produce the final price as per "mendix microflow"?    we don't have at the moment a way to validate if all the variables are added correctly etc. 
asked
2 answers
5

Article to connect Mendix with Snowflake.

Mendix Community

answered
0

Some options:

  • Use view entities (10.22+) to run analytical queries in your mendix app on your app data. See: https://docs.mendix.com/refguide/view-entities/
  • Expose your (view) entities with (odata) apis so you can 1) access them from tableau, 2) export the data via an ETL tool to a reporting/DWH database
  • Export your data with the Snowflake data loader to your Snowflake database. 

 

answered