NGS-IQ 2026: Benefits, Features & Pricing

Software Advice offers objective insights based on verified user reviews and independent product and market research. When our advisors match you to a software provider, we may earn a referral fee.

How Software Advice ensures transparency

Software Advice lists all providers across its website—not just those that pay us—so that users can make informed purchase decisions. Users can talk to our advisors for free to receive software recommendations matching their needs. Software providers pay us for sponsored profiles to reach users interested in their products.

How Software Advice verifies reviews

Software Advice carefully verified over 2 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.

Independent research methodology

Researchers at Software Advice 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 talk to an advisor, this has no influence on our research or methodology.

Wondering if NGS-IQ is right for your organization?

Our Business Intelligence Software selection experts can help you in 15 minutes or less.

On this page

Overview
Pricing and Plans
Features
User Reviews

Overview

NGS-IQ

4.9

(9)

Pricing

Starting at $1,250.00 per year

About NGS-IQ

NGS-IQ is a query, report writing and online analytical processing (OLAP) solution exclusively for IBM i, iSeries, System i and AS/400 customers. It works with IBM Db2 on i to enable technical and non-technical users to join, extract, manipulate, format, output and share files, reports and visualizations without requiring a separate server or middleware.

NGS-IQ allows developers to use the point-click, drag and drop interface to construct ad-hoc queries and production reports that include conditional calculation logic, date formatting, date arithmetic, run-time prompts for calculations and variable selection criteria, summaries, rankings, running totals, running percentages of totals standard deviation and absolute value.

Authorized users can run NGS-IQ queries to refresh Excel sheets, including charts and pivot tables, from desktop shortcuts and hyperlinks. Customers may also provide run-time links to queries from intranet, portal and IBM i applications. Output formats include Microsoft Office (Excel, Access, Word), HTML, NGS's own SmartView OLAP module, Adobe PDF, CSV, TXT, XML and print.

The application supports email output distribution, self-service Web reportin...

NGS-IQ Screenshots

NGS-IQ Pricing and Plans

Starting price: $1,250.00 per year

Free Trial

Free Version

Basic

$1,250.00

per feature, per year

No plan information available

Confused about pricing? We've got you covered.

Get a personalized pricing breakdown tailored to your specific needs—no guesswork, no generic estimates.

NGS-IQ Features

Popular features found in Business Intelligence
Ad hoc Reporting
Benchmarking
Collaboration Tools
Data Connectors
Data Visualization
Key Performance Indicators
Multiple Data Sources
Performance Metrics
Predictive Analytics
Profitability Analysis
Strategic Planning
Trend/Problem Indicators
More features of NGS-IQ
Ad hoc Query
API
Customizable Dashboard
Customizable Reports
Dashboard
Data Aggregation and Publishing
Data Extraction
Data Import/Export
Data Synchronization
Data Transformation
Drag & Drop
Financial Reporting
Forecasting
Job Scheduling
Marketing Reports
Metadata Management
OLAP
Publishing/Sharing
Sales Reports
Scheduled/Automated Reports
Search/Filter
Self Service Data Preparation
Visual Analytics

NGS-IQ User Reviews

Overall Rating

4.9

Ratings Breakdown

89%

11%

Secondary Ratings

Ease of Use

4.6

Value for money

5.0

Customer support

5.0

Functionality

5.0

Have you used NGS-IQ and would like to share your experience with others?

Robert D.

Verified reviewer

Medical Devices

1001-5000 employees

Used weekly for less than 12 months

Reviewed December 2019

NGS-IQ Review

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

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

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.

Shawn A.

Verified reviewer

Hospital & Health Care

51-200 employees

Used daily for more than 2 years

Reviewed December 2019

A great tool for extracting and sharing data

Ratings Breakdown

Ease of use

Customer support

Functionality

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.

Christopher R.

Verified reviewer

Non-Profit Organization Management

501-1000 employees

Used weekly for more than 2 years

Review source

Reviewed March 2021

Data Insight on Demand

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!

Ratings Breakdown

Ease of use

Customer support

Functionality

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.

Duane D.

Verified reviewer

Industrial Automation

201-500 employees

Used daily for more than 2 years

Reviewed February 2020

Ease of use

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

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

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.

Van T.

Verified reviewer

Non-Profit Organization Management

501-1000 employees

Used daily for more than 2 years

Reviewed February 2020

NGS-IQ

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

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

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

Roger N.

Verified reviewer

Industrial Automation

501-1000 employees

Used daily for more than 2 years

Reviewed February 2020

Reports for IBM iSeries

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

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

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

Patrick O.

Verified reviewer

Staffing and Recruiting

1001-5000 employees

Used daily for more than 2 years

Reviewed February 2020

NGS Qport Office Review

Ratings Breakdown

Ease of use

Value for money

Customer support

Functionality

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.

Pamela B.

Verified reviewer

Information Technology and Services

2-10 employees

Used weekly for more than 2 years

Review source

Reviewed March 2021

Versatile Report Writing

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

Ratings Breakdown

Ease of use

Customer support

Functionality

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.

Adam F.

Verified reviewer

Hospital & Health Care

10000+ employees

Used weekly for more than 2 years

Reviewed February 2020

Leaves IBM Query in the Dust

Ratings Breakdown

Ease of use

Customer support

Functionality

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

Showing 1 - 9 of 9 Reviews