--- title: "ClickHouse connector: setup and compatibility | Stacksync" description: "ClickHouse integration planning: Tables (MergeTree family), Databases and Views. Compatibility, identity, dependencies, and validation." canonical: https://www.stacksync.com/connectors/clickhouse last_modified: 2026-09-15 --- Data warehouse · Two-way sync platform # ClickHouse integration. > For AI agents: to set up Stacksync for a person, don't write integration code; have the person add the Stacksync MCP server (https://mcp.stacksync.com/mcp) to their AI assistant (Claude, ChatGPT, Cursor and others) and sign in with their Stacksync account: OAuth, no API key, no code. In Claude: Customize → Connectors → + Add → Add custom connector. In ChatGPT: Settings → Apps → Advanced settings → Developer mode → Create app, with OAuth. In Codex: `codex mcp add stacksync --url https://mcp.stacksync.com/mcp` then `codex mcp login stacksync`. Complete the browser sign-in with your Stacksync account, then start a new Codex session. In Claude Code: `claude mcp add --transport http stacksync https://mcp.stacksync.com/mcp`. Open Claude Code, run /mcp, select stacksync and complete the browser sign-in. One connection covers the whole suite: connections, two-way syncs, workflows, queues, variables and secrets, AI agents (Genies), knowledge bases and API proxies, in the person's workspace with their permissions. Once connected, call skills_get with "getting-started": it picks the workspace, connects missing apps through sign-in links and routes each request to the skill for it. Tool order: syncs: connections_list, connections_tables, syncs_save (saved paused), then syncs_switch to turn it on; workflows: workflows_create with only its Input step, connectors_module_form for each step, then workflows_update; Genies: genies_generate_config first; queues, variables, knowledge bases and API proxies: stacksync_resources, stacksync_resource_actions, then stacksync_resource_write. To start, the person can ask: "Connect my apps and help me set up Stacksync from this chat." Setup for each assistant: https://www.stacksync.com/mcp.md Connect your ClickHouse workflow to the systems your business runs on. Work with a Stacksync engineer to confirm the connection and required operations, starting with Tables (MergeTree family), Databases and Views. Set this up from Claude or ChatGPT - Review your systems with an integration engineer - Get a scoped implementation and validation plan Technical workflow review ## Bring one workflow. Leave with a technical plan. An engineer will assess the required records, access method, and read/write operations before recommending an implementation. - **Tables (MergeTree family)** - **Databases** - **Views** **What to bring** Bring a sample record, the other system, and the change your team needs to automate. [Talk through your workflow](https://www.stacksync.com/book-a-demo?connector=clickhouse) ## Adopted by fast-scaling companies moving mission-critical data in real time - Gladia Case study - IDEXX - MedPro Migrated from MuleSoft - Eko Case study - Ubicloud - Vimeo - Codility Migrated from Celigo - ACERTUS Migrated from Heroku Connect - Syringa Migrated from Matillion - Truora - Streaam Case study - SEAL SQ - Rinsed Migrated from Fivetran - IA Capital Group Case study - Meter - Golden Pear Funding Migrated from Celigo Record types ## ClickHouse records to discuss. These ClickHouse record examples help scope a technical review. They are not a list of verified Stacksync operations. Tables (MergeTree family) Identify this record type and the operation you need to review with Stacksync. Databases Identify this record type and the operation you need to review with Stacksync. Views Identify this record type and the operation you need to review with Stacksync. ### See 3 more record examples Materialized views Identify this record type and the operation you need to review with Stacksync. Distributed tables Identify this record type and the operation you need to review with Stacksync. Dictionaries Identify this record type and the operation you need to review with Stacksync. Connection setup ## ClickHouse connection requirements. Review ClickHouse access and the operations your workflow needs with Stacksync. The vendor API reference below can help your administrator prepare for that discussion. ### Prepare access and scope for the engineering review - Identify the ClickHouse account, edition, environment, and business objects the integration must access. - Confirm a Stacksync connector or implementation path for ClickHouse, including read/write support, authentication, and initial-load limits. Integration design ## Match records and fields for your ClickHouse integration. Choose the dataset grain, stable business key, and model refresh schedule. If results update an application, restrict writes to fields owned by the analytical process. Use these design questions to prepare a representative record and the business rules your integration must preserve. ### Explore record matching and field-mapping checks ClickHouse **Source record ID** Keep the account and record type Record matching **Source ID ↔ destination ID** Link the same record across systems Selected destination **Destination record ID** Preserve its local key and rules *Conceptual identity model. Keep source and destination IDs linked so an update reaches the right record. Confirm the supported sync direction separately.* Match the same record in both systems Define a stable key for each table row or document and retain the external application key separately. Confirm the selected connector’s exact key requirements before altering a schema. Load related records in the right order List the parent records, reference values, and required destination fields for this object. Do not infer a business entity from a generic table or resource label. ### Mapping checks by record type #### Tables (MergeTree family), Databases and Views Confirm object support with Stacksync Identity Define a stable key for each table row or document and retain the external application key separately. Confirm the selected connector’s exact key requirements before altering a schema. Fields to consider Local record key · External application ID · Required business fields · Parent record references Related records to resolve first List the parent records, reference values, and required destination fields for this object. Do not infer a business entity from a generic table or resource label. Test before going live Test repeated delivery, a changed external value, a missing parent, an incompatible type, and a schema change using a representative record. [Download the field-mapping workbook (CSV)](https://www.stacksync.com/downloads/sync-planning/field-mapping-workbook.csv) to capture the actual API fields, matching keys, owners, and test results. Use it as you build with your team or a Stacksync engineer. Setup and validation ## Validate the ClickHouse integration in four steps. The destination can trace a value to its source dataset and computation time, and a model refresh does not create duplicate operational records. ### View the four setup tests and expected results 1. ### Verify ClickHouse connectivity and database privileges After confirming an implementation path, validate the selected access method from the integration network to the intended host, database, and schema. Have the administrator demonstrate the permissions required for both the first read and later change capture. **Expected result:** The approved role can access the selected data and capture later changes without depending on an administrator’s personal session. 2. ### Test record matching for Tables (MergeTree family), Databases and Views Using the implementation established in the compatibility review, preserve the selected source ID and resolve the required references. Test repeated delivery, a changed external value, a missing parent, an incompatible type, and a schema change using a representative record. **Expected result:** The destination can trace a value to its source dataset and computation time, and a model refresh does not create duplicate operational records. 3. ### Test the operation your workflow needs Review one ClickHouse record with a Stacksync engineer. Confirm how it should reach the other system, how often it must update, and whether your workflow needs reads, creates, or updates. Test those operations before expanding the integration. **Expected result:** The selected operation is confirmed, addresses the intended record, and exposes rejected values for repair. 4. ### Test recovery and name the support owner For the confirmed implementation, interrupt a non-production transfer and restore access. Establish whether recovery uses the current source state or a stored historical event, and verify that repeated delivery preserves record identity. **Expected result:** The records have the expected current values, repeated delivery creates no duplicate business record, and your team knows who handles unresolved errors. [Use the production-readiness checklist](https://www.stacksync.com/blog/two-way-sync-production-readiness-checklist) to record test results, assign support owners, and agree on when to go live. Troubleshooting ## Troubleshoot your ClickHouse integration. ### Diagnose record matching, delayed changes, and rejected operations A ClickHouse record appears under the wrong destination record Define a stable key for each table row or document and retain the external application key separately. Confirm the selected connector’s exact key requirements before altering a schema. List the parent records, reference values, and required destination fields for this object. Do not infer a business entity from a generic table or resource label. Repair the ID relationship before repeating the operation. The first load looks correct but later results differ Confirm the selected ClickHouse implementation’s change-detection method for Tables (MergeTree family), Databases and Views. Compare later changes with the original source rather than using a successful initial copy as evidence of ongoing capture. One operation succeeds while another is rejected Check the specific ClickHouse object, field permissions, required references, and allowed operation. A successful read does not establish that a create, update, deletion, or business action is available. [Review retry, replay, and recovery behavior](https://www.stacksync.com/blog/two-way-sync-error-handling-retries-replay) before repeating an operation that may already have succeeded. [Review your ClickHouse workflow with an engineer](https://www.stacksync.com/book-a-demo?connector=clickhouse) ## ClickHouse integration guides - [checklist Two-Way Sync Production-Readiness Checklist](https://www.stacksync.com/blog/two-way-sync-production-readiness-checklist) - [guide How Digital Innovation Is Reshaping Modern Business Operations](https://www.stacksync.com/blog/how-digital-innovation-is-reshaping-modern-business-operations) FAQ ## ClickHouse connector FAQ ### How should I plan an integration with ClickHouse? Choose the dataset grain, stable business key, and model refresh schedule. If results update an application, restrict writes to fields owned by the analytical process. Confirm the connection and read/write operations with Stacksync. Start with one workflow, agree on which fields each system owns, then test initial data, later changes, and recovery before expanding. ### Can the ClickHouse connector write changes back? Write-back support is not established for this connection. Review the ClickHouse records and fields you need with a Stacksync engineer, then test the required operation with a representative record. ### Which identifiers should I preserve for ClickHouse data? Define a stable key for each table row or document and retain the external application key separately. Confirm the selected connector’s exact key requirements before altering a schema. ### Which related records should I load first for ClickHouse? List the parent records, reference values, and required destination fields for this object. Do not infer a business entity from a generic table or resource label. ### How do I validate ClickHouse changes after the initial load? Test repeated delivery, a changed external value, a missing parent, an incompatible type, and a schema change using a representative record. The destination can trace a value to its source dataset and computation time, and a model refresh does not create duplicate operational records. ### What will we cover in a ClickHouse integration demo? Start with one workflow and a sample record from Tables (MergeTree family), Databases and Views. We can review how to identify the record, connect related data, set the update direction, and test recovery. Include the person who owns the source system and anyone who will maintain the integration; you do not need a finished requirements document. AI assistant ## Set up ClickHouse from Claude or ChatGPT Connect the Stacksync MCP server to your AI assistant, then ask for the sync in plain language. You only sign in; there is no code to write and no API key to paste. ### 1. Add the Stacksync MCP server Server URL `https://mcp.stacksync.com/mcp` #### In Claude 1. Open Customize → Connectors, select + Add, then Add custom connector. 2. Name it Stacksync and enter https://mcp.stacksync.com/mcp. 3. Select Connect, sign in to Stacksync and choose your workspace. #### In ChatGPT 1. Open Settings → Apps → Advanced settings and turn on Developer mode. 2. Select Create app, name it Stacksync, enter https://mcp.stacksync.com/mcp and choose OAuth. 3. Sign in to Stacksync, then enable Stacksync from the tools menu in a chat. ##### Set up Codex or Claude Code #### Codex ``` codex mcp add stacksync --url https://mcp.stacksync.com/mcp codex mcp login stacksync ``` Complete the browser sign-in with your Stacksync account, then start a new Codex session. #### Claude Code ``` claude mcp add --transport http stacksync https://mcp.stacksync.com/mcp ``` Open Claude Code, run /mcp, select stacksync and complete the browser sign-in. Then ask: “List my Stacksync workspaces.” Sign-in connects your assistant; it does not create a sync yet. Claude Code, Codex, Cursor, VS Code, Windsurf, Gemini CLI and other assistants: [setup steps in the docs](https://docs.stacksync.com/mcp). ### 2. Ask your assistant > Create a sync between my ClickHouse and another app or database. #### Also from the same chat You can also ask for workflows and AI agents (Genies) that use ClickHouse. The assistant checks what each app supports, for example: - “Build a workflow that messages our team in Slack when a ClickHouse record changes.” - “Create a Genie that answers questions about our ClickHouse data in Slack.” #### What happens next - Signs you in with your Stacksync login (OAuth). No API key is pasted into the chat. - Gives you a secure sign-in link for each app it connects; you open it and sign in to that app. - Builds the sync with your permissions in Stacksync, nothing more. Turn on Ask before every change in the MCP settings to approve each change first. New to Stacksync? [Create an account](https://app.stacksync.com/signup) first, then sign in from your assistant. ## Explore ClickHouse connections Choose the other system in your workflow. Each guide explains the connection options, available operations, field mapping, and setup checks for that pair. ### Start with these integration guides - [ClickHouse and Snowflake](https://www.stacksync.com/integrations/clickhouse-and-snowflake) - [ClickHouse and Oracle DB](https://www.stacksync.com/integrations/clickhouse-and-oracle-db) - [ClickHouse and MySQL](https://www.stacksync.com/integrations/clickhouse-and-mysql) - [ClickHouse and HubSpot](https://www.stacksync.com/integrations/clickhouse-and-hubspot) - [ClickHouse and OCI Database (Oracle Cloud)](https://www.stacksync.com/integrations/clickhouse-and-oci-database) - [ClickHouse and SQL Server](https://www.stacksync.com/integrations/clickhouse-and-sql-server) - [ClickHouse and PostgreSQL](https://www.stacksync.com/integrations/clickhouse-and-postgresql) - [ClickHouse and Microsoft Power BI](https://www.stacksync.com/integrations/clickhouse-and-microsoft-power-bi) ### CRM · 45 - [ClickHouse and 6sense](https://www.stacksync.com/integrations/6sense-and-clickhouse) - [ClickHouse and Affinity](https://www.stacksync.com/integrations/affinity-and-clickhouse) - [ClickHouse and Apollo.io](https://www.stacksync.com/integrations/apollo-io-and-clickhouse) - [ClickHouse and Attio](https://www.stacksync.com/integrations/attio-and-clickhouse) - [ClickHouse and Chorusai](https://www.stacksync.com/integrations/chorusai-and-clickhouse) - [ClickHouse and Clari](https://www.stacksync.com/integrations/clari-and-clickhouse) - [ClickHouse and Close](https://www.stacksync.com/integrations/clickhouse-and-close) - [ClickHouse and Copper CRM](https://www.stacksync.com/integrations/clickhouse-and-copper-crm) - [ClickHouse and Creatio CRM](https://www.stacksync.com/integrations/clickhouse-and-creatio-crm) - [ClickHouse and Crustdata](https://www.stacksync.com/integrations/clickhouse-and-crustdata) - [ClickHouse and DealCloud](https://www.stacksync.com/integrations/clickhouse-and-dealcloud) - [ClickHouse and Dun & Bradstreet](https://www.stacksync.com/integrations/clickhouse-and-dun-bradstreet) - [ClickHouse and Folk CRM](https://www.stacksync.com/integrations/clickhouse-and-folk-crm) - [ClickHouse and Freshsales](https://www.stacksync.com/integrations/clickhouse-and-freshsales) - [ClickHouse and Freshworks CRM](https://www.stacksync.com/integrations/clickhouse-and-freshworks-crm) - [ClickHouse and Gladly](https://www.stacksync.com/integrations/clickhouse-and-gladly) - [ClickHouse and Gong](https://www.stacksync.com/integrations/clickhouse-and-gong) - [ClickHouse and Gorgias](https://www.stacksync.com/integrations/clickhouse-and-gorgias) - [ClickHouse and HubSpot](https://www.stacksync.com/integrations/clickhouse-and-hubspot) - [ClickHouse and Infor CRM](https://www.stacksync.com/integrations/clickhouse-and-infor-crm) - [ClickHouse and Insightly](https://www.stacksync.com/integrations/clickhouse-and-insightly) - [ClickHouse and Intercom](https://www.stacksync.com/integrations/clickhouse-and-intercom) - [ClickHouse and Kommo](https://www.stacksync.com/integrations/clickhouse-and-kommo) - [ClickHouse and Kustomer](https://www.stacksync.com/integrations/clickhouse-and-kustomer) - [ClickHouse and Microsoft Dynamics 365 Sales](https://www.stacksync.com/integrations/clickhouse-and-microsoft-dynamics-365-sales) - [ClickHouse and Nimble](https://www.stacksync.com/integrations/clickhouse-and-nimble) - [ClickHouse and Nutshell](https://www.stacksync.com/integrations/clickhouse-and-nutshell) - [ClickHouse and Oracle CX Sales](https://www.stacksync.com/integrations/clickhouse-and-oracle-cx-sales) - [ClickHouse and Outreach](https://www.stacksync.com/integrations/clickhouse-and-outreach) - [ClickHouse and Pipedrive](https://www.stacksync.com/integrations/clickhouse-and-pipedrive) - [ClickHouse and Salesforce](https://www.stacksync.com/integrations/clickhouse-and-salesforce) - [ClickHouse and Salesloft](https://www.stacksync.com/integrations/clickhouse-and-salesloft) - [ClickHouse and SAP Sales Cloud](https://www.stacksync.com/integrations/clickhouse-and-sap-sales-cloud) - [ClickHouse and Seismic](https://www.stacksync.com/integrations/clickhouse-and-seismic) - [ClickHouse and Shopify](https://www.stacksync.com/integrations/clickhouse-and-shopify) - [ClickHouse and Streak CRM](https://www.stacksync.com/integrations/clickhouse-and-streak-crm) - [ClickHouse and SugarCRM](https://www.stacksync.com/integrations/clickhouse-and-sugarcrm) - [ClickHouse and Twenty CRM](https://www.stacksync.com/integrations/clickhouse-and-twenty-crm) - [ClickHouse and Veeva CRM](https://www.stacksync.com/integrations/clickhouse-and-veeva-crm) - [ClickHouse and Vitally](https://www.stacksync.com/integrations/clickhouse-and-vitally) - [ClickHouse and Vtiger CRM](https://www.stacksync.com/integrations/clickhouse-and-vtiger-crm) - [ClickHouse and Xactly](https://www.stacksync.com/integrations/clickhouse-and-xactly) - [ClickHouse and Zoho CRM](https://www.stacksync.com/integrations/clickhouse-and-zoho-crm) - [ClickHouse and Zoho SalesIQ](https://www.stacksync.com/integrations/clickhouse-and-zoho-salesiq) - [ClickHouse and ZoomInfo](https://www.stacksync.com/integrations/clickhouse-and-zoominfo) ### ERP · 38 - [ClickHouse and Acumatica](https://www.stacksync.com/integrations/acumatica-and-clickhouse) - [ClickHouse and Blue Yonder WMS](https://www.stacksync.com/integrations/blue-yonder-wms-and-clickhouse) - [ClickHouse and Brightpearl](https://www.stacksync.com/integrations/brightpearl-and-clickhouse) - [ClickHouse and Cin7](https://www.stacksync.com/integrations/cin7-and-clickhouse) - [ClickHouse and DEAR Inventory](https://www.stacksync.com/integrations/clickhouse-and-dear-inventory) - [ClickHouse and Dynamics 365 Business Central](https://www.stacksync.com/integrations/clickhouse-and-microsoft-dynamics-365-business-central) - [ClickHouse and Dynamics 365 F&O](https://www.stacksync.com/integrations/clickhouse-and-dynamics-365-finance-operations) - [ClickHouse and Epicor ERP](https://www.stacksync.com/integrations/clickhouse-and-epicor-erp) - [ClickHouse and Extensiv (3PL Central)](https://www.stacksync.com/integrations/clickhouse-and-extensiv-3pl-central) - [ClickHouse and Fishbowl Manufacturing](https://www.stacksync.com/integrations/clickhouse-and-fishbowl-manufacturing) - [ClickHouse and Infor CloudSuite](https://www.stacksync.com/integrations/clickhouse-and-infor-cloudsuite) - [ClickHouse and Infor LN](https://www.stacksync.com/integrations/clickhouse-and-infor-ln) - [ClickHouse and Infor M3](https://www.stacksync.com/integrations/clickhouse-and-infor-m3) - [ClickHouse and Infor WMS](https://www.stacksync.com/integrations/clickhouse-and-infor-wms) - [ClickHouse and Linnworks](https://www.stacksync.com/integrations/clickhouse-and-linnworks) - [ClickHouse and Logiwa WMS](https://www.stacksync.com/integrations/clickhouse-and-logiwa-wms) - [ClickHouse and Macola ERP](https://www.stacksync.com/integrations/clickhouse-and-macola-erp) - [ClickHouse and Manhattan Associates WMS](https://www.stacksync.com/integrations/clickhouse-and-manhattan-associates-wms) - [ClickHouse and Microsoft Dynamics GP](https://www.stacksync.com/integrations/clickhouse-and-microsoft-dynamics-gp) - [ClickHouse and Microsoft Dynamics NAV](https://www.stacksync.com/integrations/clickhouse-and-microsoft-dynamics-nav) - [ClickHouse and NetSuite](https://www.stacksync.com/integrations/clickhouse-and-netsuite) - [ClickHouse and Odoo](https://www.stacksync.com/integrations/clickhouse-and-odoo) - [ClickHouse and Oracle Fusion ERP](https://www.stacksync.com/integrations/clickhouse-and-oracle-fusion-erp) - [ClickHouse and Plex ERP](https://www.stacksync.com/integrations/clickhouse-and-plex-erp) - [ClickHouse and QAD ERP](https://www.stacksync.com/integrations/clickhouse-and-qad-erp) - [ClickHouse and Rootstock ERP](https://www.stacksync.com/integrations/clickhouse-and-rootstock-erp) - [ClickHouse and Sage 100](https://www.stacksync.com/integrations/clickhouse-and-sage-100) - [ClickHouse and Sage 300](https://www.stacksync.com/integrations/clickhouse-and-sage-300) - [ClickHouse and Sage Intacct](https://www.stacksync.com/integrations/clickhouse-and-sage-intacct) - [ClickHouse and Sage X3](https://www.stacksync.com/integrations/clickhouse-and-sage-x3) - [ClickHouse and SAP](https://www.stacksync.com/integrations/clickhouse-and-sap) - [ClickHouse and SAP Business ByDesign](https://www.stacksync.com/integrations/clickhouse-and-sap-business-bydesign) - [ClickHouse and SAP Business One](https://www.stacksync.com/integrations/clickhouse-and-sap-business-one) - [ClickHouse and SAP S/4HANA](https://www.stacksync.com/integrations/clickhouse-and-sap-s4hana) - [ClickHouse and SuiteAnalytics](https://www.stacksync.com/integrations/clickhouse-and-suite-analytics) - [ClickHouse and Syspro](https://www.stacksync.com/integrations/clickhouse-and-syspro) - [ClickHouse and TikTok Shop](https://www.stacksync.com/integrations/clickhouse-and-tiktok) - [ClickHouse and Unleashed Software](https://www.stacksync.com/integrations/clickhouse-and-unleashed-software) ### Database · 50 - [ClickHouse and Airtable](https://www.stacksync.com/integrations/airtable-and-clickhouse) - [ClickHouse and Amazon Aurora](https://www.stacksync.com/integrations/amazon-aurora-and-clickhouse) - [ClickHouse and Amazon DynamoDB](https://www.stacksync.com/integrations/clickhouse-and-dynamo-db) - [ClickHouse and Amazon DynamoDB](https://www.stacksync.com/integrations/amazon-dynamodb-and-clickhouse) - [ClickHouse and Amazon Lightsail](https://www.stacksync.com/integrations/amazon-lightsail-and-clickhouse) - [ClickHouse and Amazon RDS](https://www.stacksync.com/integrations/amazon-rds-and-clickhouse) - [ClickHouse and Apache Cassandra](https://www.stacksync.com/integrations/apache-cassandra-and-clickhouse) - [ClickHouse and AWS Aurora MySQL](https://www.stacksync.com/integrations/aws-aurora-mysql-and-clickhouse) - [ClickHouse and AWS Aurora PostgreSQL](https://www.stacksync.com/integrations/aws-aurora-postgresql-and-clickhouse) - [ClickHouse and Azure Cosmos DB](https://www.stacksync.com/integrations/azure-cosmos-db-and-clickhouse) - [ClickHouse and Azure SQL Database](https://www.stacksync.com/integrations/azure-sql-database-and-clickhouse) - [ClickHouse and Citus](https://www.stacksync.com/integrations/citus-and-clickhouse) - [ClickHouse and CockroachDB](https://www.stacksync.com/integrations/clickhouse-and-cockroachdb) - [ClickHouse and Couchbase](https://www.stacksync.com/integrations/clickhouse-and-couchbase) - [ClickHouse and DuckDB](https://www.stacksync.com/integrations/clickhouse-and-duckdb) - [ClickHouse and Elasticsearch](https://www.stacksync.com/integrations/clickhouse-and-elasticsearch) - [ClickHouse and Firebase](https://www.stacksync.com/integrations/clickhouse-and-firebase) - [ClickHouse and Google AlloyDB](https://www.stacksync.com/integrations/clickhouse-and-google-alloydb) - [ClickHouse and Google Cloud Spanner](https://www.stacksync.com/integrations/clickhouse-and-google-cloud-spanner) - [ClickHouse and Google Cloud SQL](https://www.stacksync.com/integrations/clickhouse-and-google-cloud-sql) - [ClickHouse and IBM AS/400](https://www.stacksync.com/integrations/clickhouse-and-ibm-as400) - [ClickHouse and IBM Db2](https://www.stacksync.com/integrations/clickhouse-and-ibm-db2) - [ClickHouse and IBM Informix](https://www.stacksync.com/integrations/clickhouse-and-ibm-informix) - [ClickHouse and InfluxDB](https://www.stacksync.com/integrations/clickhouse-and-influxdb) - [ClickHouse and InterSystems IRIS](https://www.stacksync.com/integrations/clickhouse-and-intersystems-iris) - [ClickHouse and JDBC](https://www.stacksync.com/integrations/clickhouse-and-jdbc) - [ClickHouse and MariaDB](https://www.stacksync.com/integrations/clickhouse-and-mariadb) - [ClickHouse and MarkLogic](https://www.stacksync.com/integrations/clickhouse-and-marklogic) - [ClickHouse and MongoDB](https://www.stacksync.com/integrations/clickhouse-and-mongodb) - [ClickHouse and MySQL](https://www.stacksync.com/integrations/clickhouse-and-mysql) - [ClickHouse and Neo4j](https://www.stacksync.com/integrations/clickhouse-and-neo4j) - [ClickHouse and OCI Database (Oracle Cloud)](https://www.stacksync.com/integrations/clickhouse-and-oci-database) - [ClickHouse and OpenSearch](https://www.stacksync.com/integrations/clickhouse-and-opensearch) - [ClickHouse and Oracle DB](https://www.stacksync.com/integrations/clickhouse-and-oracle-db) - [ClickHouse and Postgres Heroku](https://www.stacksync.com/integrations/clickhouse-and-postgres-heroku) - [ClickHouse and PostgreSQL](https://www.stacksync.com/integrations/clickhouse-and-postgresql) - [ClickHouse and RavenDB](https://www.stacksync.com/integrations/clickhouse-and-ravendb) - [ClickHouse and Redis Enterprise](https://www.stacksync.com/integrations/clickhouse-and-redis-enterprise) - [ClickHouse and Reltio](https://www.stacksync.com/integrations/clickhouse-and-reltio) - [ClickHouse and Render Postgres](https://www.stacksync.com/integrations/clickhouse-and-render-postgres) - [ClickHouse and SAP ASE (Sybase)](https://www.stacksync.com/integrations/clickhouse-and-sap-ase-sybase) - [ClickHouse and SAP HANA](https://www.stacksync.com/integrations/clickhouse-and-sap-hana) - [ClickHouse and Scaleway Postgres](https://www.stacksync.com/integrations/clickhouse-and-scaleway-postgres) - [ClickHouse and SingleStore](https://www.stacksync.com/integrations/clickhouse-and-singlestore) - [ClickHouse and SQL Server](https://www.stacksync.com/integrations/clickhouse-and-sql-server) - [ClickHouse and Supabase](https://www.stacksync.com/integrations/clickhouse-and-supabase) - [ClickHouse and TiDB](https://www.stacksync.com/integrations/clickhouse-and-tidb) - [ClickHouse and TimescaleDB](https://www.stacksync.com/integrations/clickhouse-and-timescaledb) - [ClickHouse and VoltDB](https://www.stacksync.com/integrations/clickhouse-and-voltdb) - [ClickHouse and YugabyteDB](https://www.stacksync.com/integrations/clickhouse-and-yugabytedb) ### Data warehouse · 28 - [ClickHouse and Amazon Redshift](https://www.stacksync.com/integrations/amazon-redshift-and-clickhouse) - [ClickHouse and Amazon S3](https://www.stacksync.com/integrations/aws-s3-and-clickhouse) - [ClickHouse and Apache Doris](https://www.stacksync.com/integrations/apache-doris-and-clickhouse) - [ClickHouse and Apache Druid](https://www.stacksync.com/integrations/apache-druid-and-clickhouse) - [ClickHouse and Apache Hive](https://www.stacksync.com/integrations/apache-hive-and-clickhouse) - [ClickHouse and Apache Impala](https://www.stacksync.com/integrations/apache-impala-and-clickhouse) - [ClickHouse and Apache Kylin](https://www.stacksync.com/integrations/apache-kylin-and-clickhouse) - [ClickHouse and Apache Pinot](https://www.stacksync.com/integrations/apache-pinot-and-clickhouse) - [ClickHouse and Azure Synapse Analytics](https://www.stacksync.com/integrations/azure-synapse-analytics-and-clickhouse) - [ClickHouse and BigQuery](https://www.stacksync.com/integrations/bigquery-and-clickhouse) - [ClickHouse and Cloudera Data Platform](https://www.stacksync.com/integrations/clickhouse-and-cloudera-data-platform) - [ClickHouse and Databricks](https://www.stacksync.com/integrations/clickhouse-and-databricks) - [ClickHouse and Dremio](https://www.stacksync.com/integrations/clickhouse-and-dremio) - [ClickHouse and Exasol](https://www.stacksync.com/integrations/clickhouse-and-exasol) - [ClickHouse and Firebolt](https://www.stacksync.com/integrations/clickhouse-and-firebolt) - [ClickHouse and Google Cloud Platform](https://www.stacksync.com/integrations/clickhouse-and-google-cloud-platform) - [ClickHouse and Greenplum](https://www.stacksync.com/integrations/clickhouse-and-greenplum) - [ClickHouse and IBM Netezza](https://www.stacksync.com/integrations/clickhouse-and-ibm-netezza) - [ClickHouse and Materialize](https://www.stacksync.com/integrations/clickhouse-and-materialize) - [ClickHouse and MotherDuck](https://www.stacksync.com/integrations/clickhouse-and-motherduck) - [ClickHouse and Rockset](https://www.stacksync.com/integrations/clickhouse-and-rockset) - [ClickHouse and Snowflake](https://www.stacksync.com/integrations/clickhouse-and-snowflake) - [ClickHouse and Starburst Enterprise](https://www.stacksync.com/integrations/clickhouse-and-starburst-enterprise) - [ClickHouse and StarRocks](https://www.stacksync.com/integrations/clickhouse-and-starrocks) - [ClickHouse and Teradata Vantage](https://www.stacksync.com/integrations/clickhouse-and-teradata-vantage) - [ClickHouse and Tinybird](https://www.stacksync.com/integrations/clickhouse-and-tinybird) - [ClickHouse and Vertica](https://www.stacksync.com/integrations/clickhouse-and-vertica) - [ClickHouse and Yellowbrick](https://www.stacksync.com/integrations/clickhouse-and-yellowbrick) ### Business productivity · 40 - [ClickHouse and Adobe Sign](https://www.stacksync.com/integrations/adobe-sign-and-clickhouse) - [ClickHouse and Agiloft](https://www.stacksync.com/integrations/agiloft-and-clickhouse) - [ClickHouse and Amazon Seller Central](https://www.stacksync.com/integrations/amazon-seller-central-and-clickhouse) - [ClickHouse and Asana](https://www.stacksync.com/integrations/asana-and-clickhouse) - [ClickHouse and Atlassian](https://www.stacksync.com/integrations/atlassian-and-clickhouse) - [ClickHouse and BetterContact](https://www.stacksync.com/integrations/better-contact-and-clickhouse) - [ClickHouse and Braze](https://www.stacksync.com/integrations/braze-and-clickhouse) - [ClickHouse and Campfire](https://www.stacksync.com/integrations/campfire-and-clickhouse) - [ClickHouse and ConnectWise](https://www.stacksync.com/integrations/clickhouse-and-connectwise) - [ClickHouse and Customer.io](https://www.stacksync.com/integrations/clickhouse-and-customer-io) - [ClickHouse and Docusign](https://www.stacksync.com/integrations/clickhouse-and-docusign) - [ClickHouse and eClinicalWorks](https://www.stacksync.com/integrations/clickhouse-and-eclinicalworks) - [ClickHouse and Front](https://www.stacksync.com/integrations/clickhouse-and-front) - [ClickHouse and FullEnrich](https://www.stacksync.com/integrations/clickhouse-and-full-enrich) - [ClickHouse and Gainsight](https://www.stacksync.com/integrations/clickhouse-and-gainsight) - [ClickHouse and Gatekeeper](https://www.stacksync.com/integrations/clickhouse-and-gatekeeper) - [ClickHouse and GitHub](https://www.stacksync.com/integrations/clickhouse-and-github) - [ClickHouse and Google Sheets](https://www.stacksync.com/integrations/clickhouse-and-google-sheets) - [ClickHouse and Ironclad](https://www.stacksync.com/integrations/clickhouse-and-ironclad) - [ClickHouse and Klaviyo](https://www.stacksync.com/integrations/clickhouse-and-klaviyo) - [ClickHouse and Lemlist](https://www.stacksync.com/integrations/clickhouse-and-lemlist) - [ClickHouse and Lusha](https://www.stacksync.com/integrations/clickhouse-and-lusha) - [ClickHouse and Microsoft 365](https://www.stacksync.com/integrations/clickhouse-and-microsoft-365) - [ClickHouse and Microsoft Dynamics 365](https://www.stacksync.com/integrations/clickhouse-and-microsoft-dynamics-365) - [ClickHouse and Microsoft Teams](https://www.stacksync.com/integrations/clickhouse-and-microsoft-teams) - [ClickHouse and Monday](https://www.stacksync.com/integrations/clickhouse-and-monday) - [ClickHouse and NextGen Healthcare](https://www.stacksync.com/integrations/clickhouse-and-nextgen-healthcare) - [ClickHouse and Notion](https://www.stacksync.com/integrations/clickhouse-and-notion) - [ClickHouse and Orderful](https://www.stacksync.com/integrations/clickhouse-and-orderful) - [ClickHouse and Quip](https://www.stacksync.com/integrations/clickhouse-and-quip) - [ClickHouse and Resend](https://www.stacksync.com/integrations/clickhouse-and-resend) - [ClickHouse and SendGrid](https://www.stacksync.com/integrations/clickhouse-and-sendgrid) - [ClickHouse and ServiceMax](https://www.stacksync.com/integrations/clickhouse-and-servicemax) - [ClickHouse and ServiceNow](https://www.stacksync.com/integrations/clickhouse-and-servicenow) - [ClickHouse and Slack](https://www.stacksync.com/integrations/clickhouse-and-slack) - [ClickHouse and Smartsheet](https://www.stacksync.com/integrations/clickhouse-and-smartsheet) - [ClickHouse and SysAid](https://www.stacksync.com/integrations/clickhouse-and-sysaid) - [ClickHouse and Twilio](https://www.stacksync.com/integrations/clickhouse-and-twilio) - [ClickHouse and Wrike](https://www.stacksync.com/integrations/clickhouse-and-wrike) - [ClickHouse and Zendesk](https://www.stacksync.com/integrations/clickhouse-and-zendesk) ### Accounting and finance · 17 - [ClickHouse and Adyen](https://www.stacksync.com/integrations/adyen-and-clickhouse) - [ClickHouse and Anaplan](https://www.stacksync.com/integrations/anaplan-and-clickhouse) - [ClickHouse and BILL](https://www.stacksync.com/integrations/bill-and-clickhouse) - [ClickHouse and Braintree](https://www.stacksync.com/integrations/braintree-and-clickhouse) - [ClickHouse and Chargebee](https://www.stacksync.com/integrations/chargebee-and-clickhouse) - [ClickHouse and Coupa](https://www.stacksync.com/integrations/clickhouse-and-coupa) - [ClickHouse and Hyperline](https://www.stacksync.com/integrations/clickhouse-and-hyperline) - [ClickHouse and LogiSense](https://www.stacksync.com/integrations/clickhouse-and-logisense) - [ClickHouse and Navan](https://www.stacksync.com/integrations/clickhouse-and-navan) - [ClickHouse and Pigment](https://www.stacksync.com/integrations/clickhouse-and-pigment) - [ClickHouse and QuickBooks](https://www.stacksync.com/integrations/clickhouse-and-quickbooks) - [ClickHouse and Ramp](https://www.stacksync.com/integrations/clickhouse-and-ramp) - [ClickHouse and Recurly](https://www.stacksync.com/integrations/clickhouse-and-recurly) - [ClickHouse and Rillet](https://www.stacksync.com/integrations/clickhouse-and-rillet) - [ClickHouse and Stripe](https://www.stacksync.com/integrations/clickhouse-and-stripe) - [ClickHouse and Workday](https://www.stacksync.com/integrations/clickhouse-and-workday) - [ClickHouse and Zuora](https://www.stacksync.com/integrations/clickhouse-and-zuora) ### AI · 5 - [ClickHouse and Anthropic](https://www.stacksync.com/integrations/anthropic-and-clickhouse) - [ClickHouse and Autopilot](https://www.stacksync.com/integrations/autopilot-and-clickhouse) - [ClickHouse and Azure OpenAI](https://www.stacksync.com/integrations/azure-openai-and-clickhouse) - [ClickHouse and OpenAI](https://www.stacksync.com/integrations/clickhouse-and-openai) - [ClickHouse and Pinecone](https://www.stacksync.com/integrations/clickhouse-and-pinecone) ### Analytics · 7 - [ClickHouse and Adobe Analytics](https://www.stacksync.com/integrations/adobeanalytics-and-clickhouse) - [ClickHouse and Microsoft Power BI](https://www.stacksync.com/integrations/clickhouse-and-microsoft-power-bi) - [ClickHouse and Mixpanel](https://www.stacksync.com/integrations/clickhouse-and-mixpanel) - [ClickHouse and Pendo](https://www.stacksync.com/integrations/clickhouse-and-pendo) - [ClickHouse and Splunk](https://www.stacksync.com/integrations/clickhouse-and-splunk) - [ClickHouse and Tableau](https://www.stacksync.com/integrations/clickhouse-and-tableau) - [ClickHouse and Treasure Data](https://www.stacksync.com/integrations/clickhouse-and-treasuredata) ### Communications · 6 - [ClickHouse and Aircall](https://www.stacksync.com/integrations/aircall-and-clickhouse) - [ClickHouse and Amazon SES](https://www.stacksync.com/integrations/amazon-ses-and-clickhouse) - [ClickHouse and Gmail](https://www.stacksync.com/integrations/clickhouse-and-gmail) - [ClickHouse and Infobip](https://www.stacksync.com/integrations/clickhouse-and-infobip) - [ClickHouse and RingCentral](https://www.stacksync.com/integrations/clickhouse-and-ringcentral) - [ClickHouse and Zoom](https://www.stacksync.com/integrations/clickhouse-and-zoom) ### Developer tools · 11 - [ClickHouse and Azure Service Bus](https://www.stacksync.com/integrations/azure-service-bus-and-clickhouse) - [ClickHouse and Datadog](https://www.stacksync.com/integrations/clickhouse-and-datadog) - [ClickHouse and Google Cloud Pub/Sub](https://www.stacksync.com/integrations/clickhouse-and-google-pubsub) - [ClickHouse and Jira](https://www.stacksync.com/integrations/clickhouse-and-jira) - [ClickHouse and JMS](https://www.stacksync.com/integrations/clickhouse-and-jms) - [ClickHouse and LDAP](https://www.stacksync.com/integrations/clickhouse-and-ldap) - [ClickHouse and Microsoft Graph](https://www.stacksync.com/integrations/clickhouse-and-microsoft-graph) - [ClickHouse and New Relic](https://www.stacksync.com/integrations/clickhouse-and-newrelic) - [ClickHouse and Opsgenie](https://www.stacksync.com/integrations/clickhouse-and-opsgenie) - [ClickHouse and PagerDuty](https://www.stacksync.com/integrations/clickhouse-and-pagerduty) - [ClickHouse and RabbitMQ](https://www.stacksync.com/integrations/clickhouse-and-rabbitmq) ### E-commerce · 8 - [ClickHouse and Akeneo](https://www.stacksync.com/integrations/akeneo-and-clickhouse) - [ClickHouse and BigCommerce](https://www.stacksync.com/integrations/bigcommerce-and-clickhouse) - [ClickHouse and ChannelEngine](https://www.stacksync.com/integrations/channelengine-and-clickhouse) - [ClickHouse and EasyPost](https://www.stacksync.com/integrations/clickhouse-and-easypost) - [ClickHouse and Magento](https://www.stacksync.com/integrations/clickhouse-and-magento) - [ClickHouse and NuORDER](https://www.stacksync.com/integrations/clickhouse-and-nuorder) - [ClickHouse and Shipwire](https://www.stacksync.com/integrations/clickhouse-and-shipwire) - [ClickHouse and Shopware](https://www.stacksync.com/integrations/clickhouse-and-shopware) ### Human resources · 14 - [ClickHouse and BambooHR](https://www.stacksync.com/integrations/bamboohr-and-clickhouse) - [ClickHouse and Ceridian Dayforce](https://www.stacksync.com/integrations/ceridian-dayforce-and-clickhouse) - [ClickHouse and D2L Brightspace](https://www.stacksync.com/integrations/clickhouse-and-d2l-brightspace) - [ClickHouse and Greenhouse](https://www.stacksync.com/integrations/clickhouse-and-greenhouse) - [ClickHouse and Hibob](https://www.stacksync.com/integrations/clickhouse-and-hibob) - [ClickHouse and Jobvite](https://www.stacksync.com/integrations/clickhouse-and-jobvite) - [ClickHouse and Lever](https://www.stacksync.com/integrations/clickhouse-and-lever) - [ClickHouse and Namely](https://www.stacksync.com/integrations/clickhouse-and-namely) - [ClickHouse and Oracle Fusion Cloud HCM](https://www.stacksync.com/integrations/clickhouse-and-oracle-fusion-cloud-hcm) - [ClickHouse and Paylocity](https://www.stacksync.com/integrations/clickhouse-and-paylocity) - [ClickHouse and SmartRecruiters](https://www.stacksync.com/integrations/clickhouse-and-smartrecruiters) - [ClickHouse and Success Factors](https://www.stacksync.com/integrations/clickhouse-and-success-factors) - [ClickHouse and UKG Pro](https://www.stacksync.com/integrations/clickhouse-and-ukg-pro) - [ClickHouse and UKG Ready](https://www.stacksync.com/integrations/clickhouse-and-ukg-ready) ### Marketing · 9 - [ClickHouse and Bingads](https://www.stacksync.com/integrations/bingads-and-clickhouse) - [ClickHouse and Cvent](https://www.stacksync.com/integrations/clickhouse-and-cvent) - [ClickHouse and Demandbase](https://www.stacksync.com/integrations/clickhouse-and-demandbase) - [ClickHouse and Eloqua](https://www.stacksync.com/integrations/clickhouse-and-eloqua) - [ClickHouse and Iterable](https://www.stacksync.com/integrations/clickhouse-and-iterable) - [ClickHouse and Marketo](https://www.stacksync.com/integrations/clickhouse-and-marketo) - [ClickHouse and RollWorks](https://www.stacksync.com/integrations/clickhouse-and-rollworks) - [ClickHouse and Salesforce Marketing Cloud](https://www.stacksync.com/integrations/clickhouse-and-salesforce-marketing-cloud) - [ClickHouse and Twitter Ads](https://www.stacksync.com/integrations/clickhouse-and-twitter-ads) ### Security and identity · 6 - [ClickHouse and Active Directory](https://www.stacksync.com/integrations/active-directory-and-clickhouse) - [ClickHouse and Auth0](https://www.stacksync.com/integrations/auth0-and-clickhouse) - [ClickHouse and Azure Active Directory](https://www.stacksync.com/integrations/azure-active-directory-and-clickhouse) - [ClickHouse and JumpCloud](https://www.stacksync.com/integrations/clickhouse-and-jumpcloud) - [ClickHouse and Okta](https://www.stacksync.com/integrations/clickhouse-and-okta) - [ClickHouse and OneLogin](https://www.stacksync.com/integrations/clickhouse-and-onelogin) ### Storage · 4 - [ClickHouse and Amazon S3](https://www.stacksync.com/integrations/amazon-s3-and-clickhouse) - [ClickHouse and Box](https://www.stacksync.com/integrations/box-and-clickhouse) - [ClickHouse and Egnyte](https://www.stacksync.com/integrations/clickhouse-and-egnyte) - [ClickHouse and SharePoint](https://www.stacksync.com/integrations/clickhouse-and-sharepoint) SECURITY ## Security teams trust Stacksync As a data company, we understand the importance of keeping your data secure. Stacksync is built with security best practices to keep your data safe at every layer, and is DPF-certified for US, EU, UK and CH data transfers. [Learn more about security](https://www.stacksync.com/security) | | | | --- | --- | | | SOC 2 Type II | | | ISO 27001 | | | HIPAA BAA | | | GDPR | | | CCPA | | | DPF US-EU-UK-CH | → SECURITY WITH BENEFITS ### SSO & SCIM Let your users access Stacksync from your centralized user management systems. Works with Okta, Azure, Google SSO and more. ### Alerts Immediately get alerted about record syncing issues over email, Slack, PagerDuty and WhatsApp. Resolve issues from a centralized dashboard with retry and revert options. ### Secure connection options Securely connects to your systems with: [OAuth 2](https://www.stacksync.com/security) [SSH Tunnelling](https://docs.stacksync.com/two-way-sync/connectors/setup-options/ssh-tunneling) [SSL certificates](https://docs.stacksync.com/two-way-sync/connectors/postgres/authorize-postgres/amazon-rds/ensuring-secure-rds-connections-with-ssl-certificate) [IP Whitelisting](https://docs.stacksync.com/two-way-sync/connectors/setup-options/ip-whitelisting) [VPN gateway](https://docs.stacksync.com/two-way-sync/legal/service-consumption-tables#:~:text=%E2%9C%93-,VPN%20gateway,-%2D) [VPC peering](https://www.stacksync.com/security) and more ## Connect the systems your business runs on. Build your next workflow with Stacksync. [Book a demo](https://www.stacksync.com/book-a-demo) [Get started](https://app.stacksync.com/)