Resources

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
Article
Article

Sudo or SuDon't: Manage Your Privileged Command Execution and Sudo Policies

Mon, 03/13/2017
System admins need root level authority at all times, system operations staff needs periodic database and application account authority, and security admins needing to protect the environment are some of the few of the challenges of managing privilege in the enterprise server infrastructure. Read this article to learn more about Sudo alternatives.
Vulnerability Management
Offensive Security
Article
Article

Managing IT Access Privileges

Mon, 03/13/2017
THE UNSOLVED PROBLEM Secure, private, effective use of computers by a company (including hosted, cloud and other services as well as the company’s own systems) relies on managing access privileges. The problem isn’t unique to computers. Office buildings, hotels, apartments and college dorms, for example, typically have “master keys” (or smart ID badges) that can open many-toall of the locks in the...
Vulnerability Management
Article
Article

Solving Healthcare Security Concerns

Mon, 03/13/2017
According to a recent KPMG report, four-fifths of executives at healthcare providers and payers say their information technology has been compromised by cyberattacks. That same report presents how the increased risk to healthcare organizations relates to the richness and uniqueness of the information that health plans, doctors and hospitals handle. Apart from typical financial fraud, there is also...
Vulnerability Management
Article
Article

New Approaches to the SWIFT and PCI-DSS Framework

Mon, 03/13/2017
THE WORLD OF COMPLIANCE At the official start of summertime 2016 in Britain we are starting to consume the labour of last autumn, five gallons of alcoholic homemade cider (yum!) made from eight apple varieties grown in mine and my neighbors’ gardens. I’m very VERY careful sterilizing glassware, containers, and buckets: there was this unfortunate incident three years ago (no, you don’t want to hear...
Infrastructure and Data Protection
Article
Article

Pros and Cons for Puppet's Configuration Management & Security

Mon, 03/13/2017
THE GOOD, THE BAD AND THE UGLY I was at the Red Hat Summit in Boston at the end of June. We had a lot of activity at our exhibitor stand, and a lot of discussions being passed on to me by our sales team I continued to have the same conversation again and again over the three days. This seems to be the year people have finished bedding down Puppet in their server/VM infrastructure, and are looking...
Vulnerability Management
Article
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
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 key...
IBM i Business Intelligence
Article
Article

How Banks Leverage Big Data for Big Value

Fri, 08/19/2016
Technology professionals in the banking industry face a wide range of concerns due to the nature of the data stored within their systems. The potential reward in stealing or compromising financial data makes these organizations a prime target for cybercrime, while stringent industry regulations require security to be extremely tight at all times. Is it possible to strike a balance between defensive, regulatory, and data access needs and still provide access to data for analytics without compromising the security of the entire system? The truth is that many organizations in the financial sector have deployed analytics technology while being able to keep their security tight, and are benefiting from it.
IBM i Business Intelligence
Article
Article

Add Power to SEQUEL Scripts with Logic

Mon, 08/01/2016
SEQUEL Scripting is a process that allows users to run multiple SEQUEL and system commands together. Scripts allow for much of the same capability of Command Language Programs (CLP) without the need for programming knowledge or a compiling of the objects.
IBM i Business Intelligence
Article
Article

The Partitioning Paradox Solved

Mon, 06/27/2016
There is rarely a dull moment for IBM i administrators, as their operating environments continuously absorb and distribute new data. While this trend certainly keeps teams engaged, it also triggers fears that current protocols may not be enough to meet the challenges of tomorrow. First and foremost, there is often some doubt as to whether storage plans will be able to scale to manage the sheer...
IBM i Business Intelligence
Article
Article

Easily Accessing Data on Remote Databases with SEQUEL

Mon, 06/27/2016
With SEQUEL you can retrieve information not just from your local IBM i, but also on other IBM i’s, SQL servers, Oracle, MySQL, and other remote databases. Once you have the remote host definition defined you are ready to convert data on other platforms into meaningful information right from your local IBM i. The ability to design views with SEQUEL SQL and translate them on the fly to native SQL...
IBM i Business Intelligence