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.
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?
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
December 2024
Learn what your peers think about Oracle Database Appliance. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 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.
Last updated: Nov 13, 2024
Flag as inappropriateChief 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.
Buyer's Guide
Oracle Database Appliance
December 2024
Learn what your peers think about Oracle Database Appliance. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
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 Consultant at a tech services company with 501-1,000 employees
We value the appliance architecture with its “everything-in-a-box” highly standardized setup.
Pros and Cons
- "We value the appliance architecture with its “everything-in-a-box” highly standardized setup."
- "In my opinion only one single command should be used for all ODA models, as it’s confusing."
What is our primary use case?
Database consolidation and for X6-2L also database performance improvement due to NVMe storage being used, which dramatically increases I/O performance
What is most valuable?
We value the appliance architecture with its “everything-in-a-box” highly standardized setup.
For the new ODA X6-2 models there is a possibility to deploy also SE/SE2 databases in a bare-metal deployment as well as the boosted I/O performance due to NVMe Flash disks.
How has it helped my organization?
For one customer it consolidated several databases from several Windows physical servers into one single ODA and resulted in increased stability.
For another customer it was used to “isolate” the last Oracle database system on one single ODA, thereby freeing-up SAN storage and rack server slots used by an old Linux cluster.
What needs improvement?
The following issues need some attention:
- Ease of administration and deployment. With ODA X6-2 there are different “OAK” administration commands for the S/M/L models (e.g. “odacli”) compared to the HA model ("oakcli").
- In my opinion only one single command should be used for all ODA models, as it’s confusing.
- Some of the new commands have limitations/restrictions, though I assume they’ll be improved over time.
For how long have I used the solution?
We have been using the solution since 2012. We implemented 2x ODA V1 systems.
What was my experience with deployment of the solution?
With the X6-2L we had a couple of early replacements, e.g. PCI card and battery
What do I think about the stability of the solution?
We only had a stability issue with the ODA V1 due to an ASM disk mount issue (“ORA-600 [KFDJOIN3]”, bug). This issue delayed the go-live for production databases, but was fixed with the assistance of Oracle Support relatively fast.
What do I think about the scalability of the solution?
We only had a scalability issue regarding local storage, especially on the ODA V1.
How are customer service and technical support?
I would rate the technical support as six out of 10. Over the past couple of years, I’ve found that the quality of Oracle Support first-level has decreased.
Which solution did I use previously and why did I switch?
We used custom-built single-server or cluster solutions. The ODA provides a high degree of standardization.
How was the initial setup?
The initial deployment of 2x ODA V1s was accomplished in one day, including unpacking and rack-mounting.
What's my experience with pricing, setup cost, and licensing?
Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE.
Which other solutions did I evaluate?
We evaluated Exadata, which often is overkill for many small and medium sized databases.
What other advice do I have?
If you go with 1x ODA then at least establish a Data Guard standby system on a Linux server, e.g. Public Cloud. I suggest to use 2x ODAs in each DR setup.
Disclosure: My company has a business relationship with this vendor other than being a customer: Trivadis is an Oracle Platinum Partner.
CEO, Founder at Finema
Used to implement the cloud infrastructure for ISPs
Pros and Cons
- "The solution's function we use to benefit the customers is database verification."
- "The solution’s flexibility could be improved."
What is our primary use case?
We use the solution to implement the cloud infrastructure for the ISPs (internet service providers) in Thailand.
What is most valuable?
The solution's function we use to benefit the customers is database verification.
What needs improvement?
The solution’s flexibility could be improved.
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?
I rate the solution a nine out of ten for stability.
What do I think about the scalability of the solution?
I would recommend the solution for enterprise businesses.
I rate the solution’s scalability an eight out of ten.
How are customer service and support?
The solution's local in-house support team from Oracle Thailand is doing very well.
How was the initial setup?
The solution's initial setup is neither very simple nor very complex.
On a scale from one to ten, where one is difficult and ten is easy, I rate the solution's initial setup a five out of ten.
What's my experience with pricing, setup cost, and licensing?
The solution's pricing is very high.
What other advice do I have?
I am working with both on-premises and hybrid models of the solution. We use Oracle Database Appliance for machine learning. The solution's main competitor is Huawei, which is trying to conquer the market with its competitive pricing. I would recommend Oracle Database Appliance to other users.
Overall, I rate the solution an eight out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Last updated: Jun 14, 2024
Flag as inappropriateCTO 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.
MIS Coordinator at IDEA BANK
A legacy solution for operational purposes with easy setup
What is our primary use case?
We use the solution for operational purposes. It is the core app built on top of it.
What is most valuable?
I like the solution’s performance.
What needs improvement?
The solution requires improvement regarding scalability and artificial intelligence.
For how long have I used the solution?
I have been using Oracle Database Appliance as a customer for eight years.
What do I think about the stability of the solution?
I rate the solution’s stability an eight out of ten.
What do I think about the scalability of the solution?
Around 100 people are using this solution daily.
I rate the solution’s scalability a four or five out of ten.
How was the initial setup?
The initial setup is easy.
I rate the solution’s setup an eight out of ten.
What about the implementation team?
The solution requires six or seven in-house people to deploy.
What's my experience with pricing, setup cost, and licensing?
I rate the solution’s pricing a seven out of ten, where one is cheap, and ten is expensive.
What other advice do I have?
We need three people, including a Linux expert, for the solution’s maintenance.
I recommend the solution for operational purposes with performance on-prem.
Overall, I rate the solution an 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.
Lead Oracle DBA at a healthcare company with 5,001-10,000 employees
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.
Buyer's Guide
Download our free Oracle Database Appliance Report and get advice and tips from experienced pros
sharing their opinions.
Updated: December 2024
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?