13
Thu, Jun
4 New Articles

Technology Focus: Basic Database Query Tools Still Have a Place at the Table

Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

With the scope and features of business intelligence applications hitting new stratospheric heights of splendiferousness, are simple query tool products being left behind? Apparently not just yet.

 

Sometimes you just don't want all the glitz. While one of the messages our whole culture seems to be delivering is one of "biggest is best," there are still situations when simple solutions are all that's needed. One of the best illustrations of that idea may be database query tools.

 

Even though many of these data-retrieval utilities are now embedded in applications that offer levels of complexity ranging from report generation and distribution tools to business predictive-analytics suites, sometimes all you really need right now is a factoid or two to get on with the task at hand. Not that all those other bells and whistles aren't frequently useful, of course, but sometimes it's also good to focus on the basics.

Some Query Tool Vendors Agree

When posed the question of whether or not query tools are fading in importance compared to more feature-rich business intelligence (BI) apps, literally two out of three query tool vendors consulted agree.

 

Bill Langston, director of product marketing at New Generation Software, is one who agrees query tools still have their place. "In the larger companies you see BI capabilities [in demand], but in the typical small-to-medium companies that are the heart of the i market, query tools are still the primary tool," he reports. "There's a lot of buzz about [IBM's] Watson and such, but it hasn't trickled down to the smaller companies. The vast majority of users just want to query data and pull it into a spreadsheet."

 

Tom Huntington, vice president of technical services at Help/Systems, echoes Langston. "We just had a record year with SEQUEL [Help/Systems' query tool]. We're finding that many companies that have bought into large-scale BI products are [having] issues with security, latency, and complexity that have kept their end users from really using these products. It's amazing how many companies still use IBM-based green-screen query because [their] large-scale BI product is too complicated."

At Least One Doesn't

Marcel Sarrasin, product manager at ExcelSystems Software Development, which handles product support for BCD International's Clover Query and other products, is more equivocal. "There's a place for both [product types]. The pure query tool is fading for non-technical end users. Programmers will use SQL to pull a quick fact or total, especially if it's a query they don't plan to run over and over. But the end user that used [to rely on] Query/400 [increasingly wants] to get results over the Web in a graphical interface or put them into a spreadsheet. Having all the function in a BI tool reduces the need for something ad hoc, even though it may require more technical knowledge on the part of the end user."

Do Query Tools Have a Future?

When asked if query tools still have a future as a product type in a market where they must complete with full-featured BI, all three vendor representatives agreed that they do, although they differed on what role query tools will take.

 

"I think the markets are going to be more and more spread out, from tools that do one thing up to business analytics apps and so forth. There will be more and more players with wider and wider capabilities," predicts Langston.

 

"We see a very good future for SEQUEL, since it is easy to use and helps customers with their immediate needs of getting data from IBM i securely and in formats that are easily adaptable to today's market," Huntington notes.

 

"Query tools will be more for programmers [looking] for quick answers," Sarrasin forecasts. "We'll see some use of them for mass updates or deletes of records or one-time uses on test files for a specific statistic or sum."

 

If query tools have a future, then what changes might we see in them over the next couple of years?

 

"We see customers wanting more and more consolidation of data from other platforms with IBM i," Huntington relates. "The other areas of concern are easy access for end users through dashboards, and security."

 

"We see interest in people moving apps and data to hosted systems," Langston points out. "Understanding how to leverage reporting and BI in that environment will be important."

 

"If [the product type] is going to remain a query tool, it will morph into low-level BI," Sarrasin foresees. "Otherwise, people will [at least] be creating Web interfaces over them."

Vendor Advice on Buying a Query Tool

What advice would these vendors offer to a prospective customer looking for a query tool product?

 

"Be clear on who the real end users are going to be," advises Sarrasin. "[Consider] how the users will access the tool. Does it have a Web interface, easy access, and is there a way to manage queries? People getting real-time info is what people need to drive business decisions."

 

"Test-drive the product and [have] not only a developer looking at it but also have your end users and the managers involved," Huntington recommends.

 

"Look for things that let you eventually take on more capability as you need it, and look for products that can help you use existing capabilities," Langston suggests. "Leverage in-house people skills."

Query Tools and the i Market

