topic Re: Loading XML data into Oracle Database in Talend Studio

Loading XML data into Oracle Database

Anonymous — Thu, 10 Aug 2017 11:55:53 GMT

Hi All, I have an XML file which contains more child level and members. Each child level having multiple members(Sub Levels). while loading the data it is loading the first member only not all members. I have attached source and XML component screen shot. kindly advise how to process it. Regards, Avinash

Re: Loading XML data into Oracle Database

Anonymous — Fri, 11 Aug 2017 15:34:41 GMT

Hi,

You have to put your loop element on the members element 😃

Good luck !

Re: Loading XML data into Oracle Database

Anonymous — Sun, 13 Aug 2017 07:35:01 GMT

Not Working, I want to load the role name. which member belongs to what role.

Any advice.

Regards,

Avinash

Re: Loading XML data into Oracle Database

Anonymous — Wed, 16 Aug 2017 08:10:08 GMT

I think, with this solution and your xml schema, the role name must be loaded, can you send a screenshot of your mapping ?

This mapping should gave you :

| app-role-name | app-role-display-name | member-name

| BI_CFO_Procurement_Consumer_All | BI CFO Procurement Consumer All Role | Ngoash_N

| BI_CFO_Procurement_Consumer_All | BI CFO Procurement Consumer All Role | ntshan_n

| BI_CFO_Procurement_Consumer_All | BI CFO Procurement Consumer All Role | Bontsi_H

| BI_CFO_Procurement_Consumer_All | BI CFO Procurement Consumer All Role | Hoffma_A

...

It is not what you want ??

Re: Loading XML data into Oracle Database

Anonymous — Wed, 16 Aug 2017 12:50:35 GMT

Hi Sgv,

Thanks, working on adding members into the loop.

Regards,

Avinash