Volume 9, Number 6 -- February 10, 2009

DB2 Web Query Goes Multiplatform

Published: February 10, 2009

by Alex Woodie

Information Builders and IBM announced last week that they are collaborating to build an adapter that allows the DB2 Web Query for i business intelligence product to process data from non-DB2/400 databases. The first database adapter, expected later this year from Info Builders, will target SQL Server, with more database adapters expected in the future.

DB2 Web Query is a special version of Information Builder's WebFOCUS software that IBM announced almost two years ago. The 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 for i (Query/400), which has been a reliable (if aging) member of the i OS (OS/400) middleware stack for years.

Since IBM launched DB2 Web Query 18 months ago, it has sold more than 20,000 licenses, with more than half of those coming in just the last six months, according to IBM (although the current number is probably closer to 25,000). That success is partially attributable to the fact that IBM lowered license fees on the product a year ago in response to customer requests to separate the development and user licenses.

With the upcoming launch of the database connectors later this year, IBM and Info Builders are showing that they are still listening to their DB2 Web Query customers. "From the very beginning when we first brought out the product, within the first three months we heard customers saying 'Gee can't we use this to talk to SQL Server'?" says Gary Goldberg, vice president of WebFOCUS System i for Info Builders. "It was always the number one database that people asked for."

The new SQL Server database adapter is largely built on an existing JDBC-based adapter developed by Information Builders for its WebFOCUS product line, Goldberg says. "What?" you might be saying to yourself. "It's just a plain old JDBC driver?" That would be incorrect. In fact, Information Builder's SQL Server adapter is no ordinary JDBC driver.

Goldberg explains: "We always try to go for the most native, the most functional interface that we can find," he says. "So for example, we don't use ODBC or JDBC to go after Oracle--we use Oracle's native API. We don't use any kind of JDBC or ODBC driver to get to a VSAM file on a mainframe. We use native VSAM calls.

"With SQL Server, it happens to be JDBC. Because, guess what, Microsoft only supports ODBC and JDBC, so we don't have an option. And we do use the JDBC driver that Microsoft offers to the maximum extent," Goldberg continues. "We have a separate interface that we've created, a separate adapter for Microsoft SQL Server, because we maximize all the extensions that we can pass to that JDBC adapter, and the way we interact with SQL Server. So IBM will get the benefit of all that extra work that we do."

The SQL Server adapter will allow customers to join data from DB2/400 and SQL Server with a single request. Once developers build the reports, users will be able to view reports based on data originating on i OS and Windows applications, from the same environment.

That's a big time saver for System i shops that want to keep users in the System i environment, Goldberg says. "Oracle may have a great [BI] solution, but it's going to require you run it on a Windows or a Unix platform. And there are still a fair number of i customers that don't want to do that," he says.

Next to SQL Server, JD Edwards was the next most requested adapter, Goldberg says. Information Builders already sells adapters for Oracle's World and EnterpriseOne ERP suites, but there are no concrete plans for IBM to offer them. Customers can move to the WebFOCUS product and license these adapters directly from Information Builders. But IBM says it will offer new adapters for DB2 Web Query in the future. Nothing has been decided, but other possibilities include Lotus Domino, Oracle database, and Essbase, as well as JDE.

Goldberg--who was the Info Builders executive primarily responsible for brokering the DB2 Web Query deal--is bullish on the System i's BI capability, particularly with the new line of entry-level Power Systems servers.

"When they were trying to limit capacity through the CPW and at the same time promoting the use of modern languages and tools like Java, it was a losing situation, because that just didn't work technically," he says. "But the new CPW capacity is quite high. And you can run Web Query on any of those boxes without blinking an eye."

IBM says the beta for the new SQL Server adapter will start this quarter, with general availability during the first half of the year. Pricing has yet to be set, but Goldberg says to expect server-based pricing that's inline with the other add-on products for DB2 Web Query from IBM.

Info Builders develops and sells several add-ons for DB2 Web Query, in addition to the upcoming database adapters, including: the 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, and Information Builders and IBM are working on bringing some Excel functionality into the product, which hopefully will be available, along with the SQL Server adapter, by the end of June.

For more information on the product, visit IBM's DB2 Web Query homepage or www.informationbuilders.com.


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

Do you know the full spectrum of
malicious code threats?

Today's malicious code comes in many forms
and from where you least expect it. SOX-style
legislation and the evolving threat from viruses is
challenging the ability of IT management to keep
up with security requirements.

As threats from malicious code evolve, protect
your systems and network by taking the fight to
the viruses where they hide.

Learn more in
"The Modern Virus Threat"

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

ARCAD Software:  FREE Webinar, How ALM Can Save You Money, February 19
COMMON:  Join us at the 2009 annual meeting and expo, April 26-30, Reno, Nevada
Bytware:  Protect your systems by taking the fight to the viruses where they hide


IT Jungle Store Top Book Picks

Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
Getting Started with PHP for i5/OS: List Price, $59.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 Developers' 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
iSeries Express Web Implementer's Guide: List Price, $59.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
WebFacing Application Design and Development Guide: List Price, $55.00
Can the AS/400 Survive IBM?: List Price, $49.00
The All-Everything Machine: List Price, $29.95
Chip Wars: List Price, $29.95

The Four Hundred
Database Server/400, Anyone?

Who's the Fool When it Comes to Training?

Google's Love Affair with IBM's Offspring

As I See It: If I Were Wise Enough, I Might Say. . .

Web Site Vulnerabilities Continue Unabated, IBM X-Force Says

Four Hundred Guru
A Bevy of BIFs: Look Up to %LookUp

Treasury Of New DB2 6.1 Features, Part 1: Query Enhancements

Admin Alert: Time Gobbling Tasks for a System Upgrade

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

System i PTF Guide
February 7, 2009: Volume 11, Number 6

January 31, 2009: Volume 11, Number 5

January 24, 2009: Volume 11, Number 4

January 17, 2009: Volume 11, Number 3

January 10, 2009: Volume 11, Number 2

January 3, 2009: Volume 11, Number 1

TPM at The Register
NEC confirms European PC biz shutdown

US sheds 598,000 jobs in January

Ubuntu shops believe in Ubuntu

Chipzilla sits on its Tukwila

IT questions Obama's IT stimulus

Sun christens once and future Supernovas

Citrix boosts seat count for XenDesktop

Hitachi takes losses, chops jobs

Uncle Sam buys 20 petaflops BlueGene super

Dell pairs with Xsigo on virtual I/O

Sun taps ex-Merrill, ex-Fannie Mae exec for board

Intel to spill Nehalem secrets

Novell cuts 1000 100 workers

Ex-IntelCrayAkamai startup rejiggers virtualization


New Generation Software
Seagull Software
ARCAD Software
RJS Software Systems

Printer Friendly Version

Linoma Refines Data Distribution Tasks with GoAnywhere 2.0

DB2 Web Query Goes Multiplatform

GroundWork Revs Performance of Monitoring Tool

InstallAnywhere 2009 Looks to Smooth Java App Installs

New Address Correction Software from WorksRight is Suite

News Briefs and Product Shorts:

System i: The New Choice of a Fashion-Conscious Generation . . . SafeNet's Crypto Appliance Plugs Into SOA . . . Hitachi Updates Identity Management Software . . . IBM Teams with Lawson for HR Management . . . Payback Is Not Sweet for RFID, ABI Research Says . . .

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