Salesforce.com Integration – Oracle Fusion Middleware SOA and BPEL

AshokCase Studies, Industry Trends, News and Updates, Technical Tips14 Comments

Oracle Corporation has recently published a white paper written by M&S Consulting, where we take the opportunity to outline an integration approach to Salesforce.com using Oracle BPEL.

A Technical Case Study – Creating an Oracle BPEL adapter to integrate with Salesforce.com – Feb 2009

UPDATE (12/18/10): Oracle seems to have changed the link to the white paper. Until we find the new location, feel free to check out our more recent Oracle SOA 11g Integration with Salesforce.com whitepaper, which we updated to support Oracle’s newer technology offerings.

Below is the introduction to the article, which goes on to detail (with step-by-step screenshots) how to achieve integration with Salesforce.com.

INTRODUCTION
Software as a Service (SAAS) has become a viable cost effective solution to business operations, but has created a new series of challenges for maintaining business agility and data synchronization across an organization. Automated business processes often need to cut through the cloud and continue into other systems in the enterprise. High volumes of sensitive data about customers and opportunities may need to be synchronized with existing support systems. Integrating with Salesforce.com has become a common challenge faced by numerous organizations. This white paper provides a technical case study of how Oracle BPEL can integrate with Salesforce.com to expose powerful business functionality and ultimately, eliminate the boundaries between SAAS and external systems…

14 Comments on “Salesforce.com Integration – Oracle Fusion Middleware SOA and BPEL”

  1. Hi
    I just followed your technical case study to integrate SalesForce with Oracle SOA BPEL 11g. I keep getting error saying the Java null pointer exception.
    Did follow the similar steps and made appropriate changes to the Composite BPEL process. Would appreciate if you have some insights on how to go about getting this implemented in 11g.

    Thanks in Advance
    Sabir

    1. Hey Sabir, We have the 11G version of the white paper coming out this week on OTN to be presented at Oracle Open World, check back to this site in the next week or two for the link.

  2. Hi,

    I couldn’t find the PDF – “salesforce-integration-fusion-middleware-twp.pdf” on Oracle site. I’m trying to integrate SF with Oracle Fusions (11g).

    I’ve downloaded the enterprise.wsdl & when I’m trying to call login() action with valid user & passwd+securityToken, it’s saying — oracle.fabric.common.FabricInvocationException: Unable to acces
    s the following endpoint(s): https://login.salesforce.com/services/Soap/u/20.0

    Please suggest.

  3. I have struggled to integrate SOA 11g with Salesforce (SF) and I think I have addressed most of my problems as you have. But there is one issue I am still grappling with. As you know, SF doesn’t declare the objects in the schema. They only define them in a schema embedded in the wsdl. To manipulate those objects (e.g., perform a transformation) I need to declare them. I don’t want to made changes to the SF schema directly because that changes frequently for us. But I can’t really make the declarations in another wsdl that imports the SF wsdl since that violates WS-I Basic Profile (lack of visibility of embedded schemas in imported wsdls). I see that in the paper, the XML object is created from scratch. I’d rather not do that either since it is constructed independently of the schema definition: a potential source for human error and maintainability issues. I’m looking for a better option. Can anyone suggest one?? Thx.

    – Cris

    1. Hi Cris,

      Could you share the steps you performed for SF – OFMW integration.

      I’m trying to integrate SF with Oracle Fusions (11g).

      I’ve downloaded the enterprise.wsdl & when I’m trying to call login() action with valid user & passwd+securityToken, it’s saying — oracle.fabric.common.FabricInvocationException: Unable to acces
      s the following endpoint(s): https://login.salesforce.com/services/Soap/u/20.0

      Any suggestions?

      1. Shailendra:

        Try taking a smaller step first. Use SoapUI to communicate with SF. It’s an easier diagnostic tool to use. By the way, SF only admits certain IPs or IP ranges defined by your company. Are you sure your request is coming from an allowed IP?

        – Cris

  4. Hi Cris and Shailendra,

    A quick note: It appears you both are using SOA 11g, but have posted comments on our 10g page. Please feel free to visit our 11g white paper that is published on Oracle.com and has replaced the 10g article that is relatively old at this point. Info on that can be found at the following page:

    https://www.mandsconsulting.com/salesforcecom-integration-with-soa-11g

    If you still have issues after going through the 11g article, feel free to reach out with the quick contact form and I’ll get you in touch with someone on the team that can get you pointed in the right direction.

    1. Ashok:

      Strange. I thought I posted to the 11g site. Nevertheless, I had read the 11g white paper. I am not enamored with the idea of building the SF schema object via an XML fragment in the BPEL process. I’d much rather derive it from the definition provided by SF. Right now, I see only a choice between imperfect options. My least hated option is to extract the SF schema from the enterprise.wsdl so that it can be imported into other schemas/wsdls for use. I don’t like doing surgery on a vendor wsdl but I’d prefer that to creating XML fragments. I use Oracle’s xsl transformation activity to populate SF schema objects, not direct assignments.

  5. Hi, Oracle OTN site doesn’t have the ‘A Technical Case Study – Creating an Oracle BPEL adapter to integrate with Salesforce.com – Feb 2009’ pdf anymore. Is there a way to get a copy of the pdf?

    Thanks,

    Angela

  6. Thanks for this! I’ll check this site everyday and looking for some posts like this.

  7. Hi,

    We are getting ready to do our intergration with SalesForce. We have SOA 10g. I couldn’t find the white paper related to 10g. Is there anyway I can access that. Appreciate your help.

    Thanks
    Prapoorna

  8. Hi,

    We are getting ready to intergrate Oracle with SaleForce. We are running SOA 10g. I do not see that 10g whitepaper. I have the 11g paper downlaoded from the OTN site. Appreciate if you can let me know how and where if I can access the 10g whitepaper.

    Thanks
    Prapoorna

Leave a Reply

Your email address will not be published. Required fields are marked *