DB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.
$0
SAP Business Data Cloud
Score 8.6 out of 10
N/A
SAP Business Data Cloud is a fully managed SaaS solution that unifies and governs all SAP data and seamlessly connects with third-party data—giving line-of-business leaders context to make even more impactful decisions.
We are underway to evaluate both, in their benefits versus concerns. One thing that makes IBM Db2 better is it is a very mature database with great performance
The decision to select IBM Db2 is typically driven by specific enterprise needs:Mission-Critical Workloads: Db2 is built to handle highly demanding transactional (OLTP) and analytical (OLAP) workloads with high reliability and continuous availability via features like Db2 …
Db2 for i SQL is much more standard compliant than SQL Servers dialect. And with Visual Explain its much easier to optimize SQL queries for optimal performance.
I have used DBArtisan before in another project with similar use cases, and both are very reliable and work well. As this application is compatible with their platforms, the current company is using the IBM db2 for the work.
Oracle and Microsoft are the ones that we have more to compare with and they are on par with Db2. Postgres is the small solution that usually we leave behind and move to Db2. Mongo is the one that is different from what I used Db2 for but I know it has the capability to use …
The reason is pretty straight forward. Majority of our data originates from SAP source systems like SAP S4 private cloud, S4C public cloud and Bydesign. So SAP Business Data Cloud stands tall when compared to other solutions and i honestly believe this is best suited solution …
With a S4 backend a lot of core functionality is made simpler - authorization, data types, currency conversion. In particular if the front end choice is SAP Analytics Cloud.
The lack of a good connection from Power BI to the datasphere application (instead of the underlying HANA …
Business data cloud is one tool that takes care of extraction, modelling, and AI ML use case in the landscape, whereas in other tools I was using multiple services to take care of each of the functions, hence BDC is a cool tool im action for our use cases. Low low-code option …
BDC is a significant development over Datasphere in the sense that it unifies not only the transaction and olap systems but also other olap systems which may have existed in the landscape. Pce migration and availability of data from and 7.5 or B4 HANA system as a data product …
I have primarily used it as the basis for a SIS - but I have migrated more than a few systems from there database systems to DB2 (Filemaker, MySQL, etc.). DB2 does have a better structural approach, as opposed to Filemaker, which allows for more data consistency, but this can also lead to an inflexibility that can sometimes be counterintuitive when attempting to compensate for the flexibility of the work environment as Schools tend to have an all in one approach.
SAP Business Data Cloud is suited mainly for SAP data integration. We could able to easily consolidate the data from S4 and service cloud V2 system. SAP Business Data Cloud enables realtime data replications. We could able to leverage the AI core features. As my previous data warehousing skill is from SAP BW, I am missing some basic features comparing to BW. Master data manual maintenance, Time dependant masterdata, language independent text is also not straightforward.
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.
SAP Business Data Cloud help in arranging data at one single place reducing cost of maintenance for multiple platforms and governance.
Once data is arranged , it can be modelled as needed using Datasphere and in data bricks for AI needs
Data fabric provided in SAP Business Data Cloud helps in reducing man efforts to design models needed for PNL reporting as data fabric helps in quickly designing the solution with great accuracy.
The DB2 database is a solid option for our school. We have been on this journey now for 3-4 years so we are still adapting to what it can do. We will renew our use of DB2 because we don’t see. Major need to change. Also, changing a main database in a school environment is a major project, so we’ll avoid that if possible.
The platform provides strong values in terms of centralized data management, scalability, and integration with the SAP ecosystem. It supports enterprise reporting, governance and analytics effectively. While there is always room for improvement in usability and cost transparency, the long term benefits in performance, data consistency and cross functional collaboration and expanding within the organization
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.
SAP Business Data Cloud offers robust capabilities that enable me to analyze data and extract valuable business insights. It creates a single source of truth with seamless SAP integrations that enable faster, more reliable reporting. It has freed my team from complex engineering efforts by simplifying data analytics, giving us more time to focus on generating insights.
I have never had DB2 go down unexpectedly. It just works solidly every day. When I look at the logs, sometimes DB2 has figured out there was a need to build an index. Instead of waiting for me to do it, the database automatically created the index for me. At my current company, we have had zero issues for the past 8 years. We have upgrade the server 3 times and upgraded the OS each time and the only thing we saw was that DB2 got better and faster. It is simply amazing.
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.
Easily the best product support team. :) Whenever we have questions, they have answered those in a timely manner and we like how they go above and beyond to help.
support team is generally responsive and knowledgeable, and most issues are addressed within acceptable timelines. Documentation and standard guidance are helpful for common scenarios.
One of the best training session I attended and they covered most of the topics and answered all our questions. participants joined from different regions, infact they all had a different questions and it was different thoughts from all of then and helped to learn better. Though I was on travel, I could able yo attend the session.
I have done implementation of models in traditional bw and Using BDC. The integration of BDC with S4 hana for creating sap data products is seamless and reduces lot of implementation effort. The intelligent app feature is BDC also eases the implementation effort. If i have to compare the previous world with new BDC, implementation effort is largely saved
With the other two mentioned above, I needed to have processes and frameworks that executed outside of the environment driving DB management operations. Yes, these are completely different solutions; however, the support you get for framework, library, and language support allows for runtime at a different layer than with other solutions.
The reason is pretty straight forward. Majority of our data originates from SAP source systems like SAP S4 private cloud, S4C public cloud and Bydesign. So SAP Business Data Cloud stands tall when compared to other solutions and i honestly believe this is best suited solution for the warehousing and reporting to our organization.
DB2 can be configured and can work with a variety of applications as opposed to how it was designed initially to only with with IBM mainframes. It's easy implementation process makes it a good buy for many organizations to scale their applications to be the best in terms of versatility, resilience and application performance
