One of the great features announced in Dynamics 365 BC 2020 Wave 1 was the integration between D365BC and CDS.
First things first!
What is CDS? It is Common Data Service. It is a Cloud Service provided by Microsoft and is accessible through other Power Platform services and Microsoft Dynamics (initially D365 F&O and now in D365 BC). It is a a data storage service. Like a database. You can use CDS to store data in the form of tables, which is called as Entities. The data can be loaded into CDS entities through multiple ways, and it can be also extracted from there through different methods.
MSFT Link for CDS: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-intro
Second: how to setup the integration between D365BC and CDS
Step 1: Create a Common Data Service database
Follow topic Create a database in the admin center described in https://docs.microsoft.com/en-us/power-platform/admin/create-database#create-a-database-in-the-admin-center
Important: In last step, Currency should have the same Currency Code as Local Currency Code in General Ledger Setup inside Dynamics 365 BC.
Step 2: Setup Dynamics 365 BC to connect to CDS
This feature is only available in D365BC Wave 2020
Dynamics 365 Business Central
Assisted Setup (Search Bar)
Set up the Common Data Service connection
Next button
Select URL using Lookup button.
Sign in with Administrator Credentials
Next button
The selected user should have Business Central CDS Integration and Common Data Service User roles in Power Apps Admin.
This user should not be System Administrator.
Next button
And Finish button!!
And the integration setup between Dynamics 365 BC and CDS is done!
Step 3: Test integration between Dynamics 365 BC and CDS
Access to Common Data Service Sync and click Reset. This click will update this page will all entities to be synced.
After Sync All button.
Create a new Vendor
Navigate menu, Common Data Service, Synchronize
Navigate menu, Common Data Service, Synchronization Log.
Conclusions and Take Aways
It's brilliant to see a new feature to allow to link Dynamics 365 BC and the rest of Power Platform products. I am sure that all D365BC Community joins me to agree that this functionality is a must have!
The integration setup is straight forward if you follow this step by step. The most challenging part is related with Users, Roles and Security and a lack of documentation about this process.
All the tests made shows a very stable functionality.
The actual functionality is limited to sync only four tables (Contacts, Currencies, Customers and Vendors) between D365BC and CDS. And let's be honest: this is not enough!!! But it's the reality and I believe the starting point.
Let's wait for the official release (as today it is under Preview) and more important let's keep our fingers crossed and hope that Microsoft will continue to invest to improve this functionality.
If you agree with me, you have a word to say. Login http://aka.ms/bcideas and create your new idea. From my end, I already created the idea to allow to sync more that the 4 default tables. Please vote here https://experience.dynamics.com/ideas/idea/?ideaid=40e8372d-3273-ea11-99e5-0003ff689747.
Comments