Migrate from Data Team DDS to Microsoft Dynamics 365 Sales

Direct 1:1 map. Dynamics 365 Contact requires a primary AccountId — contacts without a company association in Data Team DDS are attached to a default placeholder Account record or routed to the queue configured at migration time. This ensures all contacts maintain referential integrity within the Dynamics 365 environment, preventing orphaned records and maintaining proper relationship hierarchies across accounts, contacts, and related opportunities.

Direct 1:1 map. Data Team DDS company records map to Dynamics 365 Account. Parent-child hierarchies use the ParentAccountId field. Multi-branch structures in Data Team DDS collapse to a single parent chain in Dynamics 365, so circular references are flagged before the migration run.

Direct 1:1 map. Lead Status and Lead Quality score pick-list values require value mapping if Data Team DDS uses custom status labels. We preserve the original lead source and score as custom fields since Dynamics 365 lead scoring is native only on Enterprise/Premium tiers.

Direct 1:1 map. Dynamics 365 Opportunity requires AccountId and uses a StageName pick-list scoped to a BusinessProcessFlow. We create a separate business process flow for each Data Team DDS pipeline so stage values map cleanly without cross-contamination between sales processes.

Each Data Team DDS pipeline becomes a named Business Process Flow in Dynamics 365 Sales. Stages within the pipeline map to StageName pick-list values on the Opportunity record tied to that flow. Probability and forecast category are re-applied per stage based on your Dynamics 365 configuration.

Data Team DDS activity records with type 'Call' or 'Task' migrate as Dynamics 365 Task records. Subject, description, due date, and owner are mapped directly. Completed flag and actual duration are preserved as custom fields since Task doesn't store duration natively.

Data Team DDS meeting records migrate as Dynamics 365 Appointment with original start/end times preserved. Location, regarding (linked record), and organizer are mapped field-by-field. Recurring meetings require expansion — each occurrence becomes a separate Appointment record. We also preserve the organizer email and attendee list from the original Data Team DDS meeting to maintain complete scheduling context in Dynamics 365.

Email activity stored in Data Team DDS migrates as Email activity records in Dynamics 365. The regarding field links back to the parent Contact, Account, or Opportunity. Email body and subject are preserved; attachments are converted to Note/Attachment annotation records.

Data Team DDS custom fields are audited before migration. On Sales Professional, we prioritize the top 15 most-used custom fields as Dataverse columns; remaining fields are stored as a JSON blob in a single custom text field for reference. Enterprise tier allows full migration of all custom fields as separate Dataverse columns.

File attachments stored in Data Team DDS are downloaded, re-uploaded to Dynamics 365 Dataverse as Note annotation records, and linked to the parent record (Contact, Account, or Opportunity). Files larger than 128 MB are flagged for manual re-upload since that is the Dataverse annotation size limit.

Data Team DDS owner IDs are resolved by email match against Dynamics 365 Azure Active Directory–synced users. Unmatched owners are flagged before migration — your team either provisions a Dynamics 365 license for them or we assign their records to a fallback queue. No record lands without a valid OwnerId.

Dynamics 365 sets CreatedOn at migration load time, overwriting the original timestamp. We preserve the original Data Team DDS create date as a custom datetime field (Original_Created_Date__c) on each record so reporting continuity is maintained and historical trend analysis remains accurate from day one in the new system.

Data Team DDS record IDs are stored as a custom text field on each Dynamics 365 record for traceability, duplicate detection during delta runs, and audit trail. This field is indexed for fast lookup during the 24–48 hour delta-pickup window.