Apex Code Development You need to sign in to do that
Don't have an account?
Mulesoft as a middleware to Integrate Salesforce with external Database
We are evaluating ETL/Middleware to integrate Salesforce with our external database, and the sync should happen in real time.
Use Case: When an Account gets created in Salesforce, check if the accounts exists in the external database. If it does not exist, create a record in external database. The record gets an autogenerated ExternalID__c. Then, bring the ExternalID__c back to salesforce , and and update the Salesforce record to populate the ExternalID__c field.
If the Account already exists in external database, update the record with the data from salesforce, and then bring the ExternalID__c back to salesforce , and and update the Salesforce record to populate the ExternalID__c field.
My question is what is the best solution for this use case ?
I was looking into Jitterbit and Mulesoft.
What are the Pros and Cons of of using Jitterbit vs Mulesoft for my use case?
Thanks !
Use Case: When an Account gets created in Salesforce, check if the accounts exists in the external database. If it does not exist, create a record in external database. The record gets an autogenerated ExternalID__c. Then, bring the ExternalID__c back to salesforce , and and update the Salesforce record to populate the ExternalID__c field.
If the Account already exists in external database, update the record with the data from salesforce, and then bring the ExternalID__c back to salesforce , and and update the Salesforce record to populate the ExternalID__c field.
My question is what is the best solution for this use case ?
I was looking into Jitterbit and Mulesoft.
What are the Pros and Cons of of using Jitterbit vs Mulesoft for my use case?
Thanks !
James DornAnother option to integrate external database with Salesforce is Skyvia (https://skyvia.com/data-integration/integrate-salesforce-sql-server). It is freemium and has a very intuitive UI.