How to Add the Data Source Extension in Bold Reports
The BoldReports.Net.Core
package provides an integrated data source processing extension that enables users to easily manage popular data sources like SQL Server, ODBC, and OleDb. This extension is included by default in Bold Reports.
If you want to process other data sources such as Web API, JSON, and Excel data, install the required packages to process certain types of data sources. It is crucial to install the required extension package to unlock the full potential of Bold Reports and ensure seamless integration with various data sources.
DataSource extension packages provide the necessary functionality and tools to process and integrate specific types of data sources into Bold Reports.
Please find the steps to add the extension package to the application to process various data sources.
-
Right-click the project or solution in the Solution Explorer tab, and choose Manage NuGet Packages. Alternatively, select the Tools > NuGet Package Manager > Manage NuGet Packages for the Solution menu command.
-
Search for the required NuGet package, and install it in your application.
The BoldReports.Data.WebData component is capable of handling various types of data sources such as WebAPI, JSON, XML, and OData.
Install the respective NuGet package in the application based on the required data connector. The NuGet package names for each data connector are provided in the following table:
Data source | Package Name |
---|---|
Web data sources(WebAPI, JSON, XML, and OData) | BoldReports.Data.WebData |
Postgre SQL data source | BoldReports.Data.PostgreSQL |
MySQL data sources(MySQL, MariaDB, MemSQL) | BoldReports.Data.MySQL |
Excel data source | BoldReports.Data.Excel |
CSV data source | BoldReports.Data.Csv |
Oracle data source | BoldReports.Data.Oracle |
ElasticSearch data source | BoldReports.Data.ElasticSearch |
Snowflake data source | BoldReports.Data.Snowflake |
SSAS data source | BoldReports.Data.SSAS |
Register web data source extension in application startup
To utilize the extension capability, it is crucial to register the extension assembly in the Program.cs file. By doing so, the application gains access to the additional functionalities provided by the extension methods defined within the assembly. Registering the extension assembly involves adding the necessary configuration or setup code in the Program.cs file, typically within the ConfigureServices.
-
Open the program.cs file.
-
Include the following code:
ReportConfig.DefaultSettings = new ReportSettings().RegisterExtensions(new List<string> {"BoldReports.Data.WebData",
"BoldReports.Data.PostgreSQL",
"BoldReports.Data.Excel",
"BoldReports.Data.Csv",
"BoldReports.Data.Oracle",
"BoldReports.Data.ElasticSearch",
"BoldReports.Data.Snowflake",
"BoldReports.Data.SSAS"});