DB2 vs SAP BW/4HANA | TrustRadius

What users are saying about

Score 8.3 out of 10

Based on 97 reviews and ratings

Score 8.6 out of 10

Based on 38 reviews and ratings

Pros

DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.

Read full review

J.R. Bullington

Senior Infrastructure Engineer

Open Dealer Exchange, LLCInformation Technology and Services, 51-200 employees

View all 18 answers on this topic

High speed data warehouse regardless of data volumes.
Excellent integration with SAP systems and Data sets.
Simplified data modelling due to columnar data base.

Read full review

Verified User

Director in Information Technology

Telecommunications Company, 10,001+ employees

View all 8 answers on this topic

Cons

IBM is really behind in delivering developer tools. They pride themselves on Data Studio, but it is just frustrating.
Marketing. Horrible to do a Google search and get returns for a COMPLETELY different product, for z/os. Why they share the same name is beyond me. Better marketing would also increase the user base and help the product mature.
Slower than the competition to roll out next-generation features.

Read full review

Verified User

Employee in Information Technology

Financial Services Company, 1001-5000 employees

View all 18 answers on this topic

Enterprise license pricing is very expensive and run-time license limits the usefulness of the tool.
Integration with SAP Analytics cloud for write-back to BW/4HANA. Live connection is only read from SAC.
Make run-time licenses more useful.

Read full review

Product Owner - Management Reporting SAP S4 / HANA

HP IncInformation Technology and Services, 10,001+ employees

View all 8 answers on this topic

Likelihood to Renew

DB2 8.0

Based on 2 answers

Because it is required to support our business unit

Read full review

Verified User

Engineer in Information Technology

Luxury Goods & Jewelry Company, 10,001+ employees

View all 2 answers on this topic

No score

No answers yet

No answers on this topic

Usability

DB2 8.0

Based on 3 answers

You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.

Read full review

J.R. Bullington

Senior Infrastructure Engineer

Open Dealer Exchange, LLCInformation Technology and Services, 51-200 employees

View all 3 answers on this topic

SAP BW/4HANA 8.5

Based on 2 answers

SAP BW/4HANA requires specialized skillsets around data warehouse modeling and the access to data, however the modeling capabilities are intuitive and have now become accessible to both SAP and non-SAP data warehouse specialists. This new model allows for Interchangeable skillsets and access to a broader pool of experts throughout the industry, as well as easier access to data.

Read full review

Verified User

Director in Information Technology

Telecommunications Company, 10,001+ employees

View all 2 answers on this topic

Reliability and Availability

DB2 10.0

Based on 20 answers

DB2 for i is extremely stable. I've experienced system slowdowns and performance issues on badly configured systems or badly configured system accessing the DB but that's it, never had a problem caused purely by the software. Support is also pretty good.

Read full review

Roberto Etcheverry

Solution Architect

ROER International SAComputer Hardware, 11-50 employees

View all 20 answers on this topic

No score

No answers yet

No answers on this topic

Performance

DB2 9.9

Based on 20 answers

The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.

Read full review

Verified User

Manager in Other

Banking Company, 10,001+ employees

View all 20 answers on this topic

No score

No answers yet

No answers on this topic

Support Rating

DB2 8.5

Based on 2 answers

The support experience is good. There is room for improvement in terms of the delivery of support services to customers

Read full review

Project Engineer

Wipro LimitedInformation Technology & Services, 10,001+ employees

View all 2 answers on this topic

SAP BW/4HANA 9.4

Based on 9 answers

SAP Max Attention and general support for SAP BW/4HANA is broadly available. Truth to be told, MaxAttention has a premium cost but brings great engineers. So this being an enterprise capability and extremely critical, we did not consider cost as the main factor since support works well. Just keep that in mind when making your selection.

Read full review

Verified User

Executive in Information Technology

Consumer Goods Company, 10,001+ employees

View all 9 answers on this topic

Alternatives Considered

DB2 is a similar product that is most respected. Oracle might be supported in a broader context, but DB2 is superior on every platform where the choice is there. Licensing is also a factor in which DB2 is much better, which might offset any cost differences. DB2 support is also much better at all tiers.

Read full review

Verified User

Manager in Information Technology

Consumer Goods Company, 10,001+ employees

View all 18 answers on this topic

SAP Analytics Cloud is complemented by SAP BW/4 HANA through connectors that work in real-time and allow the display of indicator information in interactive and user-friendly visualizations.SAP Data Services integrates with BW/4 HANA allowing to automate the loading of information in the system taking as a data source a wide variety of platforms.

Read full review

Gerente de Consultoría

SEIDOR AnalyticsInformation Technology and Services, 201-500 employees

View all 8 answers on this topic

Scalability

DB2 9.7

Based on 10 answers

It can grow as your company grows. It also plays well with Crystal Reports and other BI software once you create an ODBC connection for the DB. It can be managed with SQL management studio so no extra software is needed for that.

Read full review

Josh Rice, MBA, ACSP

IT Project Manager

Fort Financial Credit UnionBanking, 51-200 employees

View all 10 answers on this topic

No score

No answers yet

No answers on this topic

Return on Investment

Positive - Very good performance as compared to other traditional DBs.
Positive - Transaction and query search are made easy from a DB level with good performance, also runs on top scape on AIX servers.
Negative - There is always room for improvement, such as Webex queries and the GUI base tool. Also the available support documentation should be improved.

Read full review

Sr. SAP Basis Consultant

Gauri Ltd. | Transforming Customer Engagement For The Digital AgeInformation Technology and Services, 51-200 employees

View all 18 answers on this topic

Faster turn-around to enhancements
End users can query structures that are not limited to multi-dimensional models.
Performance improvements means that business user can do more in the same time compared to traditional BW

Read full review

Senior Technical Specialist

Rio TintoMining & Metals, 10,001+ employees

View all 8 answers on this topic

Screenshots

—

See All (6) SAP BW/4HANA Screenshots

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

Yes

Entry-level set up fee?

Optional

Add comparison