+ Start a Discussion
vickySFDCvickySFDC 

How to integrate with Salesforce to oracle real time integration ?Urgent Help need.

Hi All,

 I have requirement need connect Salesforce to Oracle when any update in Salesforce object like Account or Opportunity (Name,Stage ..etc) that values need to update in Oracle system.Please guide me Steps and Sample code .How to write Web services class for this integration? Please its very urgent help needded.
Thanks,
Vicky
GulshanRajGulshanRaj
Hello Vicky,

You need to build Webservice calling Oracle database and then simply call this webservice through workflow outbound message.
Please refer outbound message details (https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_om_outboundmessaging.htm) and call it from workflow.

User-added image


Thanks & Regards
Gulshan Raj
Sr. Developer

User-added image
 
Boris FrankBoris Frank
Hello! I can recommend an alternative way. You can use the Skyvia (https://skyvia.com/data-integration/integrate-salesforce-oracle) tool — it allows you to sync Salesforce and Oracle with ease. Skyvia will track changes in the synchronized data sources and update data automatically. You can set the frequency of data updates — for example, once a minute.