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
SUMAN KUMARI 70SUMAN KUMARI 70 

Framework to extract data from Salesforce and transfer it to oracle data base

I need to develop a JavaScript Application which will integrate with salesforce and will archive its data into offline databases(Oracle db/ my sql etc).
Can I anyone please suggest how to create such an application and integrate it with salesforce.

Thanks a lot in advance.
SwethaSwetha (Salesforce Developers) 
HI Suman,

There is no documented way to achieve this functionality. You might want to consider using third-party ETL tools like https://skyvia.com/data-integration/replicate-salesforce-to-oracle 
 
Hope this helps you. Please mark this answer as best so that others facing the same issue will find this information useful. Thank you
VinayVinay (Salesforce Developers) 
Hi Suman,

You can set up data extraction to occur every night using Data loader from the command line.

https://developer.salesforce.com/page/Using_Data_Loader_from_the_command_line

After you have the data extraction you can then run a job to load this information to your oracle database.

>> Integrate the data into salesforce.com and store the data using the Force.com Web Services API. Then build your UI interface on that data as needed. or you could use the Data Loader to update the data. 

>> Web-service enables your backend data and have apex make "callouts" (web service calls) to retrieve the data. there are some constraints about request and response size so please read the Apex Documentation links below for more information.

If your web service provides a WSDL, you can try to import it to Apex and Apex will auto-generate the apex classes.

https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_callouts_wsdl2apex_gen_code.htm
https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_objects_user.htm

Also, you can construct the web service message using the HTTP (RESTful) apex classes. 

https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/quickstart.htm

References for Javascript application.

https://trailhead.salesforce.com/en/content/learn/modules/javascript-essentials-salesforce-developers
https://developer.salesforce.com/docs/atlas.en-us.lightning.meta/lightning/js_intro.htm
https://www.sfdcstop.com/2018/08/lightningcontainer.html

Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
Vinay Kumar