> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/data-center-2/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/data-center-2/data-center/data-connectors/supported-data-connectors/database-connectors/clickhouse.md).

# ClickHouse

​![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2Fr2fqeQuLaEI1Qz1nXJhi%2Fimage.png?alt=media\&token=fff891c3-4102-4a9b-b336-816d6b437e79)​

Provide the following information to create a ClickHouse Data Connector:

* **Data Connector Name**: Provide a user-defined name to identify the data connector.
* **Description**: Provide connection details (Optional).
* **Username**: Enter a Username (It should be the same as given in the connection server).
* **Password:** Enter the Password (It should be the same as provided in the connection server).
* **IP/Host**: Enter database server details (from where the user wants to fetch data).
* **Port:** Provide the server port number. (TCP port)
* **Database Name:** Name of the database where you wish to store data.
* **Http Port:** (For Datastore purpose)
* **SSL Type**: Select SSL or Non SSL as choices.
* **Upload Key:** Select a upload key using the drop-down menu (This field appears only if the SSL option has been selected for the SSL Type field.
* Click the ***Save*** option.

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

* A success message appears confirming the connection.

&#x20;     ​![](https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FItmW1TWSN8MRUbtcXzQV%2Fimage.png?alt=media\&token=552aef22-b2c4-43b6-9979-3509b052f6e4)​

* Another success message appears confirming the creation of the Data Connector.
* The newly created ClickHouse data connector gets added to the Data Connectors list.

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark>*&#x20;

* *The user can use the Environment Variables instead of the actual Username and Password to create the ClickHouse Data Connectors.*
* *The user needs to pass two Port numbers as listed below:*
  * *TCP Port Number*
  * *Http Port Number*
    {% endhint %}