Dual-write

Completed

Dual-write is an included infrastructure that provides near-real-time interaction between model-driven apps in Microsoft Dynamics 365 and finance and operations apps. When data about customers, products, people, and operations flow beyond application boundaries, you empower all departments in an organization.

Dual-write provides tightly coupled, bidirectional integration between finance and operations apps and Microsoft Dataverse. Any data change in finance and operations apps causes writes to Dataverse, and any data change in Dataverse causes writes to finance and operations apps. This automated data flow provides an integrated user experience across the apps.

The dual-write infrastructure is extensible and reliable, and it includes the following key features:

  • Synchronous and bidirectional data flow between applications

  • Synchronization, together with play, pause, and catchup modes to support the system during online and offline/asynchronous modes

  • Ability to sync initial data between the applications

  • Consolidated view of activity and error logs for data admins

  • Ability to configure custom alerts and thresholds and to subscribe to notifications

  • Intuitive user interface (UI) for filtering and transformations

  • Ability to set and view entity dependencies and relationships

  • Extensibility for standard and custom entities and maps

  • Reliable application lifecycle management (ALM)

  • Out-of-the-box setup experience for new customers

Top reasons to use dual-write

Dual-write provides data integration across Microsoft Dynamics 365 applications. This robust framework links environments and enables different business applications to work together. The top reasons for using dual-write are:

  • Dual-write provides tightly coupled, near-real-time, and bidirectional integration between finance and operations apps and model-driven apps in Dynamics 365. This integration makes Microsoft Dynamics 365 the one place to go for all your business solutions.

  • Data from customers, products, operations, projects, and the Internet of Things (IoT) automatically flows to Dataverse through dual-write. This connection is useful for businesses that are interested in Microsoft Power Platform expansions.

  • The dual-write infrastructure follows the no-code or low-code principle. Minimal engineering effort is required to extend the standard table-to-table maps and to include custom maps.

  • Dual-write supports online mode and offline mode.

Dual-write features

The features in dual-write are:

  • Near-real time and bi-directional integration

  • Simple and intuitive user interface to enable and administer

  • Ability to add standard and custom entities

  • Embedded experience in finance and operations

  • Ability to filter and transform data

  • Ability to customize entity and field mappings

  • Low friction setup experience

  • Application lifecycle management (ALM) support

  • Error management and alert notification

Set up dual-write

The setup of a dual-write connection has the following requirements:

  • Finance and operations apps that have build version 10.0.9 (10.0.383.20013) (Quality update) and platform update 33 or later

  • Model-driven apps in Microsoft Dynamics 365 that have platform version 9.1.0000.11732 or later

The setup mechanism varies, depending on your subscription and the environment.

  • For new instances of finance and operations apps, the setup of a dual-write connection begins in Lifecycle Services. If you have a license for Microsoft Power Platform, you'll get a new Dataverse environment if your tenant doesn't have one.

  • For existing instances of finance and operations apps, the setup of a dual-write connection begins in the finance and operations environment.

For more information, see Guidance for dual-write setup.

To set up a dual-write connection, you must:

  • Be an administrator in the finance and operations environments and Dataverse environments.

  • Have access to the tenant.