Labels

Exchange data between ServiceNow instances with IDR

 

Exchange data between ServiceNow instances with Instance Data Replication (IDR)

What is IDR

  • A platform solution for data replication
  • No code configuration
  • One to many, bi-directional replication
  • Syncs data in real time
  • Preserves order
  • Data is encrypted in flight

Many use cases for IDR

  • Single source of truth for foundation data
  • Manage data across instances
    • Separate instances for different departments
    • Dev/Production stack
    • External and Internal Instances
    • Managed Services
    • Merger between customers

When not to use IDR

  • Do not use IDR to clone instances
    • IDR is designed to replicate data, not clone instances
  • Do not use IDR if your use case breaks any of the following IDR limitations
    • Replication must not take longer than seven days to complete
    • Initial seeding of the tables must be less than 3 million records per replication set
Note: IDR doesn't support domain separation. Take into account that IDR has a subscription model (due to the integrationhub that sits behind this functionality).

Bidirectional configuration

  • Instance A is both a Producer and Consumer
  • Instance B is both a Producer and Consumer
  • Instance A subscribes to B
  • Instance B subscribes to A

Producer configuration

  • Transform
    • allows re-mapping from Table A to Table B that is not the same structure as Table A
  • Discrete producer set
    • Allows some filtering to deliver relevant data to different consumers
  • Adapters
    • Adapters modify the producer data before inserting the data on consumer instances

Tables that are not recommended to replicate with IDR:
  • sys_audit
  • sys_log
  • sys_history
Keep in mind
  • Domain separation is not supported
    • Note: You can filter what is replicated
  • This is a pay for plugin
    • Subscription required to publish data
    • Can be enabled for consumption only
  • Not supported for self-hosted on-prem
Note: IDR IS NOT REPLACING BACKUP

Role required: admin or idr_admin 

The IDR plugin must be enabled on each instance that will either produce or consume replicated data. 

Note: This walkthrough is based on the Yokohama release. 

Replicating user data with IDR 

Set up continuous replication 

Enable near-real time data replication from a producer instance to one or more consumer instances in Instance Data Replication (IDR). 

Procedure:
  1. On the producer instance (PROD), navigate to Instance Data Replication > Producer Replication Sets 
  2. Select New 
  3. Enter a name and description for the producer replication set 
  4. (Optional) Create the producer replication set from a list of outbound entries by selecting Entry set. If you imported an update set from another instance, or you created one earlier on your instance, you can choose an existing entry set. 
  5. Select Submit 



  6. Specify the tables and columns on the producer instance that you want to replicate
    1. Select the Outbound Entries in the related list 
    2. Select New 
    3. On the form, fill in the fields 
    4. Repeat these steps for each table that you want to include in the replication set
      Note: If a table that you select has child tables, repeat these steps and add outbound entries for each child table to maintain data integrity 
  7. Select Submit 



  8. Make the producer data available for replication to consumers by selecting Activate 



    The producer is ready to send the data that is specified in the replication set to one or more consumer instances. 
  9. On a consumer instance (SANDBOX), navigate to Instance Data Replication > Consumer Replication Sets 
  10. Select New 
  11. On the form, fill in the fields 
    1. Producer Instance URL: Provide the URL of the Producer instance 
    2. Producer Replication Set Name: Provide the same name as the producer replication set 
  12. Select Submit 
    The list of all consumer replication sets on the consumer instance appears. The system sends a request to the producer replication set administrator to approve or deny the request. 
  13. Request Producer Approval 
    1. On the consumer instance, click on Request Producer Approval 



  14. Approve the consumer request 
    1. On the producer instance (PROD), navigate to Instance Data Replication > Producer Replication Sets 
    2. Select the producer replication set where you want to approve consumer access 
    3. Under Related Links, on the Consumer Subscriptions tab, select the option for the consumer replication set that you want to approve 
    4. On the Actions on selected rows list, select Approve 



    5. Approve consumer 



    6. The approved consumer set starts receiving replicated data 
  15. Activate the consumer replication set
    1. On the consumer instance (SANDBOX), navigate to Instance Data Replication > Consumer Replication Sets 
    2. Select the consumer replication set that you want to activate 
    3. Select Activate 
    4. After some time, the status changes to Active Replication, and the Partial Seeding and Full Seeding buttons are displayed 



    5. Select Activate 

Result 

Data in the producer tables is replicated into tables and table columns of the same name on the consumer instances. 

Resources:






Labels:

Comments

Post a Comment

Popular Posts