NGS-IQ is New Generation Software's flagship query, reporting, and business intelligence suite for companies that need to move beyond Query/400 and other IBM i query tools.
NGS-IQ is an integrated suite of business intelligence, Web modernization, enterprise reporting and analytical solutions for IBM i on Power Systems. It provides powerful query development for both IT professionals and power users with their choice of Windows, Web, and 5250 environments. Custom Web pages and reporting portals can also be designed with the drag-and-drop, point-and-click Windows interface. Users can run queries from PCs, Web pages, portals, or smartphones. Data can easily be output to interactive dashboards, on-demand Web presentations and charts, Microsoft Office applications, OLAP models, .PDF, and more.
"It's exciting to show our customers and business partners how easy it is to connect their IBM i to the Web and quickly give employees, customers, vendors, and others the ability to query their data without having to understand the back-end database or write any code. Some have considered doing this but thought it would be difficult and time-consuming.
—John O'Sullivan, NGS vice president of technology
The modular NGS-IQ solution spans ad hoc query, production, and Web reporting; online analytical processing (OLAP); business performance dashboards; summary-to-detail drill-down; native access to DB2 on i; and remote real-time access to SQL Server, MySQL, Oracle, PostgreSQL, and other data sources. Users can output distribution by email and FTP. It supports meta data, program exits, date arithmetic, CL interface, and ensures optimal security. NGS-IQ's Web reporting and dashboard development features can quickly modernize legacy reports and bring information to secure Web pages and smartphones. NGS offers packaged analytical templates for customer, sales, inventory, financial reporting, and healthcare. Licensing is flexible and includes the complete integrated suite or modules for specific needs.
NGS-IQ is a Windows, Web, and 5250 query development solution offering comprehensive HTML report formatting, on-demand drill-down on summary values in Web reports and charts, conditional (if-then) field calculations, runtime prompting for field calculation logic, and record selection criteria. Users also have one-click output to specific and saved Excel sheets and named ranges, to Access tables and Word documents, NGS OLAP, DB2, HTML, PDF, CSV, TXT, XML, print, display and more. Query results can be distributed by email and/or FTP. Other solution features include an API to enhance and run existing IBM Query/400 queries within NGS-IQ with no conversion required, dashboard development, field, record, and output-level security, and transfer of data to DB2 for i5/OS from other environments. The Web interface lets users run queries and view output over the Web. The Web design environment is drag-and-drop.
IBM i (iSeries/System i/AS/400)
IBM i OS/400 V5R3 or later
Selected by IBM as the first non-ERP offering in the company's IBM i Solution Edition program for customers interested in a cost-effective business intelligence solution. The program offers customers a choice of Power Systems Model 720 Express four, six, or eight processors, or a model 740 with 4–16 processors, all with significant discounts.
Business intelligence solution for IBM i
General Availability Date
Varies by system configuration and number of modules required
New Generation Software, Inc.
3835 N. Freeway Blvd., Suite 200
Sacramento, CA 95834
as/400, os/400, iseries, system i, i5/os, ibm i, power systems, 6.1, 7.1, V7, V6R1