• IBM i Shops Have Alternatives to Db2 Web Query

  November 15, 2023 Alex Woodie

  The sudden demise of Db2 Web Query has sent customers looking for alternatives. The good news is that IBM i software vendors offer a number of pre-built solutions that can fit the bill.

  Here are some potential business intelligence tools from vendors that could serve as replacements to Db2 Web Query. We’ll take a look at open source alternatives in a future article.

  Cozzi Research SQL World

  Cozzi Research develops two query tools for IBM i, including SQL iQuery and SQL Tools, and bundles them both in a single product called SQL World.

  Cozzi positions SQL iQuery as a native …

  Read more

• IBM, TIBCO Remain Mum on Db2 Web Query Future

  November 1, 2023 Alex Woodie

  While Db2 Web Query users are left hanging in the wind without any official way forward to protect their investments in the product, IBM and TIBCO have yet to make any public announcements about how to support these IBM i customers moving forward.

  IBM shocked the midrange last month when it announced the sudden end of life of Db2 Web Query, the IBM i-based analytics tool that was largely based on an OEM (original equipment manufacturer) version of the WebFOCUS product originally developed by Information Builders and now owned by TIBCO.

  The October 10 announcement – the same day …

  Read more

• Guru: The Transition From Modern RPG IV To Modern SQL

  October 30, 2023 Bob Cozzi

  Seven or eight years ago I was working with a client who needed more contemporary reporting than provided by the legacy Query/400 product. Initially I looked at Db2 Web Query and realized the documentation was sparse and the tutorials for most things, even “getting started” were virtually non-existent. It was also about four times more expensive than I felt it was worth to a P05 or P10 client. I mentioned the documentation issue to the folks at IBM and they agreed. Some of it was eventually resolved, but not enough in my opinion to get the masses to replace Query/400 …

  Read more

• Db2 Web Query Customers Left In The Lurch

  October 23, 2023 Alex Woodie

  The sudden collapse of the OEM agreement between IBM and TIBCO for Db2 Web Query has left users of the product in a difficult position. Where will they get technical support, updates, and fixes? Should they abandon the software? Can they sue somebody if something happens to their systems?

  These are some of the questions that IBM i shops who adopted Db2 Web Query are asking themselves in the wake of IBM’s stunning October 10 announcement to kill off the product. Effectively immediately, IBM stopped marketing and selling the IBM i product, which was an OEM version of Information …

  Read more

• Why Big Blue Is Simplifying The IBM i LPP Stack

  October 23, 2023 Timothy Prickett Morgan

  If only the paranoid survive, as legendary Intel co-founder Andy Grove once quipped, then we all would pretty much have to be paranoid pretty much all the time. And this, obviously, would not be healthy. But as legendary founder of The Four Hundred, the irreplaceable and irascible Hesh Wiener, once quipped, sometimes they really are out to get you.

  And so, we come to IBM’s recent “come to Bezos” moment starting late last year that it was going to be providing subscription pricing for hardware and systems software for the IBM i platform running on Power Systems. We fully …

  Read more

• Db2 Web Query: Way More Than Just A Query Tool

  February 27, 2023 Alex Woodie

  You might be forgiven for thinking that Db2 Web Query is just a way to run your SQL queries on IBM i from a browser. After all, “Web” and “query” are right there in the name, aren’t they? But the product’s name belies the true nature of this multi-threat analytics application, which can do a whole lot more for IBM i shops than just run queries.

  IBM’s Doug Mack tackled this reality-assumption gap during a recent webinar on Db2 Web Query, which received a bunch of new capabilities with the recent version 2.4.0 upgrade. Mack, a longtime IBMer whose …

  Read more

• Data Is Streaming Into The Cloud, Including From IBM i

  November 14, 2022 Alex Woodie

  We are in the midst of a vast migration of data into public clouds, as companies seek to leverage technological innovation occurring in the cloud for competitive advantage. While there are no IBM i runtimes in the public cloud yet, IBM i shops are still getting value by moving their valuable Db2 for i data into the cloud, often using streaming technologies and tools like Apache Kafka and Apache Camel, as well as an updated ETL offering from IBM.

  It is tough to understate the magnitude of the transition to the public cloud is having on the $4 trillion IT …

  Read more

• Db2 Web Query Gets ML-Powered Insights, Cloud DW Connection

  November 2, 2022 Alex Woodie

  Organizations adopting the latest release of Db2 Web Query will find new capabilities in the graphical designer, an automated insights generation function that uses machine learning as well as new capabilities in the data migration tool that will help customers move data to cloud data warehouses, among other capabilities.

  Db2 Web Query is IBM’s flagship business intelligence offering for the IBM i platform. The software is based on WebFOCUS, the BI offering developed by Information Builders, with whom IBM has had an OEM relationship since 2007. In 2021, Information Builders was acquired by TIBCO Software, which has continued …

  Read more

• IBM Mulls Using DataMigrator as Cloud Warehouse Pipeline

  June 29, 2022 Alex Woodie

  IBMers are playing around with an update to a little-known ETL tool called DataMigrator for i that would make it easier for IBM i shops to move transactional data to cloud-based data warehousing platforms. The update would use Apache Kafka for the final connection to the cloud.

  DataMigrator ETL Extension, as the product is formally known, is an extract, transform, and load (ETL) tool created by IBM back in 2015. The product was developed to work with Db2 Web Query, the Java-based business intelligence tool that it OEMed from Information Builders (now owned by TIBCO).

  DataMigrator for …

  Read more

• COMMON Set for First Annual Conference in Three Years

  May 18, 2022 Alex Woodie

  Don’t look now, but COMMON is about to hold its first annual conference in three years. Starting on Monday in New Orleans, POWERUp 2022 will be the biggest gathering of the IBM i community since the pandemic started more than two years ago. There is still time to register for the conference, which will feature a raft of presentations on the newly released IBM i version 7.5.

  COMMON’s annual conference scheduled for the New Orleans Marriott next week is shaping up to be a good one. More than 100 speakers are scheduled to present more than 300 sessions on …

  Read more

Previous Articles