Showing posts with label Replication. Show all posts
Showing posts with label Replication. Show all posts

Monday, May 24, 2021

DATA LOSS CAN TORPEFY YOUR BUSINESS

 

What does data mean in today’s business world?

In the age of information, data plays a vital role in the development of any business, and it can be very well said that success comes to those who can manage and protect their data in a better way.

Data gives information, knowledge, and ultimate wisdom for making correct decisions and proper actions that directly help in the growth of any business. Hence, it becomes crucial to protect your data from any loss or damage to keep your business operations smooth 24*7 without any glitch.

The Ponemon Institute’s Cost of a Data Breach Report puts the average cost of a data breach at $3.92 million, with healthcare being the most costly industry. The average time taken to identify and contain a data breach is a whopping 279 days. As expected, the shorter the lifecycle of the breach, the better. A breach lasting under 200 days costs $1.2 million less than one with a life cycle longer than 200 days.

Now the question is how data loss can affect your business and how Replication can rescue you from this situation. So let’s dive in to find the solution to these queries.

How losing data can affect your business?

In this digital world, data plays as the base of any business, and loss of data can result in a sudden break to your business, which can harm your business in many ways, such as:

1.  Productivity disruption

Productivity suffers primarily when an organization loses its data irrespective of whether the loss is due to an unplanned network outage, software failure, malicious cyber-attack, or hardware failure. This can take days to recover, causing downtime and lost sales.

According to Datto: “An hour of downtime costs $8,000 for a small company, $74,000 for a medium company and $700,000 for a large enterprise.” For large enterprises, this equates to around $11,600 per minute.

2.  Loss of reputation

In the age of information and digitalization, news travels at a very high speed. If your organization is not able to serve its clients due to data loss or ends up in the headline due to incident of data loss, it will create negative publicity for your organization and can damage your reputation permanently

3.  Loss of confidential data

Data loss can lead to exposure of confidential and private information about your company, your clients, or your employees. If personal information about your client or employee is compromised, it can cost a hefty fine against your company for failing to comply with the data protection act.

For businesses that did not adhere to these regulations, fines could be issued to the organization to the tune of up to £500,000 for failure to comply with the Data Protection Act 2018

