# WebDesigner Custom Data Providers

This topic demonstrates configuring the custom data providers in ActiveReports.

## Content

The WebDesigner Custom Data Providers sample demonstrate the method to use custom data providers (such as SQLite and OData) for supplying data to the report in the ActiveReports WebDesigner.
![Data Provider in Web Designer](https://cdn.mescius.io/document-site-files/images/b298aea2-8cb8-4a0f-be88-4f54aa263ebd/images/dataprovider.png)

### Sample Location

**C#**
[https://github.com/activereports/WebSamples20/tree/main/WebDesigner_CustomDataProviders](https://github.com/activereports/WebSamples19/tree/main/WebDesigner_CustomDataProviders "https://github.com/activereports/WebSamples19/tree/main/webdesigner_customdataproviders")

### Details

This sample describes the following methods.

* Using SQLite Provider
* Using C1 ODATA Provider
* Using ODATA Datasets

#### Using SQLite Provider

In order to use SQLite provider to add a data source, go to **Data** tab and click **Add** next to **Data Sources**. In the Data Source dialog, select the 'SQLite Provider' option in the **Provider**, set the path of the desired sqlite file in the **Connection String**, and click **Add** button. This will add a data source using the SQLite provider to the report.

#### Using C1 ODATA Provider

In order to use C1 ODATA Provider to add a data source, go to **Data** tab and click **Add** next to **Data Sources**. In the Data Source dialog, select the 'C1 ODATA Provider' option in the **Provider**, set the URL of the desired data from where the data will be fetched in the **Connection String**, and click **Add** button. This will add a data source using the C1 ODATA Provider to the report.

#### Using ODATA Datasets

In order to add ODATA Datasets, go to **Data** tab and click Add next to Data Sets. Select NWWIND dataset, an ODATA whose definition is available in the **datasets** folder.

>type=note
> **Note**:
>
> * In case you face any problem related to C1 ODATA Provider, kindly register and install the trial version of the ComponentOne's 'Service Components'.
> * This sample does not have a built-in license for [C1 Data Connector](https://developer.mescius.com/componentone/docs/services/online-dataconnector/licensing), so you may need to buy this license separately.

The project consists of the following elements.

#### Datasets Folder

This folder contains two JSON files named as Employees and Invoices.

#### Northwind.sqlite

This is the sample SQLite data source added in the project for reference. Retrieves the data to be displayed in the report.

#### Resources Folder

This folder consists of three files - Cosmo.rdlx-theme, InvoiceOData.rdlx and ListSqlite.rdlx. You can load the sample report 'InvoiceOData.rdlx' and 'ListSqlite.rdlx' that uses OData Data Source and Sqlite Data Source.

#### Implementation Folder

This folder consists of two files - FileSystemTemplates.cs and ODataDataSets.cs. FileSystemTemplates.cs is used to define the template extension whereas 'ODataDataSets.cs' is used to set the ODATA datasets.