Skip to main content

Microsoft Dynamics 365 Writer

Microsoft Dynamics 365 offers AI-powered ERP and CRM applications to help customers better manage sales, service, finance, and supply chain operations. Striim’s Dynamics 365 writer integrates with the Microsoft Dynamics platform and allows customers to write data into Dynamics 365. Note, this documentation does not include Microsoft's Business Central writer; see Microsoft Dynamics 365 Business Central Writer for details on this writer.

Feature summary

Feature

Supported?

Notes

Objects

   Standard entities (tables)

✓

   Custom entities (tables)

✓

Authentication

   Basic authentication

   OAuth authentication

✓

Supports standard OAuth via connection profiles and manual OAuth using Authorization Code Flow.

   Custom authentication methods

Security and Governance

   TLS 1.2

✓

   Connection Profile

✓

Supports OAuth (standard flow) using Tenant ID and Server Root URL.

Supported sources

   Sources that emit WAEvents

✓

All sources that emit WAEvents. You can use event formatters to convert non-WAEvents.

Building Applications / Programmability

   Wizards

   Flow Designer

✓

   Striim TQL

✓

Operations / Write modes

   Append Only

✓

The APPENDONLY mode is available, but only for tables that have a unique primary key constraint. If there’s no unique constraint, using APPENDONLY could lead to data duplication or integrity problems.

   Merge and Append

✓

Writing Methods

   Batch load

✓

   Streaming load

Additional Writing Features

   Auto-quiesce

✓

Post initial load completion is supported

   Schema evolution

-

   Replication

✓

Events are returned immediately after batch acknowledgment.

Runtime

   Resilience

✓

Configurable automatic retries

   Recovery - A1P (at-least once processing)

✓

A1P ("at-least once processing") means that after recovery there may be some duplicate events written to the target.

   Parallel execution

✓

   Metrics and auditing

✓

Supported Products

  1. Customer Service: Cases, Activities, Users, Entitlements, Queues, SocialPosts, etc.

  2. Field Service: WorkOrders, Resources, ServiceBookings, Agreements, Inventory, Products, ServiceCalls, etc.

  3. FinOpsOnline (Dynamics 365 Supply Chain Management): Products, Purchase Orders, SalesOrders, Invoices, Inventory, Warehouses, Costing, Procurement, Transactions, etc.

  4. FinOpsOnPremise (Dynamics 365 Supply Chain Management): Same as FinOpsOnline, but specifically for on-premise deployments

  5. Human Resources: Employees, Positions, Compensation, Benefits, Requests, Requisitions, AbsenceManagement, Statements, Recruiting, etc.

  6. Marketing: Campaigns, Segments, Leads, MarketingLists, Forms, Events, Emails, Posts, etc.

  7. Project Operations: Projects, Tasks, Milestones, Budgets, Invoices, Entries, Resources, Contracts, etc.

  8. Sales: Accounts, Contacts, Opportunities, Leads, Competitors, Quotes, Orders, Invoices, etc.

  9. Commerce: Products, Carts, Orders, Payments, Customers, Stores, Catalogs, Price Lists, Transactions, Categories, etc.