topic Re: MySQL to MongoDB problems in Talend Studio

MySQL to MongoDB problems

Anonymous — Sat, 16 Nov 2024 09:08:40 GMT

Hello,

i want to migrate data from mysql database to mongo database. I'll take a simple example to illustrate my problem. I've got two mysql tables :

And i want this result in MongoDB :

I don't know how to do this. Do you have any idea ?

Thanks for your help

Re: MySQL to MongoDB problems

Anonymous — Mon, 30 Oct 2017 07:52:36 GMT

Hello,

Is your input data JSON field from your mysql DB?

Please have a look at this component reference: TalendHelpCenter:tExtractJSONFields which is used to extract the desired data from JSON fields based on the JSONPath or XPath query.

And then you can generate directly desired result with tMongodbOutput by using 'Generate JSON Document' in advanced settings of tMongodbOutput component.

Best regards

Sabrina

Re: MySQL to MongoDB problems

Anonymous — Thu, 02 Nov 2017 14:57:07 GMT

I'll try your solution.

Thanks for your help

Re: MySQL to MongoDB problems

Anonymous — Fri, 03 Nov 2017 07:40:39 GMT

Hello,

Feel free to let us know if it is OK with you.

Best regards

Sabrina

Re: MySQL to MongoDB problems

Anonymous — Wed, 08 Nov 2017 14:36:55 GMT

Hello,

I used a tWriteJsonFields, it worked but now i can't handle exporting the JSON data to Mongo with tMongoDBOutput.

I don't use the tExtractJsonFields component because when the job started, i only have mysql data tables input, and not a json file or json string.

Thanks