WeDid: Salesforce and In-House Database Integration (Using Jitterbit)


The client has difficulties maintaining data between their In-house Database with Salesforce. Data needed to be replicated from Database to Salesforce.




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