> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/administrative-settings-4/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/administrative-settings-4/admin-panel-options/configurations/data-sheet-settings.md).

# Data Sheet Settings

The Data Sheet Settings option helps the administrator to configure the Data Sheets templates.

## Configuring Data Sheet Settings for MySQL Database

* Click the ***Data Sheet Settings*** from the list of ***Configurations*** under the ***Admin*** module.

<figure><img src="https://content.gitbook.com/content/Bxju1xjBIIexZfulhFPA/blobs/s05LDBXYSc19xZoDSioe/image.png" alt=""><figcaption><p><em><strong>Accessing the Data Sheet Settings option</strong></em></p></figcaption></figure>

* The **Data Sheet Settings** form opens.
* Select ***MySQL*** as Database type.
* Enter the database details to save the Data Sheet data as mentioned below:
  * **Username**: Use read-only credentials
  * **Password**: Use a valid password
  * **Host**: Provide Host address
  * **Port**: Provide the port number
  * **Database Name**: Provide the database name
* Click the ***Validate*** option to save the entered settings information.

<figure><img src="https://content.gitbook.com/content/Bxju1xjBIIexZfulhFPA/blobs/49c9iU3rSZ6ZMmcIt46l/image.png" alt=""><figcaption></figcaption></figure>

* A notification message appears and the provided ***Data Sheet Settings*** get registered.
* Click the ***Save*** option.

<figure><img src="https://content.gitbook.com/content/Bxju1xjBIIexZfulhFPA/blobs/XEDYTYq2gPCZAQo2KTsS/image.png" alt=""><figcaption></figcaption></figure>

* A notification message appears to confirm the user that the validated settings are saved for the ***Data Sheet Settings***.

<figure><img src="https://content.gitbook.com/content/Bxju1xjBIIexZfulhFPA/blobs/QcrRPjGm9wD8T8maCVxN/image.png" alt=""><figcaption></figcaption></figure>

## Configuring Data Sheet Settings for ClickHouse Database

The user can follow the same set of steps to configure the ***Data Sheet Settings*** with the ***ClickHouse*** option.

* Navigate to the ***Data Sheet Settings*** form.
* Select the ***ClickHouse*** as Database type.
* Enter the database details to save the form data as mentioned below:
  * **Username**: Use read-only credentials
  * **Password**: Use a valid password
  * **Host**: Provide Host address
  * **Port**: Provide the port number
  * **Database Name**: Provide a database name
* Click the ***Validate*** option to save the entered settings information.

<figure><img src="https://content.gitbook.com/content/Bxju1xjBIIexZfulhFPA/blobs/XclVo24b2oKsJKzcKaZx/image.png" alt=""><figcaption></figcaption></figure>

* A notification message appears and the provided ***Data Sheet Settings*** get registered.
* Click the ***Save*** option.

<figure><img src="https://content.gitbook.com/content/Bxju1xjBIIexZfulhFPA/blobs/2sFIsD4M0wE853BIFT0G/image.png" alt=""><figcaption></figcaption></figure>

* A notification message appears to confirm the user that the validated settings are saved for the Data Sheet creation.

<figure><img src="https://content.gitbook.com/content/Bxju1xjBIIexZfulhFPA/blobs/Y8H2QPhdzM2cPBSDcVHl/image.png" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark> The **Data Sheet** supports **MySQL** version up to **8.0** at present.*&#x20;
{% endhint %}