---
description: Get detailed information about NGS-IQ and how it can help you meet your business needs. Learn more about NGS-IQ price, benefits, and disadvantages for businesses in Singapore.
image: https://gdm-localsites-assets-gfprod.imgix.net/images/capterra/og_logo-e5a8c001ed0bd1bb922639230fcea71a.png?auto=format%2Cenhance%2Ccompress
title: NGS-IQ Pricing, Cost & Reviews - Capterra Singapore 2026
---

Breadcrumb: [Home](/) > [Data Preparation Software](/directory/32747/data-preparation/software) > [NGS-IQ](/software/196649/ngs-iq)

# NGS-IQ

Canonical: https://www.capterra.com.sg/software/196649/ngs-iq

Page: 1 / 2\
Next: [Next page](https://www.capterra.com.sg/software/196649/ngs-iq?page=2)

> Integrated query, reporting and OLAP application for IBM i (iSeries, AS/400) users. NGS-IQ a proven upgrade from IBM Query/400.
> 
> Verdict: Rated **4.9/5** by 9 users. Top-rated for **Likelihood to recommend**.

-----

## Overview

### Who Uses NGS-IQ?

All companies running on IBM i, iSeries, System i or AS/400. NGS-IQ is used in every industry. Customers range from departments and small offices to Fortune 500 companies.

## Quick Stats & Ratings

| Metric | Rating | Detail |
| **Overall** | **4.9/5** | 9 Reviews |
| Ease of Use | 4.6/5 | Based on overall reviews |
| Customer Support | 5.0/5 | Based on overall reviews |
| Value for Money | 5.0/5 | Based on overall reviews |
| Features | 5.0/5 | Based on overall reviews |
| Recommendation percentage | 100% | (10/10 Likelihood to recommend) |

## About the vendor

- **Company**: New Generation Software
- **Location**: Sacramento, US
- **Founded**: 1982

## Commercial Context

- **Starting Price**: US$1,250.00
- **Pricing model**: Per Feature (Free Trial)
- **Pricing Details**: Contact New Generation Software for pricing details
- **Target Audience**: Self Employed, 2–10, 11–50, 51–200, 201–500, 501–1,000, 1,001–5,000, 5,001–10,000, 10,000+
- **Deployment & Platforms**: Cloud, SaaS, Web-based, Windows (Desktop), Windows (On-Premise), Linux (On-Premise)
- **Supported Languages**: English
- **Available Countries**: Canada, United States

## Features

- API
- Ad hoc Reporting
- Customizable Dashboard
- Dashboard
- Data Aggregation and Publishing
- Data Connectors
- Data Extraction
- Data Import/Export
- Data Visualization
- Drag & Drop
- Forecasting
- Metadata Management
- Multiple Data Sources
- Publishing/Sharing
- Search/Filter
- Visual Analytics

## Support Options

- Email/Help Desk
- FAQs/Forum
- Knowledge Base
- Phone Support

## Category

- [Data Preparation Software](https://www.capterra.com.sg/directory/32747/data-preparation/software)

## Related Categories

- [Data Preparation Software](https://www.capterra.com.sg/directory/32747/data-preparation/software)
- [Reporting Tools](https://www.capterra.com.sg/directory/30053/reporting/software)
- [Business Intelligence Tools](https://www.capterra.com.sg/directory/23/business-intelligence/software)
- [Data Extraction Software](https://www.capterra.com.sg/directory/30619/data-extraction/software)

## Alternatives

1. [Adverity](https://www.capterra.com.sg/software/162524/datatap) — 4.5/5 (26 reviews)
2. [Grow](https://www.capterra.com.sg/software/136247/grow) — 4.4/5 (400 reviews)
3. [OpenText Analytics Cloud](https://www.capterra.com.sg/software/177019/opentext-analytics-suite) — 5.0/5 (1 reviews)
4. [Intellicus](https://www.capterra.com.sg/software/165802/intellicus) — 4.4/5 (19 reviews)
5. [Tableau](https://www.capterra.com.sg/software/77260/tableau) — 4.6/5 (2348 reviews)

## Reviews

### "NGS-IQ Review" — 5.0/5

> **Robert** | *20 December 2019* | Medical Devices | Recommendation rating: 9.0/10
> 
> **Pros**: I am new to the AS400/System-i environment.  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.
> 
> **Cons**: Maybe I just haven't found it yet, but it would be nice to be able to write ANSI-standard SQL if it would be quicker.  Also to do sub-queries without having to write and link two separate queries.
> 
> NGS customer support is the most responsive and helpful of any support team for any software company that I have encountered in my career.

-----

### "A great tool for extracting and sharing data" — 5.0/5

> **Shawn** | *19 December 2019* | Hospital & Health Care | Recommendation rating: 10.0/10
> 
> **Pros**: 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.
> 
> **Cons**: No real major complaints or issues, the one thing that we kind of struggled with at first was that reports needed to be copied for each base library that we want to report for.    We checked at the time and there was an add on module that would have helped with that, but we chose not to pursue it.

-----

### "Data Insight on Demand" — 4.0/5

> **Christopher** | *16 March 2021* | Nonprofit Organization Management | Recommendation rating: 9.0/10
> 
> **Pros**: 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\!
> 
> **Cons**: The only thing I can think of (and I may just have not figured it out yet) is there doesn't seem to be a quick/easy way to view the contents of a table/file. You usually have to run a generic "show all" type query, which requires selecting the file you want, re-compile the query with said file selected, then running your updated query so you can see a sample of what you're working with; no "right-click-\&gt;View" option.
> 
> 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\!

-----

### "Ease of use" — 5.0/5

> **Duane** | *6 February 2020* | Industrial Automation | Recommendation rating: 10.0/10
> 
> **Pros**: 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
> 
> **Cons**: not having a listing of new features.  documentation of changes and new features.
> 
> we have many queries and have been using the product for over 20 years

-----

### "NGS-IQ" — 5.0/5

> **Van** | *6 February 2020* | Nonprofit Organization Management | Recommendation rating: 10.0/10
> 
> **Pros**: Both IQ Client and Qport. We don't use Smartview very often but I think it is also a good tool.
> 
> **Cons**: Over all I like this software a lot; there are some great functions in the software but I have to learn the syntax in order to use them such as SKIP, PREVIOUS, ect...
> 
> Many users express that they love to run queries using NGS because it is easy, fast, and outputs reports to Excel.

-----

Page: 1 / 2\
Next: [Next page](https://www.capterra.com.sg/software/196649/ngs-iq?page=2)

## Links

- [View on Capterra](https://www.capterra.com.sg/software/196649/ngs-iq)

## This page is available in the following languages

| Locale | URL |
| en | <https://www.capterra.com/p/196649/NGS-IQ/> |
| en-AE | <https://www.capterra.ae/software/196649/ngs-iq> |
| en-AU | <https://www.capterra.com.au/software/196649/ngs-iq> |
| en-CA | <https://www.capterra.ca/software/196649/ngs-iq> |
| en-GB | <https://www.capterra.co.uk/software/196649/ngs-iq> |
| en-IE | <https://www.capterra.ie/software/196649/ngs-iq> |
| en-IL | <https://www.capterra.co.il/software/196649/ngs-iq> |
| en-IN | <https://www.capterra.in/software/196649/ngs-iq> |
| en-NZ | <https://www.capterra.co.nz/software/196649/ngs-iq> |
| en-SG | <https://www.capterra.com.sg/software/196649/ngs-iq> |
| en-ZA | <https://www.capterra.co.za/software/196649/ngs-iq> |
| fr | <https://www.capterra.fr/software/196649/ngs-iq> |
| fr-BE | <https://fr.capterra.be/software/196649/ngs-iq> |
| fr-CA | <https://fr.capterra.ca/software/196649/ngs-iq> |
| fr-LU | <https://www.capterra.lu/software/196649/ngs-iq> |

-----

## Structured Data

<script type="application/ld+json">
  {"@context":"https://schema.org","@graph":[{"name":null,"address":{"@type":"PostalAddress","addressLocality":null,"addressRegion":null,"postalCode":null,"streetAddress":null},"description":"Capterra Singapore helps find the best business software. With software reviews, ratings, infographics, and the most comprehensive list of business software.","email":"info@capterra.com.sg","url":"https://www.capterra.com.sg/","logo":"https://dm-localsites-assets-prod.imgix.net/images/capterra/logo-a9b3b18653bd44e574e5108c22ab4d3c.svg","@id":"https://www.capterra.com.sg/#organization","@type":"Organization","parentOrganization":"Gartner, Inc.","sameAs":["https://twitter.com/capterra","https://www.facebook.com/Capterra/","https://www.linkedin.com/company/capterra","https://www.instagram.com/capterra/","https://www.youtube.com/user/CapterraTV"]},{"name":"NGS-IQ","description":"NGS-IQ is for IBM i (iSeries, AS/400) only. It simplifies &amp; automates query, reporting, &amp; analytics tasks. Excel users can create &amp; refresh sheets, named ranges, &amp; pivot tables in one click. SmartView OLAP module supports drill-down, pivot, filter, chart, export. NGS-IQ doesn't require middleware or a separate server. It uses the integrated IBM IBM i  database &amp; security to ensure compliance, data integrity &amp; performance. Extensive data formatting, email and job scheduling is built in.","image":"https://gdm-catalog-fmapi-prod.imgix.net/ProductScreenshot/b5d961c0-357b-4552-b34c-9d48cad9125e.png","url":"https://www.capterra.com.sg/software/196649/ngs-iq","@id":"https://www.capterra.com.sg/software/196649/ngs-iq#software","@type":"SoftwareApplication","publisher":{"@id":"https://www.capterra.com.sg/#organization"},"applicationCategory":"BusinessApplication","aggregateRating":{"@type":"AggregateRating","ratingValue":4.9,"bestRating":5,"ratingCount":9},"offers":{"price":"1250","@type":"Offer","priceCurrency":"USD"},"operatingSystem":"Cloud, Windows, Windows on premise, Linux on premise"},{"@id":"https://www.capterra.com.sg/software/196649/ngs-iq#faqs","@type":"FAQPage","mainEntity":[{"name":"What Is NGS-IQ?","@type":"Question","acceptedAnswer":{"text":"NGS-IQ is for IBM i (iSeries, AS/400) only. It simplifies & automates query, reporting, & analytics tasks. Excel users can create & refresh sheets, named ranges, & pivot tables in one click. SmartView OLAP module supports drill-down, pivot, filter, chart, export. NGS-IQ doesn't require middleware or a separate server. It uses the integrated IBM IBM idatabase & security to ensure compliance, data integrity & performance. Extensive data formatting, email and job scheduling is built in.","@type":"Answer"}},{"name":"Who Uses NGS-IQ?","@type":"Question","acceptedAnswer":{"text":"All companies running on IBM i, iSeries, System i or AS/400. NGS-IQ is used in every industry. Customers range from departments and small offices to Fortune 500 companies.","@type":"Answer"}}]},{"@id":"https://www.capterra.com.sg/software/196649/ngs-iq#breadcrumblist","@type":"BreadcrumbList","itemListElement":[{"name":"Home","position":1,"item":"/","@type":"ListItem"},{"name":"Data Preparation Software","position":2,"item":"/directory/32747/data-preparation/software","@type":"ListItem"},{"name":"NGS-IQ","position":3,"item":"/software/196649/ngs-iq","@type":"ListItem"}]}]}
</script>
