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 |