Skip to main content

Aiven for ClickHouse® data service integration

Aiven for ClickHouse® supports different types of integration allowing you to efficiently connect with other services or data sources and access the data to be processed.

There are a few ways of classifying integration types supported in Aiven for ClickHouse:

Observability integrations vs data source integrations

Aiven for ClickHouse supports observability integrations and data source integrations, which have different purposes:

  • Observability integration is connecting to other services (either Aiven-managed or external ones) to expose and process logs and metrics.

  • Data service integration is connecting to other services (either Aiven-managed or external) to use them as data sources. In Aiven for ClickHouse, data service integration is possible with the following data source types:

    • Apache Kafka®
    • PostgreSQL®
    • MySQL®
    • ClickHouse®
    • Amazon S3®

Integrations between Aiven-managed services vs external integrations

By enabling data service integrations, you create streaming data pipelines across services. Depending on where the services are located, you can have either integrations between Aiven-managed services or external integrations (between an Aiven service and an external data source or application).

For integrating with external data sources, Aiven for ClickHouse provides two types of data service integrations:

Managed credentials integration

The managed credentials integration uses the ClickHouse named collections logic. It allows storing key-value pairs that are to be used as credentials when connecting to external data sources. To integrate data, you create tables using table engines. With the managed credentials integration enabled, querying the data is easier and quicker since you no longer need connections parameters in each query. They are stored and available from credential storage in Aiven.

Managed credentials integration in Aiven for ClickHouse is supported with the following data source types:

  • PostgreSQL®
  • MySQL®
  • ClickHouse®
  • Amazon S3®
important

The managed credentials integration works one-way: It allows to integrate with data source and access your data from Aiven for ClickHouse, but it doesn’t allow to access Aiven for ClickHouse data from the integrated data source.

For information on how table engines work in Aiven for ClickHouse services, preview Engines: database and table. For the list of table engines available in Aiven for ClickHouse, check Supported table engines.

Managed databases integration

The managed databases integration allows using a database engine for handling your external data. When enabled, this type of integration provides you with an automatically created database, where the remote data is exposed.

Managed databases integration in Aiven for ClickHouse is supported with the following data source types:

  • PostgreSQL®
  • Apache Kafka®

For information on how database engines work in Aiven for ClickHouse services, preview Engines: database and table. For more information on ClickHouse database engines, see Database engines.

Supported data source types

Depending on a data source type, Aiven for ClickHouse supports different integration modes.

Data source typeData source integration
(with Aiven service
or external source)
Managed databases integrationManaged credentials integration
PostgreSQL
MySQL
Apache Kafka
ClickHouse
Amazon S3