|
Replacing IBM Query/400 and DB2 Web Query
Are you still relying on IBM’s Query/400 or planning to replace DB2 Web Query now that it’s discontinued? While both tools have served businesses well over the years, the time has come to move beyond their limitations and adopt a more powerful, future-proof solution: NGS-IQ.
We encourage you to watch this video to help you plan your migration from these unsupported IBM tools and learn how NGS-IQ can help you satisfy a broad range of users and requirements. 55 minutes. |
|
Automating and Simplifying IBM i Analytics and Reporting with NGS-IQ
Watch this presentation to learn how NGS-IQ can help you support a wide range of IBM i and business users who need to see and analyze operational data. You'll hear a high-level overview of NGS-IQ's capabilities and a demonstration of the query development, Excel output, Web reporting, multidimensional modeling, and Microsoft 365 integration features related to Power BI and SharePoint. 55 minutes. |
|
Planning Your Exit from IBM DB2 Web Query
IBM’s decision to drop DB2 Web Query caught customers by surprise. But as IBM said in their announcement letter, there are alternative solutions, and this presentation will help you evaluate the one we recommend: NGS-IQ.
60 minutes.
|
|
Building APIs for IBM i Queries, Reports, and Applications
Do you have customers, suppliers, financial institutions, public agencies, or other trading partners who share data through application program interfaces (APIs)? Do you run your enterprise applications on IBM i? If so, you need an easy way to develop and use those APIs. Your queries and operational reports also need to include that data. During this presentation, you'll learn how the combination of NGS-IQ and Kato Integrations RPG API Express (RXS) make this solution possible. 40 minutes. |
|
Data Visualization and Analytics with NGS-IQ and Microsoft Power BI
Microsoft Power BI is a great data visualization and analytics solution, but your operational dashboards and insights are only as good as the data your analysts can draw from your IBM i database.
Watch this presentation and learn how NGS-IQ can simplify and automate the cleansing, transformation, and delivery of accurate, timely data to Power BI. 50 minutes. |
|
A Better Way to Connect IBM i Data and Microsoft 365 Users
Microsoft 365 is used widely to see, analyze, visualize, and share data. Microsoft's Power Query can enable Excel users to query a variety of data sources, including Db2 on i. But what if your Db2 on i database is too complex and sensitive to simply open up to Excel users and ODBC? We encourage you to watch this video and learn how NGS-IQ enables IBM i shops to satisfy Microsoft Excel, SharePoint, and OneDrive users but centrally manage query security and performance from IBM i. One hour. |
|
NGS-IQ: The Who, What, When, Where, and Why Tool for Your Data
Hear two IT Managers, one in distribution and one in manufacturing, describe how NGS-IQ enables them to make reports and files available to senior executives and staff members - without programming, modifying their business application software, or paying consultants. You'll also see a very brief demonstration on the product. 30 minutes. |
|
NGS-IQ + Db2 + IBM i: More Value Than Ever
We hear about big data, data science, and advanced analytics every day, but most of us work for companies where there is still room for improvement in the way we use our real-time, operational data for business advantage. See how NGS-IQ, working with Db2 and IBM i, answers the questions operational managers frequently ask. 50 minutes. |
|
Accessing Remote Data from IBM i
IBM® Db2® on i is your primary enterprise database, but you may be running customer relationship management, tax compliance, payroll, and other applications in separate LPAR’s, on other platforms, or in the cloud.
You can’t make data-driven decisions with incomplete information. With NGS-IQ's IQ Connexion module or ProData's RDB Connect, you can access, transfer, query, analyze, present, and share data wherever it’s stored—all from the IBM i. In this video, NGS and ProData show you how. 54 minutes. |
|
IBM Query for i (Query/400) Modernization: Creating and Updating Excel Sheets and Pivot Tables
If you have Query for i (Query/400) queries that return useful data, but not in the format your managers and users need, watch this video. With NGS-IQ, your users can run their old queries – as is – from Windows. In one simple click, they can create and update Microsoft Excel sheets and pivot tables. (NOTE: This is a playback of a session NGS presented at the COMMON PowerUp 2020 conference.) 25 minutes. |
|
IBM Query for i (Query/400) Modernization: Creating Real-Time, Drillable Web Reports
You probably have Query for i (Query/400) queries that return useful data, but not in the format your managers and users need to visualize and analyze real-time operational data. With NGS-IQ, your users can quickly run these old queries – as is – from their favorite Web browser to generate formatted, graphical Web reports with charts and dynamic drill down links. (NOTE: This is a playback of a session NGS presented at the COMMON PowerUp 2020 conference.) 25 minutes. |
|
Using Qport Office
Learn about Qport Office, NGS' entry-level reporting tool for Query/400 users. Output to MS Excel, Word, Access, and the Windows display as well as initiate queries to run from desktop icons and the Windows Task Scheduler. Approximately 30 minutes. |
|
|