Buyer's Guide
Data Warehouse
November 2022
Get our free report covering Teradata, Oracle, Snowflake Computing, and other competitors of Oracle Exadata. Updated: November 2022.
654,218 professionals have used our research since 2012.

Read reviews of Oracle Exadata alternatives and competitors

Juliet Hoimonthi - PeerSpot reviewer
Manager at Robi Axiata Limited
Real User
Top 5
Has good analysis and processing features for AI/ML use cases, but isn't as user-friendly and requires an advanced level of coding or programming
Pros and Cons
  • "What I like about Apache Hadoop is that it's for big data, in particular big data analysis, and it's the easier solution. I like the data processing feature for AI/ML use cases the most because some solutions allow me to collect data from relational databases, while Hadoop provides me with more options for newer technologies."
  • "What could be improved in Apache Hadoop is its user-friendliness. It's not that user-friendly, but maybe it's because I'm new to it. Sometimes it feels so tough to use, but it could be because of two aspects: one is my incompetency, for example, I don't know about all the features of Apache Hadoop, or maybe it's because of the limitations of the platform. For example, my team is maintaining the business glossary in Apache Atlas, but if you want to change any settings at the GUI level, an advanced level of coding or programming needs to be done in the back end, so it's not user-friendly."

What is our primary use case?

I'm from the data governance team, and this is how my team uses Apache Hadoop: there's a GUI called Apache Atlas, then there's an option called the "business glossary". My team uses the business glossary from Apache Atlas and also uses Apache Ranger. Apache Ranger is another GUI where you can check who is using which data source through the Apache Hadoop platform. My team also uses the Apache Hadoop platform for AI-related use cases and relevant data, so the data required from any kind of AI use case, that data is processed with ETL, specifically with the Talend tool. My team then loads the data in Apache Hadoop, uses that data by making some clusters, and uses the data for AI/ML cases.

What is most valuable?

What I like about Apache Hadoop is that it's for big data, in particular big data analysis, and it's the easier solution. I like the data processing feature for AI/ML use cases the most because some solutions allow me to collect data from relational databases, while Hadoop provides me with more options for newer technologies.

What needs improvement?

What could be improved in Apache Hadoop is its user-friendliness. It's not that user-friendly, but maybe it's because I'm new to it. Sometimes it feels so tough to use, but it could be because of two aspects: one is my incompetency, for example, I don't know about all the features of Apache Hadoop, or maybe it's because of the limitations of the platform. For example, my team is maintaining the business glossary in Apache Atlas, but if you want to change any settings at the GUI level, an advanced level of coding or programming needs to be done in the back end, so it's not user-friendly.

What do I think about the stability of the solution?

Apache Hadoop has good stability.

What do I think about the scalability of the solution?

I'm not sure how scalable Apache Hadoop is.

How are customer service and support?

In terms of technical support from Apache Hadoop, we are working with an external vendor and they are the ones helping us in every case. They are helpful.

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

We used Oracle Exadata before using Apache Hadoop. It was one or two years ago when we started using the Apache Hadoop platform. We're still thinking about using both platforms in parallel or choosing one of the two. We're still looking into the benefits of each platform, but currently, we're using both Oracle Exadata and Apache Hadoop.

How was the initial setup?

I wasn't part of the team that set up Apache Hadoop, but using it after it was set up was very easy. The solution was ready immediately, and the GUI was smooth and fast, with no issues.

What about the implementation team?

Apache Hadoop was implemented by the IT team, so it was an in-house implementation.

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

If my company can use the cloud version of Apache Hadoop, particularly the cloud storage feature, it would be easier and would cost less because an on-premises deployment has a higher cost during storage, for example, though I don't know exactly how much Apache Hadoop costs.

What other advice do I have?

My company is using both Apache Hadoop and Oracle Exadata.

I'm unsure which version of Apache Hadoop I'm using, but it could be the latest version.

Currently, the solution is deployed on-premises because here in Bangladesh, there's a limitation with transferring data outside of the country. As far as I know, there's no cloud solution internally in Bangladesh, so if you want to use a cloud solution here, you'll have to move your data outside Bangladesh, and this is why Apache Hadoop is still deployed on-premises.

More than fifty people use Apache Hadoop directly, particularly the IT and analytics expert teams. The solution is being used by developers, people in operations, and people who maintain security.

In my company, Apache Hadoop is not fully implemented yet. It's still in the implementation phase and at least for the next two to three years, there isn't any plan of discarding it.

I'm giving Apache Hadoop a rating of seven out of ten.

I don't have any recommendations currently for people who want to implement Apache Hadoop because I'm still in the learning phase and I don't have much knowledge yet. The IT team in my company is also struggling every time in terms of preparing everything and still needs help from external vendors because the team isn't an expert on Apache Hadoop yet. My company's expertise is in Oracle Exadata because usage of that product started in 2002 or 2003.

My company is a customer of Apache Hadoop.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
Syed SaqibGhawas - PeerSpot reviewer
Application Designer at LMKR
Real User
Top 5Leaderboard
The admission tools, BI tools, and data warehousing tools are great
Pros and Cons
  • "The solution has been reliable."
  • "We'd like to see it be a bit more compatible with other solutions."

What is our primary use case?

We primarily use the solution for data. 

What is most valuable?

Everything about the solution is great. The admission tools, their BI tools, and data warehousing tools are all good.

The solution has been reliable. It's stable. 

You can scale the product well. 

The implementation process is great.

Its interface is good. 

The tools are very good, efficient, and easy to work with.

What needs improvement?

I don't have any need for new features. 

We'd like to see it be a bit more compatible with other solutions. 

It could be faster. Right now, Oracle is a bit quicker in comparison. We'd like the solution to handle a larger amount of data faster. 

For how long have I used the solution?

I've been using the solution for about five to six years.

What do I think about the stability of the solution?

The performance and reliability are good. We find it to be very stable. There are no bugs or glitches. It doesn't crash or freeze. 

What do I think about the scalability of the solution?

The scalability of the product is great. It's easy to expand. 

It's quite efficient in all the features that we're currently using it extensively. It's giving more and more function. et cetera.

Thousands of users currently using this product. For example, our clients are normally banks and the users are in the thousands. They normally use it each and every day.

How are customer service and support?

I've never used technical support. Mostly I will Google questions to get help. I've never had a problem so big I had to call technical support for this.

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

I have used Oracle and I've used IBM Db2. I switched due to the job I had. Their new tool was SQL Server.

How was the initial setup?

The initial setup is quite straightforward. It's not overly complex or difficult. We didn't have any issues implementing it. 

It's very easy to use. You just follow the simple documentation and the setup is not more than 30 minutes.

I'd rate the process a five out of five in terms of ease of implementation.

What was our ROI?

I do not track ROI. A different part of the organization might follow this. 

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

I'm not sure of the licensing costs of the solution. 

What other advice do I have?

Our organization has a partnership with Microsoft right now.

I'd rate the solution a nine out of ten. I do find that, when it comes to comparing it to Oracle and other tools, there are some better things available on other products. Oracle, for example, manages a large set of data, so, and it is more optimized and a bit faster. 

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Flag as inappropriate
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.
Buyer's Guide
Data Warehouse
November 2022
Get our free report covering Teradata, Oracle, Snowflake Computing, and other competitors of Oracle Exadata. Updated: November 2022.
654,218 professionals have used our research since 2012.