Boomi Salesforce integration

Unlocking educational data with Boomi Salesforce integration

A UK school eliminated manual data entry, reducing payroll costs and accelerating business processes, with our Boomi Salesforce integration expertise.

Boomi Salesforce integration represented by business puzzle being pieced together

Executive brief

Integrating Salesforce with Boomi

Our client is a group of British independent schools with locations in London, Cambridge, and Birmingham. The group focuses on helping students gain entrance to top-tier universities in the UK. With our Boomi Salesforce integration expertise, the group was able to:

eliminate manual data entry

improve data accuracy

accelerate business processes

free staff for more valuable tasks

Wondering how Dell Boomi integration with Salesforce achieved all this? See the full story below.

The full story

The challenge

Manual processes were hindering efficiency

As our client knows, managing an independent school with locations in three cities is not easy. Firstly you have to maintain the highest educational standards. Then you have to manage relationships with students, parents, staff, and third parties. Finally, you have to keep the school viable as a business. And to achieve all this you need end-to-end efficiency.


So far the school’s digital transformation had consisted of adopting Salesforce, Sage 200, and Advanced Cloud School. But while these systems worked well in their respective areas, they didn’t talk to each other. This meant that staff had to print out data and pass it to other staff members for manual data entry. This process had the following disadvantages:


  • more hours spent on data entry
  • decreased reliability of data
  • no immediate availability of data


While the school looked at integration software that could connect Salesforce and Sage, these products did not have the flexibility to support further integrations. They needed an integration platform that would provide long-term value, whatever applications they decided to adopt in the future.

The solution

Dell Boomi integration with Salesforce, Sage, and Cloud School

After some research, the school decided on Dell Boomi as the integration platform of choice. From there it was a short step to discover our Dell Boomi services. Impressed by our decades of integration experience, the school engaged us to provide the Dell Boomi licence and services.


The project required five connections between the three systems:


  1. Salesforce to Sage 200
  2. Sage 200 to Salesforce
  3. Salesforce to Cloud School
  4. Cloud School to Salesforce
  5. Cloud School to Sage


Each of these connections had to push data only at certain times and when specific conditions were met, to suit the school’s business processes.


For the Boomi Salesforce connections, we used the standard Boomi Salesforce connector. The Sage 200 integration and Cloud School integration, on the other hand, required custom development with Boomi’s HTTP connector, OAuth2, and RESTful APIs.

The benefits

Data for the right people at the right time

This Boomi Salesforce integration project demonstrated the benefits of digital transformation for the workforce, customers, and the bottom line. The success of our Dell Boomi integration with Salesforce has encouraged the school to pursue further integrations for even greater value.


From an IT perspective, the benefits of Dell Boomi integration with Salesforce were:


  • automated data syncing between Salesforce, Sage 200, and Cloud School
  • a central integration platform for ongoing agility and scalability
  • an IT architecture that eases the adoption of new technologies


And from a business perspective, the benefits of Boomi Salesforce integration were:


  • greater value for money from the workforce
  • more time to focus on improving customer experiences
  • reduced risk of mistakes based on manual error
  • increased faith in the accuracy of business data

Transform your data for growth

This school is one of hundreds of organisations that have unlocked their data with our Boomi Salesforce integration expertise. So if you want an expert solution for your integration challenges, contact our Dell Boomi services team.


14th August 2020
Integration, Dell Boomi, Salesforce, Sage, Cloud School

Privacy Preference Center




Analytics cookies collect information that is used either in aggregate form to help us understand how our Websites are being used or how effective our marketing campaigns are, or to help us customise our Websites for you.

Google Analytics
The cookie _gcl_au is used by Google Analytics to understand user interaction with the website.

For example, in order for Google Analytics to determine that two distinct hits belong to the same user, a unique identifier, associated with that particular user, must be sent with each hit.

The analytics.js library accomplishes this via the Client ID field, a unique, randomly generated string that gets stored in the browsers cookies, so subsequent visits to the same site can be associated with the same user.

By default, analytics.js uses a single, first-party cookie named _ga to store the Client ID, but the cookie's name, domain, and expiration time can all be customized. Other cookies created by analytics.js include _gid, AMP_TOKEN and _gac_. These cookies store other randomly generated ids and campaign information about the user.

Google Analytics
_gcl_au, _gid, _ga, gtm_preview


WordPress uses cookies for authentication. That means that in order to log in to our WordPress site, you must have cookies enabled in your browser.

There are two types of cookies set by WordPress.
1 — Session cookies — These are ‘strictly necessary’ cookies as WordPress will not be able to function without it.
2 — Comment cookies — These are not ‘strictly necessary’ cookies and are set when users leave a comment on a post.

Wordpress Session cookies:
Users are those people who have registered an account with the WordPress site.

Wordpress comments:
Comments are usually turned off by default.
If by chance they are still active on a post, asides being turned off when spotted, data from these are not saved by Influential.
- When visitors comment on a post, they too get cookies stored on their computer. This is purely a convenience so that the visitor won’t need to re-type all their information again when they want to leave another comment. Three cookies are set for commenters:

Wordpress, Intercom
comment_author_{HASH} comment_author_email_{HASH} comment_author_url_{HASH} wordpress_[hash] wordpress_logged_in_[hash] wordpress_test_cookie wp-settings-{time}-[UID]