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

Pricing starting from:

US$1,250.00/year

  • Free Version
  • Free Trial
  • Subscription

Key benefits of NGS-IQ

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.

Devices

Business size

S M L

Markets

Canada, United States

Supported Languages

English

Pricing starting from:

US$1,250.00/year

  • Free Version
  • Free Trial
  • Subscription

Images

NGS-IQ Software - NGS-IQ access control
NGS-IQ Software - NGS-IQ dashboard
NGS-IQ Software - NGS-IQ graphical reporting
NGS-IQ Software - NGS-IQ conditional calculations
NGS-IQ Software - NGS-IQ chart preparation
View 6 more
NGS-IQ video
NGS-IQ Software - NGS-IQ access control NGS-IQ Software - NGS-IQ dashboard NGS-IQ Software - NGS-IQ graphical reporting NGS-IQ Software - NGS-IQ conditional calculations NGS-IQ Software - NGS-IQ chart preparation

Features

Total features of NGS-IQ: 32

  • API
  • Ad hoc Query
  • Ad hoc Reporting
  • Charting
  • Customizable Dashboard
  • Customizable Reports
  • Dashboard Software
  • Data Aggregation and Publishing
  • Data Capture and Transfer
  • Data Connectors
  • Data Extraction Software
  • Data Import/Export
  • Data Synchronization
  • Data Transformation
  • Data Visualization Software
  • Drag & Drop
  • Financial Reporting Software
  • Forecasting
  • Job Scheduling
  • Marketing Reports
  • Metadata Management
  • Multiple Data Sources
  • OLAP
  • Publishing / Sharing
  • Reporting & Statistics
  • Sales Reports
  • Scheduled / Automated Reports
  • Search/Filter
  • Self Service Data Preparation
  • Summary Reports
  • Trend / Problem Indicators
  • Visual Analytics

Alternatives

Dundas BI

4.5
#1 Alternative to NGS-IQ
Dundas BI is an extremely flexible dashboard, reporting and data analytics platform for enterprise organizations and...

Qlik Sense

4.4
#2 Alternative to NGS-IQ
Qlik Sense is a business intelligence (BI) and visual analytics platform that supports a range of analytic use cases....

ClicData

4.6
#3 Alternative to NGS-IQ
Derive insightful reports and make better data-driven decisions with ClicData’s business intelligence dashboard...

Qrvey

4.8
#4 Alternative to NGS-IQ
Qrvey is a cloud-based business analytics platform that offers enterprises with tools for data collection, analysis,...

Reviews

Overall rating

4.9 /5
(9)
Value for Money
5/5
Features
5/5
Ease of Use
4.6/5
Customer Support Software
5/5

Already have NGS-IQ?

Software buyers need your help! Product reviews help the rest of us make great decisions.

Write a Review!
Showing 5 reviews of 9
Robert D.
Overall rating
  • Industry: Medical Devices
  • Company size: 1,001-5,000 Employees
  • Used Weekly for 6-12 months
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 9.0 /10

NGS-IQ Review

Reviewed on 2019-12-20

NGS customer support is the most responsive and helpful of any support team for any software...

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.

Shawn A.
Overall rating
  • Industry: Hospital & Health Care
  • Company size: 51-200 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 10.0 /10

A great tool for extracting and sharing data

Reviewed on 2019-12-19

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.
Overall rating
  • Industry: Nonprofit Organization Management
  • Company size: 501-1,000 Employees
  • Used Weekly for 2+ years
  • Review Source

Overall rating

  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 9.0 /10

Data Insight on Demand

Reviewed on 2021-03-16

Really enjoyable! The product has a number of features that make it easy to analyze, distribute,...

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.

Duane D.
Overall rating
  • Industry: Industrial Automation
  • Company size: 201-500 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 10.0 /10

Ease of use

Reviewed on 2020-02-06

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

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.

Van T.
Overall rating
  • Industry: Nonprofit Organization Management
  • Company size: 501-1,000 Employees
  • Used Daily for 2+ years
  • Review Source

Overall rating

  • Value for Money
  • Ease of Use
  • Customer Support Software
  • Likelihood to recommend 10.0 /10

NGS-IQ

Reviewed on 2020-02-06

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

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

Showing 5 reviews of 9 Read all reviews

NGS-IQ FAQs

Below are some frequently asked questions for NGS-IQ.

NGS-IQ offers the following pricing plans:

  • Starting from: US$1,250.00/year
  • Pricing model: Subscription
  • Free Trial: Available

Contact New Generation Software for pricing details

NGS-IQ has the following typical customers:

Self Employed, 2-10, 11-50, 51-200, 201-500, 501-1,000, 1,001+

NGS-IQ supports the following languages:

English

NGS-IQ supports the following devices:

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

NGS-IQ offers the following support options:

Email/Help Desk, FAQs/Forum, Knowledge Base Software, Phone Support

Related categories

See all software categories found for NGS-IQ.