Many to Many Relations in MongoDB Collection Using Teiid.

kulbhushanc Dec 21, 2017 9:53 AM

Hi,

With reference to blog: teiid: SQL on MongoDB using Teiid - Part 2 Can we setup many to many relationship in MongoDB database?

Thanks,

Kulbhushan Chaskar

1. Re: Many to Many Relations in MongoDB Collection Using Teiid.

shawkins Dec 22, 2017 1:05 PM (in response to kulbhushanc)

Did you try defining two 1-to-many relationships?
Actions
2. Re: Many to Many Relations in MongoDB Collection Using Teiid.

rareddy Dec 23, 2017 1:59 PM (in response to kulbhushanc)

There is example of many to many example in mongodb translator document page. See that helps.
Actions
3. Re: Many to Many Relations in MongoDB Collection Using Teiid.

kulbhushanc Dec 25, 2017 3:25 AM (in response to shawkins)

Steven..
Yes, I tried with 1-to-many and it worked well.
Actions
4. Re: Many to Many Relations in MongoDB Collection Using Teiid.

kulbhushanc Dec 25, 2017 3:29 AM (in response to rareddy)

Ramesh...

@ Link MongoDB Translator - Teiid 9.0 (draft) - Project Documentation Editor it is mentioned that "Currently direct mapping of MANY-to-MANY is not supported.", so is it like teiid_mongo:MERGE is not supported? If this can be done in another way How it could be?

Thanks,
Kulbhushan Chaskar
Actions
5. Re: Many to Many Relations in MongoDB Collection Using Teiid.

rareddy Jan 8, 2018 11:09 AM (in response to kulbhushanc)

See MongoDB Translator · Teiid Documentation for many-to-many example.
Actions