What is ClickPipes?
Accelerate Your Analytics with Real-Time Data Integration
ClickPipes connects traditional databases to ClickHouse in real-time using CDC technology, creating data mirrors that accelerate analytics without disrupting your production systems.
Transform your SQL queries into secure HTTP APIs with just a few clicks, making your data instantly accessible to applications and services across your organization.
Key Capabilities​
Real-Time Data Mirroring
Capture and replicate data changes instantly from your source databases to ClickHouse using advanced CDC technology, ensuring your analytics are always based on the most current data.
Powerful Data Transformation
Transform your data during replication with built-in processors for table selection, field mapping, filtering, and more. Custom transformations can be implemented using Python.
Flexible Deployment Options
Choose between fully-managed cloud deployment or semi-managed compute engines that run in your own environment for enhanced security and performance.
Intuitive Visual Interface
Manage your entire data pipeline through a user-friendly interface, from source connection to transformation, monitoring, and API creation—no specialized technical knowledge required.
Integrated ClickHouse Service
Get started immediately with our built-in ClickHouse Cloud service—available on a pay-as-you-go basis—or connect to your existing ClickHouse instance.
Optimized for ClickHouse
Benefit from ClickHouse-specific optimizations that transform all data operations into efficient insert operations, maximizing performance while ensuring data consistency.
SQL to API Conversion
Expose your SQL queries as secure HTTP APIs with just a few clicks, making your data easily accessible to applications while maintaining security and control.
AI-Powered Query Generation
Describe your data needs in plain language, and our AI will generate the appropriate SQL queries—enabling anyone to create powerful data services without SQL expertise.
Supported Data Sources​
ClickPipes supports a wide range of data sources, enabling you to integrate data from virtually any system in your organization.
| Name | Logo | Version | Status | Replication Modes |
|---|---|---|---|---|
| Oracle |  | 9i, 10g, 11g, 12c - 21c+, RAC supported | Stable | Full, CDC |
| MySQL |  | 5.x, 8.x, 9.x | Stable | Full, CDC |
| MariaDB |  | 5.x, 10.x | Stable | Full, CDC |
| MongoDB |  | 3.x, 4.x, 5.x, 6.x, 7.x | Stable | Full, CDC |
| PostgreSQL |  | 9.x - 16.x | Stable | Full, CDC |
| SQL Server |  | 2008 - 2022 | Stable | Full, CDC |
| SYBASE |  | 16, Linux and AIX supported | Stable | Full, CDC |
| Kafka |  | 2.0 - 2.5 | Stable | Stream |
| IRIS |  | 2020.x and above | Beta | Full, CDC |
| File |  | CSV, with FTP/SFTP/SMB/S3/OSS | Beta | Full, Incremental && Changed File Monitoring |
| DB2 |  | 9.7 - 11.x | Beta | Full |
| Elasticsearch |  | 5.x, 6.x, 7.x, 8.x | Beta | Full |
| BigQuery |  | Cloud Version | Beta | Full |
Network Configuration​
Static IPs for Managed Deployments
If you are using our fully managed computing engine, please allow database network access for the following IPs based on your deployment region to ensure the service operates normally.
If your database is deployed for internal access and does not allow public access, please use the semi-managed computing engine for service provision.
| Region | IPS |
|---|---|
| eastus2 | 172.210.174.1 |
Pricing​
Pay-as-You-Go Model
ClickPipes uses a transparent pay-as-you-go subscription model, where billing is based on four key resource categories:
- Mirror engine memory usage
- Mirror task traffic consumption (no charge for semi-managed engines)
- ClickHouse Cloud Service memory, storage, and traffic usage
- AI token usage
The less you use, the lower your cost. If no resources are consumed for a period of time, you will not be charged—there are no fixed or base fees.
Free Trial Credit
Upon registration, you will receive a $300 credit with no expiration date. This credit can be used to Semi-Management Mirror Engine, allowing you to explore and experience the full capabilities of ClickPipes at no cost.
Billing Cycle
By default, your billing information is recorded and updated hourly. Charges are processed on a fixed schedule each month. If your spending during the billing cycle exceeds a certain threshold, based on internal risk control policies, we may conduct one or more early charge attempts.
If a payment attempt fails, the platform will be unable to process any new data generated. Please ensure that your payment information remains valid.