The Information Commissioner’s Office (ICO) has fined Cathay Pacific Airways £500,000 for failing to protect customers’ personal data. The UK watchdog said the airline’s computer systems had exposed details of 111,578 UK residents and a further 9.4 million people from other countries. (Cathay Pacific fined £500,000 over customer data. (2020, March 4). BBC News. https://www.bbc.com/news/technology-51736857)  

4.  Permanent failure

Data loss can cause many financial and non-financial damages to your company, out of which permanent failure is the worst one. Every year many companies have to close their services permanently after being struck by a significant data loss. The financial and non-financial loss constitutes a perfect storm that creates an impossible situation for recovery.

94% of companies suffering from a catastrophic data loss do not survive – 43% never reopen, and 51% close within two years.
(University of Texas)

7 out of 10 small firms that experience a major data loss go out of business within a year. (DTI/Price Waterhouse Coopers)

5.   Losing customers loyalty

If customers lose their essential data due to data loss occurring in your organization, their trust and loyalty are tarnished, and they might take their business elsewhere. This news will ultimately come out, and it may be a tough battle to find a new customer ever again!

Yahoo data loss Let’s take a look at one of the most significant data breaches in the 21st century, and its impact on the organisation whose customer data was hacked.   Yahoo used to be an Internet giant. According to Lauren Johnson, Yahoo was seen as a digital pioneer. It was launched in 1994 by David Filo and Jerry Yang. Twenty-two years later when it was sold to Verizon in 2016, it had moved from a global Internet giant to a company that was struggling to compete in the same space as other search engine giants like Google.   What made matters worse, was that while Yahoo was negotiating with Verizon, the company announced that in 2013-2014, its data servers were hacked a number of times and 3 billion accounts were affected. The details that were stolen across all the hacks were customer names, email addresses, phone numbers, dates of birth, passwords, as well as security questions and answers. This information about the data breaches reduced Yahoo’s sale price by about $350 million.   However, the sale price reduction was just a minor consequence of the data breaches. Ever since the announcement that 3 billion customers’ data was exposed and stolen, the company has battled to regain the territory it lost to other Internet giants like Google and Microsoft. The bottom line is that consumers do not trust Yahoo to keep their private data secure.
(The Scary Effect of Data Breaches on Your Customers’ Loyalty. (n.d.).
Retrieved August 7, 2020,
from https://www.digitalinformationworld.com/2019/02/effect-of-data-breaches-on-customers.html)  

Hence, loss of data can be a very costly affair irrespective of the size of the companies. In many cases, it takes years for the companies to recover and get back in a competitive business environment while in some situations, it can even lead to a permanent shut down!

How can Replication help you?

One of the most common uses of Replication is data recovery, which also provides accurate security at all times against any catastrophe, system breach, or software and hardware failure, where data may be compromised.

Replication focuses on ensuring that all your critical applications are up and running even after an outage. The main purpose of Replication is to provide Disaster Recovery, i.e., easy and quick resumption of work after any corruption or outage.

Replication also improves and optimizes server performance. With the help of Replication, businesses can run multiple replicas at multiple servers helping users to access data faster and also provides an additional feature of analytics replication. Data-driven organizations can replicate data from various sources to data warehouses, which allow them to power their BI tools.

By making data present at multiple locations, it ensures the large-scale sharing between various systems and thereby spreads the load of the network. The following are the various benefits of data replication to an organization:

  • Better reliability and availability: as data is present at different locations if one system fails due to any reason, data can quickly be recovered from another location.
  • Lower latency in data access: as data is available at multiple locations, the required data can be accessed from a closer location to where the transaction is being executed
  • Powerful analytic support: making data available from different sources to a data warehouse empowers other teams to work together on a common project and facilitate the use of business intelligence tools and improve the overall business process.
  • Enhance test system performance: as Replication simplifies synchronization and distribution of data, it creates quick accessibility of data for test systems enabling faster decision-making capabilities.

How Replication works

Replication involves writing or copying the same data to different locations. For example, data can be copied between two on-premise hosts, hosts in other locations, multiple storage devices on the same host, or to or from a cloud-based host. Data can be copied on-demand or transferred in bulk or batches according to a schedule, or replicated in real-time as the data is written, changed, or deleted in the master source.

Data replication stores your data in more than one site or node, which increases the availability of data. It copies your data from one server to another so users can share the same data without any inconsistency. It creates a distributed database where users can access the relevant information according to their requirements without interfering with others' work.

How can we help you in replicating?

At DBSync, we provide you with a simple and cost-effective way to replicate your salesforce data. Our cloud replication can automatically create salesforce object schemas, replicate objects in real-time, create or update Salesforce records from your database irrespective of the platforms like AWS, windows, Linux, etc. Few significant benefits of using our replication software are listed below:

  • Fulfill all your compliance and security requirements.
    Archiving your cloud application data with Cloud Replication helps you comply with FINRA and other requirements. Snapshot-based tracking means you stay on top of regulatory requirements for versioning.
  • Zero Administration – set it and forget it.
    Automatic schema creation and adjustment means zero effort on mapping schemas. The ability to run database queries on Salesforce data reduces API usage and query latency.
  • Easy enough for business users.
    No API experience? No Problem! Download the data directly and manipulate it from the database to see your updates right in your CRM.
  • Deploy and Run anywhere.
    Support for the cloud (AWS) and on-premise database back-ups such as Oracle, SQL Server, MySQL, Snowflake, and more. Run it in batch or real-time incremental data replication.
  • Adopt Salesforce with your AWS and Big Data.
    Cloud Replication’s support for Cassandra and Amazon Redshift helps you harness the power of Big Data for your business.
  • No per-user licensing, simple pricing model.
    Our pricing model provides a ton of features at a reasonable price.

With our Replication, you can save huge amounts of money that you might lose due to data loss just by spending $2k per month on an average, which keeps your business running and ensures the safety of your data.

Conclusion

There is no denial to the fact that data is acting as a fuel for the modern business world, and to sustain, grow and thrive in your business, one needs to ensure an uninterrupted supply of the fuel, i.e., data. Hence, each and every company must ensure the protection and security of their valuable data as losing it can result in substantial monetary losses, reputational losses, and in some cases, businesses can’t even recover with the loss accrued to them, resulting in permanent closure. One of the most effective solutions to avoid any of these is provided by Replication, which works as an effective way of protecting data and ensures business continuity 24*7*365.

Thursday, May 13, 2021

WHEN TO USE SAAS DATA BACKUP VS REPLICATION

 


As SaaS data management solutions evolve to meet the market's growing data management and data endpoint needs, the lines are becoming blurred between SaaS backup and replication. The following summarizes the typical SaaS backup and replication features that you are likely to encounter on the market and where these lines become blurred.

Some of the reasons for the market's evolving needs include the movement towards digitizing businesses, reflected in the increases of SaaS and cloud adoption, along with increasingly ambitious business continuity goals and more demanding regulations. Some key data goals may include:

  • Optimizing DataOps and DevOps time and resources

  • Creating a unified view of the companies data and customers

  • Seeding data lakes and warehouses for analysis

  • Meeting privacy regulations

  • Meeting financial regulations

  • Meeting business continuity RTO and RPO goals

  • Project-specific goals such as migrations and enhancing systems

[Download our Salesforce data backup and replication comparison]

SaaS Backup Solutions: What to Expect

SaaS backup solutions provide DataOps with a tool that will automate their backups and make it easy for them to recover their data, metadata, and other assets such as files. A non-technical user should be reasonably comfortable navigating the solution. The main goals of the backup app are to meet compliance, audit, and business continuity goals. The data's endpoints are usually limited to a public or private cloud, necessitating a replication solution should the company need an on-premise self-hosted solution. What you will typically find as features:

  • Scheduled/automated daily backups of data, metadata, and other assets such as files

  • Reporting to indicate changes between backups

  • Comparison tools to investigate changes

  • An audit trail to validate compliance

  • "Forget Me" tools to meet privacy regulations

  • The ability to easily and quickly recover data from the backups to meet your RTO goals



When the Lines Blur Between SaaS Data Backup and Replication


The lines become blurred between commercially available products (backup and replication) when the demand for the frequency of backups increases, additional data endpoints are needed or data use becomes more diverse. Unfortunately, this sometimes requires a bit of digging and doesn't always yield a perfect vendor-to-vendor comparison which may include charges for additional data storage and API calls. The following section will highlight the typical replication features available commercially.

[Download Our Salesforce data backup and replication comparison]

SaaS Replication Solutions: What to Expect

As your data usage or endpoints needed become more complex, the products you will find more useful become SaaS data replication solutions.

When you want to do more with your data than back it up, then you will be drawn to SaaS data replication solutions. These may be additional features from SaaS data backup providers or a unique product line from a SaaS data management company. The solution helps to get the right data to the right business unit, regardless of geography, reliably and consistently. What does that mean?

Similar to backups, replicating SaaS data can ensure that, if one system fails, data can easily be recovered from another location. With data replication, it can also reduce your RTO since the data can be replicated to a local server. Replication can certainly boost your ability to meet business continuity goals and regulatory mandates, but, because of those additional endpoints and automated schema updates, it can do much more. SaaS data replication solution can power a companies analysis by populating data lakes and warehouses on a frequency of your choosing. It also finds application in enhancing or testing system performance to help with IT decision-making. These are some of the typical feature you can expect to find.

  • Flexible frequency and scheduling 

  • Multiple endpoints (SQL, NoSQL, public cloud, private cloud and on-premise)

  • Sandbox replication

  • Automated schema updates 

  • Choice of run modes

  • Enhancements through additional APIs

  • Integration with data workflows (connectors) 



Discover which set of data management tools work best for you and your company. Download Our Salesforce data backup and replication solutions comparison.





Wednesday, May 12, 2021

REASONS TO PROTECT YOUR SAAS DATA

 Reasons to Protect Your SaaS Data

The Software-as-a-Service (SaaS) industry continues to grow in leaps and bounds — predictions suggesting that the market could grow to $157 billion in 2020.

SAAS MARKET GROWTH (BILLION U.S. DOLLAR)

SAAS MARKET GROWTH (BILLION U.S. DOLLAR)

“Software as a Service (SaaS) Market Worldwide 2008-2020.” Statista, https://www.statista.com/statistics/510333/worldwide-public-cloud-software-as-a-service/.

While SaaS empowers companies to move smarter and faster at affordable prices, it also leaves data prone to cyber-attacks that could result in lost data.

Is Your Data Safe?

Estimates suggest that at least  80% of businesses using SaaS have lost their data at some point. It’s expected that by 2021, 3 out of 4 companies will use SaaS to power up their critical applications — these numbers are symbolic of the growing need to protect Saas data.

Many SaaS vendors don’t provide protection for your data  — Salesforce, Microsoft and Google all provide limited (or no) support for data recovery, as evidenced in their company statements:

1.   Salesforce no longer to provide data recovery

Salesforce no longer to provide data recovery

2.   Microsoft Services Agreement claims no liability for any disruptions or losses

Microsoft Services Agreement claims no liability for any disruptions or losses

Microsoft Services Agreement. (n.d.). Retrieved October 19, 2020,
from https://www.microsoft.com/en-in/servicesagreement/

3.   Google claims no recovery if customers delete the data

Data Processing and Security Terms (Customers). (n.d.). Google Cloud. Retrieved October 20, 2020, from https://cloud.google.com/terms/data-processing-terms

Google claims no recovery if customers delete the data

How Can You Lose Data?

There are many ways in which a data loss incident can torpify your business.

1.Human Errors

Inevitably, the biggest cause of data loss is a human error — as high as 64%, according to some estimates. The figures and example below illustrate the threat:

The biggest causes of data loss
The biggest causes of data loss

Source: Aberdeen group

GitLab Data Loss

The benefit of a replication solution is that it can help you compare your data before and after errors are noticed and see all of the changes that have been made. Thus, you can quickly check mistakes and rectify them, recovering all lost data. Replication is used for data recovery to ensure accurate and adequate security exists to ward against system breaches or software/hardware failure where data is compromised.

2. Hackers

As noted earlier, the SaaS market is forecasted to see $157 billion in revenue in 2020 — these numbers have caught the interest of hackers, as illustrated below by the Chartered Professional Accountants of Canada (CPA) incident below:

The CPA disclosed that a cyberattack against its website allowed unauthorized third parties to access the personal information of over 329,000 members and other stakeholders.

CPA Canada discloses data breach affecting 329,000 individuals. (n.d.). BleepingComputer. Retrieved September 8, 2020,
from https://www.bleepingcomputer.com/news/security/cpa-canada-discloses-data-breach-affecting-329-000-individuals/

Archiving your data with Cloud Replication helps you comply with regulations and requirements. The “snapshot-based tracking” can help you to maintain data compliance regulations.

3.System failure

Just as humans are prone to errors, so are systems. While machines can greatly reduce the risk of individual human error, data can still be compromised/corrupted without warning, potentially leading to all your vital data vanishing at once. The consequences are beyond imagination!

Data replication stores your data on multiple sites or nodes which increases the availability of data even in adverse situations like system failure. By moving your data to different sources, you can make sure that your data is continuously available.  Thus, even in a “system crash” scenario, you will have access to all of your relevant data and can keep going.

Backup vs Replication

Backups copy and restore data to ensure original data is not lost in the case of human/system error. Even if backups are run hourly, they cannot ensure the continuity of business at a time of data loss,  as it may take hours, even days, to recover the data because it is stored offsite.

Replication copies and moves data to different sources/sites, making recovery faster, as data is retrieved quickly and at a granular level, allowing organizations to back on track in half of the time or less than backup solutions.

Because we live in an increasingly data-centric world, businesses cannot afford to compromise on the availability of data nor the level of security required to protect it.  Today’s business model requires an “always-on” level of service which cannot be delivered by a backup solution.

What Exactly is Replication?

Data replication is the process of keeping data at different locations, creating multiple copies of it that can be stored at various sources to make certain it is protected from loss or theft. Replication increases the accessibility of data by giving access to all users at the same time, irrespective of their location.

Depending on need, replication can be done once or on an ongoing basis. The dynamic nature of data necessitates flexibility and convenience, making replication even more vital in today’s business world where information must be shared instantly and globally to multiple audiences.

Types of Data Replication

  • Transactional replication

In a transactional replication, the software makes a complete copy of the original data and updates it as it changes. Data is replicated in real time from its origin to the receiver database. This type of replication guarantees transactional consistency. This is most significant as the number of rows copied each time is smaller.

  • Snapshot replication

When the snapshot replication method is used, data is replicated exactly as it appears originally and is not monitored for updates.  The entire snapshot is generated and sent to the user. This method is generally preferred when data changes only occasionally, because it requires the slower process of moving multiple records from one end to the other.

  • Merge Replication

Merge replication allows publisher and subscriber to change data dynamically. It is the most complex form of replication as data from two or more databases is merged together to form one database. It allows users to send changes from publisher to multiple subscribers.

  • Key-based Incremental Replication

This type of replication is also referred to as “key-based data capture,” as it only copies data changed from the last update. In this method, keys can be seen as elements that exist within the database and trigger data replication. Only a few rows are copied at a time, which makes it the most cost-effective replication method of all.

Advantages of Data Replication

Replication not only protects your data from a variety of threats but also provides a number of advantages:

  • Better Reliability and Availability: Since data is present at different locations, if one system fails, data can easily be recovered from another location.
  • Lower Data Access Latency:  As data is available at multiple locations, the required data can be accessed from a closer location to where the transaction is being executed.
  • Power Analytic Support: Making data from different sources available to a data warehouse empowers different teams to work together on a common project for business intelligence.
  • Enhance Test System Performance: Because replication simplifies the synchronization and distribution of data, it creates quick access to data for testing, which allows for faster decision making.

What We Do at DBSync

At DBSync, we provide you with a simple and cost-effective way to replicate your Salesforce data. Our cloud replication can automatically create Salesforce object schemas, replicate objects in real-time, and create or update Salesforce records from your database irrespective of platforms like AWS, Windows, Azure, Docker, or Linux. Further, our product:

  • Fulfills All Compliance and Security Requirements
    Archiving your cloud application data with Cloud Replication helps you comply with FINRA and other regulations/requirements. Snapshot-based tracking means you stay on top of the latest regulatory requirements (i.e. versioning).
  • Requires Zero Administration – Set It and Forget It
    Automatic schema creation and adjustment means zero effort on mapping schemas. The ability to run database queries on Salesforce data reduces API usage and query latency.
  • It is Easy to Use
    No API experience? No Problem! Download the data directly and manipulate it from the database to see updates right in your CRM.
  • Can Be Deployed and Run Anywhere
    Support for the cloud (AWS) and on-premise database backup (Oracle, SQL Server, MySQL, Snowflake, etc), allows you to run data replication in batches or in real-time increments.
  • Allows for Adoption of Salesforce With Your AWS and Big Data
    Cloud Replication’s support for Cassandra, Amazon Redshift, MongoDB, and S3 helps you to harness the power of Big Data for your business.

Conclusion

It is easy to see the valuable impact SaaS has and continues to have, on the way we currently do business. However, as shown, this brings with it the increased risk of data loss — either by employee error, system failure, or malicious intent — that can hamper the flow and productivity of any business.  The best defense: DBsync’s Cloud Replication tool. Be safe, not sorry! Arm yourself against data loss and sleep soundly at night knowing you are well-protected.

Tuesday, May 11, 2021

TWO WAYS: HOW TO CONNECT SALESFORCE TO SQL DATABASES

 

Today’s Salesforce users have more options than ever when integrating customer data with eCommerce, accounting, customer service and marketing SaaS apps. Companies quickly see the advantage as they reduce duplicate entries, helping to optimize the order-to-cash cycle. They can also gain that 360-degree view of customers, putting them heads and shoulders above the competition.

Even with all these options, dataops still hit Salesforce data workflow limitations due to inflexible integration templates and untracked changes to Salesforce metadata. This is especially true when working with SQL and NoSQL databases.

The challenges of cloud-to-SQL or other on-premise connections can have a company looking to devops and APIs for their integration solution. A third option is to leverage commercially available Salesforce data replication apps. These apps can keep your customer experience, operational and/or ERP systems up-to-date without having to pull on your devops resources or APIS.

Salesforce to SQL Database Integration Using iPaaS (Connectors)

The benefits of many data workflow solutions are they are no code and templated solutions. This empowers users to create data workflows with little to no coding knowledge quickly. The downside is the templated workflows usually are limited to the objects and fields included in those templates by the app provider.

Have custom objects or fields? Some Salesforce integration data workflow apps will allow you to create your own template. So the problem is solved. Right? Not necessarily. Even if you are diligent in keeping your templates up to date, that doesn’t mean your SQL database is up-to-date. You will need to understand how to keep your SQL database synced to include any changes to your structure/metadata.

Salesforce to SQL Database Integration Using Replication Apps

An easier way and more reliable way to connect Salesforce data to your SQL database is through a commercially available Salesforce data replication app. These commercially available apps let you skip the API and coding to replicate your Salesforce data to an SQL or NoSQL database.

DBSync’s Salesforce Replication app takes the experience one step further by offering an SQL interface that makes it an intuitive experience for SQL data admins. This app provides the peace of mind that data is replicated reliably with minimal upkeep.

If you are working on a data lake or warehouse project that leverages Salesforce data, download our SaaS brief that highlights how to overcome the challenges.

Tuesday, May 14, 2019

DBSync Replication tool: Key functions


A brief explanation of its functionalities and uses
Replication is about identifying changes and updating other data sources. Its applications are many. From data warehousing to business intelligence and compliance.
Our replication tool has many useful functionalities that can help you achieve those goals based on your business strategies. Thus, a good understanding of their scopes and differences is vital to obtain the maximum benefit from the tool.
In this article, you will learn why replication is essential by analyzing several possible use scenarios. Following this, you will understand the main features of the software and their differences, and the different ways you can run the tool.
So, let’s start by understanding where replication has a place in your business.
Why is replication important?
Replication is an integral part of your daily business tasks because by identifying changes, it keeps your data up to date in all data sets. This can be easily seen in the several potential use cases of our DBSync Replication tool.  These possible uses are:
  • Staging a database for data warehousing: our replication tool can be used to create the schema for a data warehouse. Also, once the warehouse structure has been defined, our tool can be used to populate it.
  • Create datasets for business intelligence and reporting: business intelligence and reporting need specialized data. Our tool helps you to create tailored datasets, which can be used as a data feed for specialized applications and reports
  • Create backups and archives: backups and archives are part of the life of the DBA. Our tool helps your business by automating many of the functions, thus, freeing the DBA’s time to do more valuable tasks. Archives are also an essential part of regulatory compliance. Automating data archiving according to your business characteristics is one of the best ways to ensure compliance.
  • Integrate Salesforce with in-house applications: Salesforce is a powerful application. However, when working in combination with other apps, it is even more powerful. DBSync replication tool can create the necessary data sets that feed those apps. Even more, once the data has been copied into a database, it can be combined with data from other sources, massaged and then, incorporated back into Salesforce.
  • Create a data set for in-house application development: app development needs data for many of its phases, such as testing. By using our tool, your developers can create tailored and updated data sets, with the added advantage that your production data remains untouched.
Having seen some examples that explain why replication is a must in your business, let’s see the main characteristics of the DBSync Replication tool, which define its applicability in your industry.
What are the main characteristics of the DBSync Replication tool?
The DBSync Replication tool has several outstanding technical aspects that define its scope and applicability. The most important ones are:
  • Auto-creation of new fields: when a new field is added to the Salesforce schema, it is automatically incorporated in the database structure. This ensures that your structure remains updated in your backups and other data sets, and by being automated, frees the task from the DBA list of “to do.”
  • Downloading of objects/tables into a database: our tool allows you to download Salesforce objects/tables into a database of your choice.
  • Uploading of data from a local database to Salesforce: you can upload data from a local database to Salesforce.
  • Incremental updates: our tool automatically tracks any data changes. Thus, you never miss any changes done, thereby, reducing the number of errors and freeing up the time of your DBA for other more important tasks.
  • Migration of non-replicable objects: non-replicable objects are those entities whose changes cannot be tracked over time. Examples in Salesforce are LeadShareAccountShare, and OpportunityShare. DBSync replication tool migrates them by copying the complete objects. This option is available in the Database Details section of the program.
  • Real-time integration using outbound messages: by using Salesforce’s outbound messaging capability, our integration tool helps you to have practically real-time integration.
Having understood the main technical aspects of our tool, let’s learn the main ways in which you can to use it.
How can I use the DBSync Replication tool?
Using the DBSync replication tool is straightforward. The system guides you step by step. First, you need to define your source and destination information. For example, you will have to input the credentials for your database and Salesforce.
Once your source and destination information are complete, you can run the replication tool. There are six-run options available, which are:
  • Clean copy: a Clean Copy is a copy of all the data available in a Salesforce instance. In other words, it copies all existing records in Salesforce to a database of your choice. The clean copy can be scheduled via the Scheduler, and thus, used as a backup tool.
  • Update schema: updates only the schema or structure of a database. Thus, it copies the tables and their columns with their respective names existing in the source database to the destination database. No data is copied from the source to the destination. Update schema comes in handy when we want to create a new instance of a database.
  • Source to DB (database): provides an incremental backup. In other words, it copies the records that are in the source (for example, Salesforce), but don’t exist in the database, and updates the database with those records that have been changed in Salesforce. This option can be used as a complement of the Clean Copy option, in a backup tool. For example, a backup strategy could be a clean copy scheduled every Friday night, and incremental backups scheduled daily.
  • DB (database) to Source: this option is similar to the previous one but in a reversed flow. In other words, in the source (for example, Salesforce), it creates the records that exit in the database but not in the source, and updates those that have been changed in the database, but not in the source.
  • Snapshot: a snapshot is a copy of the whole Salesforce database, which can be restored. Its name includes a time reference. Thus, snapshots become very useful for legal compliance or proof in case of litigation, as each of them is a copy of the data contained in Salesforce, at a point in time.
  • Export: allows the user to connect two different instances of Salesforce. In other words, to transfer data from a Salesforce instance to another separate Salesforce instance. This option is useful when you need to create a new Salesforce instance based on another one.
Summarizing
In this article, you have seen why replication is vital to your business and the main characteristics of our DBSync Replication tool. With the growth of data that characterizes our present times and the need for up to date information, the use of replication continues to grow, as it does the number of applications of our tool.
Ready to learn more? Go to our page and try our software, or contact one of our representatives. We are there to serve you and make your business grow.