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
karimulla testingkarimulla testing 

how to storage salesforce data into sql server... no single data should be stored in salesforce ,????

 my requirement is like this::::::
 costumer  will login in with the salesforce credentials and perform some operations then after saving data it should not be save in salesforce database....
is it possible ..please let me know....send me the links and infromation about how to store data in sql server
Best Answer chosen by karimulla testing
srlawr uksrlawr uk
I don't quite know how or why you will stop all data from being stored in Salesforce... but I suppose technically if you wanted to just use Salesforce as a front end you could - and just write Visualforce pages with a bunch of Ajax requests off to another system?

I mean, if you want to do that, just have a read up perhaps on using JQuery and so on; but you will effectivly be paying Salesforce a huge amount of money for a very not-very good web server service :D

If you want to combine the power of Salesforce and external data sources, you might want to consider Salesforce Connect (learn here: https://trailhead.salesforce.com/en/modules/lightning_connect) which lets you integrate external data sources; I would imagine some data would still live in Salesforce though. 

Otherwise, traditional API integrations are possible outbound via Apex, you could use standard Salesforce objects/forms and then have a trigger that - when a record was created, used an @future method to shoot the data out wherever you wanted with a callout (https://developer.salesforce.com/page/Apex_Callouts) and then tried to delete the info as soon as it was - technically it would live in Salesforce for a few minutes though.

 

All Answers

srlawr uksrlawr uk
I don't quite know how or why you will stop all data from being stored in Salesforce... but I suppose technically if you wanted to just use Salesforce as a front end you could - and just write Visualforce pages with a bunch of Ajax requests off to another system?

I mean, if you want to do that, just have a read up perhaps on using JQuery and so on; but you will effectivly be paying Salesforce a huge amount of money for a very not-very good web server service :D

If you want to combine the power of Salesforce and external data sources, you might want to consider Salesforce Connect (learn here: https://trailhead.salesforce.com/en/modules/lightning_connect) which lets you integrate external data sources; I would imagine some data would still live in Salesforce though. 

Otherwise, traditional API integrations are possible outbound via Apex, you could use standard Salesforce objects/forms and then have a trigger that - when a record was created, used an @future method to shoot the data out wherever you wanted with a callout (https://developer.salesforce.com/page/Apex_Callouts) and then tried to delete the info as soon as it was - technically it would live in Salesforce for a few minutes though.

 
This was selected as the best answer
karimulla testingkarimulla testing
#srlawr thanks for your response.
Thomas FolThomas Fol
You can use the Skyvia (https://skyvia.com/data-integration/integrate-salesforce-sql-server)cloud platform to connect SQL Server and Salesforce. It is a freemium app with no code.