What users are saying about

Actian Matrix

3 Ratings

QlikView

543 Ratings

Actian Matrix

3 Ratings
Score 8.6 out of 101

QlikView

543 Ratings
Score 7.7 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

QlikView

QlikView is well suited for scenarios where a heavy data is involved or heterogeneous data is there which also requires some manipulation/ cleansing or application of business rules. Also, if the UI dashboard involves complicated formulas to be worked upon, QlikView is well suited.However, if there is a need to quickly create some dashboards where the developer has little knowledge on database/ scripting and also there is no data manipulation required for input data, other technologies other than QlikView can be considered.
No photo available

Feature Rating Comparison

BI Standard Reporting

Actian Matrix
QlikView
7.3
Pixel Perfect reports
Actian Matrix
QlikView
7.1
Customizable dashboards
Actian Matrix
QlikView
8.3
Report Formatting Templates
Actian Matrix
QlikView
6.3

Ad-hoc Reporting

Actian Matrix
QlikView
7.2
Drill-down analysis
Actian Matrix
QlikView
6.6
Formatting capabilities
Actian Matrix
QlikView
6.9
Integration with R or other statistical packages
Actian Matrix
QlikView
8.7
Report sharing and collaboration
Actian Matrix
QlikView
6.6

Report Output and Scheduling

Actian Matrix
QlikView
6.9
Publish to Web
Actian Matrix
QlikView
6.5
Publish to PDF
Actian Matrix
QlikView
7.5
Report Versioning
Actian Matrix
QlikView
6.5
Report Delivery Scheduling
Actian Matrix
QlikView
7.2

Data Discovery and Visualization

Actian Matrix
QlikView
5.5
Pre-built visualization formats (heatmaps, scatter plots etc.)
Actian Matrix
QlikView
6.1
Location Analytics / Geographic Visualization
Actian Matrix
QlikView
3.6
Predictive Analytics
Actian Matrix
QlikView
6.8

Access Control and Security

Actian Matrix
QlikView
7.7
Multi-User Support (named login)
Actian Matrix
QlikView
7.6
Role-Based Security Model
Actian Matrix
QlikView
7.5
Multiple Access Permission Levels (Create, Read, Delete)
Actian Matrix
QlikView
7.9

Mobile Capabilities

Actian Matrix
QlikView
6.8
Responsive Design for Web Access
Actian Matrix
QlikView
8.0
Dedicated iOS Application
Actian Matrix
QlikView
5.2
Dedicated Android Application
Actian Matrix
QlikView
6.4
Dashboard / Report / Visualization Interactivity on Mobile
Actian Matrix
QlikView
7.8

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
  • QV's #1 strength is the drag and drop visualization tools -- with just a bit of training, you can make some really nice looking charts
  • QV's #2 strength is the simplicity of the filtering. Other SQL languages might call this "linking" or database structure ... which can be a pain.... but QV makes this easy. Further, once the data is inside QV, the ability to FILTER the data using check boxes is completely intuitive and simple.
  • QV's #3 strength is its ability to work across platforms and integrate multiple data sources and multiple types of data. QuickBooks data is just one example of something that it can chew up with ease.
David Worrell profile photo

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
  • Data must be properly structured to function within Qlikview. This applies to any in-memory tool, but it requires more effort than originally anticipated.
Robert Goodman profile photo

Likelihood to Renew

Actian Matrix6.0
Based on 1 answer
No answer on this topic is available.
QlikView8.8
Based on 29 answers
Qlikview is a solid tool for any organization looking for a in-memory dashboard tool.
Robert Goodman profile photo

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
QlikView9.8
Based on 6 answers
Once the data is loaded (which can range from simple to complex depending on the data set), it is relatively easy to create new charts/dashboards
Bill Chamberlain profile photo

Reliability and Availability

No score
No answers yet
No answers on this topic
QlikView9.8
Based on 4 answers
It is not a SAAS product.
No photo available

Performance

No score
No answers yet
No answers on this topic
QlikView8.6
Based on 4 answers
It is not a SAAS product.
No photo available

Support

Actian Matrix8.0
Based on 1 answer
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
No photo available
QlikView2.1
Based on 7 answers
They are still building it out. Just recently I received a contact for an escalation manager. I used to just call my sales guy.

Response times vary
No photo available

In-Person Training

No answers on this topic
My team attended, but I cannot myself rate, but I think it was good as they've successfully launched a training program at our company themselves for users. It was 3-4 day training.
No photo available

Online Training

No score
No answers yet
No answers on this topic
QlikView8.0
Based on 3 answers
Training was as expected. The demo environments tend to be more fully featured that our own environment, but the training was clear and well delivered.
Robert Goodman profile photo

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
QlikView7.4
Based on 13 answers
QlikView were here for a few days, and it was up and running. It was very fast.

Where it fell short, is they did the implementation in demo mode, and didn't initially work with us to help us scale. For example, should we consider a load balancer and multiple servers?. How much capacity can this environment handle from a data and user perspective. We had to learn on own by trial and error. We are bringing them in to do an architectural assessment, but we have to pay for this.

We are now bringing them back in for architectural assessment. It is a fee based engagement.
No photo available

Breadth of Deployment

No answers on this topic
Not applicable to our firm as we are small consulting firm.
Debbie Pyykkonen, MBA profile photo

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
Our shortlist included Tableau, a newer version of Microsoft's SSRS and Qlikview.

We also knew what Micro Strategies and Business Objects had to offer from our experiences with them at other companies, and knew what we could afford. We eliminated them on price and the complexity of set-up.

We liked QlikView's in memory, associative model, and self-service capability.

With "in-memory", everything that gets consumed from a dashboard is loaded in memory so it is incredibly fast. Although Qlik touts its mobile distribution capabilities, that was not a huge differentiator for us, but is something we are now exploring. Microsoft and and BO do have in-memory capabilities now.

The associative model is patented by QlikView. Basically it starts to understand the associations in your data, e.g. if A=B and B=C, then A=C. It means you can build a Qlikview model very quickly. In traditional data warehousing, you work with users and understand their requirements, refine the data model, start to physicalize it, tune it, build ETLs. It's a 3 month at best delivery cycle. That doesn’t work here at this company. Our business users will not wait for you. Our business is dynamic, we are launching new products all the time. Instead of going through an arduous process, you just load data into QlikView and build an associative model. It link things up. If it doesn’t work, you can change things very quickly. You don’t have to write data definitional language. Where you get into trouble, is if you load very large data sets into QlikView, memory not as abundant. They are releasing a tool called data explorer which allows you to do a hybrid approach – load some in memory and some in database. If data is going into frequently used dashboards it goes into memory. If infrequent access is required and the data set is very large, it makes sense to leave it in the database.

We also have a company called DataRoket that builds connectors for us, e.g. load this relational data into QlikView. They have built adapters for QlikView-Hadoop integration
No photo available

Collaboration and Sharing

No score
No answers yet
No answers on this topic
QlikView6.3
Based on 21 answers
It is easy enough to either share your screen to go over certain data with another team member. It's also easy to email the file to someone or export as multiple views. I like to export as a csv file and then format it to the key data we need for that campaign and then send over that data to a larger team and management to discuss
No photo available

Data Integration

No score
No answers yet
No answers on this topic
QlikView8.9
Based on 21 answers
Its strength lies in its ETL capabilities, it can connect to a variety of datasources both natively and to JDBC/ODBC
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
  • For us the investment value is related to the change in working practices and desire to share rich-content with our stakeholders.
  • QlikView is a good product and does what it says however the overhead of ad-hoc reporting remains.
No photo available

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

QlikView

General
Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional
QlikView Editions & Modules
QlikView
Edition
QlikView Desktop
Free1
QlikView
Custom2
1. Personal Edition
2. Per License
Additional Pricing Details
On an perpetual license basis, based on server plus number of users. Contact vendor for pricing.