Hi

You can check service metadata to find relationship between Odata entities

https://serviceurl/$metadata

not sure what you mean Raju

I can see the columns included in the tables and what they are but I can't see what is used as link between two tables.. so I have customer table and product table and in application when product is created against customer mendix somehow can display it but no idea how to recreate it in Tableau by joining both tables. 

See the documentation here: https://docs.mendix.com/refguide/odata-representation/#associations

 https://docs.mendix.com/refguide/supported-odata-operations/#query-options 

The preferred option is the link version. Excel, tablea and Power BI should recognize these links and create associations. If you use the ID option you sometimes have to attach the objects yourself by coupling the ID's.

Regards,

Ronald

Hi Maciej Bedlin,

the link between tables is stored as an ID field. for example in the product table there will be a column like product_customer that holds the ID of the related customer. In tableau you can join the product table and customer table using this ID field.

Hope this helps!

Thanks

hi @Amit... 

I don't see those columns in OData set up in Mendix Pro and not in exported table either 

I have ID field but when linking tables via ID I don't see the desired effect. 

could you maybe see some screenshots how you see those columns in Mendix? 

Hi Maciej Bedlin,

I have a entity Allocation which has associations with different tables. On of the those association is show in the below image, which has been stored as an ID.

I have loaded this data into excel to show the relation:

As you can see in the image Allocation_Category is the ID for the relation between these two tables.

Hope this helps!

Thanks

check service metadata