Skip to Content
avatar image
Former Member

SAP - SFDC Integration

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 31, 2012 at 05:37 PM
    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Jun 11, 2012 at 06:20 PM

    Use Bulk API 😊

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Ravijeet,

      Please help me understand this BULK API. I would like to know if there are any adapters that can be used for the same.

      Thanks

      Sathish

  • avatar image
    Former Member
    Dec 21, 2013 at 06:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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