Articles in this section
Category / Section

How to Add the Data Source Extension in Bold Reports

Published:
Updated:

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.

  1. 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.

  2. Search for the required NuGet package, and install it in your application.

    image.png

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.

  1. Open the program.cs file.

  2. Include the following code:

    image.png

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"});
Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
Comments (0)
Please  to leave a comment
Access denied
Access denied