Below is a profile of all the basic query tool products that are available for the IBM i market. All of them share certain characteristics. They all run natively on the i (although descriptions note if they don't run under the i/OS). All are either query tools first and foremost or else they have a query tool embedded in them. All extract information at least from DB2 databases on i servers, and most can also extract information (or have add-on products that help them) from databases on other platforms as well. Nearly all have added features that let users export data in a variety of formats, display data in a variety of ways, and plug the data into report writers and, often, other applications. If you're looking for a query tool to help you keep track of important data, the most important differentiator will be the ways in which the data a tool can retrieve for you can be used in ways that best fit the way your enterprise does business.

 

Please note that the brief summaries used here in no way cover all the features each software product provides. You should consult the links provided for each product and contact the associated vendors for a more complete idea of what each query product has to offer.

 

And as always when looking for products or services, be sure to check the MC Press Online Buyer's Guide.

 

Database Query Tools for IBM i

BCD International

Clover

Monarch for EZ-Pickin's

Clover is a Web-based tool that lets users design and run queries and reports via a browser. The product also includes query templates and SQL wizards that let even nontechnical users edit database records and generate reports, executive dashboards, and MS Excel spreadsheets.

 

Monarch for EZ-Pickin's is a query tool for mining existing reports, thereby letting users view and distribute data from reports generated on virtually any platform. The utility lets users build such aids to understanding as charts, graphs, summary reports, and customized tables.

 

Cyberscience

Cyberquery

Cyberquery is an ad hoc production query and reporting system that runs under AIX, other forms of UNIX, and Windows. It can interact with virtually any database system, including non-relational ones, making it particularly useful in mixed-platform environments. An optional accelerator add-on helps increase query performance.

 

Dharma Systems

Dharma/SQL

Dharma/SQL offers a fully functional SQL interface to a wide range of database protocols, including SQL-92, ODBC 3.5, .NET 3.5, JDK 1.6, and JDBC 4. The product interfaces with the Dharma Integrator, an application integration hub that lets users tie data queries to a wide range of application programs.

 

IBM Corporation

DB2 Web Query for IBM i

DB2 Web Query for IBM i lets end users generate queries, reports, and dashboard-style outputs from IBM i database information via a browser. Based on Information Builders' WebFOCUS product line, DB2 Web Query is a replacement for IBM's traditional Query/400 product and offers database adapters, report-authoring features, and a developer workbench for creating complex or reusable query programs.

 

Information Builders

WebFOCUS InfoAssist

WebFOCUS InfoAssist is a subordinate product of Information Builders' WebFOCUS business intelligence suite. InfoAssist provides database query and ad hoc reporting assistance for end users, enabling creation of anything from simple queries to complex reports, dashboards, and charts with a variety of possible output formats.

 

Jacana

InTuator

InTuator is a database query product that lets users extract information from IBM i databases and applications. Its features include multidimensional data drilling, chart analysis, the ability to link across application areas, the ability to export results to MS Office applications, and a portable mode that lets users perform data analysis even when not connected to the host server.

 

Linoma Software

Surveyor/400

Surveyor/400 is both a query tool for end users and a database maintenance tool for developers. Its query functions include the ability to query, display, and edit database records with a graphical file editor, as well as the ability to enter, run, and test SQL statements. Other features include the ability to download data to MS Excel, organize files into user groups, and access databases on multiple machines with a few mouse clicks.

 

New Generation Software

NGS-IQ

NGS-IQ is a business intelligence suite that includes query capabilities as well as a wide range of report and other output options for gathered data. The suite's query and reporting component, IQ Server, includes a runtime Web interface, hyperlinks in output reports, simplified file joins, wildcard file searches, and email and other report-distribution options. A separately licensed IQ Connexion module gives users access to databases on platforms other than IBM i servers.

 

ProData Computer Services

DBU

RDB Connect

SQL/Pro

DBU functions as a query tool for end users while also providing numerous database editing and maintenance features for developers and database administrators. Its query functions enable complex SQL searches, data exports to comma-delimited and XML files, and numerous on-screen formatting options for displaying data results.

 

RDB Connect provides access to off-platform databases for all IBM i high-level languages. It enables execution of any SQL query by IBM i applications on non-i databases, import and export of data to and from IBM i servers, and synchronization of data across platforms.

 

SQL/Pro breaks SQL statements down into English-like commands that even non-technical users can understand, enabling them to query, print, and alter data at will. SQL/Pro supports queries of up to 32,750 characters, generates error messages for poorly constructed queries, and offers F4 prompting to help novices build queries.

 

Sequel Software, a Help/Systems company

SEQUEL

SEQUEL is a query tool and report generator that offers a Windows-based GUI for end users, a drag-and-drop interface for building queries, optionally predefined JOIN criteria and other features that let even novices build meaningful queries, data distribution via email and Web using a variety of MS Office and other file formats, and extensive built-in reporting options.

 

Symtrax Corporation

StarQuery

StarQuery Web

StarQuery is a suite of data-access and manipulation tools that includes the ability to query several databases simultaneously, lets end users add fields and conditions needed to report specifications, and enables use of ad-hoc or standard queries.

 

StarQuery Web provides the same query and reporting features in a version that is accessible via browser.

John Ghrist

John Ghrist has been a journalist, programmer, and systems manager in the computer industry since 1982. He has covered the market for IBM i servers and their predecessor platforms for more than a quarter century and has attended more than 25 COMMON conferences. A former editor-in-chief with Defense Computing and a senior editor with SystemiNEWS, John has written and edited hundreds of articles and blogs for more than a dozen print and electronic publications. You can reach him at This email address is being protected from spambots. You need JavaScript enabled to view it..

BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$0.00 Raised:
$

Book Reviews

Resource Center

  • SB Profound WC 5536 Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • SB Profound WP 5539More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now!  Request Now.

  • SB HelpSystems ROBOT GenericForms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. How can you be sure you won’t miss important system events? Automate your message center with the Robot Message Management Solution. Key features include:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing. Manage your reports with the Robot Report Management Solution. Key features include:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed. Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: