# NGS-IQ Software Pricing, Alternatives & More 2026 | Capterra

> With the help of Capterra, learn about NGS-IQ Software - reviews, pricing plans, popular comparisons to other Business Intelligence products and more.

Source: https://www.capterra.com/p/196649/NGS-IQ

---

# 

 NGS-IQ Software Review 2026: Features, Integrations, Pros & Cons

Last updated on March 13, 2026

Provider data verified by our Software Research team, and reviews moderated by our Reviews Verification team.

[Description](#description)[Use cases](#use-cases)[Alternatives](#alternatives)[Features](#features)[Pricing](#pricing)[Support](#support)[Reviews](#reviews)

NGS-IQ

## What is NGS-IQ?

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 i database & security to ensure compliance, data integrity & performance. Extensive data formatting, email and job scheduling is built in.

## What is NGS-IQ used for?

[Reporting](https://www.capterra.com/reporting-software/)[Business Intelligence](https://www.capterra.com/business-intelligence-software/)[Data Preparation](https://www.capterra.com/data-preparation-software/)

Top alternative

Featured

Overall rating

Based on 9 user reviews

Reviews sentiment

Positive

\-

Neutral

\-

Negative

\-

Starting price

$1250

Per Feature, Per Year

Free trial  
available

Capterra Shortlist charts the highest-rated and most popular products...

Our "Best of" badge program showcases products with the highest ratings...

Our "Best of" badge program showcases products with the highest ratings...

Do you work for NGS-IQ?[Manage this product listing](https://digitalmarkets.gartner.com/get-listed/claim-bx?url=http://www.ngsi.com&name=NGS-IQ)

## Compare with a popular alternative

Capterra selects software alternatives based on relevant features, verified user reviews and user interactions. Placement may be influenced by client status.

### NGS-IQ

4.9 (9)

VS.

[4.5 (26)](https://www.capterra.com/p/162524/DataTap/reviews/)

Starting Price

$1250

Per Feature, Per Year

Starting Price

Contact vendor

Free Trial

Free Version

Pricing Options

Free Trial

Free Version

Ease Of Use

4.6 (9)

Ease Of Use

4.0 (25)

Value For Money

5.0 (5)

Value For Money

4.2 (22)

Customer Service

5.0 (9)

Customer Service

4.5 (23)

## NGS-IQ alternatives

[4.3 (329)](https://www.capterra.com/p/119119/Domo/reviews/)

Starting price

Contact vendor for pricing

Pricing Options

Free Trial

Free Version

User Rating

85%

of reviewers

rated it above 4 stars

[4.7 (19)](https://www.capterra.com/p/156756/Funnel/reviews/)

Starting price

$120.00

Per User, Per Month

Pricing Options

Free Trial

Free Version

User Rating

100%

of reviewers

rated it above 4 stars

[Grow](https://www.capterra.com/p/136247/Grow/)

[4.4 (400)](https://www.capterra.com/p/136247/Grow/reviews/)

Starting price

Contact vendor for pricing

Pricing Options

Free Trial

Free Version

User Rating

90%

of reviewers

rated it above 4 stars

[Learn More](https://www.capterra.com/p/136247/Grow/)

Highest Rated

[OpenText Analytics Cloud](https://www.capterra.com/p/177019/OpenText-Analytics-Suite/)

[5.0 (1)](https://www.capterra.com/p/177019/OpenText-Analytics-Suite/#reviews)

Starting price

$0.01

Per User, Per Month

Pricing Options

Free Trial

Free Version

User Rating

100%

of reviewers

rated it above 4 stars

[Learn More](https://www.capterra.com/p/177019/OpenText-Analytics-Suite/)

## Features

Features with the highest number of reviews are displayed first. Those that have no reviews appear next, sorted alphabetically.

Ad hoc Query

One-off queries made on an as-needed basis

Ad hoc Reporting

Generate one-off reports that meet information requirements

API

Application programming interface that allows for integration with other systems/databases

Customizable Dashboard

Alter the layout and content of dashboards

Customizable Reports

Alter the layout and content of reports

Dashboard

Assembly of graphs and charts for visualizing and tracking statistics/metrics

NGS-IQ 28 features

One-off queries made on an as-needed basis

Generate one-off reports that meet information requirements

Application programming interface that allows for integration with other systems/databases

Alter the layout and content of dashboards

Alter the layout and content of reports

Assembly of graphs and charts for visualizing and tracking statistics/metrics

Assemble data from multiple sources

Connect to big data sources

Automatically retrieve and pull information from documents, websites, images, data sets, and other sources

Import and export data to and from software applications

Synchronizing data between two or more devices/systems and automatically updating changes to maintain consistency

Translate EDI formats into data suitable for use with company applications.

Graphical representation of data

Assemble applications and processes by dragging over and arranging pre-built components

Generate reports to assess the financial performance of an organization

Form predictions based on past and present data/trends

Planning and managing the execution of tasks or jobs within a computer system, network, or other automated environments

Reports specific to marketing and associated campaigns

Collect and maintain structured information that describes data or content

Allows users to manage data from a number of sources

Online Analytical Processing technology for performing high-speed complex queries or multidimensional analysis on large volumes of data

Share pre-configured sets of data organized and presented in a specific manner with the organization

Reports specific to sales analysis for trends and strategies

Set a time to generate routine reports automatically

Search and filter data across systems to locate required information by entering keywords or certain criteria

Access, combine, transform, and store data without the help of an IT department

Visually identify direction of development and areas that require attention

Interact with data visualization elements, such as charts and graphs, to drill down into data

Get Advice

We can help you find the software with the features you need.

Features

5.0 (9)

5.0

Based on 9 reviews

## Pricing

Value for money

5.0 (5)

Free Trial

Basic

$1,250

Per Feature,Per Year

Value for money

5.0 (5)

5.0

Based on 5 reviews

Connect with a Capterra advisor for a free 15-minute consultation

Get a personalized software list aligned to your business needs with guidance from our expert advisors. Our team has helped 1 million+ businesses like yours find options that fit their needs.

## Support, customer service and training options

Customer Service

5.0 (9)

Support

-   Email/Help Desk
-   FAQs/Forum
-   Knowledge Base
-   Phone Support
-   24/7 (Live rep)
-   Chat

Training

-   In Person
-   Live Online
-   Webinars
-   Documentation
-   Videos

Deployment

-   Web
-   Android
-   iPhone/iPad

Typical users

-   Freelancers
-   Small businesses
-   Mid size businesses
-   Enterprises

Customer Service

5.0 (9)

5.0

Based on 9 reviews

## User reviews

Overall rating

4.9

Based on 9 reviews

Filter by rating

5(8)

4(1)

3(0)

2(0)

1(0)

Mentioned topic

Sorted by most recent

PB

Pamela B.

Application Annalyst

Information Technology and Services

### "Versatile Report Writing"

5.0

Overall Rating

5.0

5.0

Ease of Use

3.0

3.0

Features

5.0

5.0

Customer Service

5.0

5.0

Likelihood to Recommend

10/10

March 30, 2021

I love using NGS-IQ. I can run a variety of types of reports to whatever output I want. It is a great product.

Pros

I most love the report customization options. I can move data and totals wherever I want on the report. I like that ability to customize the page headers and footers when outputting to PDF.

Cons

I do not like the UI look of the software screens. The whole field is grey with no contrast for the tab you are working on. I would love to see more prominent buttons and sizable text.

Review source

Incentivized review: software users are invited to submit an honest review and offered a nominal incentive for their time and effort. All incentivized reviews are subject to our verification process prior to publication.

CR

Christopher R.

Application Analyst

Non-Profit Organization Management

### "Data Insight on Demand"

4.0

Overall Rating

4.0

4.0

Ease of Use

4.0

4.0

Features

5.0

5.0

Customer Service

5.0

5.0

Likelihood to Recommend

9/10

March 16, 2021

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!

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

Review source

Incentivized review: software users are invited to submit an honest review and offered a nominal incentive for their time and effort. All incentivized reviews are subject to our verification process prior to publication.

PO

Patrick O.

Manager Information Systems

Staffing and Recruiting

### "NGS Qport Office Review"

5.0

Overall Rating

5.0

5.0

Ease of Use

5.0

5.0

Features

5.0

5.0

Customer Service

5.0

5.0

Likelihood to Recommend

10/10

February 26, 2020

Pros

I can check my queries almost instantaneously and it moves the data from the AS400 to Excel beautifully.

Cons

There are no cons. This software works perfectly.

Review source

Incentivized review: software users are invited to submit an honest review and offered a nominal incentive for their time and effort. All incentivized reviews are subject to our verification process prior to publication.

RN

Roger N.

ERP Development Manager

Industrial Automation

### "Reports for IBM iSeries"

5.0

Overall Rating

5.0

5.0

Ease of Use

5.0

5.0

Features

5.0

5.0

Customer Service

5.0

5.0

Likelihood to Recommend

10/10

February 10, 2020

I use NGS-IQ daily and is used create reports and database tables

Pros

The software is very compatible with our need for reporting

Cons

How to navigate around the application, using the different function key caused a slight learning curve.

Reasons for choosing NGS-IQ

It was here when I was hired

Review source

Incentivized review: software users are invited to submit an honest review and offered a nominal incentive for their time and effort. All incentivized reviews are subject to our verification process prior to publication.

AF

Adam F.

Analyst

Hospital & Health Care

### "Leaves IBM Query in the Dust"

5.0

Overall Rating

5.0

5.0

Ease of Use

4.0

4.0

Features

5.0

5.0

Customer Service

5.0

5.0

Likelihood to Recommend

9/10

February 8, 2020

Pros

Ability to link queries Ability to email results automatically 'Memory' for joined fields

Cons

Some error messages could be more helpful The need to delete output files if they don't match could be improved to have the program perform that funtion

Review source

Incentivized review: software users are invited to submit an honest review and offered a nominal incentive for their time and effort. All incentivized reviews are subject to our verification process prior to publication.

DD

Duane D.

Sr Programmer/Analyst

Industrial Automation

### "Ease of use"

5.0

Overall Rating

5.0

5.0

Ease of Use

5.0

5.0

Features

5.0

5.0

Customer Service

5.0

5.0

Likelihood to Recommend

10/10

February 6, 2020

we have many queries and have been using the product for over 20 years

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.

Reasons for choosing NGS-IQ

NGS was being used when I joined the company 20 plus years ago.

Review source

Incentivized review: software users are invited to submit an honest review and offered a nominal incentive for their time and effort. All incentivized reviews are subject to our verification process prior to publication.

VT

Van T.

Systems Programming Manager

Non-Profit Organization Management

### "NGS-IQ"

5.0

Overall Rating

5.0

5.0

Ease of Use

5.0

5.0

Features

5.0

5.0

Customer Service

5.0

5.0

Likelihood to Recommend

10/10

February 6, 2020

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

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

Review source

Incentivized review: software users are invited to submit an honest review and offered a nominal incentive for their time and effort. All incentivized reviews are subject to our verification process prior to publication.

Robert D.

Senior Software Developer

Medical Devices

### "NGS-IQ Review"

5.0

Overall Rating

5.0

5.0

Ease of Use

5.0

5.0

Features

5.0

5.0

Customer Service

5.0

5.0

Likelihood to Recommend

9/10

December 20, 2019

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

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.

Review source

Incentivized review: software users are invited to submit an honest review and offered a nominal incentive for their time and effort. All incentivized reviews are subject to our verification process prior to publication.

SA

Shawn A.

IT Director

Hospital & Health Care

### "A great tool for extracting and sharing data"

5.0

Overall Rating

5.0

5.0

Ease of Use

5.0

5.0

Features

5.0

5.0

Customer Service

5.0

5.0

Likelihood to Recommend

10/10

December 19, 2019

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.

Review source

Incentivized review: software users are invited to submit an honest review and offered a nominal incentive for their time and effort. All incentivized reviews are subject to our verification process prior to publication.

[View all Reviews](https://www.capterra.com/p/196649/NGS-IQ/reviews/)

Independent research methodology

Capterra's researchers use a mix of verified reviews, independent research and objective methodologies to bring you selection and ranking information you can trust. While we may earn a referral fee when you visit a provider through our links or speak to an advisor, this has no influence on our research or methodology.

[Learn more](https://www.capterra.com/resources/proprietary-data-research/)

How Capterra verifies reviews

Capterra carefully verified over 2.5 million+ reviews to bring you authentic software experiences from real users. Our human moderators verify that reviewers are real people and that reviews are authentic. They use leading tech to analyze text quality and to detect plagiarism and generative AI.

[Learn more](https://www.capterra.com/resources/how-we-verify-reviews/)

How Capterra ensures transparency

Capterra lists all providers across its website—not just those that pay us—so that users can make informed purchase decisions. Capterra is free for users. Software providers pay us for sponsored profiles to receive web traffic and sales opportunities. Sponsored profiles include a link-out icon that takes users to the provider's website.

[Learn more](https://www.capterra.com/resources/how-we-ensure-transparency/)