Get Data from Single File JDBC

[Former Member]

Hi.

I have one scenario. JDBC-- PI -- File.

I want to get data (whole xml) from single field. The table have 03 field , one of them have the informacion as XML

...

   Field03: <?xml version="1.0"?> <Segment01> <Principal>....</<Principal></Segment01>

How can I get the data to transform a Payload and them use to Map to another structure.

Regards.

Xinaxu.

[baskar_gopalakrishnan2 · Accepted solution]

>How can I get the data to transform a Payload and them use to Map to another structure.

You might want to see Copy XMLsubtree feature that comes in 7.1 and later. Also if there are some variants that stop doing map the target structure then you can do using java mapping

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/8649. [original link is broken] [original link is broken] [original link is broken] [original link is broken]

[Former Member · Accepted solution]

hi.

Thanks for your reply, but I use PI 7.0. also I have a previus scenario from Flat file to Flat File and works fine, but now I want to get the source data from JDBC.

Regards.

[Former Member · Accepted solution]

You need to parse xml from field03 using udf or a java map.

Refer the following blogs/threads-

(Refer case 5)