Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to know the general approach to import relational data into mongoDB. I want to create a very complex document which uses all the one to many relationships in my relational database, so the document will be very complex and multiple levels deep.
I am not sure of the approach, as the closest article I have come across seems to indicate you need to interface with the mongoDB API manually, but then fails to elaborate on how to add complexity to the document.
http://open-bi.blogspot.co.uk/2013/10/loading-mongodb-with-talend-easy-way.html
I managed to join 2 tables in a query, and create a tWriteJSONFields component to create an array for the many side of the join, but I seem able to only add one loop element. I am likely going to need to bring together 20 tables into a complex document.
As a side matter, my log component created beautiful JSON, but ,my downstream input into mongoDB...all the documents have the double quotes escaped with a backslash....but that's a separate issue.
Any advice, links appreciated.
Stephen