• 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
    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

    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

  • 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
  • COMMON Set for First Annual Conference in Three Years
  • API Operations Management for Safe, Powerful, and High Performance APIs
  • What’s New in IBM i Services and Networking
  • Four Hundred Monitor, May 18
  • IBM i PTF Guide, Volume 24, 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 © 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.