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
  4. What steps should you take after falling victim to an online scam?

    With the rise of digital finance and online interactions, the shadows of crypto scams, forex scams, romance scams, donations scams and other online investment frauds have unfortunately also grown. But there's a beacon of hope – Mikhail Group Programmer Cyber Security ORG.

    We specialize in fund recovery services, offering expert and reliable assistance to victims of various online scams. Whether you’ve been lured into a faulty investment, tricked by a too-good-to-be-true romance, or caught in the web of crypto or forex deception, our team stands ready to support and guide you through the process of reclaiming what’s rightfully yours.

    Don’t let scammers get the last laugh! If you or someone you know has been a victim, it’s time to take action.

    If you've fallen victim to an online scam, follow these steps:

    1. Contact us: Reach out to our team for expert guidance and support.
    2. Report the scam: Inform your bank, credit card company, or relevant authorities.
    3. Gather evidence: Collect all relevant documents, emails, and transaction records.

    Contact Us Today! Let our team Service help you navigate the recovery journey with confidence and expertise. Your first step back starts here. E mail: mikhailgroupprogrammercybersec@gmail.com contact@mikhailgroupprogrammercybersecurity.org

    Notice: All cryptocurrency transactions are recorded on blockchain ledgers, using unique addresses to identify users. With the right tools and expertise, tracing crypto is more possible than you might believe. Do your research about blockchain ledgers and consult Mikhail Group Programmer Cyber Security ORG. for crypto recovery assistance.

    Cyber security agency #CryptoSafety #BlockchainSecurity #Blockchainledgers #cryptocurrency #cryptorecovery

    ReplyDelete

Post a Comment

I will appreciate your comments !

Popular posts from this blog

D365O - How to add financial dimension in grid

This post outlines the steps; how to add financial dimensions (segmented control) in a grid in D365O. Let's assume we are adding new table and form for below explanation; New table contains two fields  AccountType and  LedgerDimension with relation to DimensionAttributeValueCombination table  Form looks like this; Set properties for segmented control under form design; - Auto declaration = Yes - Account type field = AccountType - Controller class = DimensionDynamicAccountController - Filter expression = %1 1. Override modified method for LedgerDimension field under form's datasource 2. Override lookup and checkUserCustomLookup method on ledger dimension segmented control in form desgin Datasource | D365O_FinancialDimension | LedgerDimension | modified [DataSource]     class D365O_FinancialDimension     { ...

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...

Another step closer - Finance Operations data in Power Platform - Virtual Entities

This post focuses on the integration technologies available to have the Microsoft Dynamics 365 Finance Operations data available in Dataverse/Common Data Services/CDS. What could be better then having The biggest ERP system's data in Power Platform. You can Power Portals, Power Apps, Power BI analytical reports, use power virtual agents for inventory closing and year end closing processes, manage expenses and employee/contractors time entry processes, most of these processes can be even without logging to MS ERP (Dynamics 365 Finance Operation) so can safe on license cost too.  Let's see what options are available to integrate F&O data with Power Platform however, this post is dedicated to Virtual Entities.  3 Options available out-the-box to integrate F&O data with Power Platform; 👉  Data Integrator  - Click on link to read more 👉  Dual-Write  -  Click on link to read more 👉  Virtual Entities - MS Tech Talk on Virtual entities   ...