How to integrate Request, RITM & Catalog Task from 1 SNOW instance to another SNOW instance?

[tripss]

Hi Everyone,

I have a requirement of integrating these 2 ServiceNow instances for service request:

instance 1                   instance 2

req    -->                         req

ritm   -->                         ritm

task   -->                         task

 I have done the same for incident module-created inbound/outbound and it involved staging table.

 I am not sure about service request because even if ritm updates, its corresponding req and task should get updated.

Your suggestions will be appreciated.

Thanks in advance.

[Ryan Healey]

There are a couple of different ways you could go about this.  

1. Purchase middleware

2. Code your own solution

3.  Integration hub could be a possibility 

At my previous company we had an e-bonding solution that would, in theory, work with any table.  We had it configured for Incident to Incident between instances.  It wasn't all that complex.  We had a few different tables to house things like the details of the remote instance, the remote field mappings (sort of a transform map) and a table for the remote record sys_id's.  The rest was just a couple of script includes to to gather the info we needed to send in each scenario and a couple of business rules to trigger the integration.  

Hope this helps, even a little bit.  Let me know if you have any questions.  Happy to help if I can

Best,

Ryan

[tripu]

Hi Ryan,

I have no problem in the incident integration from 1 SNOW instance to another SNOW instance via both REST & SOAP web service. I am confused with the integration of Requested Item Table. Because it is not the same as I did for Incident.

We have to integrate Request table , Requested Item Table and also catalog Task table here. So my question is, do I need to integrate all these 3 tables separately and then connect each table via Business Rule or there is an alternate way or any short cut to integrate these 3 tables? I am not sure but is there any way to integrate these 3 tables using import set API?

If yes, please let me know the procedure.

Thanks

[DirkRedeker]

Hi

I have thought about the same thing several times, and here are my latest conclusions:

When you want to transfer the request from one instance to another, the big question is, what do you want to do with them on the second instance? 

If you want a 1:1 copy, I think, copying the three mentioned tables is not enough, as the RITM will have links the (possibly quite complex) catalog items. 

I stopped thinking about that, because that would need to mirror a lot. 

The second idea was what the second system will need to do with that information. 

Then, I ended up, with the conclusion, that we may need some transformation and mapping of source RITM to destination RITM,so that the destinationssystem is also happy with the transferred data. 

This will depend on your business need in detail. 

So, just implement a copy task, may not make you happy. 

Let me know if that answered your question and mark my answer as correct and helpful, please. 

BR 

Dirk 

[Community Alums]

I want to integrate the service catalogs of Snow A to Snow B and I have the common items in between them. What is the process to integrate between the catalogs and also need to automate this process via flow designer basically for to hit API and generate payload.