Which componentg to insert files stored within MS SQL into Salesforce?
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.
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
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.
