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

Actian Ingres vs Oracle Autonomous Data Warehouse 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)
Oracle Autonomous Data Ware...
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
19
Ranking in other categories
Cloud Data Warehouse (10th)
 

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…
Miodrag Milojevic - PeerSpot reviewer
A tool for data warehousing that offers scalability, stability, and ease of setup
The initial setup of Oracle Autonomous Data Warehouse is easy and basic, especially if one doesn't use the tricks to get Oracle Exadata for use. One doesn't need to know or be involved in technical stuff to do the setup since, at the least, knowledge might be required when working with some external connections, but it is easy because everything can be done within a couple of clicks. The solution is deployed on the cloud. For deployment, you don't need any technical guidance since you can sit, find it on the web, and prepare an Oracle Autonomous Data Warehouse platform by yourself for free for a limited time. The people needed for the deployment and maintenance depend on the implementation one wants. If you do a simple implementation, you don't need anybody for maintenance since everything is on the cloud. You only have to schedule your backup or see if Oracle can schedule a backup, and you don't take care of the backup. For some more sophisticated or technical implementations, you will need staff for some data warehouse except for some parts of the maintenance like backup, patches, or upgrades since these are a few things you take care of in the background, and you only seek help with the maintenance part, if needed.

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."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"The solution is used for analytics and it works for our data security needs."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"It is a very stable tool...It is an extremely scalable tool."
"The product has self-repair features."
"With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main reason we use it."
"A very good integration feature that restricts access to unauthorized people."
"The performance and scalability are awesome."
 

Cons

"The ability to reset the log file without stopping the DBMS would be helpful for us."
"The seamless integration is a bit of an issue."
"My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace."
"I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."
"The solution lacks visibility options."
"It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects."
"Ease of connectivity could be improved."
"The initial setup was pretty complex. It was not easy."
 

Pricing and Cost Advice

Information not available
"We pay approximately $70,000 per month. The cost includes maintenance and support."
"The licensing cost of the product can vary since you can integrate it very easily with other products or other cloud products...You pay as you use it, so it is not yearly or monthly payments to be made toward Oracle."
"Cloud solutions are cheaper, but in the long run, they may not be much cheaper. They certainly have a lower initial cost. The licensing is yearly, and it is based on the size of the hardware and the number of users."
"ROI is high."
"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"You pay as you go, and you don't pay for services that you don't use."
"The price depends on the configuration we choose."
"On a scale from one to ten, where one is a low price and ten is a high price, I rate the pricing an eight."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
846,617 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Government
11%
Educational Organization
9%
Insurance Company
9%
Educational Organization
47%
Financial Services Firm
8%
Computer Software Company
7%
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.
What do you like most about Oracle Autonomous Data Warehouse?
With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main...
What is your experience regarding pricing and costs for Oracle Autonomous Data Warehouse?
We pay approximately $70,000 per month. The cost includes maintenance and support.
What needs improvement with Oracle Autonomous Data Warehouse?
Optimization should be better. The SQLs are sometimes very slow. I also noticed that Java is not supported, which is not ideal.
 

Also Known As

Ingres, Ingres 2006
No data available
 

Overview

 

Sample Customers

Groupe Adeo, IsCool Entertainment
Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
Find out what your peers are saying about Actian Ingres vs. Oracle Autonomous Data Warehouse and other solutions. Updated: March 2025.
846,617 professionals have used our research since 2012.