We performed a comparison between Actian Ingres and Amazon Redshift based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."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."
"Redshift COPY command, because much of my work involved helping customers migrate large amounts of data into Redshift."
"The solution is scalable. It handles different loads very well."
"The ability to reload data multiple times at different times."
"The product offers good support for the data lake."
"I like the cost-benefit ratio, meaning that it is as easy to use as it is powerful and well-performing."
"I like it because the usage is very similar to Microsoft SQL server. The structure of the query and the temporary tables are very similar."
"If the analyst knows SQL, which is comfortable and easy to use to go between all of these tool stacks, I think it's reliable. It's a secure and reliable data warehouse."
"Has a very user-friendly SQL editor and it's very easy to use the connectors."
"The ability to reset the log file without stopping the DBMS would be helpful for us."
"The explain panel in the Redshift database could be better."
"Improvement could be made in the area of streaming data."
"One area where Amazon Redshift could improve is in adopting the compute-separate, data-separate architecture, which Delta, Snowflake are adopting, and a few others in the cloud data warehouse spectrum."
"The initial deployment was complex."
"The solution has four maintenance windows so, when it comes to stability, I think it would be better to decrease their number."
"The technical support should be better in terms of their knowledge, and they should be more customer-friendly."
"The solution could improve in handling more data formats and more native support for RDF."
"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."
Earn 20 points
Actian Ingres is ranked 22nd in Data Warehouse while Amazon Redshift is ranked 4th in Cloud Data Warehouse with 57 reviews. Actian Ingres is rated 9.0, while Amazon Redshift is rated 7.8. The top reviewer of Actian Ingres writes "Good multi-platform SQL compatibility, as well as performance and data integrity". On the other hand, the top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". Actian Ingres is most compared with Oracle Database Appliance, Snowflake, Databricks and Teradata, whereas Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Microsoft Azure Synapse Analytics, Vertica and Teradata.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.