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


Read More

Supported Operating System(s):

IBM OS/400

9 Reviews of NGS-IQ

Average User Ratings

Overall

5.00 / 5 stars

Ease-of-use

4.5

Value for money

5.0

Customer support

5.0

Functionality

5.0

Ratings Snapshot

5 stars

(9)

9

4 stars

(0)

0

3 stars

(0)

0

2 stars

(0)

0

1 stars

(0)

0

Likelihood to Recommend

Not likely

Very likely

Filter reviews by:

Sort by: Most Helpful | Most Recent

Showing 1 - 9 of 9 results

Do you use this product?Write a review

December 2019

Robert from Steris Corpration

Verified Reviewer

Company Size: 1,001-5,000 employees

Industry: Medical Devices

Time Used: Less than 12 months

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

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.

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.

December 2019

Shawn from ebix, Inc.

Company Size: 51-200 employees

Industry: Hospital & Health Care

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Customer support

5.0

Functionality

5.0

December 2019

A great tool for extracting and sharing data

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.

February 2020

Duane from Avery Weigh-Tronix

Company Size: 201-500 employees

Industry: Industrial Automation

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

February 2020

Ease of use

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.

February 2020

Van from Inland Regional Center

Company Size: 501-1,000 employees

Industry: Non-Profit Organization Management

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

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.

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

February 2020

Roger from Mueller WP

Company Size: 501-1,000 employees

Industry: Industrial Automation

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

February 2020

Reports for IBM iSeries

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

February 2020

Patrick from Defender Services

Company Size: 1,001-5,000 employees

Industry: Staffing and Recruiting

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

February 2020

NGS Qport Office Review

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.

February 2020

Adam from Optum360

Company Size: 10,000+ employees

Industry: Hospital & Health Care

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Customer support

5.0

Functionality

5.0

February 2020

Leaves IBM Query in the Dust

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

February 2020

Pamela from SANDIS

Company Size: 11-50 employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

3.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

February 2020

Versatile Report Writing Tools

Thoroughly positive experience!

Pros

NGS offers a variety of report writing software that is flexible to what you need. I truly appreciate the customer service. Their response time and attention to my problems has been excellent. The trainers are also very skilled and personable.

Cons

The user interface for NGS IQ Client, NGS QPORT are a bit dated and not scalable. Screens can be hard to read when working on projects in conference rooms. The website could also use a refresh.

February 2020

Christopher from San Diego Regional Center

Company Size: 501-1,000 employees

Industry: Non-Profit Organization Management

Time Used: Less than 2 years

Review Source: Capterra


Ease-of-use

4.0

Customer support

5.0

Functionality

5.0

February 2020

User Friendly, full of features and outstanding customer support

Pros

The accessibility it gives you to your data and the framework it provides for building out your own personalized suite of reports for your end-users

Cons

It's difficult to readily look at the data in a file