BLOB object to Salesforce

One Star

BLOB object to Salesforce

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
Community Manager

Re: BLOB object to Salesforce

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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads