BLOB object to Salesforce

Anonymous — Sat, 16 Nov 2024 10:11:54 GMT

Hi All,
We have data in BLOB datatype in our oracle Source table. We need to send this data to Salesforce String/Base64 Column.
Can anyone let us know how this functionality can be achieved using talend?
Thanks,
Mohit

Re: BLOB object to Salesforce

Anonymous — Fri, 16 Dec 2016 18:20:08 GMT

You will need to convert from oracle.sql.BLOB to a String. Retrieve the column as an Object. Cast the Object to a oracle.sql.BLOB.
I *think* something like this will work. Please keep in mind that this is not tested and from memory of doing it a while ago....

byte[] byteArray = blobColumn.getBytes(1,blobColumn.length());
String returnVal = new String(byteArray);

You will probably have to play with that a little to get it to work. f your blobs are massive that will also need changing to
handle memory issues.

topic Re: BLOB object to Salesforce in Talend Studio

BLOB object to Salesforce

Re: BLOB object to Salesforce