Report Data Source
Built-in data source
- Microsoft SQL Server
- SQL CE
- OLE DB
Custom data processing extensions
Provides support to add any additional data providers to connect to your own database or extend functionalities of the existing data providers. The .NET framework compatible custom data processing extensions need to be created using data extension interface. With minimal configurations, you can use any additional data source such as OData, SASS, WebApi, MySQL, SQLite, PostgreSQL, MongoDB, etc.
Embedded data source
Shared data source
You can add a shared data source to report that is stored on a Report Server and shared by multiple reports. The shared data source provides better security by hiding the connection details.
Report data set
This has a query and collection of ﬁelds to represent the data returned from the data source.
Embedded data set
You can create a data set using an embedded or shared data source. It stores query 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.