migrate historical data from one system(not service now) to ServiceNow

[sajal_chatterje]

Hello Community,

There is a requirement to migrate 3 year historical data from a system which is not snow to ServiceNow.Is it recommended to fetch the historical data from other platform to service now??

This historical data mainly contains the form attribute value that they were maintaining at their system.Recently we developed the same form in service now and they are looking to migrate their 3 years of data into service now.

Kindly recommend if we should be good to proceed?? 

Only challenge I feel here are difference of identification number(in service now we have RITM and their tool uses number starts with SD egSD-104903.This is the number generated when they  create the ticket at their system.)

Please recomend if it is recommended to have the historical data in service now from another system.?\

Thanks,

Sajal

[Dr Atul G- LNG]

Hi @sajal_chatterje 

Greetings!!

It is not recommended to bring the tractional data in to ServiceNow, the reason begin in which table you will store, 2nd every record has it lifecycle and you need to complete this lifecycle for all these records. It may impact your reports , also it may trigger SLA / email as well so before you bring the data need to consider these points.

[sajal_chatterje]

Hello @Dr Atul G- LNG ,

Thanks for sharing your insights. I want to migrate the data into my RITM table.So how it is going to affect the lifecycle of the records in ritm? once migrated.Is it recommended to MIGRATE the date into RITM table?.Need your help to understand this better.

Thanks again!

[Dr Atul G- LNG]

Hi @sajal_chatterje 

If you bring the data in RITM table, 

1. need to make sure the RITM must have REQ as per SN.

2. Once RITM created the associated workflow/ flow will attach.

3. If flow / wf dont have any approval then sctask may get created .

These are few challanges, and also what will be the state of RITM when imported, bcz the RITM get closed when task get closed , so need to see this point.

My only thought is try to bring 1 / 2 RITM in dev and see how it behaving and consider above points and add if you get new learning as well.