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
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.