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 |