We performed a comparison between Oracle Database, SAP Adaptive Server Enterprise, and Teradata based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."It is user-friendly. Its performance and security are also very good. There are 300 million records for our one-year data, and we can easily query this data. You can use Oracle Database as a source for easily integrating with different databases and applications. It supports Java platforms and other applications very well. It works with SAP products better than Microsoft SQL Server."
"The most valuable feature of Oracle Database is all the functionalities. When we write a code we sometimes have to create an explicit functionality to process the data that we want. At times we find that there is already existing functionality in data created by Oracle itself, it is helpful."
"The most valuable feature is that it is a complete product with all of the functionality that you need, and there is no need for any special features."
"They continue to improve and are always introducing new features."
"The thing that probably stands out the most about Oracle Database is reliability. I have been working with Oracle Databases for over 25 years, and I have never lost any data due to a machine going down or any events that were not stupid human tricks. I've never lost anybody's data using Oracle. It gets the job done and doesn't fail."
"If we make a mistake on the development side, we can recover it. However, we don't have this capability with other databases."
"From a database product perspective, I would say, they're good in what they provide. There's not much concern."
"It is stable, and its performance is good. Its interface is also fine."
"I like that SAP ASE can match code and the database index to index data in the programming language. There are many other valuable features, such as the table buffer, tuning, and various control agents like dispatcher. SAP ASE can handle many different data types, including views, domains, data elements, structures, objects, and various table types that are most useful in the application. Its modularization technique is also handy."
"Provides very good integration."
"SAP Adaptive Server Enterprise is a good transactional database."
"It's user-friendly, especially in the logistics field."
"This is a wonderful database that is, in my opinion, underrated. Users are able to get the most out of my experience by taking advantage of its centralized environment."
"The actual interface is good."
"They provide easy integration with other systems."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"The solution scales well on the cloud."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"Teradata solutions help organizations reduce IT, operations, and maintenance costs; enhance on-time delivery of products and services."
"The flexibility in design is very good."
"They can simplify and make the deployment more user-friendly. Deploying Oracle solutions requires a lot of technical input. If that can be improved, it would really add value to the business."
"I have been looking for a virtualization database engine from Oracle. They have third-party vendors that can do it but if Oracle comes with its own virtual engine, it would be helpful. Additionally, the solution could be more user-friendly and improve the Transparent Data Encryption."
"Digital support of the product could be improved."
"On the ERP side, they do not seem to be improving the on-premises version. They seem to want to push the cloud option on users."
"The solution can be quite expensive."
"Technical support and how they treat their customers need to be improved."
"The tool is costly, and migration is hard. We need tools like Database Migration Assistant for Oracle to migrate data between databases. Sometimes, older versions of Oracle are no longer supported, making the transition even more difficult."
"The product is very expensive."
"The solution should improve view partitioning. The documentation is very confined and available only for users. Distributors also would like access to it."
"There could be some improvements in barcode scanning and RFID access."
"Because the solution is customized. we do occasionally face unique bugs. There are always some changes that need to be made here and there."
"User interface could be more user friendly."
"I think that the solution needs to be positioned better within the market as it appears as though the Adaptive Server is being left out of the SAP scope."
"Cost-wise, SAP is still expensive compared to other available products."
"SAP should refine its debugging method, and the process needs to be a little faster. It should use more Pragmas and fewer pseudocomments. I would like if SAP added more features based on advanced technologies, like artificial intelligence and voice control. The modularization and if-else techniques could also incorporate the latest technology to code and solve complex problems. The SAP Editor should be more elaborative, and it should allow many more types of statements for all uses."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"I would like to see an improved Knowledge Base on the web."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"There is some improvement required on OLTP level and some analytical function is missing."
"The SQL Assistant is very basic. This tool can be improved for usability."
"The following could be better: licensing, architecture openness, integration with other tools."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
More SAP Adaptive Server Enterprise Pricing and Cost Advice →