Apex Code Development You need to sign in to do that
Don't have an account?
Rakesh S 27 Data Archival and Retrieval
I have an issue with "Exceeded Data Storage" limit in one of my Salesforce Orgs.
Possible Solutions:
Possible Solutions:
- Buy additional data storage space from Salesforce.
- Delete the unwanted data and archive the remaining data on a periodic basis on business needs in an External Database.
- Provision to access the archived data from Salesforce whenever I want to. This retrieval of data is just display of data in Salesforce
- There has to be code written in Salesforce for pushing data from Salesforce to External Database during archival, but do we have to write code at the database level as well to store and retrieve data?
- If the answer is "No" can you suggest some affordable cloud database options where this operation can be done seamlessly?
For Questions 1: No, you will not write code to retrieve the external data... Check this https://help.salesforce.com/HTViewHelpDoc?id=external_object_define.htm
For your second Question: I'm not sure, but you can probably check azure. And that's a link that shows the following steps:
https://developer.salesforce.com/blogs/developer-relations/2015/03/accessing-sql-server-azure-database-lightning-connect.html
Let me know if I can help further and do not forget to mark this as the correct answer if it fits your needs.
If I am buying these databases there would be no need of Salesforce connect (I assume), so in that case do I need to write code on the database for the storing and retrieval activity?
Did you manage to find an answer to the questions ? If yes can you share your experience.