Salesforce vs. importing data
Salesforce is a powerful tool when we want to process large amounts of data. But it is quite limited when it comes to methods of importing records.
Let’s take into consideration a fairly normal situation:
You have a local SQL-based database that needs to get updated in near-real time with data changes within Salesforce.
At this point you would have two options:
- Create an app that listens to platform events or change data capture events. Then write these changes to the SQL database.
- Craft some Apex Triggers to call an API (if it exists) that then connects to the SQL database.
The problem arises when more systems need similar integration.
It’s because you would have to go through this whole process again in order to target another database which is extremely inconvenient.
This is even more problematic for larger companies since they more commonly have to deal with large amounts of data, generally coming from various sources.
MuleSoft to the rescue!
For overcoming this obstacle Mulesoft’s Anypoint Studio offers a wide range of features that lets you build true event-driven architecture.
You won’t have to change the code of your existing applications.
It will also connect to any existing Salesforce-provided events, as well as to any other system.
Anypoint Platform offers a variety of options to connect your Salesforce events with any system or database that you need.
That way you can start building architecture without messing around with old code.
That saves a lot of time, as well as helps with any future development-related maintenance which is extremely important for larger companies.