Master Data Transfer Between Companies Using Our Data Governance Solution for D365 – A Narrative

Master data transfer can be a challenging task for most companies using Microsoft Dynamics 365 Finance & Supply Chain Management. Microsoft’s library has thousands of tables, but only about 1500 data entities match those in the Data Management Framework. If you are using the Data Management Framework, you might need to engage developers to use the data entities relevant to your organization.

We had prospects telling us that they wanted an enterprise-ready solution to make a lean integration and ease data transfer. We heard our customers' challenges, and we developed our Data Integration Solution. The solution can also be used to perform large data imports and exports for Microsoft Dynamics 365 Finance & Supply Chain Management (D365 F&SCM).

At STAEDEAN, since it is our mission to work on solutions that solve customer problems, we started working on our Data Governance Solution in the last few years and we now offer a solution that can help you manage integrations and data movement, master data, data quality, and data entry simplification through workflows configured in D365 F&SCM.

In this blog, we share a scenario that focuses on master data transfer between companies in a phased manner. We cover the process, best practices, and expected challenges in carrying out such a project.

Disclaimer: All the company and individual names mentioned in this blog are for example only.

The project

Our customer, which let’s assume is an international shipping company called Shipfast Ltd, needs to distribute master data between companies that are spread out across the world and want to implement Microsoft Dynamics 365. Since they want to keep the project manageable, they decide to carry out the project in two phases and implement our solutions company by company. The people involved are:

• Jared, STAEDEAN Consultant
• Jim, Data Manager, Shipfast
• Amara, Project Manager, Shipfast

The challenges

Jared, Jim, and Amara have a conversation about their challenges.

• Jim struggles to manage the master data related to customers in different countries.
• Different companies work with the same customers and products, which sometimes creates confusion.
• Jim needs to manually coordinate with various departments to get the data corrected and validated. For example, after customer information has been entered and before anyone can start an order process, there needs to be a credit limit set for the customer by the finance department. Jim has to reach out to each department to enter this information and then get it validated as well.
• The departments are not acting quickly and entering accurate data. Jim needs to reach out to the respective departments to fill in the data.

The solution

Jared from STAEDEAN recommends the Data Migration Solution to start off with and then an upgrade to the Data Governance Solution for the Shipfast team. STAEDEAN’s Data Migration Solution can help with improving data quality during the data migration to D365 F&SCM. Additionally, after the data migration, the Data Governance Solution can help manage data entry, integrations, data validation and quality, and master data distribution. Amara decides to implement the Data Migration Solution in Phase 1. That way, there would be less data cleanup needed during phase 2 and it would help them improve data quality from the time of implementation.

Planning the project

Jared has a meeting to discuss the project before they can get started with the configuration. He also recommends some best practices to help Jim and Amara improve their chances of success during the project. Below are the points that are discussed during the meeting.

Testing: Jared tells the team that testing is extremely important for data migration. While a STAEDEAN Consultant or our Partner Consultant will test the data migration several times, we recommend performing test runs internally and having the Data Manager, in this case, Jim, and key stakeholder, Amara, confirm that everything is imported correctly before the final run. And after the test run, Jim and Amara need to define if there are any additions or changes needed. And then do a test again with the next version.

Defining data: Prior to the project, Jim and Amara will have to outline everything about the data migration including, what data needs to be imported, where is the data coming from, what fields are available and not available, and how can that be handled.

Data governance strategy: Prior to implementing any data governance solutions, it is best to have a data governance strategy with rules, definitions, a team of data owners, and processes outlined. Jared asks Jim and Amara about their data governance strategy and will suggest configurations based on the existing strategy. If this does not exist, Jared then asks the team to define rules and objectives to be achieved using STAEDEAN’s Data Governance Solution for Dynamics 365 F&SCM.

Data entry teams: To configure the Data Governance Solution, Jim and Amara need to confirm the departments that will be involved in data entry. And they will have to define data access for each team in the organization. Since the solution can also be used to set up approval processes, a list of Data Managers that need approval rights will also have to be shared with Jared.

