New Generation Software LogoQPort Access

NGS Business Intelligence Software

Enterprise Query Execution ScreenshotEmpower Your Users

Qport Access empowers Windows users with the ability to execute IQ Server queries from their PC and transfer the results to popular Windows applications.

ODBC-free

No ODBC middleware and the accompanied security concerns are needed with Qport Access. Users access the iSeries data via IQ Server, executing the query in batch, and transfers only the finished report to their desired desktop application.

Remote Access Functionality

Since Qport Access supports TCP/IP, remote users and other authorized business partners can access the data they need with a username and password. Utilize NGSI SeQure to enhance security and control access to sensitive company data.

These videos are part of a video series published by NGSI titled “The Elevator”. It helps explain the differences between DB2 Web Query & NGS-IQ query, reporting, and business intelligence software. Above is part 1, and below is part 2.

Advanced Functionality

With Qport Access, users are given the ability to run sophisticated reports with complex record selection criteria, conditional calculations and summary level new fields, extensive formatting, file joins, member support, and summary or detailed output.

Utilize the ad hoc query functionality for run-time calculations, allowing users to change discount formulas, data ranges, customer names or item numbers without revising the query.

Automates transfer of data results to desktop applications

The results of your query can be downloaded to almost any desktop application, including Word, Excel, Access, Lotus 1-2-3 and other business productivity tools. Maintain formatting, create spreadsheet from the generated data, and map the data into the application as needed.

NGS-IQ DiagramQport Access also supports the results of queries being sent to a Windows display, an ASCII or iSeries printer, or an iSeries IFS or DB2™ file. You can also transfer to host for other departments and databases, or transfer results into SmartView for OLAP analysis.


North American Systems has been providing IT solutions, sevices and hardware for over 15 years.

If you want learn more about what we can do for your IT, please contact us at 800-927-7474, or send us an email at sales@nasi.com to get in touch with one of our experienced account executives.

Want to find out more about what North American Systems has to offer?

Fill out the form below, and one of our account executives will follow up with you promptly







Feel free to contact us at 800-927-7474, or email info@nasi.com