Article
How-To: Format, Visualize, and Deliver Data in Dashboards Quickly and Easily
Fri, 09/16/2016
Looking for quick tips for building Sequel dashboards? Look no further. Read the how-to for best practices on formatting, visualizing, and delivering data.
Blog
IT Security Compliance 101
By Robin Tatam on Sun, 08/21/2016
In this compliance 101 primer, we'll look at three high-profile breaches from the past year, each of which shows what can go wrong when data oversight isn't up to snuff. Along the way, we'll discuss some basic fixes that can help shore up network defenses.
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.
Guide
Dispelling the Myths of IBM i Data Access
Ironically, many IBM Power Systems™ users are sitting on top of a “gold mine” of data that they could use to make their lives easier, their jobs more productive, and their companies more profitable—if they only knew how to harvest it. Yet, they don’t have the first idea about how to do that. They might even be considered “power users” on their computer systems and not know how to transform the...
Guide
Key Performance Indicators and the Reporting Tools for Success
Learn why KPIs are a must for any business intelligence strategy—and how you can apply them.
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.
Guide
Download “How IT Professionals Can Navigate PCI DSS Compliance” Guide
The Payment Card Industry Data Security Standard (PCI DSS) applies to every organization that processes credit or debit card information. This includes merchants and third-party service providers that store, process, or transmit credit card data.The launch of PCI DSS helped expose serious security shortcomings, failures to follow security best practices, and a...
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.
Guide
Self-Audit: Checking Assumptions at the Door
Sysadmins, devops engineers, and cybersecurity personnel are often kept awake by a number of questions.
How should I monitor my monitoring to be sure it will alert me when there is a security issue that needs my intervention? How can I be sure that the servers and processes in the environment haven’t been rooted already?
In the quest to get better sleep, it is a good idea to self-audit your...
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...
Article
Get Started with Remote Database Access
By Heath Kath on Mon, 06/27/2016
Many organizations are expanding to use multiple platforms in their IT environments. There are many reasons for this: it can be due to company acquisitions or application vendor platform shifts, or when a department requires a certain software package with features that require a different platform. For example, many Customer Relationship Management (CRM) tools employed by sales teams reside on a...
Article
How-To: Slice and Dice Your Data with Client Tables
Mon, 06/27/2016
In the era of big data users need to view their data in a way that makes sense and lets them dive deeper. SEQUEL’s Client Tables are an interactive solution, much like pivot tables, which allow users to reorganize and summarize columns and rows of data in a spreadsheet-like format both on a PC and on a mobile device or tablet.
With Client Tables on the go, you can access data from your office, in...
Article
Sequel Tips and Tricks: Enhance Your IBM i Queries
By Mike Stegeman on Mon, 06/27/2016
Get more out of your IBM i queries (and help your users help themselves).
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...
Article
Additional ViewPoint Administrator Functions
Mon, 06/27/2016
What does this function do?
SEQUEL Field Level Authorization uses an exclusion/inclusion dictionary function that lets administrators provide authorization to libraries, files, and fields. The dictionary, which can be defined as exclusion or inclusion, is an additional filter applied on top of system object security limits. It does not replace system object authority but supplements it.
...
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...
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...
Article
How Mobile Data Access Improves Business Operations
Mon, 06/27/2016
It seems nearly everyone in certain parts of the world now has a smartphone, tablet, or both, and these devices aren't just for fun and games. Organizations are putting devices to work in the drive to streamline processes, gain insight into operations, and ensure continuity.