MongoDB to RDBMS

[Anonymous]

Do we need to write java code to extract data from MongoDB (nested) and load to RDBMS ?.

Tried several ways but not working.

[Anonymous]

Hi
Have you tried the MongoDB component such as tMongoDBInput which is used to extract data from MongoDB.
Take a look at online documentation and learn it.
https://help.talend.com/reader/JAVIF8qLh6BhZ~e4~IDqtw/54W_ergq2fADlUjc8G_3fg

Let me know if you have any questions.

Regards
Shong

[manodwhb]

@ris.tan , Please share the job if possible.

[Anonymous]

Hi Shong,

Tried several ways but did not work.

I need to split the string (validation node) below into two rows and load into RDBMS.

Can I achieve this with out using java code?

Really appreciate your help on this.

"audit" : {

"created" : ISODate("2020-02-19T20:53:16.000+0000"),

"modified" : ISODate("2020-02-24T15:43:21.000+0000"),

"payclassUpdatedDate" : ISODate("2020-02-19T20:53:16.000+0000"),

"createdBy" : "Kim M. Jaycox",

"modifiedBy" : "Kim M. Jaycox",

"validation" : [

{

"severity" : "WARNING",

"field" : "contract.effectiveDate",

"rejectedValue" : "06/01/2017",

"message" : "Record overlaps the contract effective and term dates with record ID 791340.",

"validationRule" : "DUPLICATE",

"timesReported" : NumberInt(2)

},

{

"severity" : "WARNING",

"field" : "contract.isLessorOf",

"message" : "No value chosen for Lessor Of field.",

"validationRule" : "MISSING_LESSOR_OF",

"timesReported" : NumberInt(2)

}

]

Thanks,

Sirisha

[Anonymous]

Hi Manohar,

Tried several ways but did not work. Finally I used string functions to split the validation node but not able to loop through it.

database table is getting loaded with 10 records but the first set of values shown below is repeating .

1st set:

"severity" : "WARNING",

"field" : "contract.effectiveDate",

"message" : "Record overlaps the contract effective and term dates with record ID 791340.",

"validationRule" : "DUPLICATE",

"timesReported" : NumberInt(2)

Not able to output the second set of values shown below

2nd set:

"severity" : "WARNING",

"field" : "contract.isLessorOf",

"message" : "No value chosen for Lessor Of field.",

"validationRule" : "MISSING_LESSOR_OF",

"timesReported" : NumberInt(2)

I need to split the string (validation node) below into two rows and load into RDBMS.

Can I achieve this with out using java code?

Really appreciate your help on this.

"audit" : {

"created" : ISODate("2020-02-19T20:53:16.000+0000"),

"modified" : ISODate("2020-02-24T15:43:21.000+0000"),

"payclassUpdatedDate" : ISODate("2020-02-19T20:53:16.000+0000"),

"createdBy" : "Kim M. Jaycox",

"modifiedBy" : "Kim M. Jaycox",

"validation" : [

{

"severity" : "WARNING",

"field" : "contract.effectiveDate",

"message" : "Record overlaps the contract effective and term dates with record ID 791340.",

"validationRule" : "DUPLICATE",

"timesReported" : NumberInt(2)

},

{

"severity" : "WARNING",

"field" : "contract.isLessorOf",

"message" : "No value chosen for Lessor Of field.",

"validationRule" : "MISSING_LESSOR_OF",

"timesReported" : NumberInt(2)

}

]

Thanks,

Sirisha

[Anonymous]

Attached my job. Kindly help me with this. I am new to Talend and got stuck with this for the past few days.

Thanks,

Sirisha

Looping Issue.docx