CRM migration

Migrate from PANDA Perio to Microsoft Dynamics 365 Sales

Field-level mapping, validation, and rollback between PANDA Perio and Microsoft Dynamics 365 Sales . We move data and schema; workflows are rebuilt natively in Microsoft Dynamics 365 Sales .

PANDA Perio logo

PANDA Perio

Source

Microsoft Dynamics 365 Sales

Destination

Microsoft Dynamics 365 Sales  logo

Compatibility

100%

12 of 12

objects map 1:1 between PANDA Perio and Microsoft Dynamics 365 Sales .

Complexity

BStandard

Timeline

1–3 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

PANDA Perio stores periodontal charting records, patient demographics, treatment plans, clinical notes, and provider assignments in a dental-specific data model. Microsoft Dynamics 365 Sales uses the Dataverse-backed CRM schema with Accounts, Contacts, Leads, and Opportunities as core entities. This migration maps PANDA Perio patient records to Dynamics 365 Contacts with Account linkage, preserves treatment plan and clinical note history in custom fields, and maintains provider-to-owner relationships via email-based user resolution. The PANDA Perio REST API enables structured data extraction; Dynamics 365 Sales accepts data via the Web API or Bulk Import. Clinical periodontal findings that have no CRM equivalent are stored as custom fields or attachments. Workflows, automated letters, and perio-charting templates do not migrate — those require manual reconstruction in Dynamics 365 or Power Automate. FlitStack AI sequences the migration to preserve referential integrity: patients before accounts, accounts before contacts, contacts before opportunity linkages. Custom Dataverse tables are created for TreatmentPlan and PerioVisit entities to handle clinical data without native CRM equivalents, ensuring all critical patient information transfers to your Microsoft environment.

Field-level fidelity

Every standard and custom field arrives verified.

Schema-aware mapping

AI proposes the map; you confirm before any record moves.

Relationships preserved

Parent–child, lookups, and ownership stay linked.

Full activity history

Calls, emails, meetings — with original timestamps.

Attachments & notes

Documents, uploads, and inline notes move with the record.

Why teams make this switch

Two sides of the same decision

Leaving

PANDA Perio logo

PANDA Perio

What's pushing teams away

  • The on-premise-only deployment requires dedicated Windows Server infrastructure and IT maintenance, pushing cost-conscious practices toward cloud-based alternatives with no local setup overhead.
  • No public REST API means integrations beyond Open Dental must be custom-built and maintained, frustrating practices that need bidirectional data flow with modern cloud platforms.
  • The small vendor team — three named employees with a 2-person management structure — raises concern for practices worried about long-term support continuity and software updates.
  • Larger multi-clinic periodontal groups report that SQL Server Express hits its 10GB database limit sooner than expected, forcing a costly SQL Server upgrade with no clear migration path documented.

Choosing

Microsoft Dynamics 365 Sales  logo

Microsoft Dynamics 365 Sales

What's pulling them in

  • Deep Microsoft 365, Teams, and Outlook integration makes Microsoft Dynamics 365 Sales a natural fit for Microsoft-first organizations already invested in that ecosystem
  • Sales Enterprise and Premium tiers offer unlimited custom tables and advanced AI-driven forecasting and predictive analytics not available in lower tiers
  • Professional tier pricing at $65 per user per month offers a lower entry cost than Salesforce for SMB teams with straightforward CRM needs
  • Flexible customization options allow businesses to build bespoke apps, tailor forms and views, and integrate with other Dynamics 365 modules
  • Microsoft Copilot AI tools are embedded directly into the sales workflow on Enterprise and Premium, automating routine tasks and providing deal intelligence

Object mapping

How PANDA Perio objects map to Microsoft Dynamics 365 Sales

Each row shows how a PANDA Perio object lands in Microsoft Dynamics 365 Sales , including any object-level transformations, lookup resolution, or schema-design dependencies.

Typical mapping — final map is confirmed during the sample migration step.

PANDA Perio

Patient Record

maps to

Microsoft Dynamics 365 Sales

Contact

1:1
Fully supported

PANDA Perio patient records map directly to Dynamics 365 Contacts. Patient demographics including name, date of birth, contact information, address, and phone numbers translate directly to Contact standard fields. Primary provider assignment resolves to Contact OwnerId via email match against Dynamics system users. Chart numbers and billing types from PANDA Perio migrate to custom fields on the Contact record for clinical reference and practice management integration.

PANDA Perio

Patient Record (business entity)

maps to

Microsoft Dynamics 365 Sales

Account

1:1
Fully supported

When PANDA Perio stores referring dental practice or employer information, those entities map to Dynamics 365 Accounts. The referring practice name, address, and contact details populate Account standard fields. Personal patients map to Contacts without an Account link; business-referred patients create an Account record representing the referring practice with a lookup relationship from the patient Contact record.

PANDA Perio

Guarantor / Billing Contact

maps to

Microsoft Dynamics 365 Sales

Contact (parent relationship)

1:1
Fully supported

PANDA Perio stores guarantor information per patient for billing responsibility tracking. The guarantor maps to the same Contact record structure, with a parent-contact relationship established in Dynamics 365 when multiple family members are migrated together. This preserves family billing hierarchies while maintaining individual Contact records for each family member.

PANDA Perio

Treatment Plan

maps to

Microsoft Dynamics 365 Sales

Custom Entity (TreatmentPlan)

1:1
Fully supported

PANDA Perio treatment plans contain procedure codes, phases, clinical notes, and status tracking. Dynamics 365 has no native treatment plan entity. We create a custom TreatmentPlan table in Dataverse to store plan headers including plan number, date, status, and provider assignment. Procedure line items map as child records in a linked TreatmentPlanProcedure table with procedure codes, tooth-site references using universal numbering, and fee information.

PANDA Perio

Periodontal Charting Visit

maps to

Microsoft Dynamics 365 Sales

Custom Entity (PerioVisit)

1:1
Fully supported

Each PANDA Perio visit containing periodontal charting (pocket depths, BOP, furcation, mobility) maps to a custom PerioVisit table linked to the Contact via a lookup relationship. Charting data for each tooth-site stores as JSON or delimited custom fields since Dynamics 365 does not support dental chart grid structures natively. Visit dates, provider assignments, and clinical findings are preserved for historical reference and treatment outcome tracking.

PANDA Perio

Progress Notes / SOAP Notes

maps to

Microsoft Dynamics 365 Sales

Annotation (Notes)

1:1
Fully supported

PANDA Perio clinical progress notes and SOAP notes migrate to Dynamics 365 Annotations attached to the Contact record. Note dates become Annotation Subject lines for chronological organization, while note body content populates the Annotation Body field. Rich-text formatting is preserved where possible; complex formatting converts to plain text with HTML markup retained for readability and reference purposes.

PANDA Perio

Referral Letter Template

maps to

Microsoft Dynamics 365 Sales

Template (Word/Email) + Note

1:1
Fully supported

PANDA Perio's dynamic letter templates with provider-specific phrasing and conditional logic cannot migrate directly to Dynamics 365. We export template definitions as reference documentation including field names, conditional logic patterns, provider signature blocks, and procedure code references. This documentation accelerates rebuilding via Dynamics 365 Word Templates or Power Automate. Existing sent letters are preserved as PDF attachments on the Contact record.

PANDA Perio

Clinical Workflow Manager flags

maps to

Microsoft Dynamics 365 Sales

Task + Custom field on Contact

1:1
Fully supported

PANDA Perio chart flags including recare needed, treatment incomplete, and referral pending statuses map to Dynamics 365 Tasks with appropriate category and due date assignments. The original flag type is preserved in a custom Contact field (Workflow_Flag__c) for filtering, reporting, and bulk operations. Task subjects reference the flag type and patient name for clear identification in the Dynamics 365 timeline view.

PANDA Perio

Patient Attachments / X-rays

maps to

Microsoft Dynamics 365 Sales

SharePoint / Dataverse File Attachment

1:1
Fully supported

PANDA Perio file attachments including images, X-rays, consent forms, and clinical photographs re-upload to Dynamics 365 SharePoint integration or Dataverse file columns attached to the Contact record. SharePoint document libraries provide scalable storage for large attachment volumes with folder structures mapped to match PANDA Perio organization. File size limits of 125 MB per file apply in Dataverse native storage; SharePoint integration bypasses this limitation for very large imaging files.

PANDA Perio

Provider / Doctor Record

maps to

Microsoft Dynamics 365 Sales

SystemUser (Owner resolution)

1:1
Fully supported

PANDA Perio providers and doctor records resolve to Dynamics 365 system users via email address matching. This OwnerId assignment links patient records to their responsible provider in Dynamics 365. Unmatched providers are flagged in a resolution report for manual user creation or reassignment to a default provider Contact record. Proper owner resolution ensures record visibility, task assignment, and accountability tracking in Dynamics 365.

PANDA Perio

Appointment / Visit History

maps to

Microsoft Dynamics 365 Sales

Custom Entity (Appointment) + Activity

1:1
Fully supported

PANDA Perio visit dates, providers, procedure codes, and visit types map to a custom Appointment entity linked to Contact. The custom entity stores structured visit metadata while maintaining relationship context. Visit-level activities including examinations, surgeries, and consultations also create Dynamics 365 Activity records for timeline visibility and workflow automation triggers. Historical appointments are preserved for recall reminders and treatment history review.

PANDA Perio

Insurance / Billing Information

maps to

Microsoft Dynamics 365 Sales

Custom Entity (InsuranceInfo) + Account

1:1
Fully supported

PANDA Perio insurance carrier names, policy numbers, group numbers, and coverage details map to a custom InsuranceInfo table linked to Contact. Insurance company names create or link to Account records for carrier reporting and communication tracking. The custom entity stores complete policy details while the Account link provides carrier-level aggregation for claims reporting, coverage analysis, and provider network verification within Dynamics 365.

Gotchas + challenges

What specifically takes care here

Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.

PANDA Perio logo

PANDA Perio gotchas

High

No public API — database extraction requires SQL Server access

High

SQL Server Express 10GB limit can be migration-blocking

Medium

Open Dental bridge passes IDs only, not clinical data

Medium

Treatment plan PMS codes differ from clinical letter descriptions

Low

Custom periodontal findings are practice-specific

Microsoft Dynamics 365 Sales  logo

Microsoft Dynamics 365 Sales gotchas

High

Professional tier 15-table custom table limit blocks migrations

High

October 2024 pricing increase applies at renewal for all customers

Medium

Custom fields must be created in the UI before API writes

Medium

Power Platform request limits apply to bulk migrations

Medium

Activity records orphaned to inactive owners fail silently

Pair-specific challenges

  • Periodontal charting data has no native Dynamics 365 equivalent

    PANDA Perio stores 200+ periodontal findings per patient visit in a structured dental chart. Dynamics 365 Sales has no periodontal chart entity, grid control, or tooth-site data structure. We create custom Dataverse tables (PerioVisit__c) to store probing depths, BOP, furcation, and mobility as delimited text fields or JSON columns. Tooth-site specificity (universal numbering) is preserved, but the clinical workflow of viewing a periodontal chart graphically requires a separate dental application post-migration. This is an inherent limitation of moving dental clinical data into a general CRM.

  • Custom Dataverse tables require Dynamics 365 licensing tier

    Dynamics 365 Sales Professional limits custom tables to 15 total tables in Dataverse. PANDA Perio migrations requiring a TreatmentPlan table, a PerioVisit table, a Procedure child table, and an InsuranceInfo table can exceed this limit. Practices on Sales Professional tier must either upgrade to Enterprise for unlimited custom tables or consolidate clinical data into fewer custom entities. We identify table count during discovery and advise on licensing tier before migration begins.

  • Provider-to-owner email matching may leave records unassigned

    PANDA Perio stores provider names and credentials per patient and treatment plan. Dynamics 365 requires an OwnerId pointing to an actual system user. We match providers by email address against Dynamics users. PANDA Perio providers often lack email addresses in the system, resulting in unmatched records. These are flagged pre-migration for your team to either create Dynamics users for each provider or reassign records to a default provider contact. Unresolved owners prevent record creation in Dynamics 365.

  • Letter templates and automated correspondence do not migrate

    PANDA Perio's instant letter writing feature memorizes provider phrasing and generates dynamic letters from clinical findings. Dynamics 365 has Word Templates and Power Automate for correspondence, but these are rebuilt from scratch. We export PANDA Perio letter template definitions as reference documentation including field names, conditional logic patterns, provider signature blocks, and procedure code references to accelerate Power Automate rebuild. Existing sent letters are preserved as PDF attachments on the Contact record. No letter content is lost, but the automation requires manual reconstruction by your Dynamics admin or Power Automate developer.

  • PANDA Perio SQL Server database size affects extraction method

    Larger PANDA Perio deployments store data in SQL Server Standard or Enterprise editions beyond the Express 10 GB limit. Direct API extraction may time out on large result sets exceeding API response limits. We use batched extraction with pagination from the PANDA REST API or direct SQL read (with credentials provided by your team) to pull data in manageable chunks. Extraction time and methodology are scoped during discovery based on record counts, database size estimates, and API rate limits to ensure reliable data extraction without timeouts.

Migration approach

Six steps for a successful PANDA Perio to Microsoft Dynamics 365 Sales data migration

  1. Discover PANDA Perio data structure and licensing tier

    We extract PANDA Perio data via the REST API using provided credentials, identifying patient count, custom field inventory, treatment plan volume, and attachment file sizes. We simultaneously assess your Dynamics 365 Sales licensing tier (Professional vs. Enterprise) to confirm custom table capacity. The discovery output includes a record-count matrix by entity type and a custom field inventory spreadsheet for your review before field mapping begins.

  2. Design Dataverse custom tables and column schema

    For practices with periodontal charting, treatment plans, or insurance data, we design custom Dataverse tables (TreatmentPlan__c, PerioVisit__c, InsuranceInfo__c) before data lands. This includes field naming, data type selection (text, datetime, picklist, JSON), and relationship definitions between custom tables and the Contact record. Your Dynamics admin approves the schema; we publish custom tables to your sandbox environment for validation before production migration.

  3. Resolve providers to Dynamics users and flag unlinked records

    PANDA Perio provider records are matched against Dynamics 365 system users by email address. Unmatched providers are listed in a resolution report with the provider name, role, and any contact information from PANDA Perio. Your team creates Dynamics users for each unmatched provider or designates a fallback owner. No patient records migrate without a confirmed owner assignment — this prevents Dynamics validation errors at load time.

  4. Run sample migration with field-level diff

    A representative slice of 100–500 patient records migrates to your Dynamics 365 sandbox, including patients with treatment plans, perio visits, progress notes, and attachments. We generate a field-level diff comparing source values against Dynamics field values so you can verify name formatting, date preservation, provider ownership, and custom field population. Sample results are reviewed with your team before the full migration is scheduled.

  5. Execute full migration with delta-pickup window

    The full migration loads to Dynamics 365 Production. A delta-pickup window (24–48 hours after migration start) captures any PANDA Perio records modified during the cutover period — new appointments, updated treatment plans, or modified patient information. All operations are logged to an audit trail. If reconciliation identifies missing or misaligned records, one-click rollback reverts the Dynamics environment to pre-migration state while we investigate and re-run.

Platform deep dives

Context on both ends of the pair

PANDA Perio logo

PANDA Perio

Source

