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 basic IBM i query tools.
NGS-IQ is an enterprise performance management, reporting, and analytics suite for IBM i on Power Systems. It provides powerful query development for both IT professionals and power users and supports a GUI interface for developing queries from Windows and Web browsers. Reports can be designed with a drag-and-drop, point-and-click GUI builder, and data can be output to interactive dashboards, Web presentations, and smartphones.
Developer's Take
"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. Some have considered doing this but thought it would be difficult and time-consuming.
—John O'Sullivan, NGS vice president of technology
Functions
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, includes change management tools, provides auditing, and ensures security. NGS offers packaged analytical templates for customer, sales, inventory, financial reporting, and healthcare. NGS-IQ's Web reporting and dashboard development features are used to quickly modernize legacy reports and bring information to secure Web pages and smartphones. Licensing is flexible and includes the complete integrated suite or modules for specific needs.
Features
NGS-IQ is a Windows, Web, and 5250 query development solution capable of running Query/400 queries with output to Excel, Access, Word, a PC printer, or Windows display. Users can run queries from Web pages, portals, or smartphones. The solution offers comprehensive HTML report formatting, on-demand drill-down on summary values in Web reports, and output to HTML, XML, PDF, or OLAP. It supports conditional (if-then) field calculations, runtime prompting for field calculation logic, and record selection criteria. Query results can be distributed by email and/or FTP. Other solution features include dashboard development, field- and record-level security, integration with third-party encryption software, 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.
Platforms
IBM i (iSeries/System i/AS/400)
System Requirements
IBM i OS/400 V5R3 or later
Other
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.
Product Category
Data Warehousing/Business Intelligence/Knowledge Management
Product Type
Business intelligence solution for IBM i
General Availability Date
Available now
Price
Varies by system configuration and number of modules required
New Generation Software, Inc.
3835 N. Freeway Blvd., Suite 200
Sacramento, CA 95834
916-920-2200
Email:
Web: www.ngsi.com
as/400, os/400, iseries, system i, i5/os, ibm i, power systems, 6.1, 7.1, V7, V6R1
Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.
IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn:
LATEST COMMENTS
MC Press Online