Apex Code Development You need to sign in to do that
Don't have an account?
rob_burkett DATA storage for activities - outside of Salesforce
We're experiencing data storage issues (not to be confused with file storage issues) in Salesforce and can't find any third party apps that can help.
Mainly it's our activities. We have a tremendous amount of activities for 2010 and will have even more in 2011. We've already purchased additional data storage from salesforce but it's getting quite pricey.
Has anyone exported activities older than 1 year old to an external database, then added a visualforce component pointing to that database so you can still have some visibility into your old activity, but without the storage issues?
Eloqua does this as a part of their email marketing product. It's just a visualforce page that directs back to Eloqua's site. Anyway, I'm not sure how to even start something like that and hoped someone else had already done something similar.
Thanks,
Rob
It is possible to do this, but you need to be aware that you'll no longer see your Events in the Calendar if you do so. You also need to factor in the costs of the storage on other platform (e.g. Amazon EC2) plus the running costs to keep the virtual server running.
As you'll only be accessing it from Salesforce I would suggest going for a small Amazon EC2 instance, with OpenSource database and Java App Server instances. You'll then need to create your database and some web services which you'll expose to Salesforce.
Within your Visualforce controller you can call the WebServices and populate results for display (worth encapsulating this logic in a separate helper Apex class though).
If this all sounds too much work there's plenty of Salesforce partners you can find on the AppExchange who could undertake this development.