Connecting Bold BI to TDengine data source

The Bold BI dashboard designer connects the TDengine web services through the REST API.

Choose TDengine data source

To configure the TDengine data source, follow these steps:

Click the Data Sources button in the configuration panel to add a new data connection.
Click CREATE NEW to launch a new connection from the connection panel.
Select the TDengine connection in the connection panel.

NOTE: You can also create a data source from the home page by clicking the Data Sources menu on the left menu panel and selecting Create Data Source from the data sources page.

Create TDengine data source

Once you click the TDengine data source, the TDengine data source configuration panel opens. Follow these steps to create a TDengine data source:

Enter the name and description (optional) for the data source.
Choose either the TDengine Cloud or TDengine Server radio button to select the required API connection.
If you select the TDengine Cloud radio button, enter the Cloud Token and Host Name from your cloud TDengine account. To obtain the cloud token and host name, refer to the cloud console documentation.

Choose data source from server 4. Select the TDengine Server radio button and enter the Host Name, Port, User Name, and Password from your local TDengine application.

> **Note:** Ensure the taosAdapter is running in our local machine to connect the TDengine to our Bold BI.

  ![Choose data source from server](/assets/working-with-datasource/data-connectors/images/TDengine/tdengineonpremise.png)

Click on the Database dropdown box and choose the required Database from your TDengine account.
Click on the Table dropdown box and choose the required table from your connected database.
Click on the Relative Date dropdown box and choose the required relative date range such as Today, Past Week, Past Month, Custom, etc.
If the Custom option is selected in the Relative Date dropdown, select the Start date and End date value from the date picker.
Click on the Custom Url to enter the URL manually. For more details refer to this documentation TDengine API documentation.
Choose a time interval for the Refresh Settings using the combo box to periodically trigger the Rest API request to keep the data in sync with your dashboard.

You can also edit the connection information set using the Edit Connection option.

Additional information

Refresh Settings

Period before the next refresh call is triggered. This will automatically start a call for the API configured in the data source to keep the data up to date.

Setting up the URL

To enter the URL manually, click on Custom URL and then enter the URL. Refer to the TDengine API documentation for more details.
For example, if you need to change the URL, replace your URL in the Custom URL section of the API.
Replace it in the URL to query particular conversations:

https://<:your-Hostname>/rest/sql/<:your-Database>?token=<:your-CloudToken>

For more information on the API available for this data source, refer to their official API Documentation

Preview and data import

Click the Preview & Connect to connect with the configurations that have been set.
The Choose Table(s) dialog opens. The schema represents the key fields of JSON data retrieved from the Alma Rest API request. This dialog displays a list of the schema(s) in the tree view and their corresponding values in the grid for preview. Select the required schemas from the tree view for the designer and click Connect.
Now, the data design view page with the selected table schema is opened. Drag the table from the tree view table in the left pane and drop it onto the Query Designer page.
Click Save to save the data source with a relevant name.

Connect using custom attribute and dashboard parameter

We have added support for custom attributes and dashboard parameters in the data source connection. You can now connect to the data source using custom attributes or dashboard parameters.

Custom Attribute

Custom