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
Siddharth PrakashSiddharth Prakash 

Oracle and salesforce integration using lightning connect/other methods

Hi Team,

We need to intergrate couple of objects from oracle to salesforce on a daily basis. To acheive this , we need to integrate salesforce and oracle - then read data from two tables in oracle. Does anyone have experience in this ?

Regards
Siddharth
KaranrajKaranraj
Siddharth - There are three options to integrate Oracle and Salesforce

1. Using Lightning Connect you can able to integrate with the Oracle database using OData 2.0 service. First you have to create Odata 2.0 service for your oracle database, then using that service you can able to bring the oracle data into salesforce easilt using Ligning connect.
Check this link for creating ODATA service for the Oracle database (http://download.oracle.com/oll/obe/EntityFrameworkWCF/WCFEntityFramework.htm) Currently Lighning connect supports only read access for the External data which means you can't edit external data inside the salesforce and also you have purchase Lightning connect licences sperately to use. To know more about Lighning connect check this Trailhead module - Introduction to Lightning Connect (https://developer.salesforce.com/trailhead/lightning_connect/lightning_connect_introduction)

2. ETL tool - You can use any ETL tools like Informatica, Dell boomi, Jitter bit etc., which has the salesforce and oracle connector to make the data integration between  two system on daily basis.

3. Write customer webservice code to connect the oracle system and amke webservice callout to get and store the data in the salesforce. This option is fully customized, you have develop the intergration/webservice code from the scratch.
Siddharth PrakashSiddharth Prakash
Hi Karanraj,

Thanks for the inputs. Is there any place that i can read more on Option 1 and 3.
I am assuming that the option 2 will be a paid one and I know Jitter is at 2k USD per month. I needed a more detailed insight also as in what are the things to consider , what can fail , what are the best practices used etc.

Regards
Siddharth
Siddharth PrakashSiddharth Prakash
Hi Karanraj,

Thanks for the inputs. Is there any place that i can read more on Option 1 and 3.
I am assuming that the option 2 will be a paid one and I know Jitter is at 2k USD per month. I needed a more detailed insight also as in what are the things to consider , what can fail , what are the best practices used etc.

Regards
Siddharth
KaranrajKaranraj
Hi Siddharth - To know more about Lighnint Connect check the Trailhead module which contains all the details including the other refrences documentation link, which will be helpfull for you understand about lightning connect. Check the following links which might be helpful for you
1. Building Data Integration Proof of concept using Lighning Connect (https://developer.salesforce.com/page/Building_a_Data_Integration_Proof_of_Concept_Using_Lightning_Components)
2. Integrating force.com with on-Premies Database (https://developer.salesforce.com/page/Integrate_Salesforce.com_With_Your_On-premise_Database)
3. Integrating with Force.com Platform (https://developer.salesforce.com/page/Integrating_with_the_Force.com_Platform)
4. Consideration for Lightning Connect (http://ttps://help.salesforce.com/apex/HTViewHelpDoc?id=platform_connect_considerations.htm&language=en_US)
Siddharth PrakashSiddharth Prakash
Hi Karanraj,

Thanks for these links.
But after looking at the costs for Lightning connect, we have decided to follow option 3. If you have any links on that , it would be helpful.
Else ,we will have to start the integration process from scratch

Regards
Siddharth
Jamie MartinJamie Martin
Hi there,

You can easily connect Salesforce to Oracle database with help of our product Skyvia Connect (https://skyvia.com/connect/salesforce-connect). It is a CaaS solution that allows users to expose their data via the OData protocol almost instantly, with no coding and no configuration. Besides, the price for it is more affordable then Jitterbit, it starts from $15/month.