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

Basic Integration Question


I am developer and new to Integration. Currently we have standard alone java application which is used to connect Oracle database to update salesforce data. Currently we have hard coded the credentials in java program.


 - What is best approach for programmatic (Java) Integration? SOAP or REST? (The volume of data is huge.) 

 - What is best authentication approach to avoid hard coding the credentials in the application?


As per my knowledge Oauth will work only for web applications.


Kindly clarify the above questions and also suggest the resources that gives good understanding in SOAP, Rest ,Oauth....


Thanks in advance.


- Indy.

Hi Indy,
If the volume of data is huge you would best use the bulk API (it is based on REST).

Check these links:

Regarding security and authentication you could use several ways, just search in the documentation: "authentication"

I would use Oauth - it is built in the system, and it works great (you can use it for non mobile APIs as well) or You could use the Understanding the Username-Password OAuth Authentication Flow, both are great solutions.

I hope it helps,

Hi Roy,

Thanks for your reply. 

I have gone through the documents but all the methods of Oauth , we have to use Username and Password in the client code.

Is there a way to avoid this.? Also please provide any sample code that uses Oauth.