NGS-IQ

Querying, analytics, and reporting solution for businesses

5 /5 (9 reviews) Write a Review!

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.

NGS-IQ Overview

Pricing

Starting from
$1,250.00/year

Pricing options

Free Trial
One Time License
Subscription
Value for money

Contact New Generation Software for pricing details


NGS-IQ Features

Devices
Business size
S M L
Markets
United States, Canada
Supported Languages
English

Media

NGS-IQ access control
NGS-IQ dashboard
NGS-IQ graphical reporting
NGS-IQ conditional calculations
NGS-IQ chart preparation
NGS-IQ video NGS-IQ screenshot: NGS-IQ access control NGS-IQ screenshot: NGS-IQ dashboard NGS-IQ screenshot: NGS-IQ graphical reporting NGS-IQ screenshot: NGS-IQ conditional calculations NGS-IQ screenshot: NGS-IQ chart preparation

NGS-IQ Reviews

NGS-IQ Reviews

Overall rating
5
/
5
Excellent
9

Very good
0

Average
0

Poor
0

Terrible
0

Value for Money
5
Features
5
Ease of Use
4.6
Customer Support
5
100% recommended this app
Robert D.

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.


Shawn A.

A great tool for extracting and sharing data


Duane D.

Ease of use

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


Van T.

NGS-IQ

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


Roger N.

Reports for IBM iSeries

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


Robert D.
Industry: Medical Devices
Company size: 1,001-5,000 Employees

NGS-IQ Review

Used Weekly for 6-12 months
Reviewed on 12/20/2019
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.

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.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 9.0/10

Shawn A.
Industry: Hospital & Health Care
Company size: 51-200 Employees

A great tool for extracting and sharing data

Used Daily for 2+ years
Reviewed on 12/19/2019
Review Source: Capterra

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.

Rating breakdown

Ease of Use
Customer Support

Likelihood to recommend: 10.0/10

Duane D.
Industry: Industrial Automation
Company size: 201-500 Employees

Ease of use

Used Daily for 2+ years
Reviewed on 2/6/2020
Review Source: Capterra

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.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 10.0/10

Van T.
Industry: Nonprofit Organization Management
Company size: 501-1,000 Employees

NGS-IQ

Used Daily for 2+ years
Reviewed on 2/6/2020
Review Source: Capterra

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

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 10.0/10

Roger N.
Industry: Industrial Automation
Company size: 501-1,000 Employees

Reports for IBM iSeries

Used Daily for 2+ years
Reviewed on 2/10/2020
Review Source: Capterra

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.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend: 10.0/10

User recommendation
9.8/10
Based on 9 user ratings
Compare user recommendation rating with alternatives
Compare with alternatives

NGS-IQ Pricing

NGS-IQ Pricing

Starting from
$1,250.00/year
Free Trial
One Time License
Subscription
Value for money

Contact New Generation Software for pricing details

Contact New Generation Software for pricing details

Value for Money
5/5
Based on 9 user ratings
Compare value for money rating with alternatives
Compare with alternatives

NGS-IQ Features

NGS-IQ Features

API
Activity Dashboard
Ad hoc Reporting
Business Intelligence
Charting
Collaboration Tools
Customizable Reporting
Dashboard Creation
Data Filtering
Data Import/Export
Data Visualization
Filtered Views
Monitoring
Multiple Data Sources
Predictive Analytics
Real Time Analytics
Real Time Data
Reporting & Statistics
Third Party Integration
Visual Analytics
Features
5/5
Based on 9 user ratings
Compare features rating with alternatives
Compare with alternatives

Categories

Additional information for NGS-IQ

Additional information for NGS-IQ

Key features of NGS-IQ

  • Dashboard
  • Data Visualization
  • Drill Down
  • Forecasting
  • OLAP
  • Trend / Problem Indicators
  • Visual Analytics

Benefits

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.

NGS-IQ FAQs

NGS-IQ FAQs

Below are some frequently asked questions for NGS-IQ.

Q. What type of pricing plans does NGS-IQ offer?

NGS-IQ offers the following pricing plans:

Starting from: $1,250.00/year

Pricing model: One Time License, Subscription

Free Trial: Available

Contact New Generation Software for pricing details

Q. What are the main features of NGS-IQ?

NGS-IQ offers the following features:

  • Dashboard
  • Data Visualization
  • Drill Down
  • Forecasting
  • OLAP
  • Trend / Problem Indicators
  • Visual Analytics

Q. Who are the typical users of NGS-IQ?

NGS-IQ has the following typical customers:

Small Business, Large Enterprises, Public Administrations, Non Profit, Mid Size Business

Q. What languages does NGS-IQ support?

NGS-IQ supports the following languages:

English

Q. What type of pricing plans does NGS-IQ offer?

NGS-IQ has the following pricing plans:

One Time License, Subscription

Q. Does NGS-IQ support mobile devices?

We do not have any information about what devices NGS-IQ supports

Q. What other apps does NGS-IQ integrate with?

We do not have any information about what integrations NGS-IQ has

Q. What level of support does NGS-IQ offer?

NGS-IQ offers the following support options:

Phone Support, FAQs, Knowledge Base, Video Tutorials, Online Support