Resources
Article

How to Quickly and Dynamically Summarize Your Data with Client Tables

Mon, 06/27/2016
A SEQUEL Client Table is an interactive solution for dynamic Desktop Online Analytical Processing (Desktop OLAP or DOLAP) and cube analysis. With a Client Table, it’s possible for you to build client/server views that allow end users to explore, summarize, and pivot large quantities of data quickly from IBM i and other databases. Once a Client Table is displayed, users can perform interactive...
IBM i Business Intelligence
Article

Getting the Most Out of DB2

By Heath Kath on Mon, 06/27/2016
Used the right way, structured query language (SQL) can be an advantage for any organization's operations. Used the wrong way, it can be a headache for IT professionals.  A majority of computing operations are dependent on the ability to access information from a database. That's where SQL queries come in. So the efficiency of SQL queries in DB2 can dramatically impact the tasks running on IBM i...
IBM i Business Intelligence
Article

HANDS OFF! Saying Goodbye to Manual Data Access

Mon, 06/27/2016
Organizations today face an ever-expanding volume of information that must be analyzed and delivered to the right people. While the resulting business intelligence offers us insight into processes and customers, many companies still rely on practices and technology that aren’t suited for managing data on a large scale. As a December 2012 Financial Director article highlighted, 60 percent of those...
IBM i Business Intelligence
Article

Working with Variables Part II: Taking SEQUEL Runtime Prompts to the Next Level

Mon, 06/27/2016
In an earlier article, we introduced prompted views as a way to enable end users by allowing them to retrieve data without the need for code. We discussed how this approach meets the needs of users while freeing time that database administrators might otherwise spend running countless similar queries. Finally, we showed you how to configure default values for your prompts and explained how to use ...
IBM i Business Intelligence
Article

The IBM i Partitioning Paradox: Defined

Mon, 06/27/2016
Managing big data requires making some big decisions: how to store, query, and report on the constantly increasing stream of data. Although the practice of ‘data at scale’ or table partitioning is popular on IBM i, it creates a partitioning paradox that often adds complications to efficiently querying data.
IBM i Business Intelligence
Article

SECURITY DASHBOARDS: How IT Can Use Data to Lower Risk

Mon, 06/27/2016
Data security has been a prominent feature in recent technology headlines as the costs associated with data breaches continue to escalate. Business and IT leaders alike have become all too aware of the need to protect valuable information, but questions of how - and to what extent protection is needed- are common sticking points. The rule of least privilege has been a long-held strategy that...
IBM i Business Intelligence
Guide

Request a Live Advanced Reporting Suite Demonstration

See for yourself how Advanced Reporting Suite automates performance reporting for managed service providers (MSPs), making it easy to prove your value to customers. Our team of software experts would love to discuss what you’re looking for and show you what Advanced Reporting Suite can do. Your live demo will include: Discovery to help us identify your business needs An overview of the...
Case Study

Halcyon Makes IBM i Admins and Infor M3 Users Happy at Quiksilver International

When it comes to IT management, there’s a commitment to excellence that underpins the highest levels of business efficiency and undisputed customer loyalty. So, when it came time to select a systems monitoring and management solution for Quiksilver International’s IBM i-based Infor M3 ERP software, it was Halcyon that emerged the clear winner.
Monitoring
Case Study

SunGard Public Sector Uses Halcyon's Operation Center

Halcyon’s Operations Center Suite enabled SunGard Public Sector to use an intuitive tool to automatically handle the vast majority of alerts arising from the monitoring solution, with business-critical alerts sent to a technician trained to immediately deal with systems issues.
Monitoring
Case Study

Network Services Plus, Inc Moves to Automation

NSPI was disappointed with their existing systems management software solution. It did not consistently monitor applications, it was not scalable over multiple environments, and it lacked high-quality technical support. So, they turned to Halcyon.
Monitoring
Case Study

Mizuno USA Stays Active with Halcyon Products

Mizuno USA, Inc. needed a comprehensive systems management software solution that would efficiently deliver services to new divisions within the global company and provide a high level view of systems.
Monitoring
General coding graphic
Case Study

Meridian IT Inc and Halcyon

While expanding its data center to offer managed services for IBM i, Meridian IT needed an automated systems management software solution to efficiently deliver services to customers, manage multiple platforms, provide 24/7 monitoring without the need for staff on-site, and automate hardware and software management.
Monitoring
Case Study

City Government IT Department and Halcyon

When the City Government IT department restructured, it was left without extensive IBM i knowledge for several key software applications. Without this expertise, overnight backups did not work correctly and the system was not being monitored accurately. A solution to the problem needed to be found—and fast.
Monitoring
Case Study

Halcyon Brings Mobility and Time-Savings to the IT Team at Bras N Things

For Bras N Things, a crucial component of successfully integrating their IBM i-based ERP and point-of-sale (POS) systems relied on a systems monitoring and notification solution for IBM i that could reduce systems administrator workloads and, most importantly, monitor every aspect of the server then broadcast alerts in case of systems error.
Monitoring
Case Study

Avon Finds Stability with Systems Operations Suite

With customers and independent sales representatives scattered across virtually every corner of Australia and New Zealand, efficient systems operations and business continuity is fundamental to Avon’s success.
Monitoring
Case Study

Admiral Group Utilizes Systems Operations Suite and More

The increasingly complex IT infrastructure at Admiral Group placed additional pressure on the operations team. So, Admiral installed a systems management solution to ease the burden while providing effective monitoring across a multi-platform server environment.
Monitoring