Microsoft’s Data Management Framework Versus STAEDEAN's Data Integration Solution for D365

When organizations are looking to integrate their business systems and application landscape with their ERP, in the case of Microsoft Dynamics 365 Finance & Supply Chain Management (D365 F&SCM), it is possible to have synchronous and asynchronous integrations, but it is always not easy. This is because integrations often require additional customizations and not all integrations are available out of the box within D365.

We developed a solution for integration for Microsoft Dynamics ERPs almost 15 years ago – Data Integration Solution for Dynamics 365 F&SCM. So, we understand the limitations of transferring data into and out of the Microsoft ERP between systems and have built a solution that simplifies integrations.

8 out of 10 prospects evaluating our solution usually ask us the differences between Microsoft’s Data Management Framework and STAEDEAN’s Data Integration Solution for Microsoft Dynamics 365. Here’s a comparison between the standard functionality in D365 and our Data Integration Solution.

Please note: Although we do offer our Data Integration Solution for older versions of Microsoft ERPs, in this blog, we will focus on the D365 F&SCM version.

What is the Data Management Framework of Microsoft Dynamics 365 ERP?

Microsoft’s Data Management Framework, also known as DMF in most tech circles and forums, is made up of data entities, data projects, data jobs, job history, and data packages.

The DMF offers the following functionalities:

• Validating and mapping data using data project
• Staging journals via job history
• Data recurrence schedule through data job
• Data package to compress files

To get data in and out of D365 F&SCM, you need to map data entities, which is a set of over 1500 entities. It is a set of data from several tables ranging from customer to product data, and these are understood and used by business users. After the data entities are created, they can be used for Excel Add-ins, data migrations, and integrations.

In previous versions of the DMF, data could be managed in several ways, including Microsoft Excel Add-ins, AIF, and DIXF, so all of these have been combined into data entities in D365.

Using DMF, you can migrate data from legacy or external systems. You can set up and copy configurations between companies/environments and manage synchronous and asynchronous configurations.

What is STAEDEAN’s Data Integration Solution for Microsoft Dynamics 365 F&SCM?

STAEDEAN’s Data Integration Solution for D365 F&SCM is embedded in the ERP. It has been built using the same business logic, offers the same user experience as Dynamics 365, and can also be accessed from the dashboard. So, while Data Integration Solution utilizes the framework of D365, our integration solution offers additional functionality and flexibility in configuring integrations such as additional connectors and transformation settings.

To bring data in and out of D365, it integrates with many different formats and protocols, including flat files, fixed text, EDI, XML files, and many more. The solution allows you to customize tables, pick and choose any field, and map it by configuration to make a lean integration message for import or export.

Data Integration Solution is an integration engine that allows you to configure integrations between D365 F&SCM, your business systems, and applications. The solution also features an integration monitoring app that monitors the configured integrations for you and helps you track lagging and failed integrations. Additionally, you can also leverage the integration platform to prepare and extract data for analytics.

Microsoft’s Data Management Framework Versus Data Integration Solution for D365 F&SCM

In the section below, we will compare a few features that explain the differences between Microsoft's Data Management Framework and STAEDEAN's Data Integration Solution. This will also help our readers understand how our application integration solution for D365 F&SCM can add value and make integrations easier and more flexible.

Support for tables/view and fields: Microsoft has over 1500 data entities. In the case of DMF, only predefined data entities are supported, which makes integrations difficult. Trying to integrate the same field with different naming structures in other applications or from different systems is not possible without coding.

Data Integration Solution supports the use of tables, views, entities, or a combination of all to perform integrations simply by configuration and not development.

Support for configurable data entities: Data entities cannot be configured, so you need to either hire developers or start coding in-house.

Data Integration Solution does provide support for configurable documents and data entities and allows you to configure data mapping for integrations.

Web services: Currently, DMF offers web services by adding new class libraries. You can use X++ code by adding Microsoft Visual Studio projects as a reference. However, the Application Integration Framework (AIF) is not supported for D365 F&SCM.

Using Data Integration Solution, you can configure technical integrations using web services and other various means.

File location: Saving files directly to Azure storage is not supported by standard D365, and additional tools are required. This feature is supported by Data Integration Solution.

Synchronous, asynchronous and integrations with 3^rd party systems: The standard D365 supports Odata via https/JSON/XML for synchronous and asynchronous integrations, and custom services for external applications.

Currently, Data Integration Solution can integrate with Odata and support all these integrations as well by leveraging the existing functionality of D365 F&SCM – all without any development effort.

Service Bus Connection: we can directly integrate with this connector. This would require an additional tool to reach the Service Bus queues using the standard D365 functionality.

ODBC support: ODBC or the Microsoft Open Database Connectivity is a C programming language interface. This allows apps to access data from several database management systems. Just like web services, you can use ODBC with the standard but through some coding.

Using Data Integration Solution, you can connect to external business systems and applications using ODBC via configuration.

SFTP support: You can use a Secure FTP (SFTP) protocol to copy data. Data Integration Solution supports SFTP for integrations to send and receive data. This is supported out of the box which is not available in the standard.

Value transformations: Using Data Integration Solution, you can add data transformations to fields and set up constants, defaults, and conversions. This makes integrations between systems easier and quicker. This is possible using the Data Management Framework but requires development.

Splitting of files: If you need to split files, this is not supported out of the box in DMF. You cannot split files during the extraction, and during load the capabilities are limited. Split processing during staging to target process is not supported for all data entities in DMF.

To split files, you have two options. You can use Logic Apps, but they have their set of limitations as you would need to start developing. An ISV solution such as STAEDEAN's Data Integration Solution offers the splitting of files from source to staging. Our consultants have supported complex integration implementations that have helped clients drastically reduce the time of batch file transfer from hours to under 5 minutes.

Record ID references: Dynamics 365 uses record IDs on many tables as relations. DMF requires one to use natural keys to be able to map relations. In our integration solution, we provide the option to maintain Record ID references with placeholders and during import replace them with new actual values, which makes integrations easier and more flexible.

Integration monitoring: Currently the Data Management Framework has no ready capabilities that allow you to track your integrations, whereas, Data Integration Solution has an integration monitoring app that allows you to track your integrations on the go from mobile phones and tablets. You can monitor slow and lagging integrations and failed integrations and track the URL and take swift actions when an integration shows errors.

Is Data Integration Solution the right fit for your organization?

Data Integration Solution can help you integrate your ERP, business systems, and applications and can also integrate with solutions across our portfolio for Dynamics 365 F&SCM. Additionally, the solution helps you monitor your key integrations and simplify the process of data preparation and extraction so that you could gain reliable data analytics in D365. We also have solutions for master data management and electronic data interchange that our Data Integration Solution easily integrates with.

If you do not have a plan for an integration project, we recommend reading our blog which explains the implementation pitfalls of application integrations in D365 and why some integration projects tend to fail. Each integration scenario requires planning, design, configuration, and testing, before making the integrations active.

However, the only way you would know whether Data Integration Solution is the right fit for your organization is by scheduling a demo and reaching out to our experts for some references. Meanwhile, you can download our solution factsheet from the link given below to learn how you can achieve quicker and easier integrations in D365 F&SCM.