Friday, 3 April 2015

Skyvia: Backup Your Data via The Sky

In my previous post, I was talking about Skyvia as my introduction part. As we know Skyvia is a product to help the data integration and backup in the cloud, now let’s talk first about the backup.

Since my blog is particularly purposed to Dynamics CRM-all about, so here I want to research its capability in term of CRM Backup and write every single step here, and yes, I try it on CRM Online! (As we know it is not possible for us to do backup CRM Online by ourselves without the favor from Microsoft Team).

Steps

1. Sign up and Login

Now, I have been logged in here:

image

2. Create a New Connection

image

image

Select the Dynamics CRM (for those who are not CRM Users, don’t worry, there are plenty other options)

3. Fill up The Connection Configuration Form and Test Connection, then Save it.

image

4. Go to Backup

image

5. Create New Backup Package, Select Connection

image

6. Select your Object to Backup

Well, to backup, you need to choose what Object you want to Backup, so it is Object-Based Backup.
This is very useful if you want to backup partial data that is very important.

image

7. Now, I want to Backup Account and Contact

image

8.Not only that, when you click the ‘edit’ you can perform more.

image

You can filter to not backup all Fields and can Filter by Condition.

And you can perform grouping: And, Or, and Xor (maybe more powerful than the Advance Find Smile)

image

But, now I don’t want to play around with this, I just want to backup all.

9. Setup Schedule

As usual Database Backup Task, we can set a schedule or just make it as one time only.

image

image

I make it as One-Time only in my research.

image

10. Now Back to the Top and Save it.

image

11. Backup is in Progress…

You can see the status here and you can also Force Backup Now if you already schedule it later but you want to have it immediately

image

Scrolling down, later you can se the Records and also the History of the Backup

image

*History in Calendar View

image

12. You can Create Multiple Backup Packages

image

Just wait, it’s about 30 minutes waiting

Now I can get the Report

image

That’s all the steps to backup your database.

Backup Method

Where is it stored?

According to the Engineer, Jacob Martin
Backed up data is stored in a secure Azure Geo-redundant storage (GRS), and these data are always available for viewing and restoring.

Can we Download the Data?

Skyvia allows downloading backed up data as CSV files. It does not allow downloading them as a database. However, you can view all the backed up data in the browser, filter and search them, and restore them in a couple of clicks.

What’s Next

The question now is what’s next? Is that just a backup? No, actually you can perform Update, Insert, and Delete from the selected Backup

Skyvia Backup Features (Update, Insert, Delete)

As mentioned before, this is not only just backup and that’s all. No. It is like a snapshot, imagine you are running Virtual Machine, then something happened, it gets crashed, you can just recover it all.
Now, imagine in the CRM if you accidently delete or update a record, can you undo it?
You can recover it, but you need the Audit history and recover it programmatically, which is for end users it is not recommended.

Skyvia as The Snapshot-er

Recover the Deleted Records

Back to CRM and I delete one of the Account record

image

As we can see, there is a confirmation box and also warning box as caveats to us to re-think again before we delete any record, because WE CAN”T UNDO THIS ACTION.

And Again…Another box comes up.

image

Now back to the Skyvia backup and then select the backup that we have performed before.

Search the data

image

Now, back to the left side, scroll left horizontally and then tick the selected record

image

It will open the ‘Restore’ account

Now, just click the ‘Insert Records’

Restore is in progress….

image

image

Restored Result

image

You can get the report, 1 record has been Restored, now let’s back to CRM.

And we search the record..

image

The record is successfully restored! Saved the day.

Undo the Changes

We learned how this Skyvia helps us to re-insert the deleted record.

Now, back to CRM and the users suddenly change the City and State to incorrect value, Sydney and DKI Jakarta

image

Now, I want to undo the changes

I go back to Skyvia and then perform the Update

image

Undo Result

image

Then back to CRM

image

The Address is back to its original value!

Delete Record

Now we want to delete the record in CRM easily, you can just delete from its snapshot.

I want to delete Brian Burke

image

We know we can delete it from CRM UI, but let’s try to delete from Skyvia.

image

Now no more Brian Burke in CRM

image

You can later recover it back.

History of Actions

image

image

Overall

Strengths:

- This is very useful for restoring data, undo changes, and delete just from the snapshot as long as you have the backup (of course)
- All the actions are performed in very simple steps with fancy UI
- Definitely No need to have programmatically knowledge
- No effort to create Integration environment, because all-in-one in Cloud
- Every single actions are stored and you can see in the History
As usual, there is no perfect product, so it still has Limitations

Limitations:
- Simple logic only, you can just search the record by keyword, so far no complex logic
- Restoring is object by object, can be positive for particular data (no hassle), but negative for big data
- The restored records concept is using Insert, so it will use the New GUID, so that you will lose the first Guid, lose the relationship as well
- Same concept with previous one, the ‘created on’ field will have today value, not the original ‘created on’ field

Thanks and stay tune in the next post!

9 comments:

  1. Salesforce is the cloud based tool which is used by most of the professional who do CRM. Salesforce is the cost effective tool.
    salesforce training in chennai|salesforce training institute in chennai

    ReplyDelete
  2. Our company is using salesforce for all the CRM solutions and it has never disappointed us in the past 2 years. Pleased by the service and support.
    salesforce training in chennai | salesforce training institute in chennai | FITA Velachery

    ReplyDelete
  3. Salesforce is a CRM tool which runs on cloud and very easy to use. Cloud computing is very convenient as there is no need for dedicated infrastructure for cloud computing.
    salesforce training in Chennai | salesforce training insitute in Chennai | salesforce course in Chennai

    ReplyDelete
  4. Salesforce.com is an american company which offfers CRM based cloud services and it is loved globally for it quality services
    salesforce training in chennai|salesforce training institute in chennai | FITA Chennai complaints

    ReplyDelete
  5. Cloud computing is preffered by most of the companies as this is cost effective and very fruitful, I'am using cloud for many days and I must say that it is very helpful.
    cloud computing training in chennai|cloud computing courses in chennai|cloud computing training|cloud computing training chennai|cloud training in chennai

    ReplyDelete
  6. Big data is the next big thing in the IT industry and it has created many job opportunities. Analysis of big data helps in making data driven decisions and to increase the profits of the business. Hadoop is the cloud based application which is used to analyse the big data.
    Big data training in Chennai | Hadoop training in Chennai | angularjs training in Chennai

    ReplyDelete
  7. Big data is extremely essential for the big enterprises to reach on a data driven decision. The importance of big data is increasing with every passing day. Hadoop is the best tool for analyzing the big data.
    Hadoop training in chennai | Hadoop training chennai | Big data training in chennai

    ReplyDelete
  8. Nice to see a blog dedicated to Cloud Computing Services , good luck. Keep continuing updating such kind of interested post here.

    ReplyDelete

My Name is..