topic Which componentg to insert files stored within MS SQL into Salesforce? in Talend Studio

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

JSey — Sat, 16 Nov 2024 00:37:41 GMT

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.

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

prg — Thu, 11 Feb 2021 16:46:50 GMT

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

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

JSey — Thu, 11 Mar 2021 18:43:47 GMT

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.

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

kholio_ak — Sun, 28 Mar 2021 16:28:44 GMT

Hello @Johnny Sey,

Could you please share a screenshot of the process flow?

Thanks!

regards