Choosing the Right Data Source for Your Applications

Selecting the right data source is one of the most important decisions when designing your application infrastructure. Many factors come into play, such as features, security, speed, pricing, and integrations.

Thankfully, your solution’s needs will help you select the right one. For example, it’s better to use a database with a certified connector rather than building it yourself; if your application needs to store a specific data type, it’s best to choose a database that can handle it natively. Another example is when working with canvas apps: setting up different data sources on the same application opens many possibilities when interacting with data.

Before diving into this chapter, we will go into more detail about Power Platform’s licensing model, a crucial topic for Power Platform makers. Having covered this concept, we will be able to discuss data in the Power Platform with the help of...