Which componentg to insert files stored within MS SQL into Salesforce?

[JSey]

Hi

I have files store within a column in base 64 codes within a MS SQL database, which I need to insert into Salesforce Files. I'm not sure which Talend components should I be using. Any suggestion would be appreciated, thanks.

[prg]

Hello @Johnny Sey​ ,

tSalesforceOutputBulk and tSalesforceBulkExec components are used together to output the needed file and then execute intended actions on the file for your Salesforce.com.

Help Documentation: https://help.talend.com/r/mjoDghHoMPI0yuyZ83a13Q/F~g5Eg5ePLeqw6LDRDD33g

Please revert back to the community, if needed.

Regards,

Vaishnavi

[JSey]

In the end I was able to use tSalesforceoutput to create the new contentversion records.

In MS SQL, the files were store in 64 bit, and in the schema it was read as a string. In Salesforce, the field to store the data is call version data on content version object, and the schema is set as byte. In the tmap, I had to use .getBytes() to convert the base64 into byte for the tmap to work. In the tmap:

row1.DocumentBody map to row1.DocumentBodygetBytes() to the VersionData

Also make sure to set the commit level of the Salesforce output to 1.

[kholio_ak]

Hello @Johnny Sey​,

Could you please share a screenshot of the process flow?

Thanks!

regards