NGS Blog - i View i View

Web Reporting for NGS-IQ Tutoring

Posted on September 3, 2019 by Bill Langston

Web reporting is an integrated feature of NGS-IQ. That's not new. But from surveys, site visits, and technical support calls, we know that some customers haven't gotten very far with our Web reporting features. These customers tend to fall into three groups:

  1. Those who have recently started running NGS-IQ queries from a browser.
  2. Those who have been running queries from a browser for awhile, but their output is just plain text. They haven't tried the HTML design features in IQ Client.
  3. Those who work in a company where progress is slow—there is a divide between the people in the shop who understand IBM i, DB2 on i, and NGS-IQ, and the people who are comfortable with HTML, cascading style sheets, hyperlinks, and Web servers.

If any of these shoes fit, we'd like to talk to you about our new Web Reporting Tutoring class for NGS-IQ users. We've structured this live, no-cost, online session to quickly cover everything from basic to advanced Web reporting. We provide a step-by-step guide you can use during and after the two-hour session.

You can learn to design visually impressive Web reports more quickly than you might think, without having to learn a web scripting or programming language. Let us help you get started.

Posted in Developer Tips | Comments

Building Your Business Case for New Query, Reporting and Analytics Software

Posted on June 17, 2019 by Bill Langston

Often, those benefitting the most from new query, reporting, and analytics software are the ones who need to convince a senior manager to let them invest time in evaluating potential solutions. Senior-level, non-technical executives may be skeptical of the business need—they may be unfamiliar with the potential uses of the software, concerned about the staff’s skills and training requirements, and eager to know the cost and expected return on investment. A CIO or IT director may have questions about security and server performance.

If you’re the one who needs to gain management support, you may be struggling for the words you need to effectively respond to their questions. Our new project justification tool can help you get started.

Identify yourself and answer a few questions about your business and software environment. The tool will instantly generate a customized set of arguments that you can copy and paste into your favorite word processing software. Edit and add to the text as needed and share your final version with management. 

Give our project justification tool a try. Let us know how it worked for you and tell us how we can continue to improve it.

Posted in Enterprise Software | Comments

COMMON IBM i System Administrator Bootcamp
Fills Important Need

Posted on April 23, 2019 by Bill Langston

We periodically hear from companies running IBM i software applications who are concerned about their future ability to support IBM i. With their in-house expert or small IBM i team nearing retirement age, the pool of technical knowledge is gradually shrinking.

One of IBM i's strengths is that it normally requires minimal staffing. But low maintenance doesn’t mean no maintenance. You should always have at least one staff member who understands the operating system, IBM Power hardware, database, security, storage, monitoring, IBM software and hardware maintenance plans, and system management tasks.

Fortunately, the COMMON User Group has developed an online video learning series to meet this need. The presenters are well respected experts from across North America.

Not a COMMON member? We encourage you to join. However, the bootcamp is open to anyone. Learn more about pricing, video overviews, and speakers at the COMMON website.

While there are numerous IBM Business Partners eager to help you manage your IBM i environment, we believe in-house knowledge is power.

Posted in Education | Comments

Operational Reporting and Analytics:
All-in-One, or Divide and Conquer?

Posted on February 12, 2019 by Bill Langston

Operational reporting and analytics is a multi-step process. Each step requires different knowledge and skill. First, you need to plan your business questions. Then, you need to understand your company’s database so you can locate, join, cleanse, summarize, and extract the right data. The industry term for this process is extraction, transformation, and loading (ETL). Next, you need to know how to massage and present the data to support meaningful analysis and utilization. The industry term often used for this third step is data visualization.

In our experience, a single staff member rarely has the knowledge and skill required for both ETL and data visualization. Managerial, technical, and analytical staff usually team up to complete these steps. NGS highly values this need to work together—our software supports each step but also recognizes the optimal way to modularize functions, allowing people with different skills and job duties to work both as a team and independently.

In contrast, many reporting and analytics software vendors take what I’ll call the “all-in-one” approach. Their product designs assume that the people creating visualizations are just as comfortable writing SQL scripts and complex expressions. This logic may be valid if the users you support are analytics consultants.

In companies that rely on an in-house team, the ETL developer usually passes the data to the analyst. Often, Microsoft Excel is where the exchange takes place, with good reason. Human resource departments can more easily recruit analysts with strong Excel skills, and these analysts cost less than analytics consultants. While Excel misuse poses data integrity, timeliness, and security risks, we don’t anticipate the software falling out of favor any time soon.

When you evaluate reporting and analytics software, think about whether you plan to hire consultants with “all-in-one” skills or rely on your in-house team of specialists. The solution you choose should reflect your plan. At NGS, we primarily support in-house teams. Our modular design and integration features for Excel users reflect that approach.

Posted in Analytics | Comments

IBM and Red Hat – What’s It all About?

Posted on November 13, 2018 by Bill Langston

IBM and Red Hat – What’s It all About?

Most people who work on IBM i don’t have much exposure to the LINUX operating system or familiarity with how the LINUX software marketplace is organized. Given that, you might not know what to make of IBM’s plan to pay $34 billion for the software company known as Red Hat.

Who's Red Hat?

Red Hat is a $3 billion dollar software company focused on LINUX software development, support, and consulting services.

What's LINUX?

LINUX is a computer operating system, but unlike IBM i or Windows, LINUX is an “open source” operating system, meaning it is not owned and controlled by a single company. You don’t pay a license fee for LINUX, and today you can run LINUX on IBM Power, IBM z, and many other computers.

Who Develops LINUX?

When it was introduced in the early 1990s, the creators of LINUX envisioned programmers working independently, writing and sharing source code that would lead to the development of a competitive, “free,” operating system kernel that could replace expensive, proprietary operating systems from IBM, Microsoft, and others. It’s doubtful they imagined that a substantial for-profit ecosystem would grow up to support the software.

At least in theory, anyone can contribute code to the LINUX kernel, for others to use at no cost. In practice, nearly all contributions that become part of the LINUX kernel originate with software developers employed by a handful of major companies including Intel, Red Hat, Samsung, and IBM. These companies do not own LINUX, but they do work closely with the non-profit LINUX Foundation which controls the strategic direction of the project.

How Does Red Hat Make Money?

The founders of Red Hat saw that companies were paying Microsoft and IBM a lot for operating system software and that these companies would love a competitive and lower cost alternative. They guessed correctly that companies with an interest in using LINUX would be much more inclined to do so if they could go to one provider, pay an annual support fee, and download a stable “distribution” of the software. Red Hat put together the team to provide that service and became a huge enterprise.

Why Would IBM Want Red Hat?

While IBM continues to develop and earn billions of dollars a year from proprietary operating systems like IBM i and z/OS, LINUX use is growing at a much faster rate – especially in the large data center, cloud and mobile computing markets. By acquiring Red Hat, IBM hopes to grab a much larger share of that growth.

LINUX and open source thinking has had a tremendous influence on the software industry this century. Once IBM and Red Hat are one, it’s likely that more and more of the ideas and trends in the open source software ecosystem will seep into IBM’s proprietary software.

Posted in Enterprise Software | Comments

Business Resiliency—Combat Skills Shortage with Turnover Preparedness

Posted on September 5, 2018 by Teresa Moy

While some vendors are addressing business resiliency, covering solutions from disaster recovery to encryption, they often overlook or ignore this somewhat mundane but critical aspect that can have a large impact on a company’s future success – “turnover preparedness.”

As the current generation of IT professionals looks forward to retirement, the next generation of IT professionals is often left “high and dry,” with little documentation to guide them through the business operations for which they are responsible.

In the September issue of IBM Systems Magazine, NGS’ Director of Marketing, Bill Langston, discusses the importance of turnover preparedness and offers some suggestions for handling skills shortage in your company.

Here’s the link to Bill’s article in IBM Systems Magazine:
Are You Ready for Turnover? Broaden the scope of resiliency planning to include training and skills development

Posted in Education | Comments

Overcome Software Support Phobia

Posted on August 14, 2018 by Bill Langston

Every time NGS product specialists spend time with new users, we encourage them to call our technical support hotline or use our online incident reporting system when they have questions. We spend a lot of time training non-technical, business users of our query, reporting, and financial software, and many of them tell us they never knew they had those options. Yes—they, and you, do.

