What is NGS-IQ?
NGS-IQ is a versatile data warehouse development solution designed for the IBM iSeries and i5/OS. Its integrated modules work together to satisfy the widest range of business users and data access requirements.
Plus, NGS-IQ is easy to implement because it uses industry-standard DB2 relational data base concepts for building and accessing your data warehouse.
Developing your NGS-IQ Data Warehouse
The NGS-IQ data warehouse development system runs on the iSeries 400 and may be operated from Windows, Web, and 5250 user interfaces. This powerful system supports complex data extraction, cleansing, date arithmetic, consolidation, meta-data development, and iSeries-to-iSeries file transfer. IS professionals may use the menu-driven and Structured Query Language (SQL) user interfaces of this module to access DB2/400 data bases, including multiple members of the same file and IDDU files. The system supports one-to-many file relationships; unique key processing; file joins based on derived fields; simple, conditional and custom data cleansing; detail and summary level calculations; and both detail and summary data capture and transfer.
End-User Query/Reporting with NGS-IQ
The Qport Builder and Qport Access modules of NGS-IQ provide end users with easy-to-use, full-function query and reporting capabilities. Users may develop the ad hoc queries and production reports they need in Qport Builder and use the run-time features of Qport Access when they want to send their results directly into Microsoft Access, Excel, and Word. Qport Access accepts ad hoc selection criteria and calculation logic and passes the request to the iSeries 400 for batch processing. When the job is ready, Qport Access launches the user’s target application and loads in the query result. Column headings are delivered as defined by the user, and summary values are automatically converted into spreadsheet formulas. Frequently run queries may be linked to desktop icons to further simplify and expedite end-user data base access.
NGS-IQ gives you a single point of control and access for query, reporting, data analysis and data warehousing requirements across ALL your iSeries 400 business applications. Just imagine the cost savings and the reduced learning curve for your users!
Integrated OLAP System
The Qport SmartView module is a high-performance, fully integrated Windows on-line analytical processing solution.
Qport SmartView supports ad hoc multi-dimensional reporting and graphics with sub-second response time on standard Windows workstations, even when you’re processing hundreds of thousands of rows and numerous user-defined dimensions.
Qport SmartView’s intuitive, drag-and-drop, drill-down, drill-up, pivot and graph functions can satisfy the most demanding business analyst.
Meta-Data Development
NGS-IQ lets you create a Business Information Directory in which you can assign long names and business-oriented descriptions to data base elements, making it easier for your business analysts and users to understand and work with the data.
Leverage Existing User Skills and Software Investments
By allowing you to perform data analysis in your existing desktop spreadsheet, data base and word processing software, NGS-IQ leverages not only your past software investments, but also the software skills of your users.
Data Warehouse Security with NGS-IQ
The NGS-IQ data warehouse gives you control over the entire data warehouse and the queries or reports developed in NGS-IQ. You may secure your data warehouse by user at the library, file, field and record level. You may also secure individual or group access rights to queries and reports. All data extractions, iSeries-to-iSeries data transfers, queries and reports may be tracked on-line via audit trails built into the NGS-IQ system.
Full-Service Software Consulting, Training & Technical Support
NGS backs up its NGS-IQ data warehousing solution with a team of experienced consultants, trainers and technical support personnel. Step by step with you, the NGS Data Warehouse Consultants identify your data analysis goals and system requirements, and then develop a customized implementation and methodology plan which details the entire process.
Request a copy of the white paper, "A Practical and Proven Methodology for Implementing a Data Warehouse Using the NGS-IQ Toolset." This paper, authored by an NGS customer, will help you gain a deeper understanding of the steps required for a successful project.
NGS-IQ Product Info
