ngsi.com www

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
  • query usage statistics and change management
  • optional table (file) and column (field) aliases to make data elements easier to understand

NGS-IQ provides built-in email and FTP, 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

Roger Nipper
ERP Development Manager, Mueller Company, LLC, Manufacturing

"The software is very compatible with our need for reporting. I use NGS-IQ daily and is used create reports and database tables."

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."

Christopher Rose
Application Analyst, San Diego Regional Center, Non-Profit Services

"I love how approachable NGS-IQ makes your data! The user interface is really friendly and helps readily display the way you're linking the information between files and creating relationships for your data. Another greatly appreciated feature is the versatility you have to define your own custom fields. You can build really complex logical relationships for your data sets in a separate window that doesn't then bog down the body of your query and make it much easier to understand what you and your colleagues are doing.

Last thing - the customer support is superb! You can call or email them anytime and if you're doing so during their business hours, you'll usually connect with an actual person that's genuinely curious about what you're trying to achieve with your query. They'll even go so far as to ask you to send over your entire query definition so they can scrutinize it and work out whatever strange kink you may not even realize is causing the issue. Truly a great product with an even greater user-support team!

Really enjoyable! The product has a number of features that make it easy to analyze, distribute, and update your data in a variety of formats. And, again, their customer support is outstanding!"

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."

View Benefits for Every Industry

MANUFACTURING | DISTRIBUTION | BANKING | SMALL SHOP
STAFF PRODUCTIVITY | GOVERNMENT | HEALTHCARE

NGS-IQ Brochure

Advantages of NGS-IQ over IBM Query/400

Review the NGS-IQ Architecture Diagram

Order a FREE Trial

Request a Conference Call to Discuss Your Needs

IQ Server IQ Client Qport Builder Qport Access IQ SeQure SmartView IQ Connexion

Request Literature

Discuss Your Needs

Considering IBM Db2 Web Query?

Find Your ROI

Follow Us

Privacy Policy

3835 N. Freeway Blvd, Suite 200 Sacramento, CA USA 95834
Office: (916) 920.2200 Sales: (800) 824.1220 Support: (800) 257.2442 Fax: (916) 920.1380

We Use Cookies

Site Map

Copyright & Copy; New Generation Software, Inc. All rights reserved.