Just as frequently, we discover people whose encounters with other vendors have caused them to develop a disabling condition we’ll call “software support phobia” (SSP). SSP stems from low expectations and negative feelings. If you have SSP, you may have experienced any or all of the following thoughts when contacting a vendor for software support:

We’re eager to help you recover from SSP. We believe that all of our customers, regardless of size, deserve the ready availability of NGS’s technical support and product marketing team to guide them through everything from introductory training to the most complex technical issues.

The healing process begins when you contact NGS technical support for help. We hope that’s soon.

Posted in Education | Comments

Power from Versatility

Posted on June 26, 2018 by Bill Langston

One of the most interesting aspects of meeting with NGS-IQ customers is seeing all of the different ways people use the software. It’s a testament to the versatility of NGS-IQ that it can help users satisfy such different requirements.

We recently visited a customer who uses NGS-IQ as an “extraction, transformation, loading” (ETL) tool to move data into Microsoft Access where they have developed a very nice, custom analytics solution. Whereas a larger organization might question the choice of Microsoft Access as a data mart and analytics interface solution, it works well for this customer.

Microsoft Excel is the world’s most popular data analysis and presentation tool, but while we spend substantial time teaching customers how to take advantage of NGS-IQ’s Excel reporting features, we have some customers who feel Excel is too difficult to control and frown on its use.

One customer we recently met with primarily uses NGS-IQ to generate and distribute a long list of operational reports that they run during off-peak hours and send out via email; yet another is focused on using NGS-IQ to generate files that are uploaded to the Microsoft Power BI cloud where business analysts use the data to design and share Web reports and dashboards.

The common thread for all of these organizations is that NGS-IQ provides them with the function they need to accurately, consistently, and securely extract timely data, transform it into the desired format, and make it available to the people who need it.

Posted in Developer Tips | Comments

Structured Query Language (SQL) and
Query/Reporting Software—
A Marriage of Convenience

Posted on May 7, 2018 by Bill Langston

Through the years, IBM has steadily enhanced Structure Query Language (SQL) for the IBM i environment and encouraged software developers to use SQL to define and manipulate their DB2 on i database.

The NGS-IQ query, reporting, and OLAP software is designed to enable people to extract, manipulate, format, analyze, and share reports and files without writing scripts and programs. But as more IBM i programmers become comfortable writing SQL scripts, some of them have said they like writing queries in SQL, rather than through a menu-driven application interface. Thanks to the flexibility of NGS-IQ, this is definitely a viable option.

The NGS-IQ query process includes three program exits that you can use to supplement our native functions with custom routines that tackle complex and unique requirements. The first exit is for a job that you want to run immediately before the query. The last exit is for a job that you want to run immediately after the query. The third exit is for a job that returns the value you want assigned to a new field in the query.

If you like using SQL, consider having your script perform the query logic and then generate a DB2 on i table. You can use NGS-IQ’s first exit to process that request so that you and other users can take advantage of NGS-IQ’s wide range of prompting, formatting, and output features. It’s a terrific marriage of convenience.

Posted in Developer Tips | Comments

To Move or Not to Move
Your IBM Power to the Cloud—That Is the Question

Posted on February 12, 2018 by Teresa Moy

Last Thursday, February 8, Bill Langston of NGS and Roger Mellman of LightEdge co-presented a Webinar about IBM Power cloud capabilities, pondering the question of whether moving IBM i on Power off premise was a good idea or not. While companies have been slowly heading in the direction of the cloud, the advice was to proceed with caution: consider the capabilities of the cloud and whether or not your company would take advantage of them, and ask specific questions to prepare for a smooth transition.

The Webinar recording is now available in NGS' video library. Also, check out Dan Burger's IT Jungle article about the Webinar, entitled "NGS and LightEdge Provide New Entry to the Cloud."

Posted in IBM i Marketplace | Comments

twitter logoFollow us on Twitter.


arrowAnalytics (5)
arrowDeveloper Tips (3)
arrowEducation (18)
arrowEnterprise Software (17)
arrowIBM i Marketplace (14)
arrowBusiness Partner Newsletters (7)

Recent Posts


Subscribe to our blog

How we protect your information