WebRunner is built into NGS-IQ, but maybe you haven't had time to get familiar with IQ Client's HTML formatting features. Read more
Technically, a Microsoft 365 user can connect to Db2 on i through the IBM Access Client Solutions (ACS) ODBC driver. But in practice, few Microsoft 365 users understand their company’s Db2 on i database well enough to join tables, select columns, and format the data they need. Read more
IBM i is a unique and proven enterprise computing platform. IBM announces software, operating system releases, technology refreshes, and new hardware periodically, but often the specific information you need to complete a task or explain a concept effectively isn’t in those announcement letters. Read more
This webcast highlights NGS-IQ's advanced functions and a wide range of output formats and interfaces for various users - without the cost or complexity of many of today's best known BI solutions. Read more
Check out this webcast about NGS-IQ’s many date functions to simplify date arithmetic, sorting, and record selection. Also, Russ Afton from Arbor Solutions explains IBM i’s built-in job scheduling features. The webinar includes tips for writing queries to show your company’s schedule and history to satisfy auditors and managers.
Since the earliest days of OS/400, job scheduling has been practiced in IBM i environments, its functionality improving in recent releases. And while you have a great collection of built-in job scheduling features at your disposal, you can do even more if you license the IBM i Advanced Job Scheduler or a third-party utility. Read more
Many IBM i IT professionals don’t use Excel but provide technical support to business users who do. These users need timely data they can analyze in Excel to present to their staff or customers. Read more
You're here in search of answers, and many files you have,
You join them up, you pick some fields, and then you click a tab. Read more
IT Managers, IBM i programmers, and operators often express frustration over the challenge of supporting non-technical software users. Many shops succeed thanks to only one or two non-IT staff members who learn quickly and informally. They become the office “power users.”
What? You don’t think you have any of those kinds of people? We say grow your own. Read more
We periodically hear from companies running IBM i software applications who are concerned about their future ability to support IBM i. With their in-house expert or small IBM i team nearing retirement age, the pool of technical knowledge is gradually shrinking. Read more
While some vendors are addressing business resiliency, covering solutions from disaster recovery to encryption, they often overlook or ignore this somewhat mundane but critical aspect that can have a large impact on a company’s future success – “turnover preparedness.” Read more
Every time NGS product specialists spend time with new users, we encourage them to call our technical support hotline or use our online incident reporting system when they have questions. We spend a lot of time training non-technical, business users of our query, reporting, and financial software, and many of them tell us they never knew they had those options. Yes—they, and you, do.
Just as frequently, we discover people whose encounters with other vendors have caused them to develop a disabling condition we’ll call “software support phobia” (SSP). Read more
NGS customers who are current on maintenance can take advantage of a variety of valuable, free, and educational offerings. These offerings include online tutoring sessions, share and learn Webinars, on demand videos, and even onsite product reviews with NGS product specialists traveling in your area. Most of these offerings only require an hour or two of your time. I hope you or your coworkers have taken advantage of some of these services and found them very helpful. Read more
Are you an NGS-IQ query developer who hasn’t had time to get familiar with our Web reporting features? You’ve probably seen us demonstrate WebRunner and IQ Client’s HTML design features, but up to now, your company has left Web software development and support in the hands of a separate person or team that views your IBM i environment as an uncharted island, best avoided. Read more
The item file is seemingly a simple file. Use the item number the same way as on sales orders along with the human readable description and maybe a few other fields such as color, weight, and so on. Throw in a few department or categories, too, to make summarizing easier and more meaningful to businesspeople. Read more
In my last blog entry, I misspoke. I said there were two main entities – customers and orders – on which sales departments base their reporting. While true, the real world is a little less clear. Read more
For a long, long time NGS has worked with customers who have sales related data tied up in their ERP system without easy ways to access and summarize it. Their CRM system (using that term loosely for many companies) does not interface well with the ERP data. Read more
Here we are again, the start of another year, and the start of another 365 days of new year’s resolutions which we may or may not keep. What’s at the top of that well-intentioned list? For most of us, it’s exercising more and eating healthy. Read more
We regularly hear customers say they need and want ongoing education but can’t leave their office to attend a conference, user group meeting, or training class. This problem might be due to job duties, budget, or family obligations. We certainly understand. Read more
New terms come up all the time for IT people. A really interesting new one is “Data Science” and its corresponding job title, “Data Scientist.”
A month ago, I did a video on data science, based on my background, education, and work in this area. There is not much in the video about the IBM i, but it is still one IBM i IT people should view. Read more
Most IT people have to interact with people from some other department in the company. And for most IT people writing reports from IBM i data, this interaction probably happens on a higher than average basis. Writing reports and creating views of data useful to business people requires communicating with others in relevant departments. Read more
NGS devotes considerable resources to sending product specialists into the field to meet face to face with our customers. We initiated this effort, which we call our “Customer Success” program, several years ago to proactively connect with new users who have often never received training and with long-time users who are increasingly wearing multiple hats and spending less time keeping up with new releases. Read more
From time to time, nearly all of us resist or postpone developing new skills and learning how to take advantage of new technology. This can be especially true as we age, even among information technology professionals who have had long and successful careers in an ever changing environment. Read more
Personnel changes happen more often than technology at many companies. If your company has changed IT personnel from experienced IBM i people to IT people who have little background on the platform, watch this video. Afterwards, IT professionals new to IBM i will come away with a deep background and an understanding of key IBM i concepts. Watch this short video for some ideas to stimulate the discussion in your enterprise.
Follow us on Twitter.
Subscribe to our blog