The ASP.NET MVC Report Designer supports a set of built-in data providers to create a report data source. They are:
Add any additional data providers to connect to your own database or extend functionalities of the existing data providers. .NET Framework-compatible custom data processing extensions can be created using a data extension interface. With minimal configuration, you can use any additional data source such as OData, SASS, Web API, MySQL, SQLite, PostgreSQL, MongoDB, and more in the Report Designer.
The ASP.NET MVC Report Designer allows you to create an embedded data source with your own data connection. The embedded data source is speciﬁc to a report and you can use the connection string as expressions.
You can add a shared data source to any report stored on the Report Server, and it can be shared by multiple reports. Shared data sources provide better security by hiding connection details.
You can create a data set using an embedded or shared data source. The data set stores queries used to process the report data. The embedded data set is speciﬁc to a report and you can add query parameters, ﬁlters, table relationships, and have the query string as expression.
Like shared data source, you can add a dataset that is published on a Report Server. It provides an easy way to change query at one place and reﬂect it in referred reports.