All right so let this session is basically a continuation of the previous session wherein we understood
about the limitations that we currently have and why we actually go for the other data archiving option.
So the data our favorite options that we are going to talk about in this session are data export service
Salesforce API Heroku Connect third party data integration tools an app exchange products.
And as I mentioned previously in the previous session there is no single archival option that is applicable
to all args.
It is not like one fits all depending upon the size of the are deepening above the need depending on
the priority depending on the cost depending on the customer requirements.
The archival options differ so we should choose the archival option that suits best for our now in this
lecture.
Let's discuss some of the archival options they have pros and cons and then to use it and where to use
it.
The first archival option that we are going to talk about is a data export so this.
So what does this data export serve as the name says it is exporting data while using this option we
can generate backup files of data weekly or monthly basis.
And at this data extract that we do we usually do it in the form of CSP files directly from Salesforce
or with some other EDL tools or any data handling tools.
On the other hand we can also extract data through bulk API in this option the user Salesforce API to
extract a large number of records in a batch mode.
This option of using bulk API we use it for a larger set of data than we handle large volume of data
and we can program it we can get you lose a bad jobs to automatically execute at a specific period of
time.
And at the scenes we fight so that we get more hold of these data extracts of the historical data we
can extract those historical data out of Salesforce to an external system but we can also store it as
FLAC files.
So this option off our data export it is this option is very much suited for a smaller organization
so that they do not have enormous amount of and does option.
You can also very much use when you want to automatically backup your data on your regular basis.
So that does call this automatic scheduling.
So that is also will begin to win this option.
And on top of it we also have a couple of limitations here.
The first limitation is that this option does not include metadata.
Yes it does not include metadata.
And the other limitation is that the whole export process.
It may get delayed when the CPI usage is very high.
Basically during peak hours.
So that is also another limitation that we have here.
So this is all about a data export service and its pros and cons.
Let's move on to the next option to option that we are going to discuss about is Salesforce API.
So using Sandoval's API is we can move our data and metadata to and from Salesforce inside cesspools
and also like out of Salesforce and here we can move the data and metadata we can store them or we can
move that data to some third party applications or maybe to on their sets for SOC and that this option
is very well suited for customers who already have our data our houses will already have the B.A. solutions
in place it is well suited for them basically like having pre-existing enterprise software on middleware
services for the backing of the critical data and the main limitation here is the salesforce Governor
limits.
So if you're using Salesforce API is there to backup your data then pay more attention to the golden
elements that we have incestuous effect.
So the next option that we are going to talk about is a hero to connect to.
So this option Heroku Connect this is a basically a cloud based service to move data to and from Salesforce.
So basically here we can move data from Salesforce to hero.
That is that pulls gross database.
So this is basically a bi directional synchronization between Salesforce and Houda both Chris and I
using this bi directional synchronization he local connect it unifies the data in your post this database
with your salesforce database so say it's full of data base meaning your account context any other custom
objects that you have.
And on top of that you also have the option of exposing you over a huge local data as a Salesforce external
object says it looked competitively this option takes a little more time and effort when compared to
other options but this option is very much suited for consolidating data because this does not count
against API limits.
So this is a great option for a high velocity changes and this is a great option for consolidating data
across multiple says Fields args.
You know there we have this analytics vendor backups ex it was a very we have a multiple say it's full
of logs and VBA consolidating data.
This is definitely a great option to go for and you can also go for this option of and you want to access
data from a historical app like or even management or public facing mobile app and all those apps and
if you want to sync it with Salesforce then go for this apps option and this also supports a mobile
that it saves for one so yeah.
So this option has got a pretty good number of advantages.
But one thing you need to know desired that this Heroku Connect is it does not support in-flight transformation.
So pay attention to that.
And as I mentioned earlier Venable you go for not option of the way the pros and cons and choose the
one that is best for you
OK.
The next option that we're going to talk about is a third party data integration tools in this option
this option we basically use for data out of any purpose of it and we have the complex and mature data
integration tools that supports a wide range of data based platforms can handle large data rooms and
in-flight data transformations the main advantage of using these tools is that they are well-established
in the traditional data integration space.
And then nowadays they are being adapted for the even cloud integration news cases as well.
So yeah so does option provides a lot of flexibility a by way of the customization it can support high
velocity it can support high data one room and we have a batches we can get dual dose batches.
So basically this is a robust option with the ability to support your in-flight transformations.
So this option is a very ideal for moving large volumes of data and consolidating data from multiple
sources.
And especially for complex transformation sets of goals.
This is definitely a very efficient option for us.
However it requires specialized developed less kids and not only that the support for these nuisance
pulls API is each man would be actually immediately available as well.
So while these are a couple of things that we need to have in mind if we choose to go buy this option
and the last option that we are going to talk about is using app exchange products that are a young
number of app exchange products that are available that you can use it for your data archiving process.
The main advantage of using app exchange products is that they support automated backup and they are
very robust.
You can easily configure those products and they also provide a high degree of automation.
So.
So these are some of the very effective advantages that we have by using app exchange products and we
have plenty of app exchange products.
So in this session let's talk about a few of them.
But even other than that we have plenty other options so check out the various options check the price
choose which suits best for you for your OD and then go for it.
Some of the products that I would like to show you today.
The first is the copy storm so here the pricing plan is mentioned here and here they give you options
like you can backup your data or metadata and you also have options where to back up your data to get
a relational database.
Either that is on premises or in your private cloud.
And they also offer idling Delta backups within a certain period of time and they also give a trial
period for 30 days.
So this is one product that you can consider the other a product that I would like to show you today
is back up the fight this is a good product for archiving your data.
Here again you have details here.
They support our daily automated backups all including all your objects icons context leads and all
the other objects as well.
The pricing plan as mentioned here so we'll check with the vendor before you go ahead and purchase this
product the next one this data Arqiva.
This is a pretty popular product for data archival purpose and they say that that's one the native archiving
solutions that we have and some specific features of this product is that they support the field audit
trail system audit rate and also object relationship archiving.
So these are some of the features that does not available with every data archival product.
All right.
So that is we always tell you before you purchase any product contact the vendor check out all the features
that it offers.
Take off for free trial period and then go ahead and purchase the product.
Let's talk about the next option that is easy archive.
This is again one option available for you for data archival here.
They have a basic plan that starts at twenty three dollars per month per hour and they say they provide
multiple options with different storage space so check it out check out what all the various options
that they offer and this is under the product.
Is this a storage minder and the main functionality of this product offers is that they remove all the
task Emad calls and e-mail messages and they create it'll be a PDA files for that and a storage in the
file storage basically connected to their respective leads context or icons.
So basically they handle those objects.
Those are their cards.
So try it out.
So these are some of the tools that I have come across which have been very much useful for data archival.
But again as I said there may be other excellent tools also available.
So do check it out check out the various options that you have.
Do your research and finally purchase a product.
So this is all about the concept of data are equivalent sets force.