Volume 9, Number 22 -- June 2, 2009

DB2 Web Query Updates to Ship in August

Published: June 2, 2009

by Alex Woodie

The new DB2 Web Query enhancements--including an adapter that provides "occasional" access to the SQL Server database from the i OS business intelligence tool, and the capability to access and update DB2 Web Query reports from within Excel--won't ship until August, IBM announced recently. The new capabilities were originally expected to be available by the end of June, back when the announcements were first made with Information Builders in February, but the timeline has apparently slipped.

DB2 Web Query is a special version of Information Builders' WebFOCUS software that IBM announced in 2007. The Java-based software enables users to write queries for the DB2 for i (DB2/400) database and view the results in a Web browser. It's designed primarily to be a more graphical and feature-rich replacement for IBM's Query/400, which has been a reliable member of the i OS (OS/400) middleware stack for years.

In February, Information Builders and IBM announced pending updates to DB2 Web Query that give the products more hooks into the Microsoft BI environment. This included a new adapter allowing users to incorporate data stored in SQL Server into their DB2 Web Query reports, and a new Spreadsheet Client feature will allow users to embed their DB2 Web Query reports directly into Excel, and also to refresh the data from the spreadsheet.

According to IBM, the new features provide deeper integration with Microsoft products, "without forcing you to replicate data around a network or implement different components on multiple servers," the company says in its April 28 announcement letter.

The new SQL Server Adapter will help turn DB2 Web Query into the single, go-to reporting tool for the enterprise, IBM says. While many i OS shops keep most of their data on DB2/400, they store data that's slightly less critical (but still important) on SQL Server databases. By installing the SQL Server Adapter, users will be able to analyze data from DB2/400 (DB2 for i) and SQL Server databases using the same query definitions, and simplify the report distribution and dashboard creation process along the way.

The SQL Server Adapter will support SQL Server 2000 and SQL Server 2005 databases; there's no word on whether the software will support SQL Server 2007, which introduced 64-bit support. Users will also be able to access multiple SQL Server instances with a single adapter, IBM says; there's no word on whether users can mix and match analysis of SQL Server 2000 and SQL Server 2005 data. It is likely that IBM and Info Builders will develop support for additional databases in the future.

The new Spreadsheet Client will give users of DB2 Web Query another way to access data from DB2/400 (and SQL Server if they have the adapter noted in the previous paragraph). In addition to the dashboard, PDF, and Windows-based front-ends for DB2 Web Query, which work well for executives and power users, the new Spreadsheet Client will be ideal for accountants and other financial whizzes who spend a lot of time with their noses buried in Excel spreadsheets, according to IBM.

Specifically, the new Spreadsheet Client will allow users to build spreadsheet reports that get automatically refreshed with queries from DB2 Web Query--automatically, it's worth adding, with no manual intervention required by users. Users will also be able to burst data into multiple worksheets, and refresh data in a server-based Excel application or template, according IBM. Data computations and totals are brought into Excel as native formulas, and you can add data filtering and style the output to further enhance the data within Excel, IBM says.

Users will also be able to create new queries against DB2/400 data with the new Spreadsheet Client, but only if they have named-user licenses and have the proper authorities to access the Report Assistant component of the base product. (Named user licenses are more expensive than the run-time user licenses that IBM created last year after listening to criticism that the product was too expensive.)

The Spreadsheet Client and SQL Server Adapter help round out a suite that already offered several options. Info Builders develops and sells several add-ons for DB2 Web Query, including: an OLAP Module, for drill-down and multidimensional database reporting; Active Reports, for accessing reports while disconnected from the server; and a Developer Workbench for creating more advanced reports and dashboards. IBM also recently added a new Report Broker and a software development kit (SDK) to the DB2 Web Query lineup.

