We performed a comparison between SAP Business Warehouse and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Having the back-end data set with the right information is the best qualification for this solution."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"With the technical support, the response has been pretty good from the SAP side."
"What I like most about SAP Business Warehouse is its ability to feed data into new, multiple systems in various formats. It can open its data to any system over gateway services or a portal or application that needs to consume and analyze data."
"The most valuable feature of SAP Business Warehouse is its hybrid functionality, allowing users to leverage both SQL-based data warehouse capabilities from HANA and feature-based data warehousing from BW."
"What I like most about SAP Business Warehouse is that it's a seamless integration platform. A valuable feature in the tool is the monitoring alert that makes you aware of what process chain has failed. There's no manual monitoring required if you have configured an alert system, so the process chain can run in the background, and you can get alerts about it. The functionalities I find good in SAP Business Warehouse are alerting and monitoring. If you have configured the tool and have integrated it with SAP Solution Manager, then it's a good product to use."
"The most useful feature has been he ability to feed data into multiple systems in various formats."
"Out-of-the-box reports are very useful."
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"Teradata's pretty fast."
"It is a stable program."
"It's very mature from a technology perspective."
"Teradata's best feature is its speed with historical data."
"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."
"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."
"It's a product that is at the end of life so they will not improve it anymore."
"It takes more work to get the data, including reporting on that data, because some coding is required, and a significant level of transformation is needed when using SAP Business Warehouse."
"You can start quickly but, when you have to get a little more detailed, when you have to change something, when you have to solve problems, it's not that easy. It's easy to start but evolving is not that easy."
"There is room for improvement from a technical perspective."
"I would like to see a different end solution in order to read the data and attract internal users."
"A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution."
"The way the data is stored is kind of rigid in SAP BW as a product. It could be more flexible so that when we are designing a solution, we can design our own data structures and try to improve performance."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"Data synchronization to the DR site."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"The cloud is the new challenge and the new opportunity."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"It could use some more advanced analytics relating to structured and semi-structured data."
SAP Business Warehouse is ranked 9th in Cloud Data Warehouse with 25 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. SAP Business Warehouse is rated 7.8, while Teradata is rated 8.2. The top reviewer of SAP Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". On the other hand, the top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". SAP Business Warehouse is most compared with Microsoft Azure Synapse Analytics, Snowflake, BigQuery, SAP BW4HANA and SAP NetWeaver Business Warehouse, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery. See our SAP Business Warehouse vs. Teradata report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.