cancel
Showing results for 
Search instead for 
Did you mean: 

Binary to xml conversion in PI

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182412
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Thanks Praveen for your reply.

Now, our requirement has been changed.

We are need to send Binary sting from ECC to JDBC receiver via.

Our partner is asking to store the same binary string into thier database directly without any conversion/changes.

Sender: Binary String format in one filed.

Receviver :Should receive same Binary String format and store in the database via sap pi jdbc.

Can anyone please check and help us on this.

Is SAP PI system support,to receive and send the binary string data? Please sugget us.

Thanks & Regards,

Prasad

former_member181985
Active Contributor
Former Member
0 Kudos

Thanks PraveenG, will try with this.

Regards,

Prasad