3

I have a requirement to backup salesforce data to any third party on daily basis and it should be dynamically.I do't want to use any backup service provider. To achieve this I integrated salesforce with google drive to create and upload csv file to drive but I think it's not a good solution for long term since my org has more then 5 million record that should be backed-up daily on drive. Can you please suggest any better solution for this?

Improve this question
2
  • 1
    Your back-up will be still google drive?
    – sfdcFanBoy
    Jun 9, 2016 at 5:54
  • I'm a bit confused by the question. You want to backup Salesforce data to any third party...but you don't want to use any backup service provider? That's a contradictory question, no? As mentioned, there are a number of automated daily services for this from the AppExchange. Check out: appexchange.salesforce.com/results?keywords=data%20back
    – Andy Hitchings
    Jun 9, 2016 at 10:51

2 Answers 2

Reset to default
3

There are a lot of dataloader tools that can be scheduled to export data. If you want to export daily and without manual intervention this may be a good solution.

For example Dataloader.IO can be used: https://dataloader.io/scheduling

Or Jitterbit (= more enterprise level): https://success.jitterbit.com/display/DOC/Creating+a+Schedule

Update after comment of @David Gillen: You can also use the older data loader program on the command line with config files rather than through it's UI; and then set up a scheduled task/cron job, to run it on whatever schedule you prefer.

Improve this answer
2
  • 3
    Both good options, with dataloader.io being cheaper, Jitterbit is more enterprise level. You can also use the older data loader program on the command line with config files rather than through it's UI; and then set up a scheduled task/cron job, to run it on whatever schedule you prefer.
    – David Gillen
    Jun 9, 2016 at 8:32
  • Thanks David, I am using data loader program on the command line and scheduled it using windows scheduler .
    – RaviKant
    Jun 13, 2016 at 7:57
2

If the third party can make the callouts to salesforce api then its simple thing to do: 1. Create a rest webservice in salesforce which will export the data based on the query parameters received. 2. Query the records based on the parameter received and serilize the list and return the serilized string to the third party. 3. After getting this response from sf deserilize the response and save to your database. visit the link: Rest webservices Hope this helps you!

Let me know if you need more information.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .