WeDid: Salesforce and In-House Database Integration (Using Jitterbit)
Challenges
The client has difficulties maintaining data between their In-house Database with Salesforce. Data needed to be replicated from Database to Salesforce.
Solution:
| Purpose | Replicate data from Database to Salesforce |
| Applications | Salesforce In-house Database (MSSQL) |
| Versions | Salesforce In-house Database (MSSQL) |
| Tool | Jitterbit Data Loader for Salesforce |
| Information | Database Customer > Salesforce Account/Contact Database Transactions > Salesforce Transaction Header/Details (Custom object) Database Transactions History > Salesforce Transaction History Database Fund > Salesforce Fund |
| Data Formats | DB/XML |
| Volumes | ~20000 records/day |
| Schedule | Every 30 minutes |
| Complexity | Simple |