WeDid: Teradata and Salesforce Integration
December 18, 2014 /
Posted in Integration Corner, We Did
Challenges
A client is managing support cases and work orders through Salesforce. They would like all entries and its children records to be tracked in Teradata as well.
Solution:
| Purpose | Sync any records updates from Salesforce into Teradata |
| Applications | Salesforce.com CRM Teradata |
| Versions | Salesforce Teradata |
| Tool | Boomi |
| Information | Salesforce Case > Teradata Tables Salesforce Custom Object (Work Orders) > Teradata Tables |
| Data Formats | XML |
| Volumes | ~500/day |
| Process | Salesforce Case (and its related record such as Account/Contact/Product) will be created or updated into Teradata respective tables. Salesforce Work Orders (and its related record such as Customer/Product/Warranty) will be created or updated into Teradata respective tables. |
| Schedule | Hourly |
| Complexity | Medium |
