Mass transfer of big files from sap to external

[kjyothiraditya]

Hi experts,

Any ideas on how to transfer a number of files which are big like 10 mb, 20 mb so on during business hours to non sap system - Salesforce.

I have tried to send the data in an idoc, but it is taking up resources at pi and slowing down other interface. Also taking huge time.

FTP is last option as other system - Salesforce doesn't have FTP functionality.

Right now we are sending the data in a soap XML message.

Please let me know if there are any other ways.

[Sandra_Rossi]

No doubt that Salesforce is installed on a server, and the server has FTP. And I doubt that Salesforce cannot read a file on its own server.

But your administrator should determine why the transfer is so slow too (is it SAP PI, or the network, or Salesforce software, or ...)

[kjyothiraditya]

Hi Sandra,

Hmm I am not sure about the possibility of FTP server on Salesforce.

Regarding why it is slow, it takes around 2 mins at the sap pi side itself to push the message out of the queue. Best practices suggest to use 4 or 5 mb. This is just the case of single file. But in reality, there will be several parallel files triggered and the queue may overflow/timeout. Also as we are on Dec system, we may not have that many resources. But again do not want this to impact pi system or other interface.

Is there any alternative that you can think of.

For FTP also, does it make use of pi again ?

Regards

Jyothir Aditya

[Sandra_Rossi]

In fact, you were talking about FTP and I couldn't understand "Salesforce doesn't have FTP functionality". But maybe there's a good reason that FTP was not a possible solution, like a cloud-based solution, security, or I don't know. I don't have any idea. Maybe you could add the tag "SAP Process Integration" to your question.

[former_member1716]

jyothir aditya k,

FTP could be an efficient solution for this case,before getting onto solution part please confirm if its Possible in your system with your PI team.

[Jelena_Perfiljeva]

Quick Google search finds that Salesforce recommends using bulk API in this scenario:

https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_intro.htm