NGS-IQ Pricing, Features, Reviews & Comparison of Alternatives


Querying, analytics, and reporting solution for businesses

5.0/5 (2 reviews)

NGS-IQ overview

What is NGS-IQ?

NGS-IQ is an IBM i (iSeries, AS/400) query, reporting, and analytics solution that enables business analysts, managers, and information technology professionals to access, cleanse, format, and export data from Db2 on i and other databases. NGS-IQ simplifies and automates operational processes to support one-click output from IBM i to MS Office applications, including Excel. Query developers can also quickly design dynamic Web reports featuring charts and drill-down hyperlinks. The integrated Qport SmartView OLAP module enables a non-technical users to create read-only multidimensional presentations of business data. Qport SmartView users can pivot, filter, calculate new values, format, chart, and export data. NGS-IQ operates in full compliance with a customer's IBM i security settings and does not require middleware or a separate server.

The NGS-IQ platform enables administrators to generate ad-hoc queries, develop production reports, design web reports, create spreadsheets, and distribute information in multiple formats. It lets users export data in multiple formats such as Microsoft Excel, Microsoft Word, OLAP models, HTML files with graphics, PDF, CSV, XML, TXT, DB2, and more. Managers can develop and run queries from Windows desktop items, IBM i job schedulers, web pages, portals, mobile devices, 5250 panels, and hyperlinks.

NGS-IQ enables users to add conditional logic for querying, simplify table joins, and perform statistical calculations, and access analytical summaries on rank, percent of total, running total, and more. The system is suitable for businesses across industries including manufacturing, distribution, banking, retail, public sector, and healthcare.


Starting from
Pricing options
Value for money
View Pricing Plans


Business size



United States, Canada, Latin America

Supported languages

NGS-IQ screenshot: NGS-IQ access controlNGS-IQ Query/Reporting/AnalyticsNGS-IQ screenshot: NGS-IQ dashboard NGS-IQ screenshot: NGS-IQ graphical reportingNGS-IQ screenshot: NGS-IQ conditional calculationsNGS-IQ screenshot: NGS-IQ chart preparation

NGS-IQ reviews


Very good
Value for money
Ease of use
Customer support
Robert DiSalvo

NGS-IQ Review

Used weekly for 6-12 months
Reviewed 2019-12-20
Review Source: Capterra

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

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.

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.

Rating breakdown

Value for money
Ease of use
Customer support

Likelihood to recommend: 9/10

Minimize review

Shawn Amick

A great tool for extracting and sharing data

Used daily for 2+ years
Reviewed 2019-12-19
Review Source: Capterra

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.

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.

Rating breakdown

Ease of use
Customer support

Likelihood to recommend: 10/10

Minimize review

NGS-IQ pricing

Starting from
Pricing options
Free trial
One time license
View Pricing Plans

Contact New Generation Software for pricing details

NGS-IQ features

Customizable Reporting
Data Filtering
Data Import/Export
Data Visualization
Reporting & Statistics
Visual Analytics

Activity Dashboard (122 other apps)
Ad hoc Reporting (75 other apps)
Business Intelligence (103 other apps)
Collaboration Tools (62 other apps)
Dashboard Creation (95 other apps)
Drag & Drop Interface (65 other apps)
Filtered Views (61 other apps)
Monitoring (76 other apps)
Real Time Analytics (100 other apps)
Real Time Data (79 other apps)
Third Party Integration (83 other apps)
Trend Analysis (61 other apps)

Additional information for NGS-IQ

Key features of NGS-IQ

  • Ad Hoc Reports
  • Customizable Dashboard
  • Data Source Connectors
  • Disparate Data Collection
  • Drag & Drop
  • Financial Reports
  • Marketing Reports
  • Publishing / Sharing
  • Report Export
  • Sales Reports
  • Scheduled / Automated Reports
  • Self Service Data Preparation
View All Features


User Interfaces:
• Drag-drop, point-and-click query development interface, plus graphical Web report design features.
• Authorized users can run queries from Web pages, portals, mobile devices, job schedulers, Windows desktops, and hyperlinks.
• Built-in email options simplify report and file delivery.

Valuable Functions
• Conditional new field calculations
• Run-time prompting for selections and calculation formulas
• Summary level calculations
• Date field re-formatting
• Date and time arithmetic

Output Types:
• Microsoft® Excel, Word, and Access
• Interactive Web reports with charts, banners, backgrounds, style sheets, and drill-down links
• Portable, read-only “OLAP” models
• Adobe PDF • CSV, TXT, XML, DB2, display, print

Ease of Installation:
• NGS-IQ runs on IBM i - no additional hardware or middleware is required.

Free Trials and Proofs of Concept upon request.