Great scalable long term solution
September 11, 2024

Great scalable long term solution

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Software Version

Db2 on cloud

Overall Satisfaction with Db2

Our data and analytics team uses the platform as a relational database to manage, collect and store data. I use to to maintain data coming from multiple data sources, and is used to manage tasks relating to data integrity, data governance and data hygiene. Starting with initial implementation, it was seamless to transition and get up and running across our team.

Pros

  • Database querying - using query logic within the platform to build, test and deploy queries, and run multiple jobs and execute tasks is not troublesome and works well with our data systems.
  • Manipulating data - Formatting and executing data tasks to integrate with external platforms is one of the core business needs to move data between systems.
  • Data modeling - it's been relatively smooth to begin the process of modeling our data to fit the structure of multiple business units which all have different data needs. It is flexible and works well with storing and maintaining multiple data structures.

Cons

  • Being able to execute queries of the same data while multiple users are running tasks at the same time can be problematic and cause the system to run slow.
  • The support available to troubleshoot system error codes and runtime errors can be an issue and I wished was more readily available.
  • It has been costly when we've had to scale up some of our marketing databases and data structure sizing and I would like to see a change to the cost model.
  • There is great value the solution brings when it comes to building stored procedures and ongoing tasks that allows our team to streamlines processes.
  • The platform has allowed us to see value by providing a solution for data structuring and data hygiene which prevents deduplication of data and lowers costs
  • With the integration capabilities it allows our analytics team to more seamlessly create highly visible dashboards that see directly into the data and pinpoint areas that need attention.
The scalability features of the platform stand out as a positive overall. When the needs of the business changed and the structure of our data had to change with it, we had to scale up our storage needs. Our team did not experience any significant hiccups while we scaled up over a period of several months.
The overall availability is very positive in my experience as well as hearing from colleagues. The unplanned outages and system failures happen on occasion which is to be expected, however the availability and being able to schedule downtime during off hours when needed is overall positive and has not caused great concerns.
Db2 has overall stronger capabilities with data maintenance, governance and task scheduling, however Teradata has a more developed online community with more robust and timely customer support. The support and training capabilities and the user community where you can interact with other users is stronger with Teradata, in my experience over the last few years.

Do you think Db2 delivers good value for the price?

Yes

Are you happy with Db2's feature set?

Yes

Did Db2 live up to sales and marketing promises?

Yes

Did implementation of Db2 go as expected?

Yes

Would you buy Db2 again?

Yes

The platform is a viable and flexible option for larger cross functional and technical teams who have evolving data needs and need room to move from different systems of record and multiple sources of data over time. It is not as appropriate for smaller teams that have single databases that do not connect to external systems or existing tools in your tech stack.

Comments

More Reviews of Db2

  1. Home
  2. Relational Databases
  3. Db2 Reviews
  4. User Review of Db2