Salesforce and custom ERP system
Business Challenge
An existing custom ERP system built on SQL Server had historically been the repository for all Account, Contact and Customer information and activity recording. After the implementation of Salesforce, activities for Customers would continue to be recorded in the ERP system and would need to be updated to Salesforce for visibility by the sales teams.
| Purpose | Ensure all Activity data was automatically updated between the two systems |
| Applications | In-house ERP (Database) Salesforce.com CRM |
| Versions | SQL Server 2005 Salesforce – Winter 09 |
| Integration option | Boomi – Database Connector Boomi – Salesforce Connector |
| Information | Task Table User Table Salesforce Opportunities Salesforce Activities |
| Data formats | No intermediate data format, DB records to Salesforce XML and vice versa. |
| Data volumes | < 10/day |
| Integration process | Tasks created in the ERP system are added as Activities in Salesforce |
| Schedule | Hourly |
| Error handling | Email to nominated contact at client. |
| Time Spent | 4 days |
| Complexity | Simple |
Our Solution
What is RIO
RIO ReadyMade
RIO In Action
Getting Started
Inside RIO
Find us at:
