Compare Actian Ingres vs. Snowflake

Cancel
You must select at least 2 products to compare!
Actian Ingres Logo
308 views|208 comparisons
Snowflake Logo
35,842 views|25,491 comparisons
Most Helpful Review
Find out what your peers are saying about Snowflake Computing, Oracle, Apache and others in Data Warehouse. Updated: July 2021.
522,693 professionals have used our research since 2012.
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."

More Actian Ingres Pros »

"As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes.""The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications.""They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises.""The initial setup is straightforward. You just need to follow the documentation.""The thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services.""It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL.""I like the idea that you can assign roles and responsibilities, limiting access to data.""The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes."

More Snowflake Pros »

Cons
"The ability to reset the log file without stopping the DBMS would be helpful for us."

More Actian Ingres Cons »

"There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source.""Support needs improvement, as it can take several days before you get some initial support.""The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template.""The solution could improve the user interface and add functionality to the system.""Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway.""They do have a native connector to connect with integration tools for loading data, but it would be much better to have the functionality built-in.""If you go with one cloud provider, you can't switch.""Availability is a problem."

More Snowflake Cons »

Pricing and Cost Advice
Information Not Available
"Pricing can be confusing for customers.""The whole licensing system is based on credit points. You can also make a license agreement with the company so that you buy credit points and then you use them. What you do not use in one year can be carried over to the next year.""You pay based on the data that you are storing in the data warehouse and there are no maintenance costs.""It is not cheap.""The pricing for Snowflake is competitive.""On average, with the number of queries that we run, we pay approximately $200 USD per month.""Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month.""The price of Snowflake is very reasonable."

More Snowflake Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
522,693 professionals have used our research since 2012.
Questions from the Community
Top Answer: 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… more »
Top Answer: Whilst our server up-time is in the > 99%, we still have to reboot the DBMS periodically to allow us to archive the log file. The ability to reset the log file without stopping the DBMS would be… more »
Top Answer: We currently run Web server solutions (CMS, CRM business solutions). Our CMS solution is obviously very text-oriented, and our CRM Business Solution was built for a finance and asset management… more »
Top Answer: The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed.
Top Answer: Snowflake is reasonably priced, close to half the cost of some other solutions.
Top Answer: The UI could improve because sometimes in the security query the UI freezes. We then have to close the window and restart. There should be an IDE concept similar to the Java IDE or Eclipse feature. I… more »
Ranking
14th
out of 30 in Data Warehouse
Views
308
Comparisons
208
Reviews
1
Average Words per Review
495
Rating
9.0
1st
out of 30 in Data Warehouse
Views
35,842
Comparisons
25,491
Reviews
40
Average Words per Review
588
Rating
8.4
Popular Comparisons
Also Known As
Ingres, Ingres 2006
Snowflake Computing
Learn More
Overview

Actian’s Ingres is a leading, enterprise-grade database management system designed to reduce IT costs and time-to-value, while delivering the strength and features expected from an enterprise-class database. Ingres 10.2 is the latest version of the database, containing enhancements that will make it easier to internationalize customer applications. Along with improved performance and reduced configuration overhead, users can take their first steps into big data analytics with the new Window functions.

Snowflake provides a data warehouse built for the cloud, delivering a solution capable of solving problems for which legacy, on-premises and cloud data platforms were not designed.

Offer
Learn more about Actian Ingres
Learn more about Snowflake
Sample Customers
Groupe Adeo, IsCool Entertainment
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Top Industries
No Data Available
REVIEWERS
Computer Software Company38%
Financial Services Firm14%
Manufacturing Company10%
Wholesaler/Distributor10%
VISITORS READING REVIEWS
Computer Software Company30%
Comms Service Provider15%
Financial Services Firm8%
Insurance Company5%
Company Size
No Data Available
REVIEWERS
Small Business27%
Midsize Enterprise22%
Large Enterprise51%
VISITORS READING REVIEWS
Small Business12%
Midsize Enterprise14%
Large Enterprise74%
Find out what your peers are saying about Snowflake Computing, Oracle, Apache and others in Data Warehouse. Updated: July 2021.
522,693 professionals have used our research since 2012.

Actian Ingres is ranked 14th in Data Warehouse with 1 review while Snowflake is ranked 1st in Data Warehouse with 41 reviews. Actian Ingres is rated 9.0, while Snowflake is rated 8.4. 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 Snowflake writes "Fast, convenient and requires almost no administration". Actian Ingres is most compared with Oracle Database Appliance, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Firebolt, Vertica and Teradata.

See our list of best 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.