NGS - QPort Office

Toll Free: (888) 682-5335
Live Chat
 
Home » Software » iSeries » BI & Query Reporting » NGS QPort Office 
 
BI & Query Reporting
 
 
1
NGS - QPort Office

Stop writing queries and converting your query output files into XLS or other ASCII formats for your users. QPort Office enables you to run your existing queries and automatically output them to Excel, Word, and Access. Qport Office lets you:

  • Run queries from Windows desktop icons
  • Create and update Excel workbooks, sheets, and named ranges
  • Create Word documents and Access tables from query output
  • Link queries so one mouse click initiates the execution of an entire series of queries
  • Use one tool to create query output files, convert them to XLS, and send them to the intended user
  • Leverage the business and database knowledge in your existing queries

Get your 2 Complimentary Qport Office User Licenses here!

Just complete the License Request Form to recieve your 2 Complimentary User Licenses. This Qport Office license fee waiver offer expires April 30, 2009 (promotion expiration date subject to change without notice).  

Add to Cart

 
 
NGS: Solutions
'); } else { document.write('<' + 'script language="JavaScript" type="text/javascript" src="' + rjsPath + 'iemenu.js">'); }return true;}LoadMenus();

QPort Office gives you the ability to run your Query/400 queries from the Windows desktop and direct output to Excel, Access, Word, Windows display or PC Printer. With QPort Office, users can simply run any existing query and automatically output them to Excel, Word, Access or any PC Printer. QPort Office is an entry level reporting tool for companies that aren’t ready to replace Query/400 with NGS-IQ, but would still like to give their users additional functionality and control.  

Qport Office is an easy-to-implement product add-on that enhances Query/400 without adding complexity. It can be downloaded and installed in under 15 minutes. Qport Office runs on the Windows desktop and acts as a front end to IBM Query/400 and immediately enable users to run their Query/400 queries from Windows and produce Microsoft Excel spreadsheets, Access tables, Word documents, Windows displays, and directly output onto PC printers.

QPort Office is an entry level reporting tool for companies that aren’t ready to replace Query/400 with NGS-IQ, but would still like to give their users additional functionality and control.

When sending query results to Excel, users have the ability to create, replace, or append to an existing range within a sheet. Users can also link multiple queries together for automatic sequential processing so an entire job stream can be launched from a desktop icon. You don’t even need to change your existing queries and they still process exactly as they always have on the System i, and OCBC middleware is not required.

QPort Office is easy for any non-technical user to master without a training class and customers gain useful new functions without installing DB2 Web Query.

QPort Office is not a replacement for Query/400, it enhances Query/400 output and saves you time. NGS also offers more comprehensive Enterprise Level Reporting and Business Intelligence Solutions (NGS-IQ & Decision Assist).

NGS Solutions

New Generation Software, Inc. (NGS) provides reporting, business intelligence, and data warehousing solutions for IBM System i customers. Our solutions include the following:

  • Qport Office – an inexpensive Windows desktop tool that enhances Query/400
  • NGS-IQ – our flagship query, reporting, and business intelligence suite for companies that want to move beyond Query/400 and other tools
  • Decision Assist – our line of packaged analytical templates for finance, sales, customer, inventory, and healthcare analysis.

Use the table below to decide which NGS offering is right for you.

Which NGS Solution is Right for You?

Feature

Qport Office

NGS-IQ

Decision Assist
(includes NGS-IQ)

Windows, Web, and 5250 Query Development

 

Run Query/400 Queries

Output to Microsoft Excel

Output to Microsoft Access

Output to Microsoft Word

Output to PC Printer

Output to Windows Display

Output to HTML

 

Output to XML

 

Output to PDF

 

Output to OLAP

 

Conditional (If-Then) New Field Calculations

 

Run-Time Prompting for New Field Calculation Logic

 

Run-Time Prompting for Record Selection Criteria

 

Distribute Query Results via E-Mail and/or FTP

 

Optional Meta-Data Directory

 

Dashboard Development

 

Field and Record Level Security

 

Integration with Third Party Encryption Software

 

Transfer Data to DB2 for i5/OS from Other Environments

 

Packaged DB2 for i5 OS Data Mart and Analytical Template (Financial Performance, Business Performance, Healthcare)

 
 

Pre-Defined Web Portal

 
 

Pre-Formatted Dashboards, Reports, OLAP Models, Excel Worksheets, etc.

 
 

Off-the-Shelf Solution for Vormittag Associates, Inc. (VAI) S2K

 
 

Off-the-Shelf Solution for Siemens Medical Solutions MedSeries4

 
 

Off-the-Shelf Solution for NGS Concert Series General Ledger

 
 
 
 
2130 Platinum Road, Apopka, FL 32703
Copyright © 2012. Midland Information System, Inc. All rights Reserved Terms of Use Privacy Policy Site Map