Microsoft Dataverse – An underappreciated gem
Microsoft Dataverse is a low-code, cloud-based data service and platform. With standard tables and columns, as well as the ease to define relationships between data, Dataverse was built for powerful and scalable solutions. Dataverse connects easily to all features of the Power Platform so that we can fully control, automate, and strengthen our business.
Even though Dataverse is referred to as a database (even within the Microsoft space) it is much more than just a database. Azure SQL is Dataverse’s database.
Dataverse comes with a rich set of features that are usually a staple to any type of system/application used especially in enterprises. If we compare Dataverse to a traditional software application design, we will need to develop some type of a UI layer, a database, a data access layer, its security, business logic layer in case of the traditional application. In Dataverse’s case however, all that is taken care of out-of-the-box. Developers just need to focus on the data modelling, business logic and UI layers. Dataverse should be referred to as a platform or as SDaaS (Software Dev as a Service). Below are a few examples of the things that are needed to be built for a traditional software but are available in Dataverse:
- Import and export of data
- Mobile offline capability
- Reporting feature and dashboards for end-users
- Users and Queue management
- Activities/Interactions management
- No code business logic (client & server side)
- Pre and post-event business logic execution (plugins)
- SDKs and APIs
- Auditing and Logging
- Office and Exchange integration
- SharePoint, OneDrive and OneNote integration
- Searching and querying
- Data Duplication Detection
- Currency management
- Multi-language support
- Pre-built UI template with data binding (model-driven apps in
Power Apps) - Governance, administration tools
- Core data model (Common Data Model), out-of-the-box schema.
Behind the scenes, Dataverse powers many Microsoft Dynamics 365 solutions. It is also available as part of Power Apps and Power Automate with native connectivity built right in. The AI Builder and Portals features of the Power Platform also utilize the Dataverse.
Dataverse has a very easy to use and low-code way of implementing and managing security for the user’s environments and apps. Roles assigned to members of an environment or app can easily be changed and managed which makes it very user friendly even for people who are not so friendly with technology. Low-code technology is the demand of the future and we will get to see a lot of enterprise spaces and businesses move to/ opt for Microsoft Dataverse.