Impulz Technologies LLC

Menu
  • Home
  • About Us
  • Solutions
    • Microsoft Dynamics 365 Finance & Supply Chain Management
    • Microsoft Power Platform
      • Power BI
      • Power Apps
  • Products
    • Impulz Positive Pay
    • Impulz Construction 365
  • Blog
  • Services
    • Application Support And Maintenance
    • ISV Development
    • Project Resources
  • Clients
  • Contact Us

Impulz Technologies LLC

Microsoft Dataverse is not a database

  • Home
  • Blog
  • Microsoft Dataverse
  • Microsoft Dataverse is not a database
  • February 14, 2023
  • Ahmad Hussain

Dataverse vs MySQL

In my previous blog posts, I have discussed how to connect the custom Angular application to the Microsoft Dataverse through a web API. Today, I am going to compare Microsoft Dataverse to a traditional database management system like MySQL and discuss the main motivations behind using one technology over the other.

Dataverse MySQL
Structure Relational, non-relational Relational only
Authentication Secured through Azure Active Directory OAuth and OpenID authentication.. Application security such as OAuth needs to be developed at the application layer.
API OData APIs are supported out-of-the-box. APIs need to be developed using backend tools like Node, ASP.Net etc.
Flexible Somewhat. Highly flexible.
Data Access Built-in support for Power Apps.

Through REST APIs for the custom applications.

Directly through a SQL code or through Object Relational Mappers (ORMs) like Entity Framework, Sequelize, TypeORM etc.
Non-structured support Microsoft claims to use multiple type of storage to meet the specific customer needs. Not supported.
User Management Supported with user authentication through Azure AD. Custom solution need to be developed for the user management.
Data Auditing Supported. Need to be developed.
Application Lifecyle Management Tools (ALM) Supported. Extra steps required such as migrations while using an ORM.
Pre-built UI templates Metadata driven application design through model-driven Power Apps. Not supported.
Industry accelerators Microsoft provides pre-built industry verticals for different industries such as education, not for profit, automotive etc. Through open-source community.
Infrastructure Microsoft responsibility. Customer’s responsibility.
AI-pairing such as GitHub Co-Pilot Not supported because the data model is designed is mostly through a UI. Rich support for modern-style pro-developers tooling.
Version control support Supported only at the solution level. Supported if the ORM is been used in a development workflow.
Typical skillset requirements Understanding of the relational data modelling, familiarity with the cloud concepts. Pro-developer with a specialized skillset required in relational database design and one of the modern programming language such as JavaScript, C#, Python etc.
When to use The exact answer to this question is really depends on the specific problem you are dealing with. Following been used only as a guidance:

 

–          Organization is already using Microsoft 365 or Microsoft Dynamics.

–          You want to integrate your app with other Microsoft infrastructure such as Logic Apps, Azure Data Lake etc.

–          Team is skilled on Microsoft .Net and related tooling.

Use it

–          When you want to control the entire application design.

–          Requires flexibility.

–          Not bound to Microsoft Azure.

 

 

About Impulz Technologies LLC

Impulz Technologies, is a Silver Certified Microsoft Partner company. We specialize in the implementation, consulting and development of Microsoft Dynamics and Microsoft Power Platform. Impulz Technologies also provide staff augmentation services all across the US. For more information please contact us at 630-540-6302 or email us at info@impulztech.com

Posted in Microsoft Dataverse, Microsoft Power PlatformTagged D365, Dataverse, Microsoft Azure, Power Platform

Recent Posts

  • Postman Best Practices for Microsoft Dynamics 365 Finance and Supply Chain Management
  • Microsoft Dataverse is not a database
  • Connect the Angular with Microsoft Dataverse – Part 3 of 3
  • Connect the Angular with a Microsoft Dataverse using Web API – Part 2 of 3
  • Connect the Angular App with a Microsoft Dataverse through Web API – Part I of 3

Recent Comments

No comments to show.

Archives

  • February 2023
  • January 2023
  • October 2022
  • September 2022
  • August 2022
  • July 2022

Categories

  • Business
  • Dynamics 365
  • Microsoft Azure
  • Microsoft Dataverse
  • Microsoft Power Platform
  • Power BI
  • Uncategorized

Latest Post

  • Postman Best Practices for Microsoft Dynamics 365 Finance and Supply Chain Management
  • Connect the Angular with Microsoft Dataverse – Part 3 of 3
  • Connect the Angular with a Microsoft Dataverse using Web API – Part 2 of 3
  • Connect the Angular App with a Microsoft Dataverse through Web API – Part I of 3
  • Deploying aggregate measurement for custom tables in Dynamics 365 F&O for Power BI Reports

Tags

Application integration with D365 Azure Azure AD Banking D365 D365 code management D365 FO D365 FO Azure DevOps D365 FO Customization D365 FO Extensions D365 FO VM Deployment D365 integration D365 MPOS Retail D365FO Excel Export to SharePoint Dataverse Dataverse integration Debugging Development Dynamics 365 Finance and Operations Dynamics 365 FO Security Dynamics 365 with git Lifecycle Services Microsoft .Net Microsoft Azure Microsoft Dataverse Microsoft Dynamics 365 Microsoft Dynamics 365 Commerce Microsoft Dynamics 365 Finance and Operations Microsoft Dynamics 365 Retail MPOS Microsoft Dynamics 365 Retail MPOS customization Microsoft Dynamics 365 version control Model Driven Apps OAuth 2.0 Positive pay Postman Power Apps Power BI Power Platform Reporting Safe pay SharePoint Virtual Machine Web APIs X++ XDS Framework
© Impulz Technologies - All right reserved.