What is Microsoft Dataverse?
Dataverse is the native database storage capability that the power platform hinges on, you can build all of your apps, flows, chatbots everything there. So the Dataverse allows the user to store and manage the data that is used by power platform.
Databases
- Database is an instance of Dataverse storage and contains custom data structure called tables.
- Table is a set of rows that is used to store data.
Figure 1: Define the new table in Dataverse.
- Rows contain a lot of columns to manage information about a single row.
- The user can have multi databases in Dataverse.
Type of columns in Dataverse table
- Single line of text.
- Number.
- Choice.
- Lookup.
- Date and time .
- Currency.
- File.
Type of relationships
- One to many: Each row in the table can match more than one row in table b. But each row in table b can only match one row in table a.
- Many to one: Each row in the table b can match more than one row in table A. But each row in table a can only match one row in table b.
- Many to many: Each row in the table can match more than one row in table b and vice versa.
Compare between Dataverse and SharePoint
- Data volume: for storing large data is better to use Dataverse instead of SharePoint.
- Security: Securing items within Dataverse is better and isn’t as limited as in SharePoint.
- Connectors: In SharePoint, the user can make 600 calls per minute to the connector, while in Dataverse you have 6000 in 5 minutes.
Conclusion
You may securely manage and store data that is used by business applications with Dataverse. A collection of tables is used by Dataverse to store data. Each column in the table is intended to hold a specific kind of information, such as name, age, salary, and so forth.
