Resources

Case Study
Case Study

Victaulic makes Short Work of Ad Hoc Queries with Surveyor/400

Ad hoc queries and reports are the bane of many IT departments. The need to churn out frequent, one-off, "must have" data queries for users can be a significant drain on developers' time. Users can't be blamed for the numerous impromptu requests. Customer service, continuous improvement, and the maintenance of competitive advantage demand that business people regularly look at data in innovative...
IBM i Automation
On-Demand Webinar
On-Demand Webinar

7 Signs You Need a Data Warehouse

By Mike Stegeman
How well are you keeping up with your data? A data warehouse might be able to help. Watch this webinar to learn if it’s time for you to implement a data warehouse.
IBM i Business Intelligence
Guide
Guide

Which IBM i Data Access Tool is Right for You?

Data access software is essential today to both technical users—like your IT team—and business users—like everyone else. Query/400 has long been the go-to for IBM i data access. It’s been around for over 30 years, but the tool hasn’t advanced with changes in technology. That’s where modern data access tools like Sequel have the advantage. But how do you really know which data access tool is right...
IBM i Business Intelligence
Article
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 you...
IBM i Business Intelligence
Guide
Guide

Calculating the True Cost of Bad Data

Bad data is common throughout many organizations—and the costs can be far-reaching. This white paper explores the common causes of inaccurate and incomplete business data, as well as how businesses can identify and mitigate these problems.
IBM i Business Intelligence
Blog
Blog

How “Smash and Grab” Compromises IBM i

By Robin Tatam on Wed, 03/08/2017
During an audit a few years ago, I revealed to the client’s security team that corporate payroll information on every employee, including the CEO, was being archived in an output queue (called PAYROLL) for weeks at a time. Due to poor configuration, this information was accessible to every employee.
IBM i Cybersecurity
Article
Article

The Modern Alternative to Authority Adoption

By Robin Tatam on Wed, 03/08/2017
There are several considerations with authority adoption. Each is important but can usually be accommodated. But what is the effect if the program owner has the same or less privileges than the user that called the program?
IBM i Cybersecurity
Blog
Blog

Database Transaction Log Management

Mon, 03/06/2017
Don't let database transaction logs weigh you down. Find out how to preserve data integrity and consume less disk space.
Automation
IBM i Business Intelligence