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

Actian Ingres vs Amazon Redshift comparison

 

Comparison Buyer's Guide

Executive Summary

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
Average Rating
8.6
Reviews Sentiment
7.9
Number of Reviews
2
Ranking in other categories
Relational Databases Tools (27th), Data Warehouse (16th)
Amazon Redshift
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
70
Ranking in other categories
Cloud Data Warehouse (5th)
 

Featured Reviews

GH
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…
Ved Prakash Yadav - PeerSpot reviewer
Works as a data warehouse system and collects data from different sources
In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic. We often encounter issues like someone dropping a column or changing the order of columns, which can cause synchronization problems when pushing data through our pipeline. It's a minor issue, but it can be annoying.

Quotes from Members

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

Pros

"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."
"The most valuable features for us are reliability and performance."
"Setup is easy. It's a fast solution with machine learning features, good integration, and a good API."
"Its simplicity in configuration, cost-effectiveness due to being in the cloud and close to our data sources, and the fact that it's a managed service that is scalable and reliable are highly valuable."
"Easy to build out our snowflake design and load data."
"The most valuable feature of Redshift is its cluster."
"Redshift's Excel features are handy. Redshift spectrum allows you to directly query the data on an Excel sheet. Now, SQL Server also allows this, but Redshift has many more features."
"It is quite simple to use and there are no issues with creating the tables."
"It's scalable because it's on the cloud."
"Has a very user-friendly SQL editor and it's very easy to use the connectors."
 

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."
"Migrating data from other data sources can be challenging when you are working with multibyte character sets."
"In our experiments, the handling of unstructured data was not very smooth."
"There is some missing functionality and sometimes it's so difficult to work in. We need to convert these functionalities using VACUUM inside Amazon Redshift and then it causes some complexity."
"Amazon Redshift does not have the capability to dynamically increase the VM file."
"The initial deployment was complex."
"The initial setup is a complex process, especially for someone who is not familiar with nodes and configuring terms like RPUs."
"It would be good to see Redshift as a serverless offering."
"There might be some limitations from a business intelligence perspective, but nothing we can't find a workaround for."
 

Pricing and Cost Advice

Information not available
"Amazon Redshift is an expensive solution. Larger organizations can afford this solution, but smaller businesses would struggle to afford it."
"Redshift is very cost effective for a cloud based solution if you need to scale it a lot. For smaller data sizes, I would think about using other products."
"In comparison to the price of similar solutions, Redshift's cost is the lowest."
"My customers have implementations that cost about $500 a month for a very small one. I also have a customer with a monthly invoice of about $25,000 USD."
"The price of the solution is reasonable. According to the RA3 cluster particularly, it provides 128 GB of storage with only four nodes. If you can manage your computations processes with the help of materialized views and proper queries. I think the IP clusters are very useful and overall fair for the price."
"The solution is available at a mid-range price compared to other vendors."
"The part that I like best is that you only pay for what you are using."
"The cost must be improved."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
850,028 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Government
11%
University
9%
Insurance Company
9%
Educational Organization
61%
Financial Services Firm
7%
Computer Software Company
6%
Manufacturing Company
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

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.
How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Amazon Redshift?
The tool's most valuable feature is its parallel processing capability. It can handle massive amounts of data, even when pushing hundreds of terabytes, and its scaling capabilities are good.
 

Also Known As

Ingres, Ingres 2006
No data available
 

Overview

 

Sample Customers

Groupe Adeo, IsCool Entertainment
Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
Find out what your peers are saying about Actian Ingres vs. Amazon Redshift and other solutions. Updated: April 2025.
850,028 professionals have used our research since 2012.