Resources

Article

IBM i Can Be Your Data Warehouse

By Tom Huntington on Mon, 08/10/2020
Thanks to Sequel Data Warehouse, shops using both Windows and IBM i can move their essential data storage and reporting back to the more reliable IBM i. See how here.
IBM i Business Intelligence
Article

How Do I Know When I Need a Data Warehouse?

By Alan Jordan on Fri, 08/07/2020
It can be a challendge to bring information together from across disparate sources, especially when the data is stored in different formats or with mismatched identifiers. You're likely to encounter issues that a reporting tool by itself simply cannot solve. Read on to learn why you should consider a data warehouse vs. just a database.
IBM i Business Intelligence
Article

Remember the IFS!

By Robin Tatam on Thu, 06/27/2019
Ask any security professional which area of IBM i security is most often ignored and chances are that the unanimous response is a chorus of “the Integrated File System.” Although it’s been around since V3R1, the Integrated File System, or IFS, remains a shrouded mystery that represents significant risk to many IBM i organizations.
IBM i Cybersecurity
Scale of IT capacity planning tools that balance cost and risk
Article

Comparing Different Methods for Calculating Health and Risk

By Per Bauer on Fri, 02/08/2019
How do you calculate IT health and risk? There are different methods you can use, depending on your needs. The most common methods for determining IT infrastructure health are: Threshold comparison Enhanced threshold comparison Event detection Variation from normal Allocation comparison Queuing theory for health On the other hand, the most common methods for calculating IT...
Automation
Article

A Roadmap for Consolidation

Mon, 02/04/2019
There are five key steps when planning a consolidation strategy. Considerations for each step are outlined below.
Automation
Article

Use Conditional Logic in Sequel Data Access to Convert Data into Meaningful Information

By Mike Stegeman on Thu, 03/30/2017
Let’s face it, the amount of data that we have is only continuing to grow, which will become harder to manage and understand. Per IDC Research, 90 percent of data in the world today was created in the last two years, and in 2016, we entered the zettabyte era. A huge challenge for everyone is finding the best way to convert all their data into meaningful information. But that can be tricky. If...
IBM i Business Intelligence
Data Integrity Monitoring graphic
Article

How To Maintain Your Data Integrity

By Robin Tatam on Tue, 03/21/2017
File Integrity Monitoring (FIM) helps ensure that your critical and sensitive data is viewed and changed only by authorized personnel through approved channels. Candidates for FIM include application files containing sensitive data, such as personnel or financial data, and server configuration files.
Infrastructure and Data Protection
Article

Enhance Your Reporting with Sequel Date Functions

By Heath Kath on Fri, 01/06/2017
Sequel makes it easy to work with your date fields, from converting the numeric or character field into a true date data type field to performing date calculations. Continue reading to learn how to convert non-date data type fields.
IBM i Business Intelligence
Article

Anydate: Go Back to the Future

Fri, 01/06/2017
Take time into your own hands. Discover the benefits of testing future dates, rerunning past reports, and more with date simulation software.
IBM i Business Intelligence
Article

How-To: Analyze Year-End Data Quickly with Flexible Client Tables

By Heath Kath on Thu, 12/01/2016
Year-end reporting is coming… Are you ready? Do you know your options? Are you prepared to collect all of the data you need to see how your company fared for the year? You’re in luck, because Sequel Client Tables make year-end reporting a breeze. Drill down into the level of information you need for your reports. Compare data across multiple years to spot trends and add context. And highlight...
IBM i Business Intelligence