Aiven Improves Access to Open Source Data Technologies with New ClickHouse Offering

Finnish company Aivenoffering open source data technologies in a managed avatar, today announced its entry into the cloud data warehousing segment with a new offering: Aiven for ClickHouse. The solution, currently in beta, allows enterprise developers to easily use ClickHouse’s open-source column-oriented DBMS (column database management system) for online analytic processing (OLAP) and generate reports using SQL queries in real time.

As a fast, resource-effective, open-source SQL data warehouse, ClickHouse has been adopted by companies across industries. The solution aims to match or even exceed the performance, maturity and scalability of proprietary databases. However, like all open source technologies, it can be time consuming to set up and manage, requiring specific expertise and resources for aspects such as cybersecurity and maintenance.

How Aiven comes to the rescue for ClickHouse

With Aiven for ClickHouse, enterprises can avoid hurdles and start leveraging the benefits of ClickHouse warehouse as a service in the cloud platform of their choice.

According to the company’s website, developers can use Aiven’s console (or API) to set up a fully managed ClickHouse data warehouse in less than 10 minutes. They can set up clusters, deploy new nodes, migrate between clouds (currently AWS and Google Cloud are supported), and fork databases with a few clicks — all while keeping an eye on everything from a simple dashboard.

This can easily save developers time and resources, allowing them to better focus on the core business of building applications.

The new offering also provides easy access to other open source data technologies in the Aiven console. For example, companies could integrate Aiven for Apache Kafka and Aiven for PostgreSQL as potential data sources. The former can stream data from multiple sources to ClickHouse for real-time analytics, while the latter can allow users to perform federated searches from ClickHouse for data on PostgreSQL without actually transferring it. Even Aiven for Grafana can be added to the loop to set up dashboards and visualize analytics results from ClickHouse.

“We give our customers the freedom of choice – their data is not tied to one vendor or system, but they can migrate from one cloud to another at the click of a button,” said Oskari Saarenmaa, co-founder and CEO of Aiven. told VentureBeat.

Open source technology offered

In total, Aiven provides fully managed services for 11 core open source projects: ClickHouse, Apache Kafka, M3, MySQL, Redis, InfluxDB, Apache Cassandra, PostgreSQL, Apache Flink, OpenSearch and Grafana. In addition, it keeps other open source projects such as Pghoard, a backup and recovery service for PostgreSQL. The platform provides all the necessary support for these technologies, from end-to-end security and maintenance to 24/7 monitoring.

“We are excited to introduce Aiven for ClickHouse beta to our customers and further democratize access to the best open source technologies,” said Heikki Nousiainen, CTO at Aiven.

“While our customers love our managed database offerings, such as PostgreSQL and MySQL, they need to incorporate data warehousing into their overall strategy as the data grows. ClickHouse offers the best performance and scalability to meet customer demand. With ClickHouse, we can now better support our customers in leveraging their data into actionable insights to increase revenue and overall productivity for their business,” he added.

To date, Aiven has raised $420 million in funding from Atomico, Earlybird, Eurazeo, IVP, Lifeline, Salesforce Ventures and World Innovation Lab. The company works with companies in a variety of industries and claims to have a number of high profile corporate clients such as Atlassian, Comcast and Toyota. The latest valuation was $3 billion.