• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • NGS Hooks Into Query/400 to Protect BI Investments

    June 19, 2007 Alex Woodie

    When it comes to i5/OS business intelligence (BI) solutions, good old Query/400 has a huge following. While the tool is no longer being updated by IBM, many i5/OS shops have large investments in Query/400 that they aren’t able or willing to abandon. Rather than force customers to start from scratch, BI software developer New Generation Software is now helping customers protect their Query/400 investments by inputting the queries into its NGS-IQ suite through a new API announced last week.

    The new API from New Generation Software (NGS) enables users to take their older queries developed with Query/400 and run them or input them into NGS’ flagship product, the NGS-IQ business intelligence suite. Users will gain the capability to load their older queries into Excel spreadsheets, convert them into XML, or distribute them as PDF documents. They can also run an entire series of Query/400 queries in a specified order before enhancing them with NGS-IQ, according to NGS.

    NGS IQ is a collection of business intelligence software products that run on i5/OS and Windows machines. At the heart of the NGS IQ suite is the Intelligent Query (IQ) Server, the core data warehousing and reporting tool that is used to create data warehouses, design reports, and run queries against the DB2/400 database.

    Surrounding the IQ Server is a supporting cast of products that includes:

    • Qport Access, which is used to access i5/OS-based IQ Server queries and reports and distribute them via Windows formats and applications, such as Excel
    • Qport Builder, a companion tool to Qport Access that delivers more advanced reporting capabilities and works from a Windows or a Web interface
    • IQ SeQure, a security module that works with i5/OS to allow or restrict user access to databases and queries
    • Qport SmartView, a Windows-based on-line analytical processing (OLAP) module that is used to develop advanced multidimensional reports
    • Business Performance Dashboard, a collection of prebuilt Web interfaces that exhibit IQ Server reports using a series of graphical elements, such as charts and tables, designed for specific business functions, like inventory or finance
    • Decision Assist, a pre-built, Windows-based analytical solution that works with IQ Server and SmartView to deliver detailed reports, such as sales by division or top manufacturing items by profit margin
    • IQ Client, the new Windows-based query and report writing tool that works in a drag-and-drop manner and supports all of IQ Server’s functionality

    “For thousands of System i customers, Query/400 reports embody a huge source of intellectual capital,” says John O’Sullivan, NGS’ vice president of IT. “They contain valuable information about file relationships and unique business processes. Many companies tell us they want to improve their BI solution but don’t want to recreate all their queries in order to move ahead. With this API they don’t need to, and their path to a positive return is almost immediate.”

    The huge Query/400 footprint is becoming increasingly important in the System i business intelligence market. Earlier this year, IBM announced that it would deliver a new product that would support older queries developed with Query/400 and make them available through a more modern business intelligence tool. That product, which IBM is developing with Information Builders, is called DB2 Web Query.

    Is NGS’ new API a response to DB2 Web Query? No, says Mary Lynn Treadwell, marketing communications manager for NGS. “While we always have an eye on new competitive pressures, this API is a response to our realization that the majority of our customers run IBM Query/400 and NGS-IQ in part because they have a significant legacy of existing queries they don’t have the time to rewrite, especially for queries that may not need all the added functionality of our query engine,” she writes in an e-mail.

    Besides, Treadwell continues, it’s tough to develop a counter-product to something that doesn’t even exist yet. “We don’t know how our Query/400 API compares to what IBM may include in DB2 Web Query because that product is still in development, has not officially been announced, and has no official availability date, licensing terms, or pricing at this time,” she writes. “We did feel it was important to support more than just V5R4 because the majority of System i customers worldwide are currently running earlier i5/OS releases.”

    The Query/400 API is available now as a feature of the NGS-IQ suite. The Query/400 API will work with OS/400 V5R1 and higher. Pricing for NGS-IQ was not disclosed. For more information, see www.ngsi.com.

    RELATED STORIES

    NGS Makes DB2/400 Data Accessible from MS Office

    NGS Boosts BI Offerings for System i

    NGS Provides a Quick ‘Dashboard’ View into Business Performance



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

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Raz-Lee Security

    Start your Road to Zero Trust!

    Firewall Network security, controlling Exit Points, Open DB’s and SSH. Rule Wizards and graphical BI.

    Request Demo

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    COMMON:  Join us at the Annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
    BCD:  The best integrated System i Modernization software from one vendor
    Krengeltech:  Create XML Web Services from RPG - without Java or Websphere

    IT Jungle Store Top Book Picks

    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

    ‘Catch the Wave’ OCEAN Tech Conference Returns to SoCal Parameter Passing and Performance

    Leave a Reply Cancel reply

Volume 7, Number 24 -- June 19, 2007
THIS ISSUE SPONSORED BY:

Aldon
Midrange Alliance
Maximum Availability
Bytware
Affirmative Computer

Table of Contents

  • IBM Taps Nortel for Entry-Level System i VoIP Solution
  • North Carolina Schools Laud SafeData for Online DR Solution
  • NGS Hooks Into Query/400 to Protect BI Investments
  • S4i Expands File Support in Document Management Software
  • Eastern Bag Extends iSeries App with Voxware’s Voice-Directed Picking
  • TCP/IP Configuration via iSeries Navigator Subject of New Manta Course
  • Pat Townsend’s Encryption Solution Certified Across All Major Platforms
  • Brooks Updates IDPS Print Driver for Windows Vista
  • Latest AS2 Certs Released by Drummond Group
  • Maple Leaf Farms Heralds EXTOL for B2B Connections

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Public Preview For Watson Code Assistant for i Available Soon
  • COMMON Youth Movement Continues at POWERUp 2025
  • IBM Preserves Memory Investments Across Power10 And Power11
  • Eradani Uses AI For New EDI And API Service
  • Picking Apart IBM’s $150 Billion In US Manufacturing And R&D
  • FAX/400 And CICS For i Are Dead. What Will IBM Kill Next?
  • Fresche Overhauls X-Analysis With Web UI, AI Smarts
  • Is It Time To Add The Rust Programming Language To IBM i?
  • Is IBM Going To Raise Prices On Power10 Expert Care?
  • IBM i PTF Guide, Volume 27, Number 20

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle