CRM migration

Migrate from ArkCase to Microsoft Dynamics 365 Sales

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

ArkCase logo

ArkCase

Source

Microsoft Dynamics 365 Sales

Destination

Microsoft Dynamics 365 Sales  logo

Compatibility

92%

11 of 12

objects map 1:1 between ArkCase and Microsoft Dynamics 365 Sales .

Complexity

BStandard

Timeline

1–2 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

ArkCase organizes data around Cases, Persons, Organizations, Complaints, Tasks, and Documents — a case-management model designed for FOIA, legal, and investigative workflows. Dynamics 365 Sales structures data around Leads, Accounts, Contacts, and Opportunities — a sales-cycle model built on Dataverse. The migration carries every standard ArkCase entity into its nearest Dynamics 365 equivalent: Cases to Cases (entity), Persons to Contacts, Organizations to Accounts, Complaints to Cases, Tasks to Tasks, Communications to Emails, and Document metadata to SharePoint-attached Notes. Encrypted PII fields in ArkCase (encryptedFirstName, encryptedLastName, etc.) have no native Dynamics field type — these migrate as custom text fields (ArkCase_Encrypted_*) and are flagged for manual re-identification post-migration. BPMN 2.0 workflow definitions in ArkCase do not transfer; FlitStack exports them as a JSON blueprint for your Power Automate rebuild. Document binary attachments are preserved as SharePoint file URLs with original filenames and create-dates carried as custom fields. We use Dynamics 365 Web API (Dataverse) for real-time record operations and Bulk API for large-volume batch inserts, sequencing dependent entities (Organization → Person → Case → Task) so foreign-key lookups resolve cleanly. A 24–48 hour delta-pickup window captures records modified during the cutover window so Dynamics reflects ArkCase's final state at go-live.

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

ArkCase logo

ArkCase

What's pushing teams away

  • Organisations report that the open-source tier ships with minimal support and no high-availability clustering, causing reliability concerns for production workloads that would require Enterprise pricing to resolve.
  • The learning curve for non-technical staff around BPMN workflow design is steeper than marketed — legal teams frequently need external consultants to build and maintain non-trivial routing logic.
  • Integration with third-party ECM repositories requires custom configuration that is not always well-documented, leading to support tickets and extended implementation timelines.
  • The analytics and reporting module on the open-source tier is described as limited, pushing growing organisations toward the paid tiers or an external BI tool, which adds cost and complexity.

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 ArkCase objects map to Microsoft Dynamics 365 Sales

Each row shows how a ArkCase 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.

ArkCase

Person

maps to

Microsoft Dynamics 365 Sales

Contact

1:1
Fully supported

ArkCase Person records map to Dynamics 365 Contact. The primary Organization link resolves via AccountId lookup — if the Person has no primary Organization, the record lands without an AccountId and a default organization flag is set for the admin to resolve post-migration.

ArkCase

Organization

maps to

Microsoft Dynamics 365 Sales

Account

1:1
Fully supported

ArkCase Organization maps directly to Dynamics 365 Account. Organization hierarchies (parent/child) map to the Parent Account field. Multi-address Organizations map to Account.Addresses with the primary address flagged; secondary addresses migrate as Address object rows if Dynamics 365 multi-address is enabled.

ArkCase

Case

maps to

Microsoft Dynamics 365 Sales

Case

1:1
Fully supported

ArkCase Case maps to Dynamics 365 Case (incident entity). Case status values (Active, Pending, Closed, etc.) map via value mapping to the Dynamics Case.Statuscode pick-list. Priority maps to Priority. The ArkCase CaseId is preserved in a custom Source_System_ID__c field for traceability and delta-run de-duplication.

ArkCase

Complaint

maps to

Microsoft Dynamics 365 Sales

Case

many:1
Fully supported

ArkCase Complaint is a specialized Case subtype. We merge Complaints into the Case entity and add a custom Complaint_Type__c field to distinguish them from standard Cases. The complaint reason and filing-party fields map to custom fields on the Case record. If your ArkCase setup uses a separate Complaint entity with its own workflow, a custom Case origin field tracks this.

ArkCase

Task

maps to

Microsoft Dynamics 365 Sales

Task

1:1
Fully supported

ArkCase Task maps directly to Dynamics 365 Task. Task status values (Open, In Progress, Completed, etc.) map to Task.Statuscode pick-list values. Task Priority maps to Priority. Assignee resolution uses email matching against Dynamics 365 users. Unmatched assignees are flagged before migration for admin assignment.

ArkCase

Communication (Email)

maps to

Microsoft Dynamics 365 Sales

Email (activity)

1:1
Fully supported

ArkCase Communication records of type 'Email' migrate to Dynamics 365 Email (email activity). The email subject, body, from, to, and cc fields map directly. Original timestamps (sent date, received date) are preserved in custom datetime fields. Email direction (inbound/outbound) is stored in a custom Email_Direction__c field.

ArkCase

Document

maps to

Microsoft Dynamics 365 Sales

SharePointDocumentLocation + Note

1:1
Fully supported

ArkCase Documents do not migrate as Dynamics native attachments because Dynamics 365 Sales does not have a native ECM layer. Instead, we create SharePointDocumentLocation records pointing to the ArkCase-managed SharePoint repository, and store document metadata (filename, size, version, create date, created-by user) as custom fields on a Note record linked to the parent Case or Contact. Actual binary files remain in the SharePoint repository with URL preserved for re-linkage post-migration.

ArkCase

Encrypted Person Fields

maps to

Microsoft Dynamics 365 Sales

Custom Fields (ArkCase_Encrypted_*)

1:1
Fully supported

ArkCase stores contact PII in encrypted fields (encryptedFirstName, encryptedLastName, encryptedEmail, encryptedPhone) for FedRAMP and HIPAA compliance. Dynamics 365 has no native encrypted-field type. These migrate to custom text fields named ArkCase_Encrypted_FirstName__c, ArkCase_Encrypted_LastName__c, etc. After migration, the encrypted values must be decrypted and re-identified by your compliance team and written to the standard Contact fields. We flag records with active encrypted values in a custom ArkCase_PII_Requires_Review__c boolean.

ArkCase

Audit Log

maps to

Microsoft Dynamics 365 Sales

Custom Table (ArkCase_Audit_Log__c)

1:1
Fully supported

ArkCase maintains a full user-action audit trail across all entity types. Dynamics 365's audit log captures field-level before/after values for changed fields only — it does not record every user action. We create a custom ArkCase_Audit_Log__c table in Dataverse and populate it with the ArkCase audit records, preserving the user, action, entity, record ID, and timestamp. This table is read-only post-migration and is used for compliance retrieval.

ArkCase

BPMN Workflow Definitions

maps to

Microsoft Dynamics 365 Sales

Power Automate (manual rebuild)

1:1
Fully supported

ArkCase BPMN 2.0 workflow definitions (FOIA intake, ROI processing, data-privacy workflows) have no equivalent in Dynamics 365 Sales. We export the workflow definitions as JSON blueprints and deliver them alongside a Power Automate rebuild guide that maps each BPMN task to an equivalent cloud flow or desktop flow. The actual automation must be rebuilt manually by your Power Automate admin or FlitStack's automation team as a separate engagement.

ArkCase

Person–Case Association

maps to

Microsoft Dynamics 365 Sales

Contact (Regarding ObjectId on Case)

1:1
Fully supported

ArkCase links Persons to Cases via a many-to-many association table. Dynamics 365 Cases have a primary CustomerId field pointing to an Account or Contact. We map the primary Person on a Case to the CustomerId; additional associated Persons are stored as custom multi-select text (ArkCase_Secondary_Parties__c) or linked via the Contact entity's RegardingObjectId on the Case.

ArkCase

Organization–Person Association

maps to

Microsoft Dynamics 365 Sales

Account (primary) + AccountContactRelation (secondary)

1:1
Fully supported

ArkCase allows N:N Person-to-Organization associations. Dynamics 365 Contacts have one primary AccountId and use AccountContactRelation for additional organization links. We migrate the most-recently-linked Organization as the primary AccountId and surface the rest as AccountContactRelation rows. The relationship type field (e.g., Legal Counsel, Respondent) maps to the AccountContactRelation.Roles field.

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.

ArkCase logo

ArkCase gotchas

High

Custom BPMN workflows do not auto-migrate between instances

Medium

Time entries with inactive user references will fail import

Medium

FOIA request stage names vary by jurisdiction and require explicit mapping

Low

Open-source tier lacks a documented bulk API

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

  • Encrypted PII fields have no native Dynamics equivalent and require post-migration re-identification

    ArkCase stores contact PII in encryptedFirstName, encryptedLastName, encryptedEmail, and encryptedPhone fields to meet FedRAMP and HIPAA requirements. Dynamics 365 Sales has no native encrypted-field data type — these fields migrate as plain-text custom fields (ArkCase_Encrypted_*) and are flagged with an ArkCase_PII_Requires_Review__c boolean on every affected Contact record. After migration, your compliance team must decrypt the values and populate the standard FirstName, LastName, and EmailAddress fields before those contacts are fully functional. This is a mandatory post-migration step for regulated environments, not an optional cleanup task.

  • BPMN workflows in ArkCase do not transfer to Dynamics 365 and must be rebuilt in Power Automate

    ArkCase ships with a BPMN 2.0-compliant workflow engine that automates FOIA intake routing, ROI request approvals, and data-privacy case escalation. Dynamics 365 Sales does not execute BPMN files — it uses Power Automate for workflow automation. FlitStack AI exports your ArkCase workflow definitions as JSON blueprints, but the actual automation must be manually rebuilt as Power Automate cloud flows. This is not a limitation of the migration tool; it is a platform architecture difference. Teams should plan for a 2–6 week Power Automate rebuild phase after the data migration completes. Skipping this step means your case routing, approval chains, and escalation rules will not operate in Dynamics 365.

  • ArkCase audit logs require a custom Dataverse table because Dynamics audit capture is field-change-only

    ArkCase maintains a comprehensive user-action audit trail that records every entity touched, every action taken, and the identity of the user who performed it — regardless of whether field values actually changed. Dynamics 365's audit log captures before/after values only for fields that are modified during a save operation — actions that read but do not modify records are not logged. For organizations subject to FOIA, CJIS, or FedRAMP audit requirements, this gap is significant. We address it by creating a custom ArkCase_Audit_Log__c table in Dataverse and populating it with the full ArkCase audit history as read-only records. Post-migration compliance queries run against this custom table rather than the native Dynamics audit log.

  • ArkCase document binaries require re-upload to SharePoint Online after migration

    ArkCase manages documents within its own ECM layer with FedRAMP-authorized storage. Dynamics 365 Sales does not have a native ECM layer — file attachments on Cases and Contacts are stored in SharePoint Online. During migration, we preserve document metadata (filename, size, MIME type, SharePoint URL from ArkCase's own SharePoint repository, create date, created-by user) as Note records linked to the parent Case or Contact. The actual file binaries, however, must be re-uploaded to your Dynamics 365-connected SharePoint library post-migration. We provide a re-upload script and document-to-parent mapping CSV so your SharePoint admin can bulk-restore the file tree. This is not a data-loss situation but a storage-layer migration that requires a post-migration step.

  • ArkCase case type distinctions (FOIA, Legal, Complaint) require custom fields and possibly business rule flows

    ArkCase differentiates Case subtypes — FOIA requests, Legal matters, Complaints, Investigations — each with their own workflow routing, field requirements, and SLA timers. Dynamics 365 Sales has a single Case (incident) entity without native case-type differentiation. To preserve these distinctions, we add a custom pick-list field (CaseType__c) to the Case entity and map each ArkCase case type value. If your organization uses different SLA timers per case type, those business rules must be implemented in Power Automate post-migration. We document the SLA mapping in the migration plan so your Power Automate admin can build the appropriate flows. This is a structural schema decision that should be confirmed with your Salesforce/Dynamics admin before data lands.

Migration approach

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

  1. Inventory ArkCase entities and audit the encrypted-field landscape

    FlitStack AI begins by enumerating every ArkCase entity type present in your instance — Cases, Complaints, Persons, Organizations, Tasks, Documents, Communications, and Audit Logs. We run a field-level inventory to identify all encrypted-* fields and count affected records. This inventory drives the schema setup plan: we document every custom field that must be created in Dataverse, the custom CaseType__c pick-list values, the ArkCase_Audit_Log__c table schema, and the encrypted-field re-identification workflow that your compliance team must execute post-migration.

  2. Create Dynamics 365 custom fields, tables, and SharePoint document library

    Before any data moves, we create the custom fields and tables in your Dynamics 365 environment. This includes: ArkCase_Encrypted_* custom text fields on Contact; CaseType__c and Case_ArkCase_Number__c custom fields on Case; Original_Create_Date__c custom datetime fields on Case, Contact, Task, and Note; ArkCase_Audit_Log__c custom table; and ArkCase_PII_Requires_Review__c boolean fields on Contact. We also provision the SharePoint document library that will hold document binaries post-migration. The Dynamics admin reviews and publishes all schema changes before data validation begins.

  3. Sequence migration of dependent entities with foreign-key resolution

    Dynamics 365 requires Account records to exist before Contact records can link via AccountId, and Contact records before Cases can reference them as customers. We sequence the migration in dependency order: Organizations → Accounts first, then Persons → Contacts, then Cases → Cases with Person and Organization lookups, then Tasks, then Communication/Email records, then Document metadata as Notes. Owner resolution happens at each step via email matching against Dynamics 365 users. Unmatched owners are flagged and assigned to a fallback owner before the next phase begins — no record lands without a valid OwnerId.

  4. Run a sample migration with field-level diff on encrypted fields and document metadata

    A representative sample — typically 200–500 records across Persons, Organizations, Cases, Tasks, and Documents — migrates first. We generate a field-level diff report that shows every mapped field value from ArkCase alongside its Dynamics 365 destination. The diff is reviewed by your team, with particular attention to: encrypted-field values landing in the ArkCase_Encrypted_* custom fields and the PII_Requires_Review flag set correctly; CaseType__c values mapped to the correct pick-list entries; document SharePoint URLs preserved in the Document_SharePoint_URL__c field. Approval of the sample diff triggers the full migration.

  5. Execute full migration with delta-pickup window and document re-upload handoff

    The full migration runs against Dynamics 365 using the Web API for real-time operations and Bulk API for high-volume inserts. A delta-pickup window of 24–48 hours runs concurrently — any record created or modified in ArkCase during the cutover window is captured and applied to Dynamics before go-live. Audit log records populate the ArkCase_Audit_Log__c table. Once migration completes, we deliver a document re-upload package: a CSV mapping each ArkCase documentId to its parent record and SharePoint URL, plus a PowerShell script your SharePoint admin runs to bulk-upload binaries to the destination library. The ArkCase_PII_Requires_Review__c report is handed off to your compliance team for encrypted-field re-identification.

Platform deep dives

Context on both ends of the pair

ArkCase logo

ArkCase

Source

Strengths

  • Open-source core with no per-record licensing, removing artificial data-caps on the free tier.
  • FedRAMP, HIPAA, and HITECH compliance certifications are pre-built, not add-ons, reducing compliance overhead for government and healthcare customers.
  • RESTful API and SDK are available on all tiers, including open source, enabling programmatic data access and integration.
  • BPMN 2.0 workflow engine ships with out-of-the-box templates for FOIA, ROI, and data-privacy processes.
  • Multi-language localisation (English, French, Italian, German, Spanish) is included across all tiers.

Weaknesses

  • High-availability clustering and the full analytics module are gated behind Enterprise Gold pricing, not available on the open-source tier.
  • No native bulk-export or bulk-import UI — large-volume data movement requires API scripting or professional services engagement.
  • The open-source tier offers only online-documentation support, with no named support engineer or SLA on the free plan.
  • Medical OCR/NLP AI and audio/video transcription engines are Platinum-tier exclusives, not available on Enterprise Gold.
  • Pricing beyond named-user tiers involves custom quotes and volume discounts that are not publicly standardised, complicating budget forecasting.
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 ArkCase and Microsoft Dynamics 365 Sales .

B

Overall complexity

Standard migration

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

  • Object compatibility

    A

    All 8 core objects map 1:1 between ArkCase 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

    ArkCase: Not publicly documented for any tier.

  • Data volume sensitivity

    B

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

Estimator

Estimate your ArkCase 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 ArkCase to Microsoft Dynamics 365 Sales data migrations

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

Can't find your answer?

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

Book a free 30 minute consultation

ArkCase to Dynamics 365 Sales migrations typically complete in 1–2 weeks of active migration time for under 10,000 total records. Larger repositories with 50,000+ records, multiple encrypted-field columns, or extensive document metadata extend to 3–5 weeks. The longest single phase is the encrypted-field re-identification and document re-upload, which your team controls after the data migration itself commits. Power Automate workflow rebuild — which is separate from the data migration — typically requires an additional 2–6 weeks depending on workflow complexity.

Adjacent paths

Related migrations to explore

Ready when you are

Move from ArkCase.
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