function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
kartik_salesforcekartik_salesforce 

salesforce integration with informatica (with and without using informatica cloud)

Hello sfdc experts and guru's

 

2 Questions from my end:--

 

1)  I looked at videos of informatica cloud and have seen that we can establish a connection(data sync) between  oracle server and salesforce .if i make a change in salesforce data  that change will be in sync with oracle server ( this is ok) .now if some other user of oracle server who hasnt installed informatica cloud makes change to the same oracle database table. will this change be reflected

 

2) I would love to get a step by step process on how to integrate salesforce with Informatica without using informatica cloud. Someone pls help regarding this.

 

Thanks

kartik

Vinita_SFDCVinita_SFDC

Hello Kartik,

 

Ans1: It depends how are you integrating your data with salesforce. If you are integrating salesforce with informatica then your users must have informatica.

 

Ans 2: There are two means by which you can integrate informatica with salesforce:
 

            a) SOAP API: Refer http://www.salesforce.com/us/developer/docs/api/index.htm

 

            b) REST API: Refer http://www.salesforce.com/us/developer/docs/api_rest/
Ketan Thakare 2Ketan Thakare 2
hi kartik,
Will you please tell me how to connect Salesforce to Oracle database using Informatica???
Rangeshwara KonaRangeshwara Kona
did you try Salesforce lightning connect? 
Carol LoudCarol Loud
You can connect Salesforce with Oracle using Skyvia (https://skyvia.com/data-integration/integrate-salesforce-oracle)cloud service 

Also read more about Informatica, its pros and cons, and alternatives here (https://skyvia.com/etl-tools-comparison/informatica-alternative-skyvia)