WeDid: SAP and Salesforce
Challenges
The client had implemented Salesforce, and required frequent data updates from their SAP system to Salesforce.
In addition a solution was required to allow the upload of a large volume of files into Salesforce, providing visibility
to this information to all Salesforce users.
Solution:
| Purpose | Update financial transactions from SAP to Salesforce. |
| Applications | Salesforce SAP with CSV file output File system containing files for uploaded into Salesforce |
| Versions | salesforce.com CRM |
| Tool | Talend Open Studio |
| Information | Financial Data |
| Data Formats | CSV File Format |
| Volumes | ~1000 records/day ~200 files/day |
| Process | CSV files are extracted frequently from SAP. The integration process parses the file and creates records in a custom object in Salesforce. CSV file contains links to multiple files, integration process checks for file existence in Salesforce, uploading the file as necessary, once only. |
| Schedule | Scheduled to run hourly |
| Complexity | Medium |