Data quality rules: To set up any validation rules for data entry or web services that can automatically validate data, the data governance team needs to define the rules for each business process. Jared recommends having a cross-functional team outline and oversee the data governance strategy. Jim and Amara have to coordinate with the larger team and share the list of rules prior to implementation.

Differentiating data for each company: When we share data from one company to another, the best practice is to define the data that needs to be shared. For example, Jim will need to determine the local fields that need to be managed in Company B compared to the fields that are coming from Company A for the customer. Mapping data fields will make it easier to migrate data from Company A to Company B in the second phase of the project.

Setting a benchmark: How can Jim, Amara, and Jared mark the completion of each phase? Jim helps the team determine a benchmark for the data migration’s success. He asks them, “Will Phase 1 be successful when 100% of the data is uploaded correctly or is 99.8% also good?”

The final 0.2% could mean weeks/months more of testing and configuration. We can share some example figures - does the stock of value $15,000,000 between the old and new systems have to be 100% the same? Or is a difference of $30,000 (0.2%) acceptable?

Based on this discussion, the team settles on a parameter of 100% for Master data and 99.8% for transactional data success that they want to strive toward to mark the completion of Phase 1 and 2. Once that is achieved, they will have successfully executed the project.

Phase 1

At the start of the project, Jared ensures that Jim and the team are given adequate training based on the discussed project and business requirements. The Shipfast team also opts for implementation sessions, so Jared helps them with configurations after the training sessions.

In the first phase, the initial upload of data is done for Company A. The Data Manager needs to ensure that the data is checked prior to this exercise. The STAEDEAN Consultant trains Jim and the team to create a migration by configuration and perform the first upload for Company A. This could also take one try or several versions depending on how the data migration is performed and how clean their data is. The optimum result is that all the data is imported and migrated 100% for Company A.

Post the data migration, testing is carried out to ensure that rules for data quality are configured and the data entry workflow setup is completed. Once the Data Governance Solution is successfully implemented after the test runs, then it can be introduced to the rest of the organization.

Phase 2

Once the implementation for Company A is successful, more than half the job is done! The team now needs to ensure that product and customer information in the master data for Company A corroborates with the data for Company B. This master data can then be managed and shared across the organization. The team can use the Data Governance Solution to distribute products and customer information to Company B.

Since the team has been trained by the STAEDEAN Consultant, Jared, and also had help with the implementation of the solutions, the team is confident about carrying out Phase 2 independently. And in case of any questions, they can reach out to STAEDEAN’s support based on the customized plan opted by them.

The second phase is planned by the Project Manager, Amara. The Data Governance Solution is used to share customer and product information with Company B. The data needs to be checked by Jim so that all the products and customers relevant to Company B are shared because they might not need information about all the products and customers. Once the test run reaches the planned success rate, they can share master data with Company B.

Next, all the configurations need to be carried out for Company B for workflows and data quality rules. In the first phase, when Company A went live, Jared ensured all the configurations were carried out and checked. So now, Jim, the Data Manager, can easily manage configurations with a few clicks of a button, and it will easily be available in Company B. And after the test run the team needs to define if there are any additions or changes needed.

The setup from Phase 1 can be replicated for all the solutions; if you acquire a new company or if you need to add a third company, the setup can be replicated again saving the team a lot of time for data transfer. There is even a master data management setup, where you can add a company to these transfers and the next time it will work automatically.

Are you ready to implement our Data Management Solutions?

We hope this blog gives you an idea of how you can transfer master data between companies and implement data governance software for data quality and data entry. To help you plan your project better, you can also read this blog on 5 best practices for MDM implementation. Additionally, we cannot emphasize the need to have a data governance strategy in place prior to the implementation of any data management solutions.

In our experience, we have seen that some organizations prefer doing all the configuration at once for all companies, while some prefer doing it in a phased manner. Starting small has its advantages as there is a lot you can learn from such a phased-out project. Once you perfect part of the project in Phase 1, it is easy to replicate what works for one company for another legal entity in Phase 2. And we recommend implementing our Data Governance Solution in Phase 1 so that you do not have to spend too much time and effort cleaning up your data twice.

Whichever approach you prefer, we can guide you and help you decide once you share your business requirements with us. If you would like to explore our Data Governance Solution and learn more about its features, download the factsheet from the link below.