What users are saying about

Actian Matrix

3 Ratings
Score 8.6 out of 101

Db2 Warehouse on Cloud

2 Ratings
Score 7.1 out of 101

Add comparison

Likelihood to Recommend

Actian Matrix

[Actian Matrix is well suited for:]1. Power user who wants to derive aggregate metrics by joining huge dataset.2. Batch load where you have to load billion of records very fast (copy command).3. Scenario where you want to do ELT because your ETL tool cannot handle huge volume of data.
Dipankar Pradhan profile photo

Db2 Warehouse on Cloud

IBM dashDB's ability to store and provide fast access to data both on-premise and in the cloud makes it best-of-breed when it comes to implementation flexibility. All the while you can have one data solution that pulls data together from Hyperion Planning (Oracle) and Microsoft Dynamics (MM) into the same system as part of an EDW project.
No photo available

Pros

  • Super fast. Aggregate query such as SUM(), Count() returns result within seconds from a table with more than billion records.
  • Excellent data compression.
  • Easy maintenance. We managed this database without having a full time DBA.
  • Support ANSI SQL and ODBC/JDBC. It's easy to connect to this database from other systems.
Dipankar Pradhan profile photo
  • You can size dashDB to your current needs and expand its capability later on as the needed.
  • I like the way dashDB allow for connecting to the cloud that my network engineer to set things up quickly.
  • IBM dashDB's ability to store and provide fast access to data both on-premise and in the cloud makes it a real winner for me.
No photo available

Cons

  • Dashboard for Admin instead of a linux console.
  • Admin with ability to kill inactive sessions when sessions reaches to more than allowed sessions. We ended up restarting the database.
  • Ability to easily scale up database by adding extra node.
  • Better support from Actian.
Dipankar Pradhan profile photo
  • IBM dashDB could be clearer about the technology used to deliver the particular tier of the service you buy.
  • IBM dashDB can be cost prohibitive for folks needing to push a lot of data from on-premise into the cloud on a regular basis.
  • IBM dashDB is really like three data technologies in one and the sales teams at IBM sometimes can't explain why the MPP tier is better for certain uses over the db2 BLU based tier.
No photo available

Usability

Actian Matrix6.0
Based on 1 answer
I wish to give higher rating for the speed and efficiency in handling the queries, but only 6 because of consistent bugs we encounter
No photo available
No score
No answers yet
No answers on this topic

Support

Actian Matrix8.0
Based on 1 answer
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
No photo available
No score
No answers yet
No answers on this topic

Implementation

Actian Matrix6.0
Based on 1 answer
Leader failover setup is the toughest and lack of proper documentation is making things tough.
No photo available
No score
No answers yet
No answers on this topic

Alternatives Considered

Actian Matrix is our first big data analytics storage platform, and as I was not involved in the POC process to compare it to other products out on the market, unfortunately I cannot say if it is better than other Big Data storage options. I can say that it out performs products such as Oracle or UDB in regards to the volume of data it can easily index and handle.
No photo available
IBM dashDB stacks up well against both on-premise (SQL Server and DB2), but it was a tough choice to go with over AzureDB. Ultimately, the deep discount by IBM led us to go with dashDB with the understanding that we could back out of the technology at a later date.
No photo available

Collaboration and Sharing

No score
No answers yet
No answers on this topic
Db2 Warehouse on Cloud8.0
Based on 1 answer
IBM dashDB fits well into a shop with IBM DB2 experience. Specifically, the experience with the IBM developer tools helps aid in the adoption of dashDB across teams and project.
No photo available

Data Integration

No score
No answers yet
No answers on this topic
Db2 Warehouse on Cloud9.0
Based on 1 answer
The connectivity to IBM dashDB was based on the tried a true technology used by IBM DB2 and did not have to be reviewed by our IPSec team prior to use.
No photo available

Return on Investment

  • I cannot comment on the specific numbers, all I can say is that switching to the backend greatly improved our processing speed. The more we process through our systems, the more clients we can serve. Which should bump ROI.
No photo available
No answers on this topic

Screenshots

Pricing Details

Actian Matrix

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Actian Matrix Editions & Modules
Actian Matrix
Additional Pricing Details

Db2 Warehouse on Cloud

General
Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No
Db2 Warehouse on Cloud Editions & Modules
Db2 Warehouse on Cloud
Edition
dashDB Entry
50 / month1
dashDB Enterprise
Varies
dashDB Enterprise MPP
Varies
dashDB Entry (Free)
$03
1. Per instance
3. Up to 50 GB
Additional Pricing Details