Impulz Technologies LLC

Menu
  • Home
  • Products
    • IMPULZ Positive Pay
    • IMPULZ Product unlock
  • Solutions
    • Microsoft Dynamics 365 Finance & Supply Chain Management
    • Microsoft Azure
    • Microsoft Power Platform
      • Power BI
      • Power Apps
  • Services
    • Application Support And Maintenance
    • Azure Cloud Services
    • ISV Development
    • Project Resources
  • About Us
  • Blog
  • 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

  • Optimizing Azure Workloads: Automate VM Startup and Shutdown
  • Landed Cost – Auto Cost Setup in Microsoft D365 Finance and Supply Chain
  • Big Data Capabilities of Azure Synapse, Databricks, and Data Factory
  • Fix Database Synchronization Errors in Microsoft Dynamics AX 2012
  • Dynamics 365 Finance and Supply Chain: Implement budget check via custom logic

Recent Comments

No comments to show.

Archives

  • April 2024
  • December 2023
  • November 2023
  • October 2023
  • July 2023
  • April 2023
  • February 2023
  • January 2023
  • October 2022
  • September 2022
  • August 2022
  • July 2022

Categories

  • Business
  • Dynamics 365
  • Dynamics 365 Finance and Supply Chain
  • Dynamics AX 2012
  • Introductions
  • Microsoft Azure
  • Microsoft Dataverse
  • Microsoft Power Platform
  • New Technologies
  • Power BI
  • Uncategorized

Latest Post

  • Optimizing Azure Workloads: Automate VM Startup and Shutdown
  • Landed Cost – Auto Cost Setup in Microsoft D365 Finance and Supply Chain
  • Big Data Capabilities of Azure Synapse, Databricks, and Data Factory
  • Fix Database Synchronization Errors in Microsoft Dynamics AX 2012
  • Dynamics 365 Finance and Supply Chain: Implement budget check via custom logic

Tags

Auto Cost Automation Ax2012 Azure Azure AD Azure Databricks Azure Data Factory Azure Synapse Cost Accounting D365 D365 code management D365 FO Azure DevOps Dataverse Development DevOps Duty Dynamics 365 Finanace and Operations development VM Dynamics 365 Finance and Operations Dynamics 365 Finance and Supply Chain Dynamics 365 FO Security Dynamics 365 with git Dynamics Lifecycle Services Export Freight Full Sync errors Import Item Cost Allocation Landed Cost Lifecycle Services Microsoft Azure Microsoft Dataverse Microsoft dynamics Microsoft Dynamics 365 Microsoft Dynamics 365 Commerce Microsoft Dynamics 365 Finance and Operations Microsoft Dynamics 365 version control Model Driven Apps Power Apps Power Platform Shipment SQL Error Transportation Voyages Web APIs XDS Framework
© Impulz Technologies - All right reserved.