Strengths

  • Comprehensive tooth-by-tooth periodontal charting with 200+ clinically relevant findings in a single chart view.
  • Real-time letter generation directly from charting data, eliminating manual transcription for referral correspondence.
  • Treatment-plan memorization learns individual clinician phrasing, reducing repetitive typing over time.
  • Comparison charting across up to 5 historical visits with adjustable surgical baseline, unique among periodontal tools.
  • Clinical Workflow Manager flags overdue charts and generates task lists from charting entries, improving recall compliance.

Weaknesses

  • On-premise Windows/SQL Server deployment only — no cloud hosting, SaaS option, or macOS/Linux support.
  • No public API documented; data extraction requires direct SQL Server database access or Open Dental bridge export.
  • Small vendor team of fewer than 10 employees raises long-term viability and support responsiveness concerns.
  • Pricing is per-workstation and per-month, which scales cost higher for multi-location practices faster than per-provider SaaS models.
  • No mobile or tablet-native application; only Windows-based Tablet PC support, limiting hardware flexibility.
Microsoft Dynamics 365 Sales  logo

Microsoft Dynamics 365 Sales

Destination

Strengths

  • Native integration with Microsoft 365, Teams, Outlook, and SharePoint for unified productivity workflow
  • Unlimited custom tables and complex workflows on Enterprise tier enable deep customization for complex sales processes
  • AI-driven predictive analytics and deal intelligence on Enterprise and Premium tiers help sales teams prioritize pipeline
  • Dataverse unified data layer provides a consistent API and data model across all Dynamics 365 and Power Platform apps
  • Strong security model with Field-Level Security and Record Ownership rules for governance-conscious enterprises

Weaknesses

  • Sales Professional tier caps custom tables at 15, creating a migration ceiling for highly customized SMB environments
  • October 2024 pricing increases of $15 per user across all tiers apply to existing customers upon renewal
  • Implementation typically requires costly certified partners, adding 30–50% to total project cost
  • Updates and platform releases can disrupt customizations and plugins, requiring regression testing after each wave
  • Non-Microsoft integrations require additional configuration or middleware, limiting flexibility for heterogeneous tech stacks

Complexity grading

How hard is this migration?

Standard CRM migration. All 8 core objects map 1:1 between PANDA Perio and Microsoft Dynamics 365 Sales .

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across PANDA Perio and Microsoft Dynamics 365 Sales .

  • Object compatibility

    A

    All 8 core objects map 1:1 between PANDA Perio and Microsoft Dynamics 365 Sales .

  • Field mapping clarity

    C

    Field mapping is derived from defaults — final spec confirmed during the sample migration.

  • Timeline complexity

    B

    8-object category — typical timelines run 2–7 days end-to-end.

  • API constraints

    B

    PANDA Perio: Not publicly documented.

  • Data volume sensitivity

    B

    PANDA Perio doesn't expose a bulk API — REST + parallelization used for high-volume runs.

Estimator

Estimate your PANDA Perio to Microsoft Dynamics 365 Sales migration cost

Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.

Step 1

What are you migrating?

Pick a category, then your source and destination platforms.

Category

FAQ

Frequently asked questions about PANDA Perio to Microsoft Dynamics 365 Sales data migrations

Answers to the questions buyers ask most during PANDA Perio to Microsoft Dynamics 365 Sales migration scoping. Not seeing yours? Book a call.

Can't find your answer?

Walk through your PANDA Perio to Microsoft Dynamics 365 Sales migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Most PANDA Perio to Dynamics 365 migrations complete in 1–3 weeks for practices with fewer than 10,000 patient records and standard demographics. Practices exceeding 25,000 records, extensive treatment plan histories, or multiple custom clinical tables typically require 4–6 weeks. The longest phase is typically schema design and provider resolution, not data loading. We scope timelines during discovery based on record counts and custom field complexity.

Adjacent paths

Related migrations to explore

Ready when you are

Move from PANDA Perio.
Land in Microsoft Dynamics 365 Sales , intact.

Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.

Accuracy guarantee Rollback included Quote in 1 business day