• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • NGS Brings Modern DB2/400 Query Development to BI Suite

    August 28, 2007 Dan Burger

    At the heart of business intelligence solutions is the capability to easily and quickly take care of query and report-writing tasks. In the IBM native System i, iSeries, and AS/400 environment, such tasks have been the primarily confined to green-screen development. Well, guess what? It’s time for graphical point-and-click, drag-and-drop query and report writing courtesy of New Generation Software, which earlier this month introduced IQ Client, a new query development module within the NGS business intelligence product suite.

    IQ Client will likely surprise many veteran green-screen developers and power uses with its query-building functionality. This is not a watered-down version of what they have grown accustomed to in terms of capability. Even hard-core green-screen advocates should find much of this Windows-based functionality to their liking. NGS officials predict productivity gains for all but the most averse to trying new methods.

    It’s also going to appeal to casual users who want to build or revise queries, but were hesitant to do so in the past because it required them to make a trip outside of the Windows environment. In addition to IQ Client, NGS offers a product called Qport Builder, which uses screen-scraper technology to provide a Web interface for those who prefer that environment.

    In designing IQ Client, NGS made certain that it retained the complete functionality of IQ Server, the native i5/OS (OS/400)-based query engine for the company’s business intelligence offerings that have been rooting out and piecing together financial, sales, customer, vendor, and inventory performance data for more than 15 years.

    Queries, from brief ad hoc requests to large production reports, can be created and revised and then run from NGS-IQ’s Web browser and 5250 user interfaces. Not only are there no query translation or conversion requirements, but for those of you experienced with DB2/400 (DB2 for i5/OS), you’ll appreciate the benefits of native, batch query processing, and security that the platform provides. Those are more than mere conveniences when compared to the hazards of query building done outside the platform. IQ Client also allows users to work with or without a live System i or Internet connection, which is a convenience factor that many remote workers will appreciate.

    Another convenience feature is that queries developed by staff with advanced green screen skills can be downloaded by non-technical users and used within the Windows interface. Some of these may contain certain data fields that are not intended for all eyes to see. Security should always be a concern when query and reporting is the topic. Access to sensitive files and objects is controlled through the System i (highly secure for those who know how to make use of it) and a security management module (IQ SeQure) that is sold as an add-on to NGS-IQ. The NGS module restricts access by file, field, record, and output.

    Yet another convenience is IQ Client’s one-click connection to a variety of integrated functions through Qport Access, the client module of NGS-IQ that provides direct output to Microsoft Excel, Access, and Word; NGS-IQ’s multi-dimensional OLAP module; display mode; to print mode; and output defined on the server, such as dynamic Web NGS dashboards, PDF, HTML, DB2 UDB (summary or detail), XML, CSV, and TXT. The result is that queries can be easily built, saved, and output by using icons on a screen.

    For the pros at query development, IQ Client supports simple and conditionally calculated fields; multi-file joins; run-time prompts for selection criteria and/or calculations; date arithmetic; report break summaries and calculations, rankings, running totals, averages, and percentages; extensive formatting; e-mail and FTP delivery.

    New Generation Software has been actively building out its business intelligence suite in 2007. In March it introduced Web-based dashboard applications and a new release of its flagship IQ Server. Its focus has been on delivering key performance indicators (KPIs) graphically in a Web browser and being able to continually update and refresh that information from DB2/400 (via hooks into the NGS-IQ server), without additional work or input from the user.

    IQ Client pricing is based on the P group rather than by named user. The reason, NGS officials say, is so customers have the freedom to install this software on as many PCs as they like without worrying about the number of users they have licensed. Because IQ Client supports offline development, the queries users develop are ultimately processed in batch by the integrated NGS-IQ software on the System i, where the customer controls their workload by concurrent user. Any number of people can simultaneously develop queries with IQ Client, without consuming any i5/OS cycles, but the user decides how many of those queries can be run simultaneously. From the NGS point of view, this is more practical than a named user pricing model that forces customers to enroll each user and keep track of who has the software as personnel changes occur.

    RELATED STORIES

    NGS Takes Deconstructive Approach to Business Intelligence

    NGS Boosts BI Offerings for System i



                         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
    WorksRight Software

    Do you need area code information?
    Do you need ZIP Code information?
    Do you need ZIP+4 information?
    Do you need city name information?
    Do you need county information?
    Do you need a nearest dealer locator system?

    We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

    The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

    PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

    Just call us and we’ll arrange for 30 days FREE use of either ZIP/CITY or PER/ZIP4.

    WorksRight Software, Inc.
    Phone: 601-856-8337
    Fax: 601-856-9432
    Email: software@worksright.com
    Website: www.worksright.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    Krengeltech:  Compose, transmit and parse XML without ever leaving RPG
    COMMON:  Join us at the annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
    NowWhatJobs.net:  NowWhatJobs.net is the resource for job transitions after age 40

    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

    SAP Gets Ready to Launch A1S Online Apps on September 19 PHP: An Easy Yet Powerful Language Syntax

    Leave a Reply Cancel reply

Volume 7, Number 32 -- August 28, 2007
THIS ISSUE SPONSORED BY:

Profound Logic Software
Vision Solutions
COMMON
Bytware
DRV Technologies

Table of Contents

  • Help/Systems Launches Comprehensive Security i5/OS Suite
  • Database Optimizing Goes Autonomic with New Tool from Centerfield
  • SkyView Opens Up Security Policy Product
  • NGS Brings Modern DB2/400 Query Development to BI Suite
  • Hong Kong Company Supports i5/OS with Backup Product
  • Valid Tech Supports Windows Terminal Services with Biometric Authentication System
  • InfoPrint Solutions Launches Two Color Printers
  • English Consultancy Launches Application Modernization Initiative
  • Homebuilder Taps LANSA for Lead Management System
  • Infor Updates i5/OS-Based Distribution Solution

Content archive

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

Recent Posts

  • IBM i Has a Future ‘If Kept Up To Date,’ IDC Says
  • When You Need Us, We Are Ready To Do Grunt Work
  • Generative AI: Coming to an ERP Near You
  • Four Hundred Monitor, March 22
  • IBM i PTF Guide, Volume 25, Number 12
  • Unattended IBM i Operations Continue Upward Climb
  • VS Code Is The Full Stack IDE For IBM i
  • Domino Runs on IBM i 7.5, But HCL Still Working on Power10
  • Four Hundred Monitor, March 6
  • IBM i PTF Guide, Volume 25, Number 11

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 © 2023 IT Jungle