How are Dataverse for Teams and Dataverse different?
Effective November 2020:
- Common Data Service has been renamed to Microsoft Dataverse. Learn more
- Some terminology in Microsoft Dataverse has been updated. For example, entity is now table and field is now column. Learn more
This article will be updated soon to reflect the latest terminology.
Applications within a team in Microsoft Teams have access to a Dataverse for Teams environment. Dataverse for Teams is a common platform that allows all these interfaces to have a unified understanding of how the data is modeled and consumed. Dataverse for Teams delivers a targeted set of the features commonly needed for creating apps, flows, and more within Teams. If your organization requires additional capabilities, such as more granular control for security and governance, or capacity beyond the approximately 1 million rows a Dataverse for Teams environment can contain, Dataverse for Teams can be upgraded to Dataverse.
Following are the differences between a Dataverse for Teams and Dataverse table features.
|Feature||Dataverse for Teams||Dataverse|
|Basic data types||Yes||Yes|
|Advanced data types (customer, multiple transaction currencies)||No||Yes|
|Common Data Model||Coming Soon||Yes|
|Non-relational storage (logs)||No||Yes|
|Managed data lake||No||Yes|
|File and image support||Yes||Yes|
|Find, filter, sort||Yes||Yes|
|Advanced and relevance search||No||Yes|
Note that most of the standard tables that are provided with a Dataverse environment won't be present as part of Dataverse for Teams.
Business intelligence and professional developer features
This table describes the differences between Dataverse for Teams and Dataverse business intelligence and professional developer features.
|Area||Feature||Dataverse for Teams||Dataverse|
|Business intelligence||Data visualization||Yes||Yes|
|Paginated reports (SQL Server Reporting Services)||No||Yes|
|Professional developer||API access||No||Yes|
In Dataverse for Teams and Dataverse, data is stored within an environment. Dataverse for Teams creates a single environment for each team in Teams where you create data, apps, chatbots, and workflows. Environments support backups, point-in-time restore, and disaster recovery. With Dataverse for Teams, capacity is measured with relational, image, and file data. The 2-GB capacity provided to a team can typically store up to 1 million rows of data.
To make management easier, the lifecycle of the Dataverse for Teams environment is connected to that of the associated team. For example, when a team is deleted, the associated environment is also deleted.
Whereas Dataverse for Teams focuses on one environment per team for up to 10,000 teams, Dataverse supports unlimited environments in addition to capabilities that are relevant for multiple environments, such as copy and reset.
|Environment lifecycle||Dataverse for Teams||Dataverse|
|Environments||1 per Team||Unlimited|
|Maximum size||1 million rows or 2 GB||4 TB or more|
|Upgrade to Dataverse||Yes||N/A|
Because collaboration in Teams happens with people inside and outside your organization, the security model needed to support this is easy to use. In Dataverse for Teams, access is preconfigured with a security role based on membership type such as owners, members, or guests.
Because Dataverse isn't specific to the Teams environment, it delivers more options for admin and user roles. It also includes a number of additional security capabilities such as customer-managed keys, field-level security, hierarchical security, sharing, and support for legacy authentication.
Because Dataverse for Teams environments are specific to a team, they only contain one business unit.
|Security feature||Dataverse for Teams||Dataverse|
|Admin roles||System Administrator and System Customizer||System Administrator and System Customizer and additional service admin roles. More information: Use service admin roles to manage your tenant|
|User roles||Team owners, members, and guests||Several standard security roles and custom roles can also be created. More information: Security roles and privileges|
|Customer-managed environment encryption key||No||Yes|
Integration with Dataverse for Teams is delivered primarily through connectors. Support for both standard connectors and the ability to use the Dataverse connector to connect to a Dataverse for Teams for a Teams environment is included. Users with Premium licenses have access to the full set of over 350 standard and premium connectors available. This provides the ability to bring data into or retrieve data from tables in Dataverse for Teams, execute workflows when data in those tables change, and also use data from tables in workflow logic.
Dataverse can also use connectors. Additionally, Dataverse includes other built-in integration capabilities that can export data to a data lake or publish events to an event hub, service bus, or by using webhooks. Dataverse also supports the TDS protocol, which provides integration with SQL Server.
Dataverse can also be used with server-side sync to synchronize with Exchange or POP3, and with Data Export Service, which synchronizes data to Azure SQL Database.
|Integration feature||Dataverse for Teams||Dataverse|
|Export to Azure data lake||No||Yes|
|Data Export Service||No||Yes|
|Events to Azure Event Hubs||No||Yes|
|Events to Azure Service Bus||No||Yes|
|SQL Server Management Studio||No||Yes|