In this article, I will discuss about the integration between AWS S3 and Salesforce, using Amazon APPFlow. This is the easiest way to fetch data from Salesforce to AWS. Fun part, all of the steps are configuration only. So, you do not need to take care about complex code, integration failure etc.
The uses cases for this integration
- Archive data from Salesforce, mainly non-transactional or old data which can reside outside of Salesforce.
- Data backup( Full or partial).
Here is the alternate way to fetch data from Salesforce using CDC and Amazon APPFlow
Step 1
Go to Amazon Console and find the appflow from services
https://us-east-1.console.aws.amazon.com/console/home?region=us-east-1 (This link is sample only. Depending upon the region this changes)
Step 2
Search the Amazon AppFlow in the console. Specify the Flow name and description and select the source. There are a lot of sources in the list. From the list choose Salesforce and click next.
Step 3
Click on Create a New Connection and then select appropriate value like Production or sandbox and Enabled or disabled (Private link). For this blog, I entered Production and Disabled value. Then click on Connect and it will ask you the Salesforce credentials. Provide the credentials and it will be connected with the Salesforce.
Step 4
In the next section, choose Salesforce Object, I used Opportunity. Then Select destination as S3 and you need to provide the S3 folder name where the data will be added.
Step 5
Now time to schedule the flow. Choose the trigger option, frequency, start time and date. Addition to that select Transfer mode.
Step 6
Map the source and destination fields and then click on next. In this step additionally you can add validation as well. For this blog, I choose to migrate the opportunities with description.
Step 7
Add the filter if you want. This will give you an added option to filter out the records based on the attributes. Here, I choose to migrate the opportunity where amount is not 0. This is the last settings. After this click on the Activate flow and flow will start.
Step 8
Go back to your S3 bucket and check the data. You will find a folder like below in the S3 and inside that data will be there.
In the next blog, I will discuss how you can migrate the changes from S3 to Salesforce using Amazon AppFlow.
Leave a Reply