Resources

Article

Don’t Be Exposed In *PUBLIC!

Security typically operates so that users who are not granted authority have no authority. IBM i security, however, has a unique concept known as *PUBLIC.
Article

What's New for Security in IBM i 7.1

IBM added additional security functions in version 7.1 to further establish the Power Systems IBM i operating system as a world-class securable environment.
Article

Save Time by Modernizing Your Data

Many Query/400 users spend too much time trying to manage existing queries, from modifying old ones to searching for the right one just to get basic data. SEQUEL can make this process much faster and easier.
Article

Save Changed Views Automatically with SEQUEL Versioning

Have you ever made a change to an IBM i object and then wished you could undo the change like with PC objects? This is a common mistake many business and IBM i professionals encounter on a regular basis, but SEQUEL now gives you a built-in solution.
Article

Working with Variables Part II: Taking SEQUEL Runtime Prompts to the Next Level

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

How to Quickly and Dynamically Summarize Your Data with Client Tables

A SEQUEL Client Table is an interactive solution for dynamic Desktop Online Analytical Processing (Desktop OLAP or DOLAP) and cube analysis. With a Client Table, it’s possible for you to build client/server views that allow end users to explore, summarize, and pivot large quantities of data quickly from IBM i and other databases. Once a Client Table is displayed, users can perform interactive...
Article

SECURITY DASHBOARDS: How IT Can Use Data to Lower Risk

Data security has been a prominent feature in recent technology headlines as the costs associated with data breaches continue to escalate. Business and IT leaders alike have become all too aware of the need to protect valuable information, but questions of how - and to what extent protection is needed- are common sticking points. The rule of least privilege has been a long-held strategy that...
Article

Separate Signal From Noise in Big Data

You don’t need a reminder of the strain big data will place on your IBM i storage environments in the coming months and years, but server workloads won’t be the only thing expanding. As CIOs navigate the transition from megabytes and gigabytes to terabytes and petabytes, their colleagues' business intelligence plans continue to grow more complex and ambitious as well.In the age of data-driven...
Article

How Mobile Data Access Improves Business Operations

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

Who Knew You Could Do THAT with SEQUEL Data Warehouse?

While SEQUEL Data Warehouse is primarily a tool for building and managing data warehouses and data marts (along with the associated ETL), our customers are always finding innovative "off-label" uses. These are some of the common ones we've heard about. It's likely you will find more things to do with SEQUEL Data Warehouse, too. And every additional use you find within your organization increases...
Article

Have You Met SAM?

Isn’t it time your job scheduling environment (and your IBM i) got the modern look it deserves? Give Schedule Activity Monitor a try for graphically monitoring your jobs on the go.
Article

Interfaces with Robot Schedule

If you’re using EnterpriseOne or SAP, it may be to take a closer look at the security and business process automation that Robot Schedule can offer these key applications on IBM i. We don’t talk enough about the integration we’ve done between Robot Schedule and EnterpriseOne (formerly JD Edwards, now owned by Oracle) and SAP.
Case Study

Fortra Meets IT Security Needs for Napa Recycling and Waste Services

Napa Recycling and Waste Services (NRWS) provides recycling and waste collection to businesses and residents in the City of Napa and southern unincorporated Napa County. The entire county, with 90 percent of its agricultural land devoted to viticulture, is home to more than three hundred wineries in the Napa Valley, and is one of the top wine producing areas of the United States. In addition, the...