logo

NJP

Data Replication from one Instance to Other in ServiceNow

Import · Jun 10, 2020 · article

Instance Data Replication (IDR) copies data updates from one instance to one or more other instances. IDR facilitates maintaining consistent data across different organizations in your company.

IDR provides a one-to-many replication, which enables one instance to propagate data across different departments and business units to keep data in sync.

How It works

Use the Instance Data Replication plugin to replicate data updates on one instance, called the producer instance, to one or more other instances, called consumer instances.

A producer replication set specifies the tables and table columns on the producer instance to replicate. A consumer data set specifies the tables and table columns on consumer instances that receive the producer replication set data.

Activating both producer and consumer replication sets turn on IDR functionality. Data updated in a producer replication set automatically updates the corresponding data in consumer replication sets.

Syncing producer and consumer replication sets involve a one-time seeding of all the producer replication set data to the consumer instances. Future replications involve data updates only.

By default, table data on a producer instance goes into tables of the same name on consumer instances.

Note: - IDR overwrites data on instances and can replicate sensitive data. Given the potential for data loss and data exposure, test your IDR implementation in a pre-production environment.

image

Not to use IDR in below scenarios:

  1. Do not use IDR to clone instances.
  2. IDR does not replicate metadata tables, child metadata tables, and most user and system tables. IDR is designed to replicate data, not clone instances.
  3. Do not use IDR if your use case breaks any of the following IDR limitations:
  4. Replication must not take longer than 7 days to complete.
  5. Initial seeding of the tables must be less than 3 million records per replication set.
  6. Producer and consumer instances must be in the same geographic region.

Set up Instance Data Replication in four simple steps:

Pre-requisite:

Instance Data Replication (IDR) requires a separate subscription and only ServiceNow personnel can install the plugin. Once the plugin activates, you can configure the producer and consumer instances.

Role required: admin

The following procedure provides an overview of the required and optional tasks you complete to set up IDR. Links in each step provide details for completing the tasks.

image

Steps:

View original source

https://www.servicenow.com/community/developer-articles/data-replication-from-one-instance-to-other-in-servicenow/ta-p/2319588