We have previously made a brief introduction about the document cache component in one of our blog post. We will continue to elaborate further in this chapter on how this powerful component can help in improving and simplifying your integration process to meet business needs.
Take a look into the following scenario:-
Thousands of sales orders in csv format is retrieved from an FTP server and the information is require to be created into Salesforce as Contact and Opportunities for the existing Salesforce Account records as available in the csv file. The Account’s Shipping Address is require to map to the newly Contact’s Mailing Address and Opportunity’s Shipping Address respectively as well.
One way to achieve this in Boomi is to query the corresponding account’s information (i.e. the Shipping Address) using a connector call in a map function for each incoming record which would utilize multiple API calls.
We can save up the API calls and improve the integration performance by querying all Salesforce Account at once and store the information retrieved by utilizing the “Add to Cache” component instead. For example:-
By using the Document Cache shape as with above:-
- It reduces the usage of multiple connector call in multiple branches hence improve the integration process
- The “cached” data can be easily retrieved in subsequent branches
- Both CSV (customer/sales order information) and Salesforce Account information (Account’s Shipping Address) can be easily combined/retrieve in a single map and processed