Set up docs MCPErathos is an ELT platform built for control without the overhead, letting teams manage every sync job from SaaS tools and databases into the warehouse.
Overview
Erathos gives teams visibility and control over every sync job as data moves from SaaS tools, ERPs, and CRMs into ClickHouse. Instead of managing pipelines as opaque, scheduled jobs, Erathos lets you monitor and control syncs in real time, making it easier to catch issues early and keep your warehouse up to date.
Connecting Erathos to ClickHouse
Find your ClickHouse credentials
After creating a service in ClickHouse Cloud, find the following required settings:
To connect to ClickHouse with HTTP(S) you need this information:
| Parameter(s) | Description |
|---|---|
HOST and PORT |
Typically, the port is 8443 when using TLS or 8123 when not using TLS. |
DATABASE NAME |
Out of the box, there is a database named default, use the name of the database that you want to connect to. |
USERNAME and PASSWORD |
Out of the box, the username is default. Use the username appropriate for your use case. |
The details for your ClickHouse Cloud service are available in the ClickHouse Cloud console. Select a service and click Connect:
Choose HTTPS. Connection details are displayed in an example curl command.
If you’re using self-managed ClickHouse, the connection details are set by your ClickHouse administrator.
Configure the destination in Erathos
In Erathos, go to Settings > Destination, select ClickHouse, and enter the following:
- Host — your ClickHouse service URL (ClickHouse Cloud URLs typically end in
.clickhouse.cloud) - Port — usually
8443for HTTPS connections - Username — often
default - Password — the password for the account above
Save the configuration to complete the connection.
Additional resources
For more details, see Erathos’s ClickHouse destination docs, or contact support@erathos.com.