Migrating the data from 3rd party system to ServiceNow.

[santoshkomerave]

Hello All,

We are planning to move from 3rd party system (CA PPM) to ServiceNow ITBM. Any one can provide me some resources or knowledge to migrate the data to ServiceNow which includes Portfolios, Programs, projects, tasks, team members, cost plans... etc....

Thanks,

Santosh

[Uncle Rob]

Hey Santosh,

I'd be willing to discuss specifics, but I just spent a couple months doing exclusively project data migration.  Can't dump all that knowledge into a single thread.

[santoshkomerave]

Hi Robert,

Thanks for your help!

I will try to explain at my best what I am trying to do. Feel free to ask if you are unclear with the below description.

Currently, we use PPM to manage projects in 3rd Party tool- CA Clarity PPM. We use modules like Portfolios, Programs, Projects, Projects associated with Teams/Tasks, Cost plans at the project, Ideas.

Now, we have plans to migrate the current PPM system to ServiceNow ITBM along with the existing data (Portfolios, Programs, Projects, Projects associated with Teams/Tasks, Cost plans at the project, Ideas) needs to be moved to ServiceNow ITBM related applications. Once we migrate the data all the users have to manage the projects in ServiceNow as they are doing currently in CA Clarity PPM.

At the moment, I am trying to do a POC where I want to migrate the projects and its association's data to SNOW ITBM projects application. Once I complete this initial POC, I should also follow a similar process to migrate the data for other applications for Programs, Portfolios, Ideas etc...

Regards,

Santosh

[Uncle Rob]

Ok, so ServiceNow's existing project import utility only works with MS Project, not Clarity.  This means you'll need to use conventional import mechanisms.  Exporting excel or csv from CA and building data sources and transforms over on the ServiceNow side.

To do that successfully you're going to have to understand any differences in how the two systems treat each concept.  For example, MS Project and ServiceNow have a massive difference in how "Start ASAP" constraint types work.

After that its just a question of importing in the right order.

I'd like to say this is as simple as a blog post to address, but its not.  Took me weeks just to get Resource Plans right on a Project to ServiceNow migration.

Depending on the fidelity you need between the systems, I could offer your org a support package to help you through it.

[PRABHASH2]

Hi Santosh, 

You can integrate servicenow with 3rd party systems using following methods :

1. Direct data source integration : DB/ FTP etc

2. Web Service Integration : SOAP/ REST

I guess CA has the WS capabilities. You might need to confirm from their end.

Check out the below links :

https://docs.servicenow.com/bundle/london-application-development/page/integrate/web-services/reference/r_AvailableWebServices.html