Pricing for the SQL Adapter ranges from $1,600 on a P05 box to $28,800 on a P60 box. Pricing for the Spreadsheet Client ranges from $400 on a P05 box to $12,000 on a P60 box. The new products will ship with DB2 Web Query V1R1M1 on August 21. For more information, see Software Announcement 209-090 and, be sure to check out IBM's DB2 Web Query Web page for APARs associated with the new software.


DB2 Web Query Goes Multiplatform

IBM Updates DB2 Web Query Business Intelligence Tool

IBM Makes DB2 Web Query More Affordable

IBM Prepares to Launch DB2 Web Query for System i

More Details Emerge on Query/400's Java-Based Replacement

IBM to Distribute Info Builders' iSeries BI Tools

                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot

Sponsored By

Resilience for a Smarter Planet:
Real Stories. Real Options.


Learn how companies just like yours are
stopping downtime pain.


On June 23rd join IBM Vice President, Stephanie Carmel and Vision Solutions Chief Technology Officer, Alan Arnold to learn how IBM's new Dynamic Infrastructure initiative and Vision's Resilience 2.0 technologies are helping companies like yours prevent application downtime.


When: Tuesday, June 23rd at 10:00 a.m. Central


Click to register!

Editor: Alex Woodie
Contributing Editors: Dan Burger, Joe Hertvik,
Shannon O'Donnell, Timothy Prickett Morgan
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Sponsored Links

Halcyon Software:  Webinar: How to Survive in IT with a reduced headcount, June 4
Maximum Availability:  *noMAX - Subscription edition now available (US & UK)
10ZiG Technology:  BOSaNOVA, Inc. is now 10ZiG Technology


IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
The iSeries Express Web Implementer's Guide: List Price, $49.95
The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
Can the AS/400 Survive IBM?: List Price, $49.00
Chip Wars: List Price, $29.95

The Four Hundred
IBM Makes the Case for Power Systems SSDs

Server Sales Breakdown Bigtime in the First Quarter

COBOL at 50: Same Age as Barbie, But More Like Rodney

Why Are Systems Programmers Always To Blame?

OCEAN Conference Emphasizes Higher Education, Lower Fees

Four Hundred Guru
Faster Fetching

A Bevy of BIFs: %Dec to the Rescue

Admin Alert: Four Ways to Encrypt i5/OS Backups, Part 2

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

System i PTF Guide
May 30, 2009: Volume 11, Number 22

May 23, 2009: Volume 11, Number 21

May 16, 2009: Volume 11, Number 20

May 9, 2009: Volume 11, Number 19

May 2, 2009: Volume 11, Number 18

April 25, 2009: Volume 11, Number 17

TPM at The Register
AMD cuts Opteron prices pre-Istanbul

Novell cuts ERP outsource deal

Novell carbon copies another quarter

Super computer innovator preps for asset sale

EMC lashes another to its systems management vision

IDC: First quarter worst for servers in 12 years

Cisco touts self as Unified Computer System pioneer

Ingres and Red Hat unite to thwart Ellison's Sun love

Intel: Nehalem EP ramp is steep

Intel pushes Nehalem EXs into 2010

Rambus pitches XDR2 for future memory

Unisys soups up mainframe engines

Super interconnect maker Quadrics going titsup

IBM ships SSDs for Power Systems


10ZiG Technology
Vision Solutions
Computer Keyes
RJS Software Systems

Printer Friendly Version

OpenSpan Aims to Bring Mainframe Qualities to Desktop Integration

DB2 Web Query Updates to Ship in August

Quadrant's IntelliChief Gets Integration Hooks to JDA's MMS

SugarCRM Updated with Version 5.5 Beta

MQ Security Tools from Capitalware Now Available for i OS

News Briefs and Product Shorts:

D&B Global Helps Companies Calculate the True Cost of EDI . . . Ferrosan Outsources i to IBM, Eliminates Expense and Complicatedness . . . Vision Offers Web-Based Training for HA . . . VAI Brings Two More Companies Onto the i OS Platform . . . Are You an IT Action Hero? Aldon Wants to Know . . .

Four Hundred Stuff


Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2009 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement