Blog
Hacktivists Show the Danger of Leaving IBM i Unprotected
Thu, 08/11/2016
Your IBM i is only as secure as you make it. IBM i security experts have been saying this for years, but at least one organization learned the hard way.
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...
Blog
Say Goodbye to Document Mismanagement
Thu, 07/28/2016
We write a lot on this blog about document management, but this time we wanted to share a graphic illustrating the struggles that some companies and individuals still face in their processes.
Can you see yourself (or your company) in any of these stats? If so, let us help you find a solution!
With RJS, your company can digitize...
Guide
The Query Decision-Making Kit
Is Query/400 still cutting it? Probably not. You’ve most likely heard that there are other data access tools out there, but you might not be sure which one is right for you—or even if it’s the right time to upgrade. The Query Decision-Making Kit can help.
For starters, you want data access to be simple, no matter your skill level. You want the option to view visual data in real-time, access data...
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
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
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
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
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
Working with Variables Part II: Taking SEQUEL Runtime Prompts to the Next Level
Mon, 06/27/2016
In an earlier article, we introduced prompted views as a way to enable end users by allowing them to retrieve data without the need for code. We discussed how this approach meets the needs of users while freeing time that database administrators might otherwise spend running countless similar queries. Finally, we showed you how to configure default values for your prompts and explained how to use ...
Article
Is the i Ready for the Three Vs of Big Data?
By Tom Huntington on Mon, 06/27/2016
The three Vs of big data are volume, velocity, and variety, but in order derive value from big data, IT departments need tools to store massive amounts of data (volume) and make sure it is always available for quick analysis (velocity).
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.
Article
How to Use the SEQUEL ViewPoint Repository to Your Advantage
Mon, 06/27/2016
With the new SEQUEL ViewPoint repository, it’s easier than ever to manage, find, and run your SEQUEL objects. Learn more about the benefits of the repository.
Article
Sequel Tips and Tricks: Build Mobile-Friendly Dashboards
By Heath Kath on Mon, 06/27/2016
Get our best practices for building mobile-friendly dashboards.