I am in need of setting up a daily data transfer of data from a MySQL database to Salesforce. From what I understand by following instructions here: http://www.cloveretl.com/blog/salesforc ... cloveretl/ this works great but requires extracting the data from MySQL, saving to a CSV file, then using Salesforce Bulk Uploader to upload the CSV file to be imported into Salesforce.
To me this process of saving the export as CSV then sending that to Salesforce seems rather counterintuitive. Is there a better way to do this?
To me this process of saving the export as CSV then sending that to Salesforce seems rather counterintuitive. Is there a better way to do this?
-
Hello Jesse,
If you don't like saving the CSV file, you don't have to. Just use UniversalDataWriter saving the records not into your file system but forwarding the csv via output port to HTTPConnector.
Now you can set Input mapping in the HTTPConnector. Ignore $out.0.inputFileUrl and set $out.0.requestContent instead.
I hope this helps.
Please sign in to leave a comment.
Comments 1