cancel
Showing results for 
Search instead for 
Did you mean: 

SAP - SFDC Integration

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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..

Former Member
0 Kudos

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

Former Member
0 Kudos

Use Bulk API

rajasekhar_reddy14
Active Contributor
0 Kudos

Hi Ravi.

Could you please share more info on Bulk API.

Former Member
0 Kudos

Using the normal upsert call you can't handle bulk updates to SFDC. To achieve Bulk transfer of data you need to use the Bulk API option in SalesForce. You need to submit a batch job which is async in nature and accepts REST calls.

rajasekhar_reddy14
Active Contributor
0 Kudos

Will it work in Sync mode?

Former Member
0 Kudos

I hope not. Bulk API is for doing mass data transfers. As you know you just can't keep a SOAP HTTP thread open when you are trying to do a mass data transfer.

If you are trying to send small volume of data you go for Upsert call else go for Bulk API.

rajasekhar_reddy14
Active Contributor
0 Kudos

Yeah i knew it Sync call always risky while  handle bulk load. i doo have exposure to APEX environment and SFDC(little bit) but never tried BULK APIS.

Thnaks for you valuable informatio Ravijeet.

Former Member
0 Kudos

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

MichalKrawczyk
Active Contributor
0 Kudos

Hi,

there a few documents on salesforce integration on SDN like this one:

http://www.google.pl/url?sa=t&rct=j&q=sfdc-sap%20&source=web&cd=1&ved=0CDwQFjAA&url=http%3A%2F%2Fwww...

but there are some more too - please do a search

Regards,

Michal Krawczyk

Former Member
0 Kudos

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

MichalKrawczyk
Active Contributor
0 Kudos

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