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.
|Purpose||Update financial transactions from SAP to Salesforce.|
SAP with CSV file output
File system containing files for uploaded into Salesforce
|Tool||Talend Open Studio|
|Data Formats||CSV File Format|
|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|