Master Data Management System is a module that allows users to set up any set of data within the Microsoft Dynamics 365 Business Central (Dynamics NAV) database and replicate it to another Business Central database to ensure data consistency.
Users are allowed to set up any number of Receivers, which are target companies, to which data is replicated. The structure of data replicated can be set up as data sets.
Users can use any number of created data sets and set them up to be replicated to a particular receiver, by using the replication card. Replication can be either Full or Incremental. While processing Incremental replication, only data changed during the last replication will be exported.
The module is particularly useful when a company wants to create and maintain certain Dynamics 365 Business Central cards (e.g. items, BOMs, vendors) in one company – called “master” company – and afterwards synchronize the data within all the subsidiaries (“receiver” companies).
The module uses files stored in shared folders as a data transport layer.
In Master Data Management System, data exchange is always performed from the Master Company to Receiver Companies. A Master Company is a company where all data considered global is stored. Receiver Companies are the companies to which data is sent.
Depending on the type of Dynamics 365 Business Central (Dynamics NAV) installation in the organization, data exchange is managed within one database, or within multiple databases, or within databases located at multiple SQL servers or in the scenarios using corporate ERP systems such as SAP, Oracle, etc.
In manual replication, the user can run replication manually, from the Replication Card or the Replication List pages. It is also possible to set up replication to be run automatically by using the Dynamics 365 Business Central (Dynamics NAV) Job Queue module.
Full replication loops through all the records from the Data Set, including filters set up on a selected replication line (if any). If no filters have been set up, all records will be exported each time replication is run.
Incremental replication includes only data that has been recently modified (since the dates set in Last Run Date and Time on the replication card).
It is also possible to use the internal CHANGECOMPANY function in Dynamics 365 Business Central to replicate data – available only for the companies within the same database.
To manually process any new incoming messages, the user should run the Read function in the Replication Inbound Entries window. It is also possible to set up a job queue to handle incoming transmissions.
By default, replication processes all the records from a selected table. However, in the course of incremental replication only recently modified records are exported. It may be necessary to specify a certain subset of records that should be replicated to specified
receivers. By using the Record-level Replication function, each receiver can manually mark which records they want to receive.
It is possible to delete records in the Master Company. Records that have never been replicated yet can be deleted when the “Allow Deleting Before Replicated” field is enabled in the Master Data Management System Setup window. For records that have been replicated, the system will automatically issue a webservice call to all receiving companies that have ever received this particular record, and will attempt to delete the record. If the process is completed successfully, the records will be deleted from the Master Company.
The history od records sent from all replications is stored.
When using the Group Receivers feature, it is possible to process one replication for multiple receivers simultaneously.
In order to incorporate advanced business logic efficiently, Master Data Management System now publishes the following events:
OnAfterImportedRecordModify – allows you to perform actions on imported records. Sample usage (Updating Currency Code on the customer card, this time on the side of the receiving company).
Master Data Management System is a module certified by Microsoft for Dynamics 365 Business Central (Dynamics NAV). Therefore, its installation does not require the purchase of additional development objects. Starting from the NAV 2017 version, Master Data Management System modifies only one standard object, and starting from the Dynamics 365 Business Central version, the module was redesigned to be provided as an Extension.
Master Data Management System objects are available for the following Microsoft Dynamics NAV and Dynamics 365 Business Central.
Please note that IT.integro provides support only for the solution versions based on the Dynamics 365 Business Central and Dynamics NAV versions that are supported by Microsoft at the time
MDMS price is based on the number of Full users in the main BC/NAV license
If there are more than 100 users in the license we can provide the “unlimited” option at the cost of either 12 000 EUR (Perpetual) or 500 EUR/month (Subscription).
Thanks to MDMS, we managed to standardize data between the databases maintained in two different data centers (in Europe and North America), ensuring the high quality of the data at the same time. This way, the exchange of inter-company documents became much more effective. With standardized and harmonized data, we are also able to streamline report creation in our BI tools.
We decided to implement Microsoft Dynamics NAV integrated with LS Retail because the existing ERP system limited the growth of our business - it worked only locally and lacked scaling capabilities. We were looking for a global solution – the one that was unified and could be used by all company locations. The solution that would provide secure and instant access to a coherent database and reliable analytical tools. To achieve the desired effect, MDMS - a module supporting the management of central data was implemented. The new tool allows more effective monitoring of business activities carried out in individual subsidiaries and seamless data synchronization.
MDMS was implemented in June 2017. The solution, powered by IT.integro, was developed to facilitate central control of all master data related to financial transactions, customers, vendors, items and system settings. The system has helped Kleen-Tex to effectively administer our master data and keep it consistent between the databases. Due to the high volume of intercompany transactions we have, this has helped a lot in streamlining the documents between systems. We are currently testing the new version of MDMS that will give us additional functionality, such as direct SQL to SQL replication. We are happy to comment on those features after we have time to test them and use them in a productive settings.
I must say the design that went into this addon is extremely clean and one of the best I’ve seen! It is also very simple and transparent. IT.integro’s team has done wonderful work here!