NGS: NGS-IQ Overview

Graphical, Web, and Mobile Query and Reporting
for IBM i (iSeries, AS/400) Users

Watch a One-Minute Capabilities Video | Build Your Business Case for NGS-IQ

NGS-IQ™ enables business users and analysts to write queries that can:

output to Excel, Access, Word, PDF, CSV, TXT, HTML, and XML
develop analytical reports
build multidimensional models
integrate Web reporting with charts and drill-down features into your intranet or Web portal

Query developers enjoy powerful, time saving features, including:

conditional (if-then), new column (field) calculations
run-time prompting for row (record) selection and calculation formulas
date formatting and arithmetic
simplified table (file) joins (inner, outer, exception, one-to-many, unions)
report break summaries and calculations based on summary results
SQL group by and having
program exits to support unique data access and manipulation processes
row selections based on lists stored in Db2 on i tables
query usage statistics and change management

NGS-IQ provides built-in email, FTP, and report "bursting" to distribution lists, plus the benefits of IBM i security and querying remote data sources. You can modernize your reporting without adding another server or database to your network.

New Generation Software, Inc. also offers these solutions:

Qport Office—easy-to-learn tool that enables users to run IBM Query/400 queries from the Windows desktop and output to Microsoft Excel, Word, and Access.

NGS Query Developer Kit—affordable, one developer license of our query and Web reporting tools bundled with online education and technical support.

Customer Reviews

Duane Danner
Senior Programmer/Analyst, Avery Weigh-Tronix, Manufacturing

"Ease of use, creating reports on the fly. allowing other users to create reports and taking programming request away fron our RPGLE programmers. Support is awesome.

NGS was being used when I joined the company 20 plus years ago. We have many queries and have been using the product for over 20 years."

Van Truong
Systems Programming Manager, Inland Regional Center, Non-Profit Services

"Many users express that they love to run queries using NGS because it is easy, fast, and outputs reports to Excel."

Robert DiSalvo
Senior Software Developer, Steris, Medical Devices

"I appreciate how easy NGS-IQ makes it to query files in the system. The green-screen interface is good, but the separate desktop GUI client is even better. I can quickly develop a query and publish it to production. Using the web-interface my users have access to the query immediately. I am able to let them self-serve results from our 40+ year old system.

NGS customer support is the most responsive and helpful of any support team for any software company that I have encountered in my career."

Shawn Amick
IT Director, Ebix, Hospital & Health Care

"A great tool for extracting and sharing data. NGS-IQ works and works well. I've used the product to write literally hundreds of reports in the 10+ years that I have been a user. We have built significant business processes out of the data that we are able to extract from our system with this product. The ease of getting data out of our IBM database and out to Excel where it can be shared with coworkers or clients is fantastic. The product works well and is very well supported in the rare case that there is a problem. The regular, free training webinars offered are invaluable to picking up and learning more about the capabilities."