on 01-31-2012 5:34 PM
Hi Experts,
Recently , we completed a POC for SFDC-SAP integration in which SFDC sends a request and gets a response in their APEX environment. The scenario was SOAP-RFC synchronous.
However, moving ahead with development we want to transfer bulk data ( around 1,000 rows+) from SAP into SFDC on a daily basis.
What are the possible architectural options for this requirement ?
Which scenario/adapters should we use ?
Any other useful tips ?
Thanks in Advance
Dear Folks,
Can some one tell me the adapter that i should use for working with BULK API. Can we use REST adapter for this? What are the steps?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Satish,
I have implemented this integration multiple times and provide consulting on SFDC-SAP integrations.
Technically from PI perspective, it does not matter what API they expose. You should be good to go and use the same methodologies whether its REST/BULK on SFDC side.
On SAP side, you can use PROXY or RFCs, you choice and requirements.
There are no adapters for BULK and REST differently, you have to use SOAP adapter on SFDC side.
Hope it answers your questions..
Hi Sathish,
In normal Enterprise wsdl you can send 200 records per transaction, in Bulk API you can go upto 10000 records per transaction so you can keep your governor limits within control for mass data interchange.
To get the session id you have to call the Enterprise wsdl login method.
I had implemented bulk API using BPM and also implemented by using Java Proxy which was like a wrapper API on SAP WebAS Java.
You can also use the standard HTTP adapter because Bulk API uses HTTP GET and HTTP POST methods to send and receive XML data. Basically you have to carry out series of steps like Create a job( use HTTP POST) and get the JOB ID in response, Query a job using HTTP GET and you get your job status and then add/ send data to the existing batch referencing the JOB ID and then at end you can start processing the job by sending a HTTP POST to close the job.
Normally REST/ BULK API work differently as they involve HTTP architecture and SAP PI normally supports HTTP GET and POST, to implement PATCH/ DELETE you have to either go for JAVA PROXY( expose it as SOAP service and call it using a SOAP adapter and avoid using the XI adapter as that is deprecated and not advisable on PI 7.11 onwards) or rely on Advantco HTTP adapter for REST architecture.
There is no standard adapter for Bulk API but if you feel volume and Governor limits are a constraint then you can rely on other SAP partner solution like SKYVVA cloud but for that you have to buy the solution.
Regards
RJ
Use Bulk API
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
there a few documents on salesforce integration on SDN like this one:
but there are some more too - please do a search
Regards,
Michal Krawczyk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Michal,
Thanks for the response.
We already did a Proof of Concept. Now we are looking for options for bulk data transfer from SAP to SFDC. The scenario we created during POC was SOAP - RFC. However, I doubt we can follow the same approach for bulk data transfer from SAP to SFDC i.e 1000+ rows on daily basis. kindly assist
Hi,
>>>>However, I doubt we can follow the same approach for bulk data transfer from SAP to SFDC i.e 1000+ rows on daily basis.
that's what POCs are for - just test it with 2000 or more date records on the scenario that you have
1000 calls for PI is nothing but you need to test it with SFDC yourself first - once you have issues you can get back
and ask how can it be tuned (either PI or SFDC)
Regards,
Michal Krawczyk
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.