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

Likelihood to Recommend

Actian Matrix (discontinued)

Actian matrix is not good for small data sets. If you have a limited data pool, or do not plan on having multiple users/clients accessing a data source, stick with a more traditional relational database model - Access for the truly small user base, or a DB2 or Oracle back end if your going to have multiple users, and moderate sized data. Actian is for LARGE data sets (Big Data, in the industry parlance). Millions of rows of data from multiple sources with various down stream systems accessing the database. It is for data analytics of large data groups and intense data mining.
Anonymous | TrustRadius Reviewer

SAP BW

SAP BW is best for:1. Large enterprises2. Enterprises with 3+ legacy systems with entrenched users (politically difficult to merge)3. Enterprises with employees who can understand both the technical capabilities of SAP BW and the needs of the business users - ability to speak both languages, otherwise the program could be unwieldy and potentially underutilized (it's not particularly inexpensive)SAP BW is less appropriate for:1. Small enterprises2. Enterprises who have well established, same location, CRM and UFS - the integration of data analysis will be easier and less expensive with other solutions3. HANA
Jeff Looby, CPA | TrustRadius Reviewer

Pros

Actian Matrix (discontinued)

  • 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 | TrustRadius Reviewer

SAP BW

  • it has the best availability tool for generating different reports like Bex analyzer
  • different data models like sementic data model for different data management systems
  • can easily integrate and generate the reports from different sources like XML file uploading, 3rd party data sources etc...
Pradeep Bele | TrustRadius Reviewer

Cons

Actian Matrix (discontinued)

  • Some of the bugs were annoying and QA definitely needs improvement
  • Connectivity to Informatica and ETL providers
  • Workload management could be better like when you compare with Teradata
Anonymous | TrustRadius Reviewer

SAP BW

  • I wish it could hold a part where even though it is not in use yet, but you know you will need it, it won't allow it to be checked it rather than put on backorder.
  • Some of the menu paths can be a little difficult to remember or follow.
  • It is not easy for a novice user to go in and create a report quickly.
Brandi Brown-Lang | TrustRadius Reviewer

Usability

Actian Matrix (discontinued)

Actian Matrix (discontinued) 6.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
Anonymous | TrustRadius Reviewer

SAP BW

SAP BW 9.0
Based on 1 answer
It basically stores all data I need in designed reports, which helps a lot with the analysis and calculation.It's quite interactive when you understand reports and know how to drill-down/swap. Fresh users might need some training. There are quite a lot of options to display data differently, or to add more filters in data as well as to extract the data in xlsx/csv/html format.
Anonymous | TrustRadius Reviewer

Support Rating

Actian Matrix (discontinued)

Actian Matrix (discontinued) 8.0
Based on 2 answers
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
Anonymous | TrustRadius Reviewer

SAP BW

SAP BW 8.0
Based on 4 answers
SAP BW is a consolidated tool. There are thousands of SAP notes in order to solve your problems and in case do not exist, SAP support will help you on the issue you face.
Anonymous | TrustRadius Reviewer

Implementation Rating

Actian Matrix (discontinued)

Actian Matrix (discontinued) 6.0
Based on 2 answers
Leader failover setup is the toughest and lack of proper documentation is making things tough.
Anonymous | TrustRadius Reviewer

SAP BW

No score
No answers yet
No answers on this topic

Alternatives Considered

Actian Matrix (discontinued)

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.
Anonymous | TrustRadius Reviewer

SAP BW

SAP Business Warehouse scores higher in data warehouse functionalities for integration to SAP ERP and other SAP solutions such as SAP CRM, SAP APO, and SAP SRM. Standard SAP data source extractors which are available in SAP ERP can be used immediately for full or delta replication into SAP Business Warehouse. System governance in SAP Business Warehouse is top-notch with change management support for migration between system landscape from the development system to production system.
Julius Shen | TrustRadius Reviewer

Return on Investment

Actian Matrix (discontinued)

  • ROI is great, less spending on full time DBA and that money could be use to add additional node.
  • Negative - Not many developers are well aware of this tool, it takes some time to learn.
Dipankar Pradhan | TrustRadius Reviewer

SAP BW

  • The positive Return on Investment we receive with the software was the ability to import decades of data. We were then able to review the materials see trends we were previously unable to see without intense work.
  • The only negative impact was applying the training and changing procedures to deal with the software. This worked out, obviously, because this is not a software to be using without proper training.
Alfred Brock | TrustRadius Reviewer

Pricing Details

Actian Matrix (discontinued)

General

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

SAP BW

General

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

Add comparison