Edit

Guidance for dual-write setup

  • Article

You can set up a dual-write connection between a finance and operations environment and a Dataverse environment.

  • A finance and operations environment provides the underlying platform for finance and operations apps (for example, Microsoft Dynamics 365 Finance, Dynamics 365 Supply Chain Management, Dynamics 365 Commerce, and Dynamics 365 Human Resources).
  • A Dataverse environment provides the underlying platform for customer engagement apps (Dynamics 365 Sales, Dynamics 365 Customer Service, Dynamics 365 Field Service, Dynamics 365 Marketing, and Dynamics 365 Project Service Automation).

Important

The Human Resources module in Dynamics 365 Finance supports dual-write connections, but the Dynamics 365 Human Resources app doesn't.

Dual-write can be setup from Lifecycle Services for both new and existing environments involving finance and operations apps and customer engagement app. You can follow the guidance from Dual-write setup from Lifecycle Services.

Before you start dual-write on an entity, you can run an initial synchronization to handle existing data on both sides: Finance and operations apps and customer engagement apps. You can skip the initial synchronization if you don't have to sync data between the two environments.

An initial synchronization lets you copy existing data from one app to another bidirectionally. There are several setup scenarios, depending on the environments that you already have and the type of data in them.

The following setup scenarios are supported:

A new finance and operations app instance and a new customer engagement app instance

To set up a dual-write connection between a new instance of a finance and operations app that has no data and a new instance of a customer engagement app, follow the steps in Dual-write setup from Lifecycle Services. When the connection setup is completed, the following actions automatically occur:

  • A new, empty finance and operations environment is provisioned.
  • A new, empty instance of a customer engagement app is provisioned, where the CRM prime solution is installed.
  • A dual-write connection is established for DAT company data.
  • Table maps are enabled for live synchronization.

Both environments are then ready for live data synchronization.

A new finance and operations app instance and an existing customer engagement app instance

To set up a dual-write connection between a new instance of a finance and operations app that has no data and an existing instance of a customer engagement app, follow the steps in Dual-write setup from Lifecycle Services. When the connection setup is completed, the following actions automatically occur:

  • A new, empty finance and operations environment is provisioned.
  • A dual-write connection is established for DAT company data.
  • Table maps are enabled for live synchronization.

Both environments are then ready for live data synchronization.

To sync the existing Dataverse data to the finance and operations app, follow these steps.

  1. Create a new company in the finance and operations app.
  2. Add the company to the dual-write connection setup.
  3. Bootstrap the Dataverse data by using a three-letter International Organization for Standardization (ISO) company code.
  4. Run the Initial sync functionality for the tables that you want to sync data for.

For links to an example and an alternative approach, see the Example section later in this article.

A new finance and operations app instance that has data and a new customer engagement app instance

To set up a dual-write connection between a new instance of a finance and operations app that has data and a new instance of a customer engagement app, follow the steps in the A new finance and operations app instance and a new customer engagement app instance section earlier in this article. When the connection setup is completed, if you want to sync the data to the customer engagement app, follow these steps.

  1. Open the finance and operations app from the Lifecycle Services page, sign in, and then go to Data Management > Dual-write.
  2. Run the Initial sync functionality for the tables that you want to sync data for.

For links to an example and an alternative approach, see the Example section.

A new finance and operations app instance that has data and an existing customer engagement app instance

To set up a dual-write connection between a new instance of a finance and operations app that has data and an existing instance of a customer engagement app, follow the steps in the A new finance and operations app instance and an existing customer engagement app instance section earlier in this article. When the connection setup is completed, if you want to sync the data to the customer engagement app, follow these steps.

  1. Open the finance and operations app from the Lifecycle Services page, sign in, and then go to Data Management > Dual-write.
  2. Run the Initial sync functionality for the tables that you want to sync data for.

To sync the existing Dataverse data to the finance and operations app, follow these steps.

  1. Create a new company in the finance and operations app.
  2. Add the company to the dual-write connection setup.
  3. Bootstrap the Dataverse data by using a three-letter ISO company code.
  4. Run the Initial sync functionality for the tables that you want to sync data for.

For links to an example and an alternative approach, see the Example section.

An existing finance and operations app instance and a new customer engagement app instance

The setup of a dual-write connection between an existing instance of a finance and operations app and a new instance of a customer engagement app occurs using Lifecycle Services power platform integration setup.

  1. Follow Connect finance and operations apps with a new Microsoft Dataverse instance to establish the link using Lifecycle Services.
  2. A dual-write connection is established for all legal entities. You can remove legal entities from the dual-write workspace within finance and operations apps if you do not wish to synchronize the data for a specific company.
  3. Run the Initial sync functionality for the tables that you want to sync data for.

For links to an example and an alternative approach, see the Example section.

An existing finance and operations app instance and an existing customer engagement app instance

The setup of a dual-write connection between an existing instance of a finance and operations app and an existing instance of a customer engagement app occurs in the finance and operation apps environment.

  1. Follow Connect finance and operations apps with an existing Microsoft Dataverse instance to establish the link using Lifecycle Services.
  2. A dual-write connection is established for all legal entities. You can remove legal entities from the dual-write workspace within finance and operations apps if you do not wish to synchronize the data for a specific company.
  3. To sync the existing Dataverse data to the finance and operations app, bootstrap the Dataverse data by using a three-letter ISO company code.
  4. Run the Initial sync functionality for the tables that you want to sync data for.

For links to an example and an alternative approach, see the Example section.

Example

For an example, see Enabling the Customers V3—Contacts table map

For an alternative approach that is based on data volumes in each entity that must run an initial synchronization, see Considerations for initial synchronization.