This content has been marked as final.
Show 1 reply
-
1. Re: MongoDB: how do map ObjectID?
rareddy Jan 13, 2014 7:14 PM (in response to ichanjasper)Ivan,
Are you working with existing MongoDB document? If yes, in that case you can map an additional column in your source table as string. For new MongoDB documents that are generated through Teiid translator, what I have done is, instead of using the MongoDB generated ObjectID, I mapped the ObjectID element to the PK column of the table. So, the value of ObectID becomes whatever the PK value that is being inserted. It can even support composite primary keys to represent ObjectID. Note that a PK column's "NameInSource" is automatically set to to "ObjectID", since MongoDB requires column with name "id".
HTH.
Ramesh..