Overview |
In this article you will learn how to transfer data from and to an FTP server to Saleforce. First, you will see a data map, explaining the relationship between fields in Salesforce and fields in the file stored in an FTP server.
Data Map |
As we are tranferring data from / to Salesforce to / from a file stored in an FTP server, we need to map the fields from Salesforce to the fields in our file. The fields from Salesforce are defined by the chose table (for example Accounts). The fields in the file are defined by the user, although it is a good practice to keep the same nomenclature.
Data Flow |
As we are working with Salesforce and a file defined by us, the data flow is defined by Salesforce, and mirrowed by the file content.
Field Mapping |
As we saw in the data map, we can map the fields from Salesforce into fields of different names created in the file stored in the FTP server. It is a good practice to keep the same nomenclature. The figure that appears below shows an example for the Accounts table from Salesforce. However, be aware that any other table from Salesforce could have been considered.
Creating the Integration |
In order to transfer data from Saleforce to an FTP server (and vice versa), do the following steps:
Note: to transfer from Salesforce to an FTP server, define the Trigger using the Salesforce connector and the Rule using the FTP connector.
Additional Information |
You can find additional information in the following links:
How to conveniently transfer data to and from FTP servers using DBSyn : this article contains a detailed description on how to transfer data between Salesforce and a file contained in an FTP server.