Try our new research platform with insights from 80,000+ expert users
reviewer2534070 - PeerSpot reviewer
Senior Software Engineer at a tech company with 10,001+ employees
Real User
Top 20
Leveraging ETL capabilities for efficient data processing and reporting
Pros and Cons
  • "Oracle offers ETL with PL/SQL as a programming language for SQL programming, which is majorly used in data engineering."
  • "It isn't as popular as AWS, GCP, or Azure as it lacks scalability and cloud-native services like containerization."

What is our primary use case?

It's a typical client-server architecture where we host databases on a Linux server, and we have an Oracle client that allows connection to the server. We allow connection to dev, test, and UAT environments with different databases, where the production server is on a Linux server.

How has it helped my organization?

The availability of Oracle Database Appliance definitely helps, but you cannot go beyond a certain capacity of server if you are storing a large amount of data. You will need new infrastructure, as it's not as scalable as it's a monolithic system and not distributed.

What is most valuable?

Oracle offers ETL with PL/SQL as a programming language for SQL programming, which is majorly used in data engineering. Shell scripting and Informatica are useful for loading data into the Database and creating, manipulating, and transforming data. It's also good for reporting purposes and can parse semi-structured data like JSON and XML.

What needs improvement?

The scalability part is missing. It isn't as popular as AWS, GCP, or Azure as it lacks scalability and cloud-native services like containerization. The Oracle cloud hasn't reached the level of offering all cloud services that the competitors do.

Buyer's Guide
Oracle Database Appliance
May 2025
Learn what your peers think about Oracle Database Appliance. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
851,604 professionals have used our research since 2012.

For how long have I used the solution?

I have been familiar with Oracle Database Appliance for close to 14 years.

What do I think about the stability of the solution?

Clients are hesitant now because it's on-prem, and the scalability factor is an issue. Oracle doesn't offer modern features available with cloud solutions.

What do I think about the scalability of the solution?

It's not as scalable because it is a monolithic system. I would rate its scalability as four out of ten due to some limitations.

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

Most companies are moving away from Oracle to cloud-based solutions like Databricks and AWS due to more advanced features fit for modern analytic solutions.

How was the initial setup?

The initial setup involves having a server and infrastructure. Oracle DB takes care of the installation, so it's not particularly difficult.

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

I have heard from colleagues that Oracle is very costly compared to open databases like PostgreSQL. I cannot personally comment on it.

Which other solutions did I evaluate?

I have experience with competitors like AWS and Microsoft Azure, and they offer more advanced components and benefits as a package compared to standalone systems.

What other advice do I have?

With current developments, Oracle attempts to incorporate the latest technologies like Azure and AWS, but it must ramp up its offerings to match the capabilities competitors provide in cloud services.

I'd rate the solution eight out of ten.

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
PeerSpot user
Operations Manager at Missan Alnjoom IInformation Technology
Reseller
Top 5
Reliable platform with good technical support services
Pros and Cons
  • "The product is excellent. It is simple and reliable in terms of installation and maintenance."
  • "They could incorporate a more secure and internet-centric management system for the platform."

What is most valuable?

The product is excellent. It is simple and reliable in terms of installation and maintenance.

What needs improvement?

They could incorporate a more secure and internet-centric management system for the platform.

For how long have I used the solution?

I have been working with Oracle Database for over 24 years. I started working with Oracle Database Appliance about two to three years ago by acquiring a new machine for my database needs.

What do I think about the scalability of the solution?

The scalability of the Oracle Database Appliance is satisfactory, particularly when compared to the extensive cloud scaling capabilities.

How are customer service and support?

The technical support services are good.

How would you rate customer service and support?

Positive

How was the initial setup?

The platform is easy to install for me as I am an expert in Oracle. I have worked as an application developer and programmer for the past 24 years. Thus, the setup is not a major issue for me.

What was our ROI?

The Return on Investment (ROI) for Oracle Database Appliance is positive, particularly when considering the support and overall quality of the machine. Oracle's support, although initially less expensive, proves to be superior in the long run compared to other hardware solutions. The machine's quality surpasses that of competitors like Nutanix. While the upfront cost may be slightly higher, the investment is justified.

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

The product is costly. However, it is the price is justifiable for the excellent technology it offers.

Which other solutions did I evaluate?

We evaluated different versions of the product. We considered storage extendability and high availability while making purchase decisions.

We opted for Oracle Database Appliance utilizing software and hardware to create a comprehensive Oracle environment. We wanted to implement a private cloud that seamlessly connects with Oracle Cloud Infrastructure (OCI), forming a hybrid solution. However, due to budget constraints, the decision was made to start with ODA and gradually expand the infrastructure to align with the initial vision, incorporating private and public cloud components as the company grows.

What other advice do I have?

The product’s licensing structure tied to processors is advantageous compared to non-Oracle alternatives. It simplifies the database management tasks by providing frequent updates and high availability.

The integrated systems approach of the application has significantly impacted our IT efficiency. It consolidates applications within the same machine, avoiding the need to distribute them across multiple machines. As we evolve towards a private cloud infrastructure, the synergy between ODA and the Oracle Private Cloud Appliance for connecting two to three machines.

I advise others to use the product for better pricing and licensing. I rate it a ten out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Reseller
PeerSpot user
Buyer's Guide
Oracle Database Appliance
May 2025
Learn what your peers think about Oracle Database Appliance. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
851,604 professionals have used our research since 2012.
IT Specialist at Supremo Tribunal Federal
Real User
Good value for money and secure
Pros and Cons
  • "The product is good value for money. It is a secure solution."
  • "The feature that I would like to see improve is the interface. It is really not good. I almost have to work on script by script in it. There is always some issue with the user interface."

What is our primary use case?

Our production database and development are in Oracle Database Appliance. We currently only have one machine, so we are thinking of buying another two. 

What is most valuable?

Oracle Database Appliance is scalable. It is a great solution for Oracle Database. This is the best hardware environment you can do it.

What needs improvement?

The feature that I would like to see improve is the interface. It is really not good. I almost have to work on script by script in it. There is always some issue with the user interface.

A firewall feature embedded in the solution would be good as well. 

For how long have I used the solution?

I have been using Oracle Database Appliance for four years. 

What do I think about the stability of the solution?

Oracle Database Appliance is very stable. 

What do I think about the scalability of the solution?

Oracle Database Appliance is scalable. On a scale of one to 10, with one being bad and 10 being good, I would rate this solution a nine for scalability. 

How are customer service and support?

We have been trying to upgrade our database since July of 2022. We have had to open a lot of service requests with Oracle's support. We ended up solving our issue with our developers here in Brazil. I realized then that Oracle's local support do not talk to other Oracle support people who. It's very strange; sometimes it feels like two different companies.

How would you rate customer service and support?

Neutral

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

We previously used Posters for a minor database. We switched because it was too small. Oracle Database Appliance is much cheaper for us to use overall. 

How was the initial setup?

The initial setup was very difficult for us. It took us 20 to 25 days. 

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

Oracle Database Appliance is very expensive. On a scale of one to 10, with one being cheap and 10 being expensive, I would rate Oracle Database Appliance a seven. 

What other advice do I have?

My advice for those looking to implement this solution is: it's a great solution but you will need two machines to run it. 

The product is good value for money. It is a secure solution. 

Overall, on a scale of one to ten, I would give Oracle Database Appliance an eight. 

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.
PeerSpot user
Muhammad Usman Muzaffar - PeerSpot reviewer
Senior Vice President IT Operations at ZTBL
Real User
Top 10
Easy to manage platform with good stability
Pros and Cons
  • "The product’s valuable feature is its capability to pre-configure and pre-install the settings."
  • "The product's technical support services need improvement."

What is most valuable?

The product’s valuable feature is its capability to pre-configure and pre-install the settings. We can easily manage the website.

What needs improvement?

The product's technical support services need improvement. 

For how long have I used the solution?

We have been using Oracle Database Appliance since 2014.

What do I think about the stability of the solution?

I rate the product’s stability a ten out of ten.

How are customer service and support?

The technical support services regarding hardware issues could be better.

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

We switched to Oracle Database Appliance from the commodity server for better compatibility and performance.

How was the initial setup?

Oracle Database Appliance is easy to implement. It takes two to five hours or up to a day to complete. It needs a basic understanding of how all the product works and the process of allocating the IPs. A team of three people executes the deployment.

What other advice do I have?

The product is pre-implemented in appliances. It doesn’t require any further improvement. It is suitable for mid-sized companies.

I rate it a ten out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Software Engineer at a financial services firm with 1,001-5,000 employees
Real User
Has drastically reduced the amount of processing time from seven days to one day
Pros and Cons
  • "The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day."
  • "In terms of what can be be improved, I'd say Artificial Intelligence, AI. It would be really helpful if AI was incorporated within the solution."

What is most valuable?

I use Oracle databases with multiple clients mainly for analyzing financial transactions. They use it to find the profit and loss for each and every day of trading activity.

Finding out out a single day's profit and loss used to take them almost seven days to calculate. For example, if they wanted to find out something new, they could find the profit and loss of the day's data only by the following week. So we introduced Oracle Database Appliance for the extra data and to gather all the information we have across all the systems. We built a warehouse database that will accommodate all the information and we reduced the time to determine the entire transactions of P and L into a single day.

The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day. This is our main use for Oracle. The business intelligence and data warehousing features are the best part of Oracle Database Appliance.

What needs improvement?

It could be that we may not be using Oracle and GoldenGate in the way we are supposed to be using them. We have faced a couple of issues with GoldenGate. Whenever we have issues, the Oracle support will take the time to understand how GoldenGate works. The stability of the GoldenGate could be improved, although it is pretty stable.

In terms of Database Appliance, the important thing is how you design it. If the underlying design is good, then Oracle will perform exactly how we want it to perform. But if the underlying design or the underlying architecture is bad, then Oracle is not going to give the expert the results he needs. It all depends upon the developer who designs it. I haven't seen any drawback with the Oracle database assets, and for the past five years I've been using it in our team.

In terms of what can be improved, I'd say Artificial Intelligence, AI. It would be really helpful if AI was incorporated into the solution.

On a scale of one to ten, I would rate Oracle Database Appliance an eight.

For how long have I used the solution?

I've been using Oracle Database Appliance for five years. I moved to AWS Cloud Platform and now we are migrating the Oracle appliances to the Cloud Platform, which is an AWS platform as a service.

What do I think about the stability of the solution?

Oracle Database Appliance is really reliable. The stability and scalability of Oracle Database are reliable. I would say that it is more reliable than scalable. With the 19c, I've seen that it is stable in most cases but we had certain issues when we tried to create scale on 12c. We had issues when we used the previous, older version of Oracle, 12c. It was not that easy to use 12c because we had to get certain hardware. 

What do I think about the scalability of the solution?

In terms of scalability, it is not bad. It was not that easy to scale. I don't think it's easily scalable.

I think more than 400 or 600 people are using it in the company.

How are customer service and technical support?

Their technical support is really good. It has really good products and I'm pretty satisfied.

How was the initial setup?

The initial setup of Database Appliance is straightforward. But It depends upon the applications that you're using.

If you want to use it on top of the database, it's going to be straightforward. But if you want to do it at some other part of the process the third party client has to do an APA call. It depends upon the way they implement it. If it's going to be a third party vendor using it he'll have to make APA calls, then it's going to be a bit complex.

What other advice do I have?

I would recommend Oracle Database Appliance. Oracle is the benchmark in the field. Still, I would recommend you doing a proof of concept with Oracle Database first and then consider the other databases.

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.
PeerSpot user
Chief Executive Officer at Standard Bank South Africa
Real User
A scalable, stable and effective solution
Pros and Cons
  • "The tool is a specific and effective system. I am impressed with its usability."
  • "The tool's setup can be easier."

What is most valuable?

The tool is a specific and effective system. I am impressed with its usability. 

What needs improvement?

The tool's setup can be easier. 

What do I think about the stability of the solution?

The solution is stable. 

What do I think about the scalability of the solution?

The product is scalable. 

How was the initial setup?

The tool's setup is little complex. 

What other advice do I have?

I would rate the product an eight out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Real User
Top 5
The solution is stable and scalable, but it is very expensive, and the setup is a bit complex
Pros and Cons
  • "Oracle is a stable database."
  • "The setup is a bit complex."

What is our primary use case?

We use the solution for our enterprise applications.

What is most valuable?

Oracle is a stable database.

What needs improvement?

The setup is a bit complex.

For how long have I used the solution?

I have been using the solution for many years.

What do I think about the stability of the solution?

The tool is stable.

What do I think about the scalability of the solution?

The tool is scalable. All my key applications are on Oracle. We might increase the usage depending on the business growth.

How are customer service and support?

I have contacted support. We have a good relationship with the team.

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

We have used MySQL and PostgreSQL.

What about the implementation team?

The solution can be deployed in-house.

What was our ROI?

We have seen some value in the solution.

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

Oracle’s pricing is ridiculously high.

What other advice do I have?

I would recommend the product if someone is using very data-sensitive applications. Overall, I rate the product a seven out of ten.

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.
PeerSpot user
reviewer1274235 - PeerSpot reviewer
Lead Oracle DBA at a healthcare company with 5,001-10,000 employees
Real User
Affordable, user-friendly, and offers good technical support
Pros and Cons
  • "The solution is pretty automated, which takes out the possibility of human error."
  • "The product is quite complex to set up, initially. It would be ideal if it was simpler."

What is our primary use case?

We support their warehouse and we are looking into the network data warehouse product, which is tightly integrated. This is pretty much the go-to product for that process due to the fact that it's all in one box, and is pre-packaged. It's all Oracle servers, and Oracle hardware, and Oracle software and it's all in one.

How has it helped my organization?

We used to have different vendors and servers. Everything was all over the place. Now that we are on Oracle, everything is centralized, removing a lot of complexity.

What is most valuable?

The deployment is super-simple as everything is pre-packaged. There's very little configuration to worry about.

We manage everything through the appliance. It's easier to manage from our side of the managed databases and add more storage, et cetera. It's very easy to mimic what we need. we can easily add more storage whenever we want. The scalability is great.

We had Commodity servers - those bales servers on-premises - and there was a lot of maintenance going on with that. After moving to RDA, life is much easier because everything is managed through those deployed solutions. It's easier to manage this way.

From a maintenance point of view and from an upgrade and migration point of view, it is very easy because most of the upgrades are fast. We can take one down and finish the upgrade and move onto the next as necessary. It's easier to manage the patches and upgrades.

The solution is pretty automated, which takes out the possibility of human error.

The pricing is great. It's much better than what the competition is offering.

The product is pretty user-friendly.

What needs improvement?

There aren't really any features that the solution is lacking.

The product is quite complex to set up, initially. It would be ideal if it was simpler.

Any limitations within the solution are case by case. The solution may work for some, but it isn't for everyone.

The product is still evolving. It could still, for example, be more user-friendly. It's not quite perfect yet.

For how long have I used the solution?

I've been using this solution since last year.

What do I think about the stability of the solution?

The solution is pretty stable. I don't recall bugs or glitches. It doesn't crash. I find it pretty reliable overall.

What do I think about the scalability of the solution?

The solution can easily scale. We've found that if we need to add more storage, it's very straightforward to do so. If a company needs to scale, it's not a problem with Oracle.

In our case, because we are on-premises, there are some limitations due to the fact that we only have two servers. We understand our limitations and we know it will work well for us over the next five years or so. And then, if we need to expand, we can plan for that.

We have about 500 active users within our company on the solution. We have reporting applications and a lot of data manipulations, and all that going on, on this database. It's mostly IT personnel on it currently.

How are customer service and technical support?

We've worked with Oracle a lot, compared to other previous solutions. The company sells it with support and clients get account managers that they can reach out to. Overall, technical support has been good. I'd rate it a nine out of ten. They are very knowledgeable and responsive. They are very good. We've been satisfied with the service provided.

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

We used to have similar databases on different servers, and we had to work through different vendors. We had different storage, then different servers, then different vendors and the backup solution was on another vendor as well. There was a lot of coordination required. It added a lot of complexity to everything. With this kind of a solution, everything is on one kind of a black box. We don't have to worry too much and the level of coordination required has dissipated.

How was the initial setup?

The initial setup is not straightforward. It's quite complex. Once you get the hang of it and get it going, it's easier for others on our application team. It's also easier to manage int he long run. The main problem is that it's quite different from what we used to do, so there's a bit of a learning curve during the setup.

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

The pricing is really good for us. We have no complaints there. It's not as expensive as other products on the market. The excellent price point is one of the reasons we moved to RDA.

What other advice do I have?

We're just a customer. We don't have a business relationship with Oracle.

Due to the current contractual agreements, et cetera, within our organization, we are not doing or considering anything on the cloud - from the database side at least.

I'd rate the solution eight out of ten. There are still some limitations. That said, it did simplify a lot of things for us, compared to our old setup.

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.
PeerSpot user
Buyer's Guide
Download our free Oracle Database Appliance Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2025
Product Categories
Data Warehouse
Buyer's Guide
Download our free Oracle Database Appliance Report and get advice and tips from experienced pros sharing their opinions.