topic Re: MongoDB to RDBMS in Talend Studio

MongoDB to RDBMS

Anonymous — Sat, 16 Nov 2024 03:11:46 GMT

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

Tried several ways but not working.

Re: MongoDB to RDBMS

Anonymous — Wed, 26 Feb 2020 10:16:44 GMT

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

Re: MongoDB to RDBMS

manodwhb — Wed, 26 Feb 2020 12:53:43 GMT

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

Re: MongoDB to RDBMS

Anonymous — Wed, 26 Feb 2020 13:47:12 GMT

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

Re: MongoDB to RDBMS

Anonymous — Wed, 26 Feb 2020 13:52:30 GMT

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

Re: MongoDB to RDBMS

Anonymous — Wed, 26 Feb 2020 14:58:39 GMT

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