Error while inserting data into hana cloud database BLOB type field with Integration Suite

[amysh95]

Hello Community,

There is one issue while inserting base64 data into hana cloud database where the receiving type field in a BLOB type.

Could someone help on how to insert the image/pdf type of data into hana cloud database with a BLOB type field.

I'm using XML method to insert the data to the JDBC receiver which is pointing to the hana cloud db.

Sample Input

<?xml version="1.0" encoding="UTF-8"?> <root> <StatementName> <dbTableName action="UPDATE_INSERT"> <table>DEVELOPER.DRIVER_MASTER</table> <access> <DRIVER_NAME>test_Name</DRIVER_NAME> <LICENSE_NO>12345</LICENSE_NO> <LICENSE_IMAGE>base64String</LICENSE_IMAGE> </access> <key1> <LICENSE_NO>12345</LICENSE_NO> </key1> </dbTableName> </StatementName> </root>

Here the filed lecense_image is having type blob in hana cloud db.

I cannot change the XML method for inserting the data.

Thanks

[amysh95]

It got resolved by doing some deep search. Thanks