ClickHouse
ClickHouse is a high-performance, column-oriented database management system designed for rapid data processing and analytics. Its efficient architecture enables real-time querying and analysis of large datasets, making it ideal for handling both transactional and analytical workloads with ease.
ClickHouse Integration with ADOC
ADOC extends its data reliability capabilities to data visualized through ClickHouse. Integrating ClickHouse as a data source into ADOC allows users to monitor and ensure the dependability and integrity of their visualized data, facilitating real-time data processing and analytics.
Steps to Integrate ClickHouse as a Data Source
To add ClickHouse as a data source:
- Click the Register icon from the left pane.
- Click Add Data Source button.
- Select the ClickHouse data source. The Data Source Details page is displayed.
- Enter a name for the data source in the Data Source name field.
- (Optional) Enter a description for the Data Source in the Description field.
- Enable the Data Reliability capability by switching on the toggle switch.
- Select a Data Plane from the Select Data Plane drop-down menu. To create a new Data Plane, click Setup Dataplane.
You must either create a Data Plane or use an existing Data Plane to enable the Data Reliability capability.
- Click Next. The Enter Connection Details page is displayed.
- Enter the required JDBC URL, Username, and Password to establish a connection.
- Click Test Connection. If your credentials are valid, you receive a Connected message. If you get an error message, validate the ClickHouse credentials you entered.
- Click Next. The Observability Setup page is displayed.
- Provide the required details and enable the Crawler Execution Schedule: Turn on this toggle switch to select a time tag and time zone to schedule the execution of crawlers for Data Reliability.
- Click Submit.
ADOC V3.1.0's integration with ClickHouse represents a significant advancement in data observability. By leveraging ClickHouse's powerful visualization tools within the ADOC platform, businesses can achieve deeper insights, improved data reliability, and more informed decision-making processes.