Think. Build. Salesforce Solutions.

Salesforce Consulting Services across Salesforce Clouds & Across App Lifecycles

Blog

How to connect AWS and Salesforce Using Dell Boomi?

By |2023-08-22T08:58:22+00:00August 22nd, 2023|

Your organization is using both AWS and Salesforce, and you want to establish a robust integration between the two platforms. The primary goal is to automate data flow and ensure real-time data synchronization, reducing manual efforts and data inconsistencies. To achieve this, we’ll use Dell Boomi, a cloud-based integration platform that simplifies the process of connecting different applications and systems.

Prerequisites:

1. Create/Have an AWS account.

  • https://aws.amazon.com/console/
  • Click on Sign…….
  • IF you do not have an AWS account so create the account following these steps:
  • Go to the AWS website (https://aws.amazon.com/console/) and click on the “Create an AWS Account” button at the top right corner of the page.
  • Enter your personal details with your email address then sign up.
  • You need to credit card/debit card the create an AWS account.

2. Create/Have a Salesforce account.

3. Create/Have a Dell Boomi Account.

  • https://platform.boomi.com/
  • Click on Sign…….
  • IF you do not have a Dell Boomi account so create the account following these steps:
  • Go to the Dell Boomi website (https://boomi.com/form/trial/) and click on the “Free Trail” button.
  • Enter your First Name, Last Name, business email address, and some more details then submit.
  • You will get a mail after submitting your detail then you can reset your password.
  • Now you can log in to your Dell Boomi account after following all the steps.

4. Basic knowledge of AWS and Salesforce.

AWS:
AWS documentation: https://docs.aws.amazon.com/

Salesforce:
Salesforce documentation: https://developer.salesforce.com/docs/

Dell Boomi:
Dell Boomi Integration documentation: https://help.boomi.com/category/integration

Here are the steps for How to connect AWS and Salesforce Using Dell Boom:

Step 1: AWS

AWS is an Amazon Web Service by Amazon that provides on-demand cloud computing and some tools to use for sending email, data access, and so on.

1. Create an AWS Elastic User:

Amazon Web Services (AWS) Elastic Compute Cloud (EC2) is a web service that provides resizable compute capacity in the cloud. It allows users to create a username and give permission to the user.

Here’s how to create an AWS Elastic User:

  • Open the link.
  • https://us-east-1.console.aws.amazon.com/iamv2/home?region=us-east- 1%23/security_credentials
  • Navigate to Access Management >> Users >> Add Users
  • Enter Username>> Next.
  • Permissions Options >> Attach Policies directly
  • Permissions Policies >>Give Amazon S3 Full Access Permission >>Next.
  • Review the details and Click on the button ‘Create User’. Below AWS Elastic user record in AWS gets created.

Connect AWS and Salesforce

2. Create Access keys:

Amazon Web Services (AWS) provides access keys and secret key that allow user to connect and access from the AWS.

Here’s how to Create Access keys:

  • Click on your AWS Elastic User >> Security Credentials >> Create Access keys.
  • Application running outside AWS >>Next >>Next>> Done.

Create Access keys

3. Create AWS S3 Bucket and upload the file.

Amazon S3 (Simple Storage Service) is a highly scalable and durable object storage service provided by Amazon Web Services (AWS). We need to update the file in Amazon S3 Bucket after that we can access outside the salesforce.

Here’s how to Create AWS S3 Bucket:
Create Bucket in AWS S3.
Upload the file in a bucket and give the permission as Everyone (public access) (Read)

Step 2: Dell Boomi

Dell Boomi is a cloud integration platform for connecting the cloud and On-Prem applications and it also has ETL capabilities. It is an IPAAS (Integration Platform as a Service)

1. Create a folder and Process in the Boomi.

  • Connect AWS and SalesforceCreate a New Process in the Dell Boomi.
  • Create New  >> Process  >> Start with No Data.

2. Create the Amazon S3 Connection.

  • Add the Amazon S3 REST Connector with GET Action.
  • We need to add Connection and Operations.
  • Connections >> Like, Amazon S3 REST Connection
  • Give Amazon the access key and secret key.

Connect AWS and Salesforce

  • Operations >> Like, Amazon S3 REST Operations.
  • Click on Import button >> fetch your bucket which is present in AWS S3 >> Finish.

Connect Salesforce and AWS

  • Add the Parameter that is Id and the static value is that file name which is present in AWS.

Connect Salesforce and AWS

3. Create Branch Shape

  • Branch shape is used when you have multiple action, but you want to execute one by one.
  • There we have created 2 branches because we want to create/upset account records after create account link by account.
  • We need to first branch create/upset accounts with an external id.
  • After that, the second branch creates contact with an account using an external id.

Connect AWS and Salesforce

4. Create a Decision Shape in Branch 1:

  • The Decision Shape is the comparison of two values according to true/false.
  • As of now, we have written decision shape according to AnnualRevenue <=50000
  • If it is true, then save the account record with one filed custom (Unchecked).
  • If it is false, then save the account record with one filed custom (Checked).

Connect AWS and Salesforce

5. Create Map Shape

  • Map shape is used for mapping the fields.
  • We can use also use formulas in the map.
  • We have created map and create account and contact according to AWS file field.

Connect Salesforce and AWS

6. Create Try/Catch Shape

  • When we are using try/catch shape if you want to catch your error.
  • Here we are using try/catch, In the try block, we are storing data in the salesforce account and contact object.
  • In the catch block, we catch errors and map the field, and store errors in the salesforce error object.

7. Create Salesforce Connector

  • Add Salesforce Connector according to the Account/Contact/Error object with Send Action.
  • We need to add Connection and Operations.
  • Connection is the same for all the objects. Username >> your salesforce username and Password >> salesforce password + security token.

Connect Salesforce and AWS

  • Operation is different according to the object.
  • Import >> Choose your connection >> Next >> Choose object (Account/Contact/Error) and choose action (Create/Upsert/Update/Delete) >> Next >> Finish.
  • For Account Object. We have added the Account_External_Id__c field for External ID.

Connect AWS and Salesforce

  • For Contact Object, Account ID >> Account (Object Type) , Account_External_Id__c (Ref External ID).

Connect AWS and Salesforce

  • For Exception Log Object to store the error.

Connect Salesforce and AWS

8. Create an End/Stop Shape

The Stop Shape provide to terminate the data flow in process path.

9. Overall Process

Connect AWS and Salesforce

10. Atom and Environment

  • Atom: The Atom Cloud is a highly scalable, highly available execution environment that can support many users.
  • Manage >>  Atom Management >> New Atom (For Prod and testing).
  • Environment: An Environment is a workspace that users create for testing or production.
  • Manage >> Atom Management >> New Environment (Add Atom for Prod and testing).

Connect Salesforce and AWS

11. Test Mode

  • Test Mode allows u to quickly test processes from the build page without deploying the process to an atom.
  • Connect AWS and Salesforce
    Click on the Test button >> Select Test Cloud >> OK.

12. Deployment

Deployment is how you prepare your processes and components to run and operate in a Test or Production Environment

Deployment Steps:

  • From the Build tab, select Create Packaged Component >> Next: Add Details
  • Version >> IE-MONYYYY-01, Package Notes >> Initial Package, click Not Allowed, Press Create Packaged Component(1) >> Close >> Deploy >> Packaged Components.
  • Action >> Deploy >> Production, notes >> initial deployment >> Select Versions >> Review >> Deploy >> View Deployments.

Conclusion:

Integrating AWS and Salesforce using Dell Boomi streamlines your organization’s data flow and eliminates manual data handling, enabling you to make better-informed decisions and enhance operational efficiency.

Leave A Comment