In this chapter, we introduced the CDS—a premium data storage element that underpins all aspects of the Power Platform. Being completely cloud-based and having the same feel as simple database solutions such as Microsoft Access, the CDS provides an excellent choice for storing data. If you are looking to structure your data in a more controlled way rather than using other data sources such as SharePoint or Excel, then the use of the CDS is the preferred way.
The databases generated by the CDS are directly linked to the environment and therefore has a limit of only one database per environment. Due to the integration within the environment, however, there are no requirements for database names or credentials to connect to the database.
We learned how data within the CDS is held within entities, which is the equivalent of a table within a database. Within those entities, we can define fields with a large range of data types available to us to ensure that we are storing and...