We just raised a $30M Series A: Read our story

Oracle Exadata Competitors and Alternatives

Get our free report covering Teradata, Oracle, Amazon, and other competitors of Oracle Exadata. Updated: September 2021.
540,884 professionals have used our research since 2012.

Read reviews of Oracle Exadata competitors and alternatives

DR
Sr. Software Developer at Tech Mahindra Limited
Real User
Top 20
Impressive performance from massively parallel processing, supports ELT for importing data, and has awesome technical support

Pros and Cons

  • "It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL."
  • "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."

What is our primary use case?

The primary use case for Snowflake is in our data warehouse project. We have a private DW and whoever has the credentials can access it. I am a data integration developer and we are using ETL tools to extract the data from different source systems and then load it in the data warehouse.

What is most valuable?

Snowflake is the latest technology. It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL.

This solution automatically performs micro-partitioning when the data is loaded. This creates a dynamic partition and based on the cluster, the performance is fast and really impressive.

Snowflake is using MPP, massively parallel processing techniques, which is a great feature. It saves developers time and allows us to focus more on client requirements.

What needs improvement?

It is difficult in some cases to perform ETL and this is something that should be included. As it is now, I use Informatica PowerCenter to load data from on-premises to the Snowflake cloud-based data warehouse. If this could be done by Snowflake directly, without an external integration tool, then it would become a full package. It would be awesome.

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. We would like to be able to just write an SQL query and do our work.

For how long have I used the solution?

I have been working with Snowflake for six months.

What do I think about the stability of the solution?

We have not had any major issues with stability.

What do I think about the scalability of the solution?

Snowflake does not require manual scaling because it does it for you. Developers just need to load the data and process the query. That's it. The developer's job is not to spend time improving performance, as it was with an on-premises solution. We had to do the partitioning, collect the stats, and everything else. In the case of this cloud-based solution, it doesn't require as much work. Instead, we can focus on the queries.

We are planning to increase our usage of Snowflake.

How are customer service and technical support?

I have been in contact with technical support many times and it was awesome. I got great support. Whenever I needed anything they were ready to help me out, which was nice.

Which solution did I use previously and why did I switch?

I have experience with Informatica PowerCenter and Oracle. PowerCenter uses ETL techniques instead of ELT. Oracle does not automatically perform micro-partitioning. Instead, you have to partition manually and it is a static partition.

Prior to Snowflake, I was using an on-premises data warehouse. Snowflake is the first experience I have had with a cloud-based data warehouse. It is an awesome tool.

How was the initial setup?

There is no need to install this software, which is the best part. It doesn't require any maintenance, and although DBA support is required, it is much less compared to an on-premises solution. This type of cloud-based solution has no requirement for software, hardware, or maintenance because everything is managed by Snowflake's system.

What about the implementation team?

The only assistance I had during the setup was from the integration tool, Informatica PowerCenter. This was used to export our on-premises data from Oracle and import it to Snowflake on the cloud.

What's my experience with pricing, setup cost, and licensing?

You pay based on the data that you are storing in the data warehouse and there are no maintenance costs.

What other advice do I have?

This is an awesome tool, but there is room for improvement in terms of integration. Also, in terms of management, nothing is perfect and everything can be improved.

I would rate this solution an eight out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
reviewer1501218
Managing Director at Jet iT Ltd.
Real User
Top 10
Good multi-platform SQL compatibility, as well as performance and data integrity

Pros and Cons

  • "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 ability to reset the log file without stopping the DBMS would be helpful for us."

What is our primary use case?

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 business, which is capable of handling millions of transactions.

Performance, access control, data integrity are fundamental to any application but we have been able to more than satisfy our clients with the solutions we have delivered.

We have Ingres running on an AWS Linux server. We have Windows Server running front end solutions using Ingres OpenRoad and Linux Servers serving Web Applications through Apache and PHP.

How has it helped my organization?

Ingres is the only database solution that has maintained a level of consistency and integrity about the way users interact with it. As a database administrator, there is a level of transparency and control at all levels.

Over the last few years, we have migrated all of our business functional logic into database procedures, which improves performance significantly and allows us to alter our development tools/programming languages easily.

Our products CK5 and JS5 are offered as SaaS solutions through jetpac.co.nz

What is most valuable?

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 User is never exposed to any configurations or logins other than their own initial identification.

The SQL capability is consistent across all platforms. This means that we can code into our PHP functions to manage the database so that the users can be generally self-sufficient and requiring DB support only rarely.

What needs improvement?

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 helpful for us.

We have created our own error management/reporting process within our database procedures. Unfortunately, if there is a database error, such as a duplicate key, the default action is to abort. This means that our information is generally lost. An option to not abort on failure would be great. Of course, this only really occurs in testing.

For how long have I used the solution?

I first came across Actian Ingres in 1992 and have been using it in all of my solutions since then.

What do I think about the scalability of the solution?

It is completely scalable, as the Query Execution Process is completely dynamic based on the current number of rows and efficiency of the index structures.

Which solution did I use previously and why did I switch?

We did not use another solution, as this was a greenfield opportunity

Which other solutions did I evaluate?

We evaluated Oracle and DB2.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
MukundMishra
Practice Lead (BI/ Data Science) at a tech services company with 11-50 employees
Real User
Top 20
Good for managing and replication of big data but needs a better user interface

Pros and Cons

  • "It's good for storing historical data and handling analytics on a huge amount of data."
  • "The solution could use a better user interface. It needs a more effective GUI in order to create a better user environment."

What is most valuable?

The solution is perfect for when you have big data. It's good for managing and replication.

It's good for storing historical data and handling analytics on a huge amount of data.

What needs improvement?

It could be because the solution is open source, and therefore not funded like bigger companies, but we find the solution runs slow.

The solution isn't as mature as SQL or Oracle and therefore lacks many features.

The solution could use a better user interface. It needs a more effective GUI in order to create a better user environment.

For how long have I used the solution?

I've been using the solution for seven years.

What do I think about the stability of the solution?

The solution is stable.

What other advice do I have?

I've used the solution under cloud, hybrid and on-premises deployment models.

I'd recommend the solution, but it depends on the company's requirements. If you don't have huge amounts of data, you probably don't need Hadoop. If you need a completely private environment, and you have lots of big data, consider Hadoop. You don't even need to invest in the infrastructure as you can just use a cloud deployment.

I'd rate the solution seven out of ten. I'd rate it higher if it had a better user interface.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Get our free report covering Teradata, Oracle, Amazon, and other competitors of Oracle Exadata. Updated: September 2021.
540,884 professionals have used our research since 2012.