What users are saying about
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
8 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 7.6 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

IBM Db2 Warehouse

DB2 is better suited for OLTP workloadsIt can get better for OLAP workloadsScaling is flexible, HA and DR options are also good.Admin will have controls to stop and start warehouse and spark clusters. Replication is another critical element.Stored Procedure is located in IDAX, some of the useful procs are Decision tree, K-mean clustering, linear regression, Naive Bayes, random sampling, regression tree. SQL's are supported, SQL statements are executed in the database manager
Sathish Palanivel(He/Him) | TrustRadius Reviewer

Pros

Actian Avalanche

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

IBM Db2 Warehouse

  • ACID compliant
  • Good for transaction like work load
  • Suitable for continuous small amount of loads
Sathish Palanivel(He/Him) | 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

IBM Db2 Warehouse

  • handling more volume use changes
  • concurrent users
Sathish Palanivel(He/Him) | TrustRadius Reviewer

Alternatives Considered

Actian Avalanche

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

IBM Db2 Warehouse

Db2 Warehouse provided more flexibility than another tool in the market for a hybrid solution. The ability to integrate with Oracle also was one of the useful features for our business case.
Sathish Palanivel(He/Him) | 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

IBM Db2 Warehouse

No answers on this topic

Pricing Details

Actian Avalanche

General

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

IBM Db2 Warehouse

General

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

Add comparison