What users are saying about
4 Ratings
16 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.1 out of 100
4 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.4 out of 100

Likelihood to Recommend

Actian Avalanche

This is a tool geared for smaller to mid-sized business that has disparate sources of data from different platforms in varying incarnations. It’s a great ETL tool to solve the problems a scenario like that causes, but you can also achieve that with good BI Tools like Qlik Sense. So be careful that you really need an ETL tool, as opposed to an end-use tool with a built-in ETL component. If you are going ELT and have a lot of data an not a lot of corporate resources, this is a better option than Microsoft or Informatica
Anonymous | TrustRadius Reviewer

ClickHouse

The most important thing when using ClickHouse is to be clear that the scenarios in which you want to use it really are the right ones. Many users think that when a database is very fast for a specific use case, it can be extrapolated to other contexts (most of the time different) in which a previous analysis has not been carried out.
ClickHouse is an analytical database, as such, it should be used for such purposes, where the information is stored correctly, the data volumes are really large and the queries to be performed are not the typical traditional queries on several columns with multiple aggregations. ClickHouse is not the solution for this.
On the other hand, if your case is not one of the above, it is quite possible that ClickHouse can help you. Where ClickHouse shines is when you are looking for aggregation over a particular column in large volumes of data.
Anonymous | TrustRadius Reviewer

Pros

Actian Avalanche

  • Quick response for queries involving multi-million rows
  • Low cost
Anonymous | TrustRadius Reviewer

ClickHouse

  • Opensource
  • High performance
  • Multiple engines to adapt user cases
  • Easy configuration of data replication
Anonymous | TrustRadius Reviewer

Cons

Actian Avalanche

  • As I said before, more training or greater visibility to training tools/options would be a plus. It’s easy to publish YouTube videos these days, I think they should make more of them.
  • Differentiation would help, there’s not a lot out there to drive you to buy the product if you are well informed in the market. If you know the market, you steer towards the large or trendy products. It’s a good product, but lost in the noise of the field I think.
  • Hitching the wagon to a major software brand (like Mule did to Salesforce) would help grow the user base, and thus increase the activity in the support community. More users also translates into product champions.
Anonymous | TrustRadius Reviewer

ClickHouse

  • Avro data manipulation
  • Kafka consistency
  • DDL operations errors (by replica configuration)
Anonymous | TrustRadius Reviewer

Alternatives Considered

Actian Avalanche

Oracle>DB2>MS SQL Server>GreenPlum>Vectorwise
Anonymous | TrustRadius Reviewer

ClickHouse

ClickHouse was not compared to them as a competitor but as the ideal partner to complete an information analysis system, providing users with the most complete and efficient tools. Therefore, in this case it was considered that it would be the ideal candidate due to its characteristics compared to the other competitors.
Anonymous | TrustRadius Reviewer

Return on Investment

Actian Avalanche

  • We had to move out of VectorWise after using the database for 2 years. Hence no positive impacts.
Anonymous | TrustRadius Reviewer

ClickHouse

  • Queries that used to take more than 2 minutes now take less than 1 second
  • Possibility to analyze use cases in real time (before was impossible)
  • The applications are more complete and the users decisions are better
Anonymous | TrustRadius Reviewer

Screenshots

ClickHouse

Pricing Details

Actian Avalanche

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
Optional

ClickHouse

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison