Skip to main content

The Dual Write implementation - Part 2 - understand and action pre-requisites

Prior linking environments (D365 FinOps and CDS) for dual write integration, let's work on what are the pre-requisites for this bi-directional integration from D365 FinOps to CDS or vice versa.

Check all these steps are passed and marked checklist



Follow these steps to link environment (all these steps are detailed at here).

Go to D365 FinOps | Data Management workspace | Dual-write





















Click New link to environment
Choose CDS environment to link with D365 Finops, CDS environment has to be on same tenant and your user must have been added as an admin as have seen in Part 1
Select available list of Legal Entities from D365 FinOps. These can be filtered as shown below for selection.
Health check confirms all pre-requisites are installed/configured
























































































Setup Application users in D365 FinOps and CDS (CE environment) - But why ?


"The reason for that is because the dual write technology is tightly coupled, Synchronous engine and what that means is that the data or the integration have a direct connection between the two system. So for example, FinOps when it needs to send data, it send the data to CDS using direct connection. What you need to do is to create some application users on each application side to allow those incoming connections."


Those being setup and detailed in Part 1 of this blog series


There are two application ids being added to Azure Active Directory application screen.


 
1. One application user is for incoming connections from the data integrator side
2. One is for incoming connection from my CDS instance

Why data integrator side on the incoming connection?

When initial write happens, the initial write is nothing but a hidden data integrator project, an initial sync mode or an initial write mode is we have incoming connection from the data integrator to D365 Finance and Operations.

Once you are in live sync (running state) mode then connection would be incoming from CDS instance.

This is why you need application users for two different type of connections.

P.S. You also need a similar setup in your CDS instance.

Two Dual Write solutions and Two Aspects

Dual write has two aspects

Think about Dual Write is not just he infrastructure framework like you are configuring it and using it and then you are going to get data from left to right.

  1. The infrastructure is providing you near real time experience with live sync of data
  2. The application side of things we really need to have OTB experience so you do need to develop something that just an easy configuration at the end.



Two dual write solutions have to be installed in the CDS environment, as installed and detailed in Part 1 

1. The Dual-write Core Solution is focus on the infrastructure capabilities at the solution awareness for the dual write maps


2. The Dual-write Orchestration Solution includes all OTB entities and mappings that MS has shipped as part of Dual-write

This is available with name Dynamics 365 Finance and Operations Dual Write Entity Maps.


Once applied to the environment it creates all Out of the box entity maps and will look like as follows.

Click Apply Solution and choose Dynamics 365 Finance and Operations Dual Write Entity Maps solution



After the solution is being applied, the first screen will appear will look like this


Stay tune, will continue with next steps in next post. 

Comments

  1. Wow! Such an amazing and helpful post this is. I really really love it. It's so good and so awesome. I am just amazed.
    data management report

    ReplyDelete
  2. Great post Faizal. Got a question.
    When a new customer is created in CE, can we select multiple company so that the same customer is synced to multiple legal entities in FinOps

    ReplyDelete
  3. It was truly acceptable to research articles composed with the site. I'd likewise wish to comprise a couple of plans together with top of my insight which can help per-user to an ever-increasing extent.SMO Company in Kanpur India

    ReplyDelete

Post a Comment

I will appreciate your comments !

Popular posts from this blog

The Dual Write implementation - Part 1 - Understand and Setup

What is Dual-write? Tightly couples – complete at one transaction level Near real time Bi-directional Master data and business documents – Customer records you are creating and modifying and at this document we are talking about sales orders or quotes and invoice. Master data could be reference data e.g. customer groups and tax information Why Dual-write and why not Data Integrator? Data Integrator is Manual or Scheduled One directional Now, Let's deep dive and understand what is required for Dual-write setup and from where to start. First thing first, check you have access to https://make.powerapps.com/ Choose right environment of CDS (CE) Make sure you have access to the environment too, click on gear icon and Admin Center  Look for required environment and Open it, you must have access as going forward you are going to configure dual write steps in the environment user the same user you are logged in now. Now, go back to power platform admin center and

D365FO: Entity cannot be deleted while dependent Entities for a processing group exist. Delete dependent Entities for a processing group and try again.

Scenario: There are times when you want to delete an entity from target entity list and when you do so, you face an error message which does not tell you where exactly the entity has been used.  "Entity cannot be deleted while dependent Entities for the processing group exist. Delete dependent Entities for a processing group and try again. " Solution: Browse the environment by appending this part  /?mi=SysTableBrowser&TableName=DMFDefinitionGroupEntity&cmp=USMF   at the end.  For example; if the environment URL is  https://daxture.sandbox.operations.dynamics.com then the complete URL will be https://daxture.sandbox.operations.dynamics.com/?mi=SysTableBrowser&TableName=DMFDefinitionGroupEntity&cmp=USMF Filter for Entity and it will give you the DefinitionGroup where the entity has been added or used in data management import/export projects. Get the DefinitionGroup name and search in the export/import projects under data management and either delete the whole

Dual-write connection set error: An item with the same key has already been added

If you happen to see this error message then you have duplicate records in cdm_company entity in CDS environment. Check for cdm_companycode field this is normally not allowed but have a look and delete the ones with duplicates.