• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Help/Systems’ SEQUEL Gets More BI Tooling

    June 17, 2008 Alex Woodie

    Help/Systems launched a new release of SEQUEL last week that will give users more reasons to use it as a business intelligence tool. With a new Gauge Wizard in SEQUEL version 9.0, adding graphical representations of data through speedometers and dials is a matter of making a few mouse clicks. Better integration with Help’s i OS-based job scheduler and Google Maps highlight this iterative release of the popular and multipurpose tool.

    SEQUEL has so many uses, it must be difficult at times for the folks at Help/Systems to figure out how to market it to potential users. The software, which was the crown jewel of Help’s acquisition of Chicago-based Advanced Systems Concepts (ASC) two year ago, can be used as a programmer productivity tool, a form design and report output tool, a database conversion tool, or a Web enablement tool, among other uses.

    “SEQUEL can be used for many different things,” says Tom Huntington, vice president of technical services for the Eden Prairie, Minnesota, company. “Business intelligence seems to be the best fit for categorizing it.”

    But owing to SEQUEL’s long heritage as an ad hoc query and reporting tool for the IBM i OS (formerly OS/400) midrange server line, Help/Systems usually elects to focus attention on the product’s strong business intelligence capabilities, including drill-down and OLAP data cube management. It’s worth bearing in mind, however, that SEQUEL can perform all sorts of data access tasks on DB2/400 systems (not to mention SQL Server, Oracle, and MySQL databases) that may not fall within the traditional boundaries of business intelligence.

    With the launch of version 9 last week, Help is boosting SEQUEL’s reputation as a business intelligence tool. The software has long supported the capability to build executive dashboard interfaces, via the optional ViewPoint component. Version 9 adds a new Gauge Wizard that makes it easier to develop gauges, such as speedometers, thermometers, and dials, to help executives and managers monitor critical indicators, as reflected in their business data.

    The new Gauge Wizard in SEQUEL 9 makes it easier for users to add dials and other gauges into business intelligence dashboards.

    Another handy new feature in version 9 is the capability to open results directly in an Excel spreadsheet. The new plug-in installs on a user’s Excel interface and enables a user to open an existing SEQUEL table or view in Excel, without first having to run a view or create a file.

    The new Excel plug-in will come in very handy for spreadsheet junkies who absolutely need to have their DB2/400 data laid out before them in Excel, so they can play around with the data and exploit Excel’s rich graphical capabilities to create all kinds of graphs and tables.

    Opening SEQUEL data in Excel is easy thanks to a new plug-in.

    Help/Systems also added a new interface to Robot/SCHEDULE, its job scheduling software for the i-based Power Systems server (formerly System i). Users previously were able to integrate the two products, but it required more work. With the new interface, it’s easier to submit SEQUEL output as batch jobs.

    Also improved with this release is SEQUEL’s interface to Google Maps, which was first introduced in the fall of 2006. With SEQUEL 9, Help/Systems has introduced a new Google Wizard to streamline the creation of objects required to integrate SEQUEL data into Google Maps. The integration between the two products enables users to dynamically generate maps or create routes based on zip codes, addresses, or geographical coordinates that may be stored in i OS-based applications.

    Last but not least are improvements to SEQUEL’s powerful CL-like scripting environment with version 9. Help/Systems says it’s easier than ever to use programming structures like loops, internal variables, conditional logic, and error monitoring with its SEQUEL scripts.

    SEQUEL version 9 is available now. Pricing was not provided by the company. For more information, visit www.helpsystems.com.

    RELATED STORIES

    Island Pacific to Continue Selling Help/Systems BI Tools

    Help/Systems Gives SEQUEL a Web Makeover

    Summit Partners Sells Help/Systems to Audax Group

    Help’s Database Query Tool Gets Google Maps Interface

    System i Vendors Merge as Help/Systems Acquires ASC

    ASC’s SEQUEL Database Tool Goes Multi-Platform



                         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
    Manta Technologies

    The Leader in IBM i Education!
    Need training on anything i?
    Manta is all you need.

    During the month of May, when you purchase a license for the Free-Form RPG Programming series for any term (one, two, or three years) and any user license level, and you will get the equivalent license for the Coding Free-Form RPG course for FREE.

    130 courses and competency exams on:
    · IBM i operations
    · System Management and Security
    · IBM i Programming Tools
    · Programming in RPG, COBOL, CL, Java
    · Web Development
    · SQL, DB2, Query

    Product features:
    · Runs in every popular browser
    · Available 24/7/365
    · Free Student Reference Guides
    · Free Student Administration
    · Concurrent User License
    · Built-In IBM i Simulator

    You can download our 200-page catalog and take sample sessions at MantaTech.com.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    OCEAN:  Technical conference, June 30, 2008, Irvine, CA
    RJS Software Systems:  Spring Sale! Savings on WebDocs and Value Bundles
    COMMON:  Join us at the Focus 2008 workshop conference, October 5 - 8, in San Francisco, California

    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

    Enterprises Are Judged by the Measure of IT Performance Creating an RPG-based Web Service Using WDSC, Part 1

    Leave a Reply Cancel reply

Volume 8, Number 24 -- June 17, 2008
THIS ISSUE SPONSORED BY:

Help/Systems
LANSA
Profound Logic Software
Bytware
RJS Software Systems

Table of Contents

  • Hospital Supplier Installs VAI’s WebSphere-Based Portal
  • Sysload Delivers Fine-Grain Monitoring for Virtual Servers
  • Adobe Eases Deployment with New Release of LiveCycle Suite
  • PowerTech Updates i OS Log Management Software
  • Help/Systems’ SEQUEL Gets More BI Tooling
  • Varsity Teams with NGS for New BI Product
  • Professionally Speaking, Lotus Users Getting Better Connected
  • InfoPrint Solutions Introduces New Printers, AFP Options
  • iSeries-to-Windows Conversion Successful at Admiral Beverage
  • LANSA Touts Eight RAMP Successes

Content archive

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

Recent Posts

  • POWERUp Brings IBM i Base Back Together in the Big Easy
  • New Nav for i Brings New Stuff to You
  • Why Infor’s IDF Is Important for Customer Innovation
  • Four Hundred Monitor, May 25
  • IBM i PTF Guide, Volume 24, Number 21
  • How Committed Is Big Blue To The IBM Cloud?
  • Immutable Copies Are Only As Good As Your Validation
  • Guru: IBM i *USRPRF Security
  • ERP Transitions Loom for SAP on IBM i Customers
  • Inflation Pumps Up Global IT Spending, Supply Chain Deflates It

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

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.