Build your next application on Dataverse – now with hyperscale support for any enterprise data
Dataverse, Microsoft’s modern and scalable business application platform in the cloud, enables developers to build enterprise-grade applications at hyperscale. Today, Dataverse encompasses over 3.5 million Azure SQL databases and leverages Azure SQL Hyperscale to support up to 100 TB per individual database–with rapid scale up, rapid scale out, and high availability.
At Ignite, we announced Dataverse Link to Fabric, which enables low-code developers to activate enterprise data at any scale. We are happy to announce general availability for bulk operation APIs, improving data integration throughput and supporting even larger data estates. Dataverse supports seamless customization and extension of Dynamics 365 applications and Power Platform solutions directly by enterprise customers. Similarly, Dataverse supports integrated extensions and independent application solutions from ISVs, of which there are thousands published on Microsoft AppSource. Additionally, Microsoft Industry Cloud solutions are building atop Dataverse and Power Platform. To further empower developers, and customize Dynamics 365 and building Power Platform solutions, we are happy to announce general availability for:
- Elastic Tables, built for flexible schema and hyperscale data, while ensuring responsible AI usage, enterprise-grade security, and ease of governance.
- Dependent assemblies simplify development of plug-ins for implementing .NET business logic.
Enabling Hyperscale data with flexible schema using elastic tables
Dataverse Elastic tables, powered by Azure Cosmos DB under the hood, is a powerful new option to be considered for application scenarios that entail very high scale throughput and frequent changes to the data model. Developers get all the benefits of underlying Cosmos DB, low-code application layer and granular security, without the need to maintain the infrastructure and the plumbing of application/business tier. With its ability to massively scale horizontally using data partitioning, Elastic tables allows very high write throughput and low latency querying. Developers can take advantage of Dataverse bulk operation APIs (CreateMultiple, UpdateMultiple, UpsertMultiple and DeleteMultiple) to bulk load data at high throughput and efficiently within the Dataverse API limits. Elastic tables are already being used extensively by Microsoft Dynamics 365 applications including storing more than 3Bn records in a single table, while enabling 120 million writes per hour and 6000 reads per second. For scenarios where the data shape changes, Elastic tables allow you to store and query data stored as JSON. You can query JSON columns using ExecuteCosmosSqlQuery. Additionally, when a business scenario, such as a timebound marketing campaign, requires the data to be stored only for short time periods, you can choose to automatically remove the data with time-to-live policies. In today’s world driven by data and AI, where security and governance are non-negotiables, your data in elastic tables is protected by Dataverse security backed by Microsoft Entra ID and additional safeguards like customer managed key management and lockbox. This robust security framework for your business-critical information provides flexibility for developers to support diverse scenarios on top of already stored data, across your ecosystem. Developers can accelerate development time by leveraging low code Power Platform. For example, you can apply business logic using a plugin with a Power Automate Flow. This streamlined integration allows for the rapid creation of applications, while empowering your team to efficiently build and deploy solutions that meet your unique business needs.
“Using the Dataverse elastic table feature enabled us to keep unstructured data alongside and related to our standard Dataverse tables. This greatly reduced the dev efforts to separately integrate with any external storage and enabled faster time to market with a Power App for our application.”
David Yack, CTO and Co-founder 365.Training
Read more about using Dataverse Elastic tables.
Activate large scale enterprise data faster using Dataverse integration with Microsoft Fabric
Dataverse’s two-way integration with Microsoft Fabric, enables low and pro code developers to generate insights from their business-critical data, without having to physically move this data. Ferranti, who builds solutions for energy and utility companies, have reimagined their utility billing and customer engagement solution, MECOMS, with Power platform and Fabric for the future. Utilities generate a lot of data (for e.g. each meter from home or business is read every 15mins), the meter data and aggregated billing data accumulates very quickly. MECOMS was primarily used to process back-end customer bills and preserve details for many years for audit purposes. With the power of Fabric and Power Platform integration, they have expanded their product footprint to end customers served by utilities with proactive suggestions based on insights generated from the data.
With no-copy Dataverse to Fabric integration, Dynamics data stored in Dataverse such as customers, payments, and pricing tables, becomes available to join, merge and consolidate with meter data read from smart meters. Data is joined, processed, and stored in Microsoft OneLake using Spark and other big data tools built into Microsoft Fabric. Normalized meter data in OneLake is available for billing and managing customer interactions in Dynamics 365 without the need to copy. Developers can focus on building business logic and application without the need to orchestrate data and build pipelines saving them a lot of time and effort. MECOMS developers have built a customer-facing portal that uses detailed sensor data and billing details. Using Copilots built in Power Pages and AI plugins, consumers can ask questions and get suggestions on data generated, such as how to reduce their power consumption with ease.
“We worked closely with Microsoft at the time when Dataverse and Fabric integration was being developed. We were able to leverage the latest innovations in no-copy, no-ETL integration as well as Fabric capabilities without building features or laying out infrastructure on our own – this enabled us to focus on building and reimagining the solution that we specialize on…”
Ian Bruyninckx, Lead Product Architect, MECOMS, A Ferranti Company
Read more about Dataverse to Fabric integration.
New performant APIs for high throughput write operations
We are excited to announce the general availability of new bulk operation messages designed for very high throughput write scenarios with three new APIs CreateMultiple and UpdateMultiple. UpsertMultiple. These new APIs offer a more focused approach to executing write operations as compared to ExecuteMultiple and ExecuteTransaction APIs, enabling batching by operation and entity for significant performance improvements. No additional cost is incurred to use these APIs and you can accomplish more write operations within the same service protection limits. Early preview customers have witnessed and reported upto 82% less time spent in end-to-end scenarios using CreateMultiple and UpdateMultiple on SQL tables. Data migration speed of over 25,000 records per second with UpsertMultiple on Elastic Tables were also observed by these customers. Customer have experienced throughput improvement of up to 5x using the new bulk operation messages, growing from 2 million records created per hour using ExecuteMultiple to 10 million records in less than an hour using CreateMultiple.
In the snapshot above, view 2 Postman runs against the same SQL table in the same environment with no special configurations. CreateMultiple API completes creation of 1000 records >23 times faster than Create API. Bulk operations performance on Dataverse can be tuned for a much higher throughput.
“We, the KingswaySoft team, were very excited to hear about the Bulk API features introduced by the Microsoft Dataverse team, we saw a huge benefit of embracing the new technology. As we gained more knowledge about the new API by adding its capabilities to our Dynamics integration toolkit, we were even more impressed by the benefits that the new API brings, particularly the vast performance improvement. Overall, we think the API is well-designed and provides the benefits that every Dynamics developer should cherish and embrace, particularly when it comes to the situation where you need to work with large quantity data movement.”
Daniel Cai, Managing Director of KingswaySoft
The new bulk operation APIs are generally available starting today — click here to get started!
Dataverse plug-in development & management becomes easier
Dependent assemblies for Dataverse plug-ins simplify plug-in development by removing the overhead of using IL Merge to manually merge dependent assemblies. With dependent assemblies, rather than registering an individual .NET assembly, you can now upload a NuGet Package that contains your plug-in assembly and any dependent assemblies. • Bring assembly dependencies of plug-in assemblies during the registration process. • Multiple plugin assemblies can be packaged into a single NuGet package. • Register the package through Power Platform Tools for Visual Studio or PAC CLI and Plug-in Registration tool (PRT) • New versions of packages can be updated in-place or registered side by side. • Assembly Full Name signing of plugin assemblies are no longer required when the assembly is part of plug-in package.