The evolution of Db2 Web Query for i continues with a new
version announced on October 3rd, 2017. With Version 2.2.1, both the
Business Intelligence product set and the DataMigrator ETL (Extract,
Transformation, and Load) component are enhanced - adding several new features
to address user requests as well as bring new industry features for reporting
and analytics to IBM i customers.
There have been several times in the history of this product
where IBM has delivered minor changes, and other times when you could say the
product capabilities took a major leap. An example of a big leap was when Db2
Web Query went from the Report/Graph Assist report authoring tools to the much
more intuitive, powerful InfoAssist component. Another major leap was adding DataMigrator ETL
with its integrated ability to un-tangle data into data marts or data
warehouses.
Version 2.2.1
marks another major leap! This new version, available in mid-December, extends the
community of users to the data analyst (or data scientist). New powerful “data
discovery” analytics and visualizations make it even easier for analysts to
navigate through data to understand what is driving the business.
End users will be more empowered by new features such as auto link, auto drill down, and dynamic parameter navigation. Version 2.2.1
makes it easier for the end user to iterate through data and across
multiple reports without having to go back to the report author for changes in
the original report(s). The ability to interactively select data on the report
to create a filter will be very useful to analysts to focus on related data of
interest – within the same report.

Were you aware of the geographical mapping visualizations in previous versions
of Web Query? In 2.2.1, this gets even more interesting with additional
enrichment to bring in information to your maps quickly and easily. New
“layers” on the maps support such things as adding demographic data.
Learning how to build new Data Visualizations will be easier
with embedded video links to walk you through the steps. Here is a complete set of Version 2.2.1 Video Demonstrations - be sure to look at the ones titled "Visualizations."
Upgrading to 2.2.1
is a no charge software update (assuming you are current on software
maintenance). The Db2 Web Query EZ-Install package for 2.2.1 is now available to simplify that upgrade, or you can use it to install for the first time and run the complete product set under a 70
day trial.
To request the package, send an email to QU2@us.ibm.com and include your name, company name, and serial number of the system where you plan to install the software. When you're done installing we'll point you to a website for "next steps" that includes a test-drive, tutorials, and documentation on the Query/400 Discovery tool and Sample System Administration reports!
Doug, I noticed the videos showed the IBI version. How much of this functionality will make it into the IBM version?
ReplyDeleteWhat I saw can totally replace Tableau!! Awesome!
KT
Hi Kris, yes, I posted these videos specifically because this is the functionality coming into 2.2.1 (and we aren't done yet with our own video versions)!
Delete-- Doug
Your link ibm.biz/db2wqezinstall-info did not work for me. It says the link is pointing to C drive??
ReplyDeleteThanks for any help with this.
Hi Cole, I'll take a look - its working for me, but, actually, it would just take you to another blog post - so just scroll down a bit to see the post.
Delete