logo

NJP

Instance Data Replication and its Configuration , Plugins , Version

Import · May 14, 2021 · article

Plugins and Installation:

New York is the earliest version that supports IDR. The IDR plugin ID is com.glide.idr. When purchasing an IDR subscription, ServiceNow personnel also activate the following plugins that IDR depends upon:

  • com.snc.db.data_replicate
  • com.glide.transform
  • com.glide.kmf

To purchase a subscription, contact your ServiceNow account manager. The account manager can arrange to have the plugin activated on your organization's production and sub production instances, generally within a few days.

Procedure

  1. Navigate to System Applications > All Available Applications > All.
  2. On the All Applications page, click Request Plugin to open the Request form on HI

Instance Data Replication:

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

  • Data is automatically replicated to one or more other instances.
  • Data can be modified and mapped to any table column on other instances.
  • Data that is updated on consumer instances can be replicated to the producer instance
  • Business rules can trigger post-replication workflows, such as generating notifications or validating the replication
Web Service IDR
Maintaining data consistency across instance via we service can be cumbersome. • Create integration via REST / SOAP • Setup polling period and delta • Define behavior for different data set. • Monitor performance and address failure. image IDR remove that overhead with fully integrated platform option for instance-instance data syncing that is: image

How IDR is different?

It uses the concept of producer replication set and consumer replication sets

By configuring a producer replication set, you can specify the tables and table columns on the producer instance to replicate.

image

  • Dedicated message bus
  • Handles large data set
  • Preserver orders
  • Performance monitoring
  • One to many , bi-directional replication

image

Limitation: When not to use IDR:

  • Need to move very large data set
    • Its not a replacement of cloning; Seeding limit is 3M records.
  • Need to move metadata & Encrypted Data.
    • Configuration, settings, etc. are not included with replicated data set.
    • Encrypted data cannot be replicated.
  • Need to replicate data outside of ServiceNow.
    • Does not support integration or data export use cases.
  • Need to replicate data from below tables; Excluded tables:
    • Tables with the prefixes V_PREFIX, SYSX_, sys, ts_, ua_, usageanalytics_, wf_, ecc_, clone_, jrobin_, rrd_, imp_, pf_, pfd_, idr_sys_domain is an exception.
    • Rotated tables, including syslog, sys_querystat, ecc_queue, ecc_event, cmdb_metric, sysevent
    • Tables without a sys_id
    • sso_federation
    • saml2_update1_properties
    • sso_properties
    • digest_properties

Simple Configuration Process

image

Bidirectional Configuration:

image

Step by Step Configuration:

Use Case: Incident data replication

As IDR follow the concept of Producer and consumer replication set, we require two ServiceNow instance (Instance A and Instance B).

Instance A – Producer Instance

Instance B – Consumer Instance

Note: For this use I will be using Instance A and Instance B instead of producer and consumer instance

  1. Create “Producer Replication Set” in instance A

image

image

Name

Bi-Directional

Discrete

Description

Entry Set

image

  1. Submit
  2. Open the same record

Your record should look like below

image

  1. Click new on “Outbound Entries”, Select incident table and pass all the fields from left to right in selected bucket: See below for reference

image

  1. Submit
  2. Click “Activate” button to activate the producer set.

Your form should look like below

image

  1. Create “Consumer Replication Set” in instance B

image

image

  1. Fill the form
    1. Producer Instance URL: Copy “Instance A” URL and paste it here
    2. Producer Replication Set Name: Copy it from “Instance A” and past here

image

  1. Save it
  2. It will send and approval to producer instance.
  3. Now go to “Instance A”
  4. Open “IDR-Incident-Demo” record under Producer Replication Set.
  5. Go to related lit and see; You should be having one record under “Consumer Subscription” to approve the data replication from consumer side. See Below

image

  1. Open the record and approve it. You will see an popup, Select “Yes”
  2. Go to “Instance B”
  3. Refresh you consumer replication set. You should the form like below

image

  1. Click Activate. You should see “Seed” button enabled.Select the record and click Seed.

image

21. Wait while seeding is starting

image

22. Wait until the seeding is complete.

23. Once seeding is completed you should have all your incident from Instance A to Instance B

All the best!!

Happy Learning.

Please mark help or book mark this article if you have liked it.

Regards

Sandeep kumar

Labels:

image

View original source

https://www.servicenow.com/community/now-platform-articles/instance-data-replication-and-its-configuration-plugins-version/ta-p/2323579