- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2024 04:23 AM
Hello Everyone,
I need to synchronize user, group, and role data from our Production instance to our Dev and Test instances. Specifically, when a user, group, or role record is created in Production, it should also be created in the Dev and Test instances.
I attempted to achieve this using REST integration; however, this approach is causing issues with sysid mismatches. When a record is created in Production and then replicated to Development/Test instances using the REST POST method, it is assigned a different sysid in those instances. I've learned that any integration or transform map may lead to sysid conflicts, so this approach isn't feasible.
I am aware that the IDR (Instance Data Replication) plugin can replicate data but it is paid and is not recommended for system tables such as user, group, and role records. Since we need to automate this process, a manual import/export approach is not suitable.
Could anyone suggest an alternative method to automate this synchronization?
Thank you.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2024 10:42 PM
This requirement can be fulfilled using the paid ServiceNow Remote Instance Spoke. Once the proper connection is established, records can be created in lower instances. We encountered a sys_id issue, which we addressed by making necessary customizations in the transform map.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2024 07:31 AM
Clone prod over your dev and other instances.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2024 07:43 AM
We had considered this as well but it will clone down the entire instance. We don't want that and we can not perform clone always as we need to automate the process.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2024 07:48 AM
Use Clone Exclude Tables and Data Preservers. Good luck on getting an integration to work as you desire.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2024 08:24 AM
Yes we can add user, group, roles tables in preserver but that doesn't means it will be clone specific to user, group, roles. When I checked regarding clone it says it will clone down entire instance. eg if we add these tables in preserver then it will replicate the same data as it is in prod but at the same time it will also affect other tables and we don't want that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2024 11:25 AM
Hi Teja,
Please export user, group, roles records to xml by taking 1 new user record from PROD and import it in lower environments avoid 'sys_id' conflicts. Later you can try repeating for bulk users.
Mark helpful, if it works.
Thanks,
Suman.
