> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-trino-dialect.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Using a third-party ETL tool

> Page describing how to use a third-party ETL tool with ClickHouse

export const Image = ({img, alt, size = "lg", background}) => {
  const normalizedSize = ["sm", "md", "lg"].includes(size) ? size : "lg";
  const backgroundColor = background === "white" ? "white" : background === "black" ? "rgb(31 31 28)" : undefined;
  return <div className={`ch-image-${normalizedSize}`}>
      <Frame>
        <img src={img} alt={alt} style={{
    backgroundColor
  }} />
      </Frame>
    </div>;
};

A great option for moving data from an external data source into ClickHouse is to use one of the many popular ETL and ELT. We have docs that cover the following:

* [Airbyte](/integrations/connectors/data-ingestion/etl-tools/airbyte-and-clickhouse)
* [dbt](/integrations/connectors/data-ingestion/etl-tools/dbt/index)
* [Vector](/integrations/connectors/data-ingestion/etl-tools/vector-to-clickhouse)

But there are many other ETL/ELT tools that integrate with ClickHouse, so check your favorite tool's documentation for details.

<Image img="https://mintcdn.com/private-7c7dfe99-trino-dialect/P37Ln6i-rM2atqdZ/images/integrations/migration/third-party-01.webp?fit=max&auto=format&n=P37Ln6i-rM2atqdZ&q=85&s=51f8f83a04de274aaf3d69daa465b5bd" size="lg" alt="Migrating Self-managed ClickHouse" width="2048" height="456" data-path="images/integrations/migration/third-party-01.webp" />