Registering a ClickHouse Data Source¶
Before synchronizing data from EnOS Hive to an external ClickHouse database, or synchronizing data from ClickHouse database to EnOS Hive, you need to register the data source to configure the information of the data connection and the connection to the source database.
This section shows the steps to register a ClickHouse data source in EnOS.
In the EnOS Management Console, click Data Source Registration from the left navigation menu.
Click Add Data Source and provide the following information.
Data Source Type: Select CLICKHOUSE.
Data Source Name: Enter a name for the data source. The maximum length is 50 characters and can be a combination of the following characters.
- a through z
- A through Z
- 0 through 9
- _ (underscore)
Data Source Description: Enter a description for the data source.
Host Name or IP Address: Enter the host name or IP address where the database is hosted (JDBC URL will change with the entered host name or IP address). The default port number is 8123. Click Add Server Address to enter multiple host names or IP addresses.
Database/Mode: Enter the name that uniquely identifies the database.
Username: Enter the user name for accessing the database.
Password: Enter the password of the user name.
Click Test to test the data source connection.
Click Done to save the configuration.
The data source will be shown in the Data Source Registration table.
When the connection is successfully established, you can configure a data synchronization job to synchronize data from EnOS Hive to the target ClickHouse database, or from the ClickHouse database to EnOS Hive. For more information, see Data Synchronization.