The product’s valuable feature is its capability to pre-configure and pre-install the settings. We can easily manage the website.
Senior Vice President IT Operations at ZTBL
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?
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.
Buyer's Guide
Oracle Database Appliance
January 2025
Learn what your peers think about Oracle Database Appliance. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,158 professionals have used our research since 2012.
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.
Senior Software Engineer at a tech company with 10,001+ employees
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.
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.
Last updated: Nov 13, 2024
Flag as inappropriateBuyer's Guide
Oracle Database Appliance
January 2025
Learn what your peers think about Oracle Database Appliance. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,158 professionals have used our research since 2012.
Chief Executive Officer at Standard Bank South Africa
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.
IT Specialist at Supremo Tribunal Federal
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.
Administrator at champ Solutions limited
Stable, scalable, and easy to deploy
Pros and Cons
- "The most valuable feature of the solution is the ability to combine all the data without the need for additional devices."
- "It would be beneficial to have dedicated RAM included in the Oracle Database Appliance."
What is our primary use case?
We usually provide insurance operations software. Therefore, we sell applications to insurance companies, and we use the ODA to configure them to run the application.
How has it helped my organization?
I think one of the reasons I was looking for a comparison between the SPARC and the Oracle Database Appliance is because, with most other services, we can't get everything combined as we can with the Oracle Database Appliance. We would have to get a server, extra storage, and other devices to set up shop. With the Oracle Database Appliance, once we put our application on the solution, it is enough.
What is most valuable?
The most valuable feature of the solution is the ability to combine all the data without the need for additional devices.
What needs improvement?
I am certain that Oracle Servers do not have RAM, not even the usual RAM, or usually obtain OCP. It would be beneficial to have dedicated RAM included in the Oracle Database Appliance.
For how long have I used the solution?
I have been using the solution for four years.
What do I think about the stability of the solution?
Oracle Database Appliance is extremely stable.
What do I think about the scalability of the solution?
Although we have not needed to scale the solution yet, Oracle Database Appliance is scalable.
How was the initial setup?
The initial setup is straightforward. The deployment takes one business day.
What about the implementation team?
We implement the solution in-house with the assistance of Oracle technical support when required.
What's my experience with pricing, setup cost, and licensing?
The solution may be expensive, but when we consider the problems it solves, the stability it provides, and the fact that we don't have to buy separate parts and assemble them into a system, it becomes more affordable. Otherwise, we would have to purchase components from different sources, assemble them, and then pay to resolve any stability issues that arise.
What other advice do I have?
I give the solution an eight out of ten.
There are no other solutions similar to Oracle Database Appliance on the market. I've been looking for others to have compared, but there are none.
Oracle Database Appliance is a good solution and I recommend it.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
Senior Software Engineer at a financial services firm with 1,001-5,000 employees
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.
Senior Vice President IT Operations at ZTBL
Quick performance with all-flash memory, and good technical support
Pros and Cons
- "The most valuable feature is the performance."
- "We would like the ability to add more storage without having to upgrade to Oracle Exadata."
What is our primary use case?
End User response time for Core Banking Application
How has it helped my organization?
By adding ODA in our infrastructure, it helps to spare time for other Adminstration & Research activities..
What is most valuable?
The most valuable feature is the performance. Its a pre-configured device and you just plug and play..
What needs improvement?
It has limitations of Storage as well as network connectiivty over 10G Fiber.
For how long have I used the solution?
We have been using the Oracle Database Appliance for about six years, since 2014.
What do I think about the stability of the solution?
The appliance is pretty stable.
What do I think about the scalability of the solution?
It is scalable, although it only has two storage shelves available. The total usual storage after RAID dual parity is between 12 and 15 TB.
How are customer service and technical support?
Technical support is very good and the people are nice.
Which solution did I use previously and why did I switch?
Prior to using the appliance, we had our Oracle Database installed on a Dell server. We had some performance issues with the system, which is why we switched.
How was the initial setup?
The initial setup is okay. We just have to plug in the machine and set up the applications.
What about the implementation team?
Although, the purchase contract have engagement of the vendors for its deployment and in PAKISTAN we at ZTBL is the first who are deploying the ODA. since its a pre configured machine so no special training is required for its deployment. Moreover, the expertise level of the vendor is satisfied.
What was our ROI?
By deploying ODA in your infra, you can spare time for other activities instead of resolving issues of traditional system.
What's my experience with pricing, setup cost, and licensing?
Should go wiht ODA , breakup the cost of hardware, setup & Licensing, you will find that ODA is much cheaper than any other solution in terms of setup and operational cost
Which other solutions did I evaluate?
we had reviewed traditional system configuration like servers attached wiht any SAN storage. But the performance benchmarks we have with ODA is not avavilabe in other options.
What other advice do I have?
The Oracle Database Appliance is a product that I recommend. It is really good for small businesses where there are database-intensive applications that need high performance.
I would rate this solution a ten out of ten.
Which deployment model are you using for this solution?
On-premises
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
CTO at TOSB
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.
Buyer's Guide
Download our free Oracle Database Appliance Report and get advice and tips from experienced pros
sharing their opinions.
Updated: January 2025
Product Categories
Data WarehousePopular Comparisons
Oracle Exadata
VMware Tanzu Data Solutions
Apache Hadoop
SAP BW4HANA
IBM Netezza Performance Server
IBM Db2 Warehouse
Microsoft Parallel Data Warehouse
IBM Integrated Analytics System
Actian Ingres
Buyer's Guide
Download our free Oracle Database Appliance Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza
- When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?
- At what point does a business typically invest in building a data warehouse?
- Is a data warehouse the best option to consolidate data into one location?
- What are the main differences between Data Lake and Data Warehouse?
- Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?
- What is the best data warehouse tool?
- Which Data Strategy solution have you used?
- Why is Data Warehouse important for companies?