CRM migration
Field-level mapping, validation, and rollback between The Service Manager and Pipedrive. We move data and schema; workflows are rebuilt natively in Pipedrive.
The Service Manager
Source
Pipedrive
Destination
Compatibility
14 of 14
objects map 1:1 between The Service Manager and Pipedrive.
Complexity
BStandard
Timeline
3–5 days
Overview
Microsoft System Center Service Manager stores IT service data — Incidents, Problems, Service Requests, Change Requests, and Configuration Items with a full CMDB graph. Pipedrive is a sales CRM built around People (contacts), Organizations (companies), Deals, Activities, and Leads. These are different domains, and the migration requires careful selection of what ITSM data has business value in a CRM context and what gets carried as reference records or rebuilt manually. FlitStack AI extracts Service Manager data via its SQL back-end or API, maps IT records to CRM objects, creates the necessary custom fields in Pipedrive to hold SLA priority, category, and relationship metadata, and loads everything through Pipedrive's bulk API with rate-limit-aware batching. The key limitation is that ITSM workflows, SLA timers, approval chains, and knowledge-base article associations have no Pipedrive equivalent and must be rebuilt as Pipedrive automations or handled through integrations. We sequence the migration as: audit and select source data, create Pipedrive custom fields, resolve owners by email match, run a sample migration with field-level diff, then execute the full import with a delta window. Source systems remain operational throughout using scoped read access.
Every standard and custom field arrives verified.
AI proposes the map; you confirm before any record moves.
Parent–child, lookups, and ownership stay linked.
Calls, emails, meetings — with original timestamps.
Documents, uploads, and inline notes move with the record.
Why teams make this switch
Leaving
What's pushing teams away
Choosing
What's pulling them in
Object mapping
Each row shows how a The Service Manager object lands in Pipedrive, including any object-level transformations, lookup resolution, or schema-design dependencies.
Typical mapping — final map is confirmed during the sample migration step.
The Service Manager
Incident
Pipedrive
Activity (Task)
1:1Service Manager Incidents map to Pipedrive Activities of type Task. The original incident title becomes the activity subject; description maps to the notes field. Priority, category, and affected CI metadata become custom fields in Pipedrive since the CRM has no native ITSM priority concept.
The Service Manager
Incident
Pipedrive
Note
1:1Service Manager Incident long-description and resolution-notes fields exceed the character limits for activity subject fields. These map to Pipedrive Notes attached to the corresponding Activity record, preserving the full incident narrative with original create timestamps. The notes maintain the complete incident history including all resolution steps and communications, ensuring customer-facing teams have access to the full context when reviewing records in Pipedrive.
The Service Manager
Problem
Pipedrive
Note
1:1Service Manager Problems have no direct Pipedrive equivalent in the CRM data model. Root-cause analysis text and known-error details migrate as Notes attached to the linked Incident Activity record in Pipedrive. This approach keeps the full audit trail accessible to the customer-facing record while maintaining the relationship between the problem record and associated incidents that were resolved through the known-error procedure.
The Service Manager
Service Request
Pipedrive
Deal
1:1Service Requests map to Pipedrive Deals when they represent a billable or customer-facing service engagement that has commercial significance. The request title becomes the deal name, while request category and urgency map to custom fields on the deal record. Request status drives the Pipedrive deal stage mapping, allowing service requests to flow through standard sales pipeline stages. This transformation preserves the service context while adapting it to CRM workflow capabilities.
The Service Manager
Service Request
Pipedrive
Activity (Task)
1:1Each Service Request is also represented as an Activity in Pipedrive so that timelines and owner assignments are visible in Pipedrive's activity feed alongside the corresponding deal record. This dual representation ensures that service request handlers can see their assigned work in the activity timeline while managers can track overall deal progress. The activity record captures the operational details while the deal captures the commercial relationship.
The Service Manager
Change Request
Pipedrive
Activity (Task)
1:1Change Requests map to Pipedrive Activities with custom fields capturing the change type, risk level, CAB approval status, and implementation schedule. This preserves the operational context of each change request within the CRM record. However, approval chains and workflow routing that exist in Service Manager are not reproducible in Pipedrive's data model and must be rebuilt as Pipedrive automations or handled through external workflow tools.
The Service Manager
Configuration Item
Pipedrive
Organization
1:1Service Manager CIs representing organizational assets (servers, software products, business services) map to Pipedrive Organizations. CI class type (Hardware, Software, Business Service) becomes a custom field on the Organization record. CIs with a display name and owning organization get linked accordingly.
The Service Manager
Configuration Item Relationship
Pipedrive
Custom Field
1:1Service Manager CI-to-CI relationships such as contains, depends-on, and impacts form a typed graph that has no equivalent in Pipedrive's flat entity model. We store the relationship type and target CI ID as custom fields on the source Organization record. This preserves the relationship metadata for reference purposes, allowing your team to manually reconstruct relationships in Pipedrive's relationship model or maintain the graph structure externally.
The Service Manager
User (Analyst / Affected User)
Pipedrive
Person
1:1Service Manager users (both analysts and affected end-users) map to Pipedrive People. Analysts who created or were assigned incidents become the Pipedrive Activity owner. Affected users with accounts in Service Manager become CRM contacts. Display name splits into first and last name where possible.
The Service Manager
Support Group
Pipedrive
Custom Field on Activity
1:1Service Manager Support Groups define team ownership and escalation paths for incidents and service requests. These groups have no direct Pipedrive equivalent in the CRM's user management model. The group name migrates as a custom field on Activity records so teams can filter activities by the original support team that handled an incident or service request. This allows managers to analyze workload distribution across legacy support groups.
The Service Manager
Service Catalog Item
Pipedrive
Deal (custom field)
1:1Service Manager Service Catalog items represent the offerings available to end-users through the service portal. These catalog items are preserved as a custom field on the linked Service Request Deal in Pipedrive, so the originating service offering is visible in the sales record. This allows sales and customer success teams to understand what service level the customer originally requested and track how service offerings map to revenue.
The Service Manager
Attachment / File
Pipedrive
Pipedrive Attachment
1:1Attachments stored in Service Manager's SharePoint document library or file share are downloaded during the migration and re-uploaded to the corresponding Pipedrive Activity or Organization record. Inline images embedded in incident notes or problem descriptions are extracted and stored as separate file attachments. Pipedrive plan tiers impose per-file and per-user storage limits that must be verified against total attachment volume before migration execution.
The Service Manager
Knowledge Base Article
Pipedrive
Note (on Organization)
1:1Service Manager knowledge-base articles contain structured ITSM documentation with workflow associations and publish-status fields. These articles have no Pipedrive equivalent since Pipedrive lacks native article storage or knowledge-base features. We extract article titles and the Service Manager article URL as Notes attached to the Organization record linked to the CI the article references. This preserves a navigable reference for customer-success teams without duplicating full article content in the CRM.
The Service Manager
Incident Timeline (Status Changes)
Pipedrive
Activity Log (custom)
1:1Service Manager incident status transitions including Active, Pending, Resolved, and Closed states along with the timestamps of each transition are stored as a custom log field on the Pipedrive Activity record. This preserves the complete incident lifecycle history for customer-success reviews and allows teams to analyze response times and resolution patterns. The timeline data supports service level analysis and customer health scoring in Pipedrive.
| The Service Manager | Pipedrive | Compatibility | |
|---|---|---|---|
| Incident | Activity (Task)1:1 | Fully supported | |
| Incident | Note1:1 | Fully supported | |
| Problem | Note1:1 | Fully supported | |
| Service Request | Deal1:1 | Fully supported | |
| Service Request | Activity (Task)1:1 | Fully supported | |
| Change Request | Activity (Task)1:1 | Fully supported | |
| Configuration Item | Organization1:1 | Fully supported | |
| Configuration Item Relationship | Custom Field1:1 | Fully supported | |
| User (Analyst / Affected User) | Person1:1 | Fully supported | |
| Support Group | Custom Field on Activity1:1 | Fully supported | |
| Service Catalog Item | Deal (custom field)1:1 | Fully supported | |
| Attachment / File | Pipedrive Attachment1:1 | Fully supported | |
| Knowledge Base Article | Note (on Organization)1:1 | Fully supported | |
| Incident Timeline (Status Changes) | Activity Log (custom)1:1 | Fully supported |
Gotchas + challenges
Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.
The Service Manager gotchas
Dense service history causes export pagination failures
Custom fields on Work Orders differ by FSM version
Serialized asset cross-references break after migration
Parts inventory snapshot staleness at cutover
Pipedrive gotchas
Custom field hash keys differ per account
Export access gated by visibility groups
Token-based API rate limits since December 2024
Sequences and Automations not exposed via REST API
Cost escalates via workflow caps and add-ons
Pair-specific challenges
Migration approach
Audit and select source data from Service Manager
We connect to the Service Manager SQL Database (read-only access) or use SMLets PowerShell to enumerate Incidents, Problems, Service Requests, Change Requests, Configuration Items, and Users. We produce a data inventory report showing record counts per class, custom field counts, attachment volume, and relationship cardinality. Based on this inventory, we agree with your team on which record types and time windows to migrate — migrating every historical incident from a 10-year-old Service Manager deployment is often unnecessary and inflates cost without business value.
Create Pipedrive custom fields before data import
Before any records land in Pipedrive, we create the custom fields required for ITSM metadata based on the field mapping specification. This includes fields such as SM_Incident_ID__c, SM_Priority__c, SM_Category__c, SM_Support_Group__c, SM_Tier__c, SM_CI_Class__c, SM_Related_CIs__c, SM_Resolved_Date__c, SM_SR_ID__c, SM_Risk_Level__c, SM_CAB_Approved__c, and any additional custom fields identified during the audit phase. This ensures the destination schema is fully prepared before validation runs commence and prevents partial imports or data loss due to missing field definitions.
Resolve owners and users by email match
Service Manager analysts and affected users are matched to Pipedrive users by email address. Unmatched owners are flagged before migration so your team can either invite them to Pipedrive or assign their records to a designated fallback owner. No Activity lands without a valid Pipedrive user_id. Configuration Items without a clear organizational owner are assigned to a default 'IT Assets' Organization in Pipedrive.
Run a sample migration with field-level diff
A representative slice migrates first — typically 200–500 records spanning incidents, service requests, change requests, and a sample of CIs. We generate a field-level diff comparing source values against destination field values for every mapped field. This lets your team verify custom field completeness, relationship resolution, and attachment re-upload before the full run commits. Discrepancies are corrected in the mapping plan before Phase 2.
Execute full migration with delta-pickup window
The full dataset migrates using Pipedrive's bulk API with rate-limit-aware batching. A delta-pickup window of 24–48 hours after the main run captures any Service Manager records modified or created during the cutover. Audit logs record every operation, and one-click rollback is available if reconciliation fails. We deliver a post-migration validation report showing record counts, custom field fill rates, and any records that could not be migrated with the reason for each exclusion.
Platform deep dives
The Service Manager
Source
Strengths
Weaknesses
Pipedrive
Destination
Strengths
Weaknesses
Complexity grading
Standard CRM migration. 3 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across The Service Manager and Pipedrive.
Object compatibility
3 of 8 objects need a mapping; the rest are 1:1.
Field mapping clarity
Field mapping is derived from defaults — final spec confirmed during the sample migration.
Timeline complexity
8-object category — typical timelines run 2–7 days end-to-end.
API constraints
The Service Manager: Not publicly documented.
Data volume sensitivity
The Service Manager doesn't expose a bulk API — REST + parallelization used for high-volume runs.
Estimator
Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.
Step 1
Pick a category, then your source and destination platforms.
Category
FAQ
Answers to the questions buyers ask most during The Service Manager to Pipedrive migration scoping. Not seeing yours? Book a call.
Walk through your The Service Manager to Pipedrive migration with a real engineer — 30 minutes, free, written quote within 24 hours.
Book a free 30 minute consultationAdjacent paths
Other ways to leave The Service Manager
Other ways to arrive at Pipedrive
Ready when you are
Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.