Skip to Content
avatar image
Former Member

Binary to xml conversion in PI

Hi All,

We have two fileds at target, one is for to populate field name and second field is for the content.

1. Sender system ECC [AL11 path] data in binary.

2. Receiver is JDBC system [should send xml format.

We are receving whole string text as a string in the binary format, that should be converted into xml and place whole xml data as a string in one targer field and send it to JDBC Receiver.

Sender data in binary like:

<File_Content>

0A464F4525250A30363639330A6665727874726174730A6A626F646E650A6D6165727473646E650A6316FAA5006011FD95FB38682FC86241A131068AF15A24EC0A7BD0D699EE4BEBAE9D82F391EDD5A6F1695E4EFB8575D8AC9B36F500EB6245AC9BB51C4E1DBB004F3C7715A7473EBA85F017B1153611395A53D860C149DB169D4517D84EC15B51B17675C89F6FCE5CDB3A798D5A99465D4CDDF66224EBC3DA8576E65BDB7D33F19399C6C609BFF187D55BA8376564707C36786DAAD1688F2F1376E99B38686661E67BF345342676831E49B25C01C1270BEF824A9504920FEA020FE8EFB8DE40981C5F8254BFAEA139E1003436C8687327B4E879C8CD7922D93EC8E79EB7A5EA459386476502F57F225A5615DCB25D47648309D88AAFFEABED1BCF85DB5BDC769A20786B9182641E1B66DAADB7EE35DF3DF644DDB9F0811BE4B94810A6EB962585DBC8508F3B846C69F85047DE382C91E395EC137E770BFB336F0A31DAA5F82441F575094C100CE2C075D75B43D03AD4BE43AD90D293D7DEEDD8C48BE374A9D43472B9BBAC55A68B1720FC06AD82EFC6FAC1B01

</File_Content>

Can you please provide step by step process in pi how to reach this scenario.

Thanks & Regards,

Prasad

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 19, 2015 at 12:52 PM

    Hi Prasad,

    Use below UDF.

    What version of PI you are using, you need to see see javax.xml.bind.DatatypeConverter is available in your system or not.

    Mapping will be File_Content->UDF->TragetFiled

    Result:

    You can check below thraed also.

    Regards,

    Praveen.

    Add comment
    10|10000 characters needed characters exceeded