 <p>You can do</p> <pre><code>CREATE FOREIGN TABLE cases( id varchar(50) PRIMARY KEY, CaseId varchar(50), CaseAddressString varchar(50), CaseOpenDatetime date, CaseBeginDatetime date, CaseDescription varchar(200), RequestorFirstName varchar(50), RequestorLastName varchar(50), CaseCurrentStatus varchar(25), age integer, gender varchar(20), CaseLat float, CaseLong float, ServiceName varchar(50) ) OPTIONS(UPDATABLE 'TRUE'); CREATE FOREIGN TABLE CasePhoneNumbers ( caseid varchar, type string, number string, FOREIGN KEY (caseid) REFERENCES cases (_id) ) OPTIONS(UPDATABLE 'TRUE', "teiid_mongo:MERGE" 'cases') </code></pre> <p>You can see more documentation at <a href="https://docs.jboss.org/author/display/TEIID/MongoDB+Translator" rel="nofollow">https://docs.jboss.org/author/display/TEIID/MongoDB+Translator</a></p> <p><a href="https://issues.jboss.org/browse/TEIID-3040" rel="nofollow">https://issues.jboss.org/browse/TEIID-3040</a> removes th verbose IDREF fields, but this will be in Teiid 8.9</p>