1_10_vendhan - NorCal OAUG

wakefulchardSoftware and s/w Development

Feb 17, 2014 (3 years and 7 months ago)

108 views

Integrating SalesForce To Oracle

Anthony Vendhan

Sami Vellaiyan


Jan 21, 2008


Metron Consulting Specializes in



Oracle Applications Implementations



SOA and Web Services Development



Java & OA Framework Development



OBIEE Development



Web 2.0 Developments using LAMP technologies



Custom Reporting Solutions (Using Oracle tools and
open source technologies)


ABOUT US

AGENDA


Business Case


Proposed Solution


Proposed Architecture


SalesForce Setup


SOA/BPEL Technology


Demo Integration


Reference Information


Questions



BUSINESS CASE



Customer Calls/emails Customer Service (CS) Team



CS Team member creates a case in SalesForce



CS Team member sends an email to the OM Team



OM Person logs into SalesForce system to obtain the serial
number of the returned unit using the case number



OM Person logs back into Oracle Financials system (OFS) and
looks for the serial number using the serial number form



OM Person identifies the customer and create the RMA



OM Person logs back into SalesForce and updates the case with
the RMA Number



BUSINESS CASE CONT’D



Pain Points



Manual Data Entry Errors



Long turn around time



Dissatisfied customers



Lack of Auditing and transparency



Data Integrity Issues




Business wanted to build a seamless integration between
SalesForce and Oracle Applications



PROPOSED SOLUTION



Leverage Salesforce’s outbound messaging functionality



Develop a webservice using Oracle BPEL for Salesforce’s
outbound message


This webservice consumes the case data, validates serial number
and creates the RMA


Deploy the Oracle webservice in Salesforce



PROPOSED ARCHITECTURE

SALESFORCE SETUP



Login to Salesforce (user should have Setup privilege)



Create New Workflow Rule



SALESFORCE SETUP





SALESFORCE SETUP





CREATE CASE IN SALESFORCE





RMA

CREATION IN ORACLE
APPS





BPEL/SOA TECHNOLOGY





BPEL/SOA TECHNOLOGY





BPEL/SOA TECHNOLOGY





BPEL/SOA TECHNOLOGY





BPEL/SOA TECHNOLOGY





BPEL/SOA TECHNOLOGY





REFERENCE INFORMATION


www.salesforce.com


www.developer.force.com


www.salesforce.com/community





Questions????