What you can do with report data sources
Built-in data sources
The Blazor Report Designer supports a set of built-in data providers to create a report data source. They are:
- Microsoft SQL Server and Azure SQL Database
- SQL CE
- OLE DB, ODBC, and XML
Custom data processing extensions
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.
Embedded data sources
The Blazor 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.
Shared data sources
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.
Embedded data sets
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.
Shared data set
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.