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.