Resources

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
Powertech Compliance Monitor for IBM i
Article

Managing Your IBM i Audit Data

By Robin Tatam on Wed, 08/01/2018
Let’s face it; system administration remains a largely thankless task. From scheduling jobs to balancing workloads to answering messages in QSYSOPR, administrators and operators work diligently behind the scenes to ensure that IBM i servers are available to run mission-critical applications.
Compliance
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
Article

Increase Productivity with Sequel View Builder

By Mike Stegeman on Thu, 08/25/2016
Business success hinges on sharing relevant information with the people who need it. When members of your organization can make informed decisions, productivity increases and problems can be solved more creatively. With Sequel Data Access, more business users within your organization can see these benefits on an even greater scale. Not using Sequel yet? Learn more > Using Sequel? Keep...
IBM i Business Intelligence
Article

Database 101: Why You Can Rely on IBM i

Fri, 08/19/2016
IBM i is the perfect environment for data access and reporting. Read this article to learn how you can better utilize your Power Systems databases.
IBM i Business Intelligence