Try our new research platform with insights from 80,000+ expert users

Actian Ingres vs SAP BW4HANA comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Actian Ingres
Ranking in Data Warehouse
18th
Average Rating
8.6
Reviews Sentiment
7.9
Number of Reviews
2
Ranking in other categories
Relational Databases Tools (26th)
SAP BW4HANA
Ranking in Data Warehouse
8th
Average Rating
7.6
Reviews Sentiment
6.4
Number of Reviews
44
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of January 2026, in the Data Warehouse category, the mindshare of Actian Ingres is 1.8%, up from 0.6% compared to the previous year. The mindshare of SAP BW4HANA is 3.7%, down from 4.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse Market Share Distribution
ProductMarket Share (%)
SAP BW4HANA3.7%
Actian Ingres1.8%
Other94.5%
Data Warehouse
 

Featured Reviews

GH
Sr Sales Engineer at a tech vendor with 10,001+ employees
Reliable performance enhances operations with good technical support
We run the entire IRS system, the income system, and the tax system. We also manage the entire Absa banking system in Africa. There's a lot of database applications, similar to those used in banks and the IRS The most valuable features for us are reliability and performance. Our system is used…
HP
SAP Analytics Lead at Miracle Software Systems, Inc
Support and pricing challenges overshadow user expertise
In SAP BW4HANA, I have worked in modeling, extraction, and reporting. I have experience with different tools including Power BI, BEx tools, Web Intelligence reports, and SSC. The best features include the ability to create data sources directly on tables, and perform mapping without creating info objects. It directly maps to target fields and source fields. There is no info cube concept, only ODS concept. We can create BEx queries in HANA itself, not as a separate tool. The modeling and reporting processes are easier to accomplish.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable features for us are reliability and performance."
"The deployment of our solution across a number of servers using Ingres .NET has meant that we can protect the database server behind a highly secure firewall and deploy the front end solutions on a normal web server."
"We benefited from BW/4HANA's ability to utilize predefined content inside. We didn't need to start from scratch."
"Some of the main features of this solution are that it uses HANA and it has good performance."
"The processes are the most valuable aspect of this solution."
"The solution is based on SAP ERP, so there's some business content already included. For customers who use SAP ERP, SAP BW4HANA is a good choice for their DW implementation."
"The most valuable feature is that it's robust."
"Its direct approach is the most valuable. You get more real time and capabilities than BW."
"Technology-wise, it is a very robust tool."
"I like the reporting features of the solution."
 

Cons

"The seamless integration is a bit of an issue."
"The ability to reset the log file without stopping the DBMS would be helpful for us."
"It's complicated to use. You need to spend a lot of time learning about it. The interface could be improved. It's not intuitive to build a data model and use their ETL tools."
"The UI is not user-friendly."
"The tool is not easy to use for an end user."
"Connecting multiple sources is a challenge because you have to go through a lot of different setups."
"The tool is not cloud-compatible."
"BW/4HANA could improve query optimization. For example, there could be an error message that pops up when you hover over it if any query fails. That would make it easier to find out what went gone wrong. Guided SAP help tools would make it easier for us to go forward."
"They have taken out a few BW functionalities when they redesigned this. The way of multi-dimensional thinking and star schema got a little bit lost. It may be because of the cost, but certain functionalities that were previously implemented from the BW side should come back again in the whole product. It is a young product. It is version 2.0. In time, I'm pretty sure they will come back again because otherwise, it limits the potential of the product, and I have to do a lot of modeling towards that direction. For me, the analytics focus is too much. It is not cube-oriented in that way, so its functionality is limited. It is not really technically limited in the back end; it is more limited in the front end. It has a data-mining mindset for SQL developers. The navigational attributes should be easy. It needs to be built in models. I see the data mark cube or understanding that the composite provider needs to be models in a cube coming back. The multi-dimensional star schema approach and the reporting need to be done as well as possible to leverage the star scheme below. This is definitely not understood by many consultants and even composite providers for star schema. They always think in terms of flat tables, which is limiting. You need to build the right dimensions, objects, and so on. If you can build this in BW4HANA, then you have this understanding that BW4HANA is not forcing you in this direction, but it should force you a bit better in this direction. Maybe a few elements which were in use in BW should come back again. It would help the community to determine the direction to build on the cube. You can have maybe 50 elements, and then you can expand it to what you need by leveraging navigation. So far, this functionality is a little bit limited in the tool, and it is not thought through, but I think it will come. They should also be adding more capabilities for the transformation between different objects. In BW, this is currently limited, especially towards composite providers. It is a bit complex basically in the building. You have to have a lot of knowledge as well as know how to do it better because it is a bit different from BW. There is not too much expertise currently in the consulting markets. Many are trying to build something, but it may be based on their knowledge of what they have from the BW and HANA side. You have to find the right mix from both of them at this time. We also have HANA Native. These are our two different sync sources basically, and we have approaches to connect nicely, but it is hard to manage your team because a lot of coaching is required."
"The integration with AI/ML in SAP BW4HANA is currently very limited, which is definitely an area that needs improvement."
 

Pricing and Cost Advice

Information not available
"We started as early birds from the SAP side. We got this entire suite for free. I cannot really talk about the price because we didn't have to pay anything."
"This is an expensive solution and there are costs in addition to the standard licensing fees."
"The SAP HANA application still hasn't been leveraged to the fullest extent, but it's a five-year enterprise license."
"The tool is affordable."
"As an investment, the solution is very expensive."
"For some, the rates offered by SAP can be costly while for others it may seem cheap. The price ultimately depends on how you have negotiated your contract with SAP."
"The price is high and currently only affordable for large organizations."
"The solution is expensive."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
881,082 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
18%
Outsourcing Company
9%
Manufacturing Company
9%
Legal Firm
7%
Manufacturing Company
14%
Retailer
11%
Financial Services Firm
11%
Computer Software Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise4
Large Enterprise29
 

Questions from the Community

What needs improvement with Actian Ingres?
The seamless integration is a bit of an issue. I would like to see more direct connectors and stuff like SQLAlchemy. It's there but isn't available as a standard, so it involves going to GitHub to ...
What is your primary use case for Actian Ingres?
We run the entire IRS system, the income system, and the tax system. We also manage the entire Absa banking system in Africa. There's a lot of database applications, similar to those used in banks ...
What is your experience regarding pricing and costs for Actian Ingres?
Initially, it's a lot less expensive than competitors. Price performance has always been a priority, ensuring we remain competitive in the market.
What do you like most about SAP BW4HANA?
One significant advantage of SAP BW/4HANA is the direct integration with the SAP HANA database, providing seamless access to real-time analytics. Additionally, it enables real-time data integrati...
What needs improvement with SAP BW4HANA?
The integration with AI/ML in SAP BW4HANA is currently very limited, which is definitely an area that needs improvement. The second area for improvement is integration with third-party systems, whi...
 

Comparisons

 

Also Known As

Ingres, Ingres 2006
SAP BW/4HANA
 

Overview

 

Sample Customers

Groupe Adeo, IsCool Entertainment
Information Not Available
Find out what your peers are saying about Actian Ingres vs. SAP BW4HANA and other solutions. Updated: December 2025.
881,082 professionals have used our research since 2012.