Empower All Your Users

IQ Server™ is an IBM i-based (AS/400) advanced-function query, reporting, and BI solution that serves as the foundation of the NGS-IQ™ product line.

A Company-Wide Hub for Reporting and Business Intelligence

IQ Server works directly with your DB2 data on the IBM i and can also reach out to MySQL, SQL Server, Oracle, PostgreSQL, and DB2 on other platforms, so you can use it as the hub for all your query, reporting and BI needs.

One-Step Reporting and Analysis

IQ Server offers hundreds of features, but for many customers, the single, most valuable advantage of IQ Server over IBM Query/400 and nearly all competing BI software is IQ Server’s ability to produce professional reports, Web pages, presentations, and analytical models in one step, using only one query to obtain the results users need.

One-step report writing means increased productivity and better system performance because your users get accurate information quickly without wasting system resources running multiple queries.

Query/400 Migration and Assistance

Many customers discover NGS-IQ after using IBM Query/400. To ease migration, NGS offers IQ Server users a Query/400 API they can use to run and enhance Query/400 queries in IQ Server without rewriting or converting them. This Query/400 API enables you to leverage your company’s past development efforts and the database knowledge embedded in your existing queries.

Advanced Features (full description of the below features)

• "WebRunner" Interface
• Conditional Calculations
• On-Line Formatting
• Run-Time Prompting
• Record Selection and Exclusion
• Analytical Summary "Matrix" Reporting
• Adobe® Acrobat File Generation
• Web Report Publishing
• XML File Generation
• Simplified File Joins
• Database Field Aliases
• Previous Record/Skip Record
• Program Exits
• Report and Data Distribution
• File Unions
• New Fields/Sorts
• SQL Command Interface
• Report Management
• DB2 for i File Member and IDDU Support

Data Base Reporting Without Limits

IQ Server can raise your productivity and dramatically cut your reporting backlog while satisfying a wide range of users.

Related customer story:
NGS Software Solutions Make the "Grade" at MSU Bookstore

NGS-IQ, and IQ Server are trademarks of New Generation Software, Inc. All other trademarks are the property of their respective owners.