Attached is a sample pipeline that connects to a Salesforce Object, downloads an attachment and inserts it into MySQL. Since the object already exists in Salesforce there is no need for a create script, but there is a script to create a sample table in MySQL.
To use:
Use the attached script to create a table in MySQL
set a salesforce account to the Salesforce SOQL Snap
set a MySQL account to the MySQL - Insert Snap and select the schema and table
preview the pipeline to confirm all setting are correct, minor adjustments to the fields in the Salesforce SOQL may be required, but it should work as is in most cases.
run the pipeineCreate_sf_attachment_table_in_Msql.csv.zip (861 Bytes)
get sf attachments and insert into mysql_2017_02_28.slp (6.0 KB)
