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
naveen reddy 19naveen reddy 19 

How to connect oracle DB from salesforce

Hi,

 We have a requirement to integrate salesforce with oracle DB. We need the the ability to create, read, edit and delete on the oracle DB and data should be stored in oracle DB from salesforce.

 We can use lightening connect to create, read, edit and delete data from and into an external system using any of these adapters.
A.    OData 2.0 adapter or OData 4.0 adapter
B.    Salesforce adapter
C.    Custom adapter created via Apex

***But we read from blogs and lighting connect documentation that there are limitations/challenges in using lightining connect for write/delete/update to external system.

We have any ODBC/JDBC kind of plug ins to connect from salesforce to Oracle DB?. Please provide any information  or any other options on how can we connect salesforce to oracle DB other then lightning connect adapters.

Thanks,
Naveen
Sumit Sarkar 2Sumit Sarkar 2
SF connect is read/write. What limits are you reading about?

Btw, this is a nice Salesforce/Oracle integration webinar with Appirio and DataDirect who build Salesforce ODBC/JDBC drivers: http://forms.progress.com/datadirect-wbr-Oracle_Data_Integration_Salesforce_Connect
Osvald MarkusOsvald Markus
To connect your Salesforce and Oracle DB try Skyvia (https://skyvia.com/data-integration/integrate-salesforce-oracle). It`s cloud-based solution for no-coding integration with broad mapping and flexible scheduling features.
SimmoSimmo
Hi Naveen,

Did you successfully manage to connect Salesforce to an Orcalce database?
If so, how did you do it?

Thanks
Jon