Read Unstructured Binary Data in BODS

[Former Member]

Hi Experts,

The source data is in the form of  Binary data.

Example data:

#S206BIL10000101113550021697C4C687FEE6668E0000XX92000005355044029400000000000023517211700000000000000000

000000000000000000032110000304300003358XXXX0000037500000000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000000000000000000324000003310000031300000351000003770000

03460000039000000331000003150000000000000000000000000000000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

00000000000000826080001234567800000018160800876543210000000000000000000000000000000.

For example the Values about the Machine: Voltage , Temperature, ...etc will come in the form of the above data. We need to decode the binary data and take the values in it and to load to HANA.

Thanks,

Amarnath

[Former Member · Accepted solution]

HI Amarnath,

This record will be read as long data type and use long_to_varchar() function to convent it as varchar value and then use string functions in bods for further processing.

Regards

Asgar

[Former Member]

The above sample data is just one record, which has all the machinery information