function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jconnerjconner 

Direct Salesforce calls to Oracle databases

A lot of what I've seen involves more of accessing Salesforce data in an Oracle PL/SQL program, or creating Oracle database tables from Salesforce data.  A requirement for a project is to display some credit balance fields, which can change often, in Salesforce.  These are sourced in Oracle EBS tables.  We have a few different interfaces up and running, one which, on a nightly basis interfaces changed customer records (addresses, certain attributes, etc.) and batch interfaces which run nightly and send over sales and registrations data.

 

I'm wondering if anyone has implemented a solution to pull data directly from Oracle onto a Salesforce user's screen and can offer recommendations.

 

Thank you!

Satish_SFDCSatish_SFDC
There are oracle web services. I have never implemented this but please check if this is what you need.

http://docs.oracle.com/cd/B28359_01/appdev.111/b28369/xdb_web_services.htm

Regards,
Satish Kumar
Please mark my answer as a solution if it was helpful so it is available to others as a proper solution.
If you felt I went above and beyond, please give me Kudos by clicking